Menu

#17 column aliases do not work with SQLite

open
nobody
None
5
2004-04-11
2004-04-11
No

require 'dbi'
dbc = DBI.connect('DBI:SQLite:/tmp/test.db')
res = dbc.execute("SELECT column AS alias FROM table")
puts res.fetch_hash.inspect

Output:
{nil=>"1"}

sqlite-ruby alone doesn't have this problem.

Ruby-DBI version: 0.0.21

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.