| Message: 60356 |
 |
BY: Gavin Kistner (phrogz)
DATE: 2008-09-11 16:49
SUBJECT: type_translation doesn't work for count() irb(main):001:0> require 'rubygems'
irb(main):002:0> require 'sqlite3'
irb(main):003:0> db = SQLite3::Database.new( 'foo.db' )
irb(main):004:0> db.execute( 'select foo,count(foo) as hits from bar group by (foo) limit 1' )
=> [["hello", "2"]]
irb(main):005:0> db.type_translation = true
irb(main):006:0> db.execute( 'select foo,count(foo) as hits from bar group by (foo) limit 1' )
=> [["hello", "2"]]
I would expect the result of count(foo) to be an integer with type_translation enabled. Is this a bug with sqlite3-ruby or SQLite3? | |
Start New Thread
type_translation doesn't work for count() 