On 10/23/2018 03:13 AM, Peter Ďurica wrote:
Table with sample data:
*create table t(a int, b int);*
*insert into t values(1,11);*
*insert into t values(2,12);*
now query using any window function (row_number, rank, ....) after UNION or
UNION ALL will cause sqlite.exe crash (no regular error)
for example:
*select a, rank() over(order by b) from t *
*union all *
*select a, rank() over(order by b desc) from t;*
WILL CRASH
but single statement is fine
*select a, rank() over(order by b desc) from t; *
and also window function just before union is fine
*select a, rank() over(order by b) from t *
*union all *
*select a, b from t;*
when I used e_sqlite3.dll (https://github.com/ericsink/SQLitePCL.raw) from
my c# app, I got error below
Exception thrown at 0x00007FFF563BF797 (e_sqlite3.dll) in WebLES.exe:
0xC0000005: Access violation reading location 0x0000000000000008.
I believe it's a bug in core sqlite, which should be fixed
It is indeed, thanks for reporting it. Should now be fixed here:
https://www.sqlite.org/src/info/059ff53a46c7f1e4
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users