diff options
Diffstat (limited to 'test/alter.test')
| -rw-r--r-- | test/alter.test | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/test/alter.test b/test/alter.test index 2eb944cb2..3ddd5769c 100644 --- a/test/alter.test +++ b/test/alter.test @@ -11,7 +11,7 @@ # This file implements regression tests for SQLite library. The # focus of this script is testing the ALTER TABLE statement. # -# $Id: alter.test,v 1.18 2007/02/24 11:52:55 drh Exp $ +# $Id: alter.test,v 1.19 2007/04/06 02:32:34 drh Exp $ # set testdir [file dirname $argv0] @@ -625,10 +625,11 @@ do_test alter-7.1 { execsql { CREATE TABLE t1(a TEXT COLLATE BINARY); ALTER TABLE t1 ADD COLUMN b INTEGER COLLATE NOCASE; - INSERT INTO t1 VALUES(1,'2'); + INSERT INTO t1 VALUES(1,'-2'); + INSERT INTO t1 VALUES(5.4e-8,'5.4e-8'); SELECT typeof(a), a, typeof(b), b FROM t1; } -} {text 1 integer 2} +} {text 1 integer -2 text 5.4e-8 real 5.4e-08} # Make sure that when a column is added by ALTER TABLE ADD COLUMN and has # a default value that the default value is used by aggregate functions. |