AryaWu/sqlite

1# 2011 June 232#3#    May you do good and not evil.4#    May you find forgiveness for yourself and forgive others.5#    May you share freely, never taking more than you give.6#7#***********************************************************************8#9# This file contains tests for SQLite. Specifically, it tests that SQLite10# does not crash and an error is returned if localhost() fails. This 11# is the problem reported by ticket 91e2e8ba6f.12#13 14set testdir [file dirname $argv0]15source $testdir/tester.tcl16 17set testprefix tkt-91e2e8ba6f18 19 20do_execsql_test 1.1 {21  CREATE TABLE t1(x INTEGER, y REAL);22  INSERT INTO t1 VALUES(11, 11);23} {}24 25do_execsql_test 1.2 {26  SELECT x/10, y/10 FROM t1;27} {1 1.1}28 29do_execsql_test 1.3 {30  SELECT x/10, y/10 FROM (SELECT * FROM t1);31} {1 1.1}32 33do_execsql_test 1.4 {34  SELECT x/10, y/10 FROM (SELECT * FROM t1 LIMIT 5 OFFSET 0);35} {1 1.1}36 37do_execsql_test 1.5 {38  SELECT x/10, y/10 FROM (SELECT * FROM t1 LIMIT 5 OFFSET 0) LIMIT 5 OFFSET 0;39} {1 1.1}40 41do_execsql_test 1.6 {42  SELECT a.x/10, a.y/10 FROM 43    (SELECT * FROM t1 LIMIT 5 OFFSET 0) AS a, t1 AS b WHERE a.x = b.x44  LIMIT 5 OFFSET 0;45} {1 1.1}46 47do_execsql_test 1.7 {48  CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 5;49  SELECT a.x/10, a.y/10 FROM v1 AS a, t1 AS b WHERE a.x = b.x LIMIT 5 OFFSET 0;50} {1 1.1}51 52finish_test53