diff options
Diffstat (limited to 'test/windowfault.test')
-rw-r--r-- | test/windowfault.test | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/test/windowfault.test b/test/windowfault.test index e037c467b..e97544f4c 100644 --- a/test/windowfault.test +++ b/test/windowfault.test @@ -230,7 +230,7 @@ do_execsql_test 10.0 { CREATE TABLE t2(a, b, c, d); } -do_faultsim_test 1 -faults oom* -prep { +do_faultsim_test 10 -faults oom* -prep { } -body { execsql { SELECT row_number() OVER win @@ -246,4 +246,21 @@ do_faultsim_test 1 -faults oom* -prep { faultsim_test_result {0 {}} } +reset_db +do_execsql_test 11.0 { + DROP TABLE IF EXISTS t0; + CREATE TABLE t0(c0 INTEGER UNIQUE); + INSERT INTO t0 VALUES(0); +} {} + +do_faultsim_test 11 -faults oom* -prep { +} -body { + execsql { + SELECT * FROM t0 WHERE + (0, t0.c0) IN (SELECT DENSE_RANK() OVER(), LAG(0) OVER() FROM t0); + } +} -test { + faultsim_test_result {0 {}} +} + finish_test |