blob: a9085d063a123fdf58a775f0559747f3f0d74542 [file] [log] [blame]
drh0bbaa1b2005-08-19 19:14:12 +00001# 2005 September 19
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# This file implements regression tests for SQLite library. The
12# focus of this script is testing the ALTER TABLE statement and
13# specifically out-of-memory conditions within that command.
14#
danielk1977cdc3a6b2007-08-25 13:09:26 +000015# $Id: altermalloc.test,v 1.4 2007/08/25 13:09:26 danielk1977 Exp $
drh0bbaa1b2005-08-19 19:14:12 +000016#
17
18set testdir [file dirname $argv0]
19source $testdir/tester.tcl
20
drh0bbaa1b2005-08-19 19:14:12 +000021# If SQLITE_OMIT_ALTERTABLE is defined, omit this file.
22ifcapable !altertable {
23 finish_test
24 return
25}
26
danielk1977cdc3a6b2007-08-25 13:09:26 +000027source $testdir/malloc_common.tcl
drh0bbaa1b2005-08-19 19:14:12 +000028
29do_malloc_test altermalloc-1 -tclprep {
30 db close
31} -tclbody {
32 if {[catch {sqlite3 db test.db}]} {
33 error "out of memory"
34 }
35} -sqlbody {
36 CREATE TABLE t1(a int);
37 ALTER TABLE t1 ADD COLUMN b INTEGER DEFAULT NULL;
38 ALTER TABLE t1 ADD COLUMN c TEXT DEFAULT 'default-text';
39 ALTER TABLE t1 RENAME TO t2;
40}
41
42finish_test