On 3/22/19, Marek Šrom <[email protected]> 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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
