Re: [Ruby-DBI-devel] SQLite: column aliases do not work at all

[Michael N. <mne...@nt...>]

On Sun, Apr 11, 2004 at 08:11:27PM +0200, Andreas Schwarz wrote:
> 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.

We definitly have to implement the sqlite_compile and sqlite_step
functions. Today, I've hacked a simple script together, which uses
Ruby/DL to call Sqlite. But I need some more time to complete it.  Of
course, it will be not as fast as a pure C solution, but it has
definitly less bugs and is much easier to code (have a look at the
sqlite dbd, some parts are a kind of hack). 

Regards,

  Michael