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)
I dug a little more into this with a debug build; was able to get the
same crash trace with the slightly smaller query
CREATE TABLE t(a);
SELECT 1, 1
UNION ALL
SELECT a, RANK() OVER (ORDER BY a) FROM t;
which fails the pTab!=0 assertion in sqlite3ColumnsFromExprList.
It seems lik
On Monday, 22 October, 2018 14:13, 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);*
...
What is up with the asterisks, they make copying VERY VERY VERY VERY difficult.
If you want to put "stars" around
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)
fo
4 matches
Mail list logo