Import SQLite 3.10.2.

third_party/sqlite/src/test/e_createtable.test

 # 2010 September 25
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 355 matching lines @@
 }
 do_createtable_tests 1.1.2 {
   1    "CREATE TABLE sqlit_abc(a, b, c)"         {}
   2    "CREATE TABLE temp.sqlitehelloworld(x)"   {}
   3    {CREATE TABLE auxa."sqlite"(x, y)}        {}
   4    {CREATE TABLE auxb."sqlite-"(z)}          {}
   5    {CREATE TABLE "SQLITE-TBL"(z)}            {}
 }
 
 
-# EVIDENCE-OF: R-10195-31023 If a <database-name> is specified, it
-# must be either "main", "temp", or the name of an attached database.
+# EVIDENCE-OF: R-18448-33677 If a schema-name is specified, it must be
+# either "main", "temp", or the name of an attached database.
 #
 # EVIDENCE-OF: R-39822-07822 In this case the new table is created in
 # the named database.
 #
 #   Test cases 1.2.* test the first of the two requirements above. The
 #   second is verified by cases 1.3.*.
 #
 do_createtable_tests 1.2.1 -error {
   unknown database %s
 } {
@@ skipping 27 matching lines @@
 drop_all_tables
 do_createtable_tests 1.4 -tclquery {
   unset -nocomplain X
   array set X [table_list]
   list $X(main) $X(temp) $X(auxa) $X(auxb)
 } {
   1    "CREATE TEMP TABLE t1(a, b)"      {{} t1 {} {}}
   2    "CREATE TEMPORARY TABLE t2(a, b)" {{} {t1 t2} {} {}}
 }
 
-# EVIDENCE-OF: R-49439-47561 It is an error to specify both a
-# <database-name> and the TEMP or TEMPORARY keyword, unless the
-# <database-name> is "temp".
+# EVIDENCE-OF: R-23976-43329 It is an error to specify both a
+# schema-name and the TEMP or TEMPORARY keyword, unless the schema-name
+# is "temp".
 #
 drop_all_tables
 do_createtable_tests 1.5.1 -error {
   temporary table name must be unqualified
 } {
   1    "CREATE TEMP TABLE main.t1(a, b)"        {}
   2    "CREATE TEMPORARY TABLE auxa.t2(a, b)"   {}
   3    "CREATE TEMP TABLE auxb.t3(a, b)"        {}
   4    "CREATE TEMPORARY TABLE main.xxx(x)"     {}
 }
 drop_all_tables
 do_createtable_tests 1.5.2 -tclquery {
   unset -nocomplain X
   array set X [table_list]
   list $X(main) $X(temp) $X(auxa) $X(auxb)
 } {
   1    "CREATE TEMP TABLE temp.t1(a, b)"        {{} t1 {} {}}
   2    "CREATE TEMPORARY TABLE temp.t2(a, b)"   {{} {t1 t2} {} {}}
   3    "CREATE TEMP TABLE TEMP.t3(a, b)"        {{} {t1 t2 t3} {} {}}
   4    "CREATE TEMPORARY TABLE TEMP.xxx(x)"     {{} {t1 t2 t3 xxx} {} {}}
 }
 
-# EVIDENCE-OF: R-00917-09393 If no database name is specified and the
-# TEMP keyword is not present then the table is created in the main
-# database.
+# EVIDENCE-OF: R-31997-24564 If no schema name is specified and the TEMP
+# keyword is not present then the table is created in the main database.
 #
 drop_all_tables
 do_createtable_tests 1.6 -tclquery {
   unset -nocomplain X
   array set X [table_list]
   list $X(main) $X(temp) $X(auxa) $X(auxb)
 } {
   1    "CREATE TABLE t1(a, b)"   {t1 {} {} {}}
   2    "CREATE TABLE t2(a, b)"   {{t1 t2} {} {} {}}
   3    "CREATE TABLE t3(a, b)"   {{t1 t2 t3} {} {} {}}
@@ skipping 1481 matching lines @@
   1   "INSERT INTO t12 DEFAULT VALUES"                {integer 1}
   2   "INSERT INTO t12(y)   VALUES(5)"                {integer 2}
   3   "INSERT INTO t12(x,y) VALUES(NULL, 10)"         {integer 3}
   4   "INSERT INTO t12(x,y) SELECT NULL, 15 FROM t12" 
       {integer 4 integer 5 integer 6}
   5   "INSERT INTO t12(y) SELECT 20 FROM t12 LIMIT 3"
       {integer 7 integer 8 integer 9}
 }
 
 finish_test