gitlab.com/CoiaPrant/sqlite3@v1.19.1/testdata/tcl/unionallfault.test (about)

     1  # 2020-12-16
     2  #
     3  # The author disclaims copyright to this source code.  In place of
     4  # 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  
    13  set testdir [file dirname $argv0]
    14  source $testdir/tester.tcl
    15  set testprefix unionallfault
    16  
    17  do_execsql_test 1.0 {
    18    CREATE TABLE t1(x,y,z);
    19    CREATE TABLE t3(x,y,z);
    20  }
    21  faultsim_save_and_close
    22  
    23  
    24  do_faultsim_test 1 -faults oom-t* -prep {
    25    faultsim_restore_and_reopen
    26  } -body {
    27    execsql {
    28      SELECT * FROM t1, (
    29        SELECT x FROM t1 UNION ALL SELECT y FROM t1
    30      ), t3
    31    }
    32  } -test {
    33    faultsim_test_result {0 {}}
    34  }
    35  
    36  finish_test