Re: [sqlite] BUG - LEFT JOIN + IFNULL

2019-03-23 Thread Richard Hipp
On 3/23/19, Marek Šrom wrote: > I'm using 3rd party wrapping library for delphi, it was a bug in it. The > problem was that Sqlite3_ColumnDeclType for last column returns null (don't > > know if it is ok or not?)... > The library was setting column type from the first row value - it was > NULL...

Re: [sqlite] BUG - LEFT JOIN + IFNULL

2019-03-22 Thread Richard Hipp
On 3/22/19, Marek Šrom wrote: > > I found following bug, using SQLite version 3.27.2 on windows... > The following test script seems to work fine for me. create table test (a text); insert into test values(null); insert into test values('test'); create table test2 (b text); .mode quote .echo

[sqlite] BUG - LEFT JOIN + IFNULL

2019-03-22 Thread Marek Šrom
Hello, I found following bug, using SQLite version 3.27.2 on windows... Using field from left joined table in ifnull when first row contains null value causes in following rows value to be empty string instead of correct value... To reproduce: create table