AryaWu/sqlite

1# 2023 March 302#3# The author disclaims copyright to this source code.  In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#***********************************************************************11#12 13set testdir [file dirname $argv0]14source $testdir/tester.tcl15set testprefix aggfault16 17 18do_execsql_test 1 {19  CREATE TABLE t1(x);20  CREATE INDEX t1x ON t1(x, x=0);21}22faultsim_save_and_close23 24do_faultsim_test 2 -faults oom* -prep {25  faultsim_restore_and_reopen26  execsql { SELECT * FROM sqlite_schema }27} -body {28  execsql {29    SELECT * FROM t1 AS a1 WHERE (30      SELECT count(x AND 0=a1.x) FROM t1 GROUP BY abs(1)31    ) AND x=(32      SELECT * FROM t1 AS a1 33      WHERE (SELECT count(x IS 1 AND a1.x=0) 34      FROM t1 35      GROUP BY abs(1)) AND x=036    );37  }38} -test {39  faultsim_test_result {0 {}}40}41 42 43finish_test44