On Tue, 2008-07-29 at 08:24 +0200, Balazs Scheidler wrote: > On Mon, 2008-07-28 at 22:29 +0200, Markus Hoenicka wrote: > > Balazs Scheidler writes: > > > > > > Thanks, this sounds great. > > > > I've checked in a fix for this problem. Turns out that recent versions > > of SQLite have a PRAGMA to make it behave like other database engines > > when there are no rows in a result set: > > > > Test 11: Retrieve zero rows: > > libdbi: [query] SELECT * from test_datatypes WHERE 0=1 > > test_datatypes contains 26 columns > > > > I don't know precisely when this pragma was introduced. The test in > > libdbi-driver's "make check" will tell you whether or not it works. > > Thanks, this sounds even greater :) I'm going to check the changes ASAP, > and report whether it works. >
It works great. Thanks for fixing this issue. Running SQL query; query='SELECT * FROM messages3 WHERE 0=1' Running SQL query; query='ALTER TABLE messages3 ADD test text' Running SQL query; query='INSERT INTO messages3 (logdate, message, test) VALUES (\'Jul 29 09:24:34\', \'-- MARK --\', \'Jul 29 09:24:34\')' This immediately fixes two problems for me: * table existance can easily be tested * table format updates work nicely -- Bazsi ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
