1.3 KiB
1.3 KiB
Summary
**No review yet**Minimized query
PRAGMA full_column_names = FALSE;
PRAGMA short_column_names = TRUE;
PRAGMA vdbe_addoptrace = 1;
.limit
CREATE TABLE /**/ T (
a TEXT,
b INTEGER,
c REAL
);
INSERT INTO T VALUES (('a' || ''),1,2.0), ('a',2,-3.0), ('b',1,4.5);
SELECT a,b,c,
SUM(c) OVER (
PARTITION BY a
ORDER BY b
) AS d
FROM T;
Actual output
length 1000000000
sql_length 1000000000
column 2000
expr_depth 1000
compound_select 500
vdbe_op 250000000
function_arg 127
attached 10
like_pattern_length 50000
variable_number 32766
trigger_depth 1000
worker_threads 0
a|1|2.0|2.0
a|2|-3.0|-1.0
b|1|4.5|4.5
Expectation
length 1000000000
sql_length 1000000000
column 2000
expr_depth 1000
compound_select 500
vdbe_op 250000000
function_arg 1000
attached 10
like_pattern_length 50000
variable_number 32766
trigger_depth 1000
worker_threads 0
a|1|2.0|2.0
a|2|-3.0|-1.0
b|1|4.5|4.5
Flag