On 3/22/19, Marek Šrom <marek.s...@email.cz> 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 on
select a, test2.b, ifnull(test2.b,test.a) from test left join test2 on
(1=0) order by a DESC;
select a, test2.b, ifnull(test2.b,test.a) from test left join test2 on
(1=0) order by a;
Are you seeing the problem on the native SQLite command-line shell, or
in some third-party GUI tool.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
