AryaWu/sqlite

1# 2017-07-152#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# This file implements regression tests for SQLite library.  The12# focus of this file is error handling in the swarmvtab extension.13#14 15set testdir [file dirname $argv0]16source $testdir/tester.tcl17set testprefix swarmvtabfault18 19ifcapable !vtab {20  finish_test21  return22}23 24proc fetch_db {file} {25  forcedelete $file26  sqlite3 dbX $file27  set rc [catch {28    dbX eval { CREATE TABLE t1(a INTEGER PRIMARY KEY, b) }29  } res]30  dbX close31  if {$rc!=0} {error $res}32}33 34forcedelete test.db135forcedelete test.db236 37do_execsql_test 1.0 {38  ATTACH 'test.db1' AS aux;39  CREATE TABLE aux.t1(a INTEGER PRIMARY KEY, b);40  INSERT INTO aux.t1 VALUES(1, NULL);41  INSERT INTO aux.t1 VALUES(2, NULL);42  INSERT INTO aux.t1 VALUES(9, NULL);43  DETACH aux;44} {}45 46faultsim_save_and_close47do_faultsim_test 1.1 -faults oom* -prep {48  faultsim_restore_and_reopen49  db func fetch_db fetch_db50  load_static_extension db unionvtab51  db eval {52    CREATE VIRTUAL TABLE temp.xyz USING swarmvtab(53        'VALUES54        ("test.db1", "t1", 1, 10),55        ("test.db2", "t1", 11, 20)56        ', 'fetch_db'57    );58  }59} -body {60  execsql { SELECT a FROM xyz }61} -test {62  faultsim_test_result {0 {1 2 9}} {1 {sql error: out of memory}}63}64 65finish_test66