xref: /sqlite-3.40.0/test/returningfault.test (revision c6977c1c) 
1*c6977c1cSdan# 2022 January 5
2*c6977c1cSdan#
3*c6977c1cSdan# The author disclaims copyright to this source code.  In place of
4*c6977c1cSdan# a legal notice, here is a blessing:
5*c6977c1cSdan#
6*c6977c1cSdan#    May you do good and not evil.
7*c6977c1cSdan#    May you find forgiveness for yourself and forgive others.
8*c6977c1cSdan#    May you share freely, never taking more than you give.
9*c6977c1cSdan#
10*c6977c1cSdan#***********************************************************************
11*c6977c1cSdan#
12*c6977c1cSdan
13*c6977c1cSdanset testdir [file dirname $argv0]
14*c6977c1cSdansource $testdir/tester.tcl
15*c6977c1cSdansource $testdir/malloc_common.tcl
16*c6977c1cSdan
17*c6977c1cSdan
18*c6977c1cSdando_execsql_test 1.0 {
19*c6977c1cSdan  CREATE TABLE t1 (b);
20*c6977c1cSdan} {}
21*c6977c1cSdanfaultsim_save_and_close
22*c6977c1cSdan
23*c6977c1cSdando_faultsim_test pagerfault-1 -faults oom-t* -prep {
24*c6977c1cSdan  faultsim_restore_and_reopen
25*c6977c1cSdan} -body {
26*c6977c1cSdan  execsql {
27*c6977c1cSdan    INSERT INTO t1(b) VALUES(65) RETURNING (
28*c6977c1cSdan      SELECT * FROM sqlite_temp_schema
29*c6977c1cSdan    ) AS aaa;
30*c6977c1cSdan  }
31*c6977c1cSdan} -test {
32*c6977c1cSdan  faultsim_test_result {1 {sub-select returns 5 columns - expected 1}}
33*c6977c1cSdan}
34*c6977c1cSdan
35*c6977c1cSdan
36*c6977c1cSdanfinish_test
37