Re: SQLite 3.3.16 nulls test results
- From: Tim.Bunce@xxxxxxxxx (Tim Bunce)
- Date: Mon, 30 Apr 2007 13:07:59 +0100
On Fri, Apr 27, 2007 at 08:52:21AM -0700, Alex Teslik wrote:
as requested by the DBI man page:
[root]/home/alex# perl perl_dbi_nulls_test.pl
Using connect arguments, db version: 3.3.16
=> Drop table 'dbi__null_test_tmp', if it already exists...
DBD::SQLite::db do failed: no such table: dbi__null_test_tmp(1) at dbdimp.c
line 271 at perl_dbi_nulls_test.pl line 92.
=> Create table 'dbi__null_test_tmp'...
=> Insert 4 rows into the table...
Values 1 Homer
Values 2
Values 3 Marge
Values 4
=> Testing clause style 6: WHERE mycol = ? OR (mycol IS NULL AND ? = 1)
=> WHERE clause style 6 returned incorrect results.
Non-Null test rows returned: 3
Null test rows returned:
It's unfortunate and surprising that style 6 isn't supported as that's
the only style that every other database supports.
Could you look into that some more. Perhaps there's a bug somewhere.
closing dbh with active statement handles at perl_dbi_nulls_test.pl line 167.
Looks like a bug in DBD::SQLite. Executing a prepared NON-select statement
(like a CREATE TABLE or INSERT) should not leave $sth->{Active} true.
1 styles are supported
4: WHERE mycol = ? OR (mycol IS NULL AND ? IS NULL)
I've updated the docs. Thanks.
Tim.
.
- References:
- SQLite 3.3.16 nulls test results
- From: Alex Teslik
- SQLite 3.3.16 nulls test results
- Prev by Date: Re: DBD::Sybase
- Next by Date: Re: Proposal for new $h->{ReadOnly} attribute
- Previous by thread: SQLite 3.3.16 nulls test results
- Next by thread: Re: :CSV and multi character separator
- Index(es):
Relevant Pages
|
|
