1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sqlite3api/TEST/TclScript/tkt2450.test Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,48 @@
1.4 +# 2007 June 24
1.5 +#
1.6 +# The author disclaims copyright to this source code. In place of
1.7 +# a legal notice, here is a blessing:
1.8 +#
1.9 +# May you do good and not evil.
1.10 +# May you find forgiveness for yourself and forgive others.
1.11 +# May you share freely, never taking more than you give.
1.12 +#
1.13 +#***********************************************************************
1.14 +#
1.15 +# This file is to test that ticket #2450 has been fixed.
1.16 +#
1.17 +# $Id: tkt2450.test,v 1.1 2007/06/24 06:32:18 danielk1977 Exp $
1.18 +#
1.19 +
1.20 +set testdir [file dirname $argv0]
1.21 +source $testdir/tester.tcl
1.22 +
1.23 +do_test tkt2450-1 {
1.24 + execsql {
1.25 + CREATE TABLE "t a" ("""cb""");
1.26 + INSERT INTO "t a" ("""cb""") VALUES (1);
1.27 + SELECT """cb""" FROM "t a";
1.28 + }
1.29 +} {1}
1.30 +
1.31 +do_test tkt2450-2 {
1.32 + execsql {
1.33 + SELECT * FROM "t a";
1.34 + }
1.35 +} {1}
1.36 +
1.37 +do_test tkt2450-3 {
1.38 + execsql {
1.39 + SELECT "t a".* FROM "t a";
1.40 + }
1.41 +} {1}
1.42 +
1.43 +do_test tkt2450-3 {
1.44 + execsql {
1.45 + CREATE TABLE t1(a);
1.46 + INSERT INTO t1 VALUES(2);
1.47 + SELECT * FROM "t a", t1;
1.48 + }
1.49 +} {1 2}
1.50 +
1.51 +finish_test