Lines Matching refs:a
4 # a legal notice, here is a blessing:
33 # Test the creation and use of tables that have a large number
123 # Here's a test for a bug found by Joel Lucsy. The code below
128 CREATE TABLE t1(a);
136 # Here's a test for yet another bug found by Joel Lucsy. The code
142 CREATE TABLE t2(a);
143 INSERT INTO t2 VALUES('This is a long string to use up a lot of disk -');
144 UPDATE t2 SET a=a||a||a||a;
145 INSERT INTO t2 SELECT '1 - ' || a FROM t2;
146 INSERT INTO t2 SELECT '2 - ' || a FROM t2;
147 INSERT INTO t2 SELECT '3 - ' || a FROM t2;
148 INSERT INTO t2 SELECT '4 - ' || a FROM t2;
149 INSERT INTO t2 SELECT '5 - ' || a FROM t2;
150 INSERT INTO t2 SELECT '6 - ' || a FROM t2;
156 # Make sure we actually see a semicolon or end-of-file in the SQL input
157 # before executing a command. Thus if "WHERE" is misspelled on an UPDATE,
162 CREATE TABLE t3(a,b);
165 UPDATE t3 SET a=0 WHEREwww b=2;
170 SELECT * FROM t3 ORDER BY a;
176 # the parser first detects a syntax error, the error handling routine
213 a TYPE PRIMARY KEY,
221 a INTEGER PRIMARY KEY,
228 CREATE TABLE t5(a,b,c,PRIMARY KEY(a,b));
230 SELECT * FROM t5 ORDER BY a;
237 } {1 {UNIQUE constraint failed: t5.a, t5.b}}
245 SELECT * FROM t5 ORDER BY a;
271 CREATE TABLE t1(a unique not null, b unique not null);
272 INSERT INTO t1 VALUES('a',1234567890123456789);
277 } {0 {a 1234567890123456789 b 1234567891123456789 c 1234567892123456789}}
282 # 2005-07-16: There is no longer a limit on the number of terms in a
284 # that use a large number of terms in the WHERE clause.
326 # Make sure the initialization works even if a database is opened while
333 execsql {UPDATE t1 SET a=0 WHERE 0}
348 # all comparisions where numeric if either operand looked like a number.
361 CREATE TABLE t6(a INT UNIQUE, b TEXT UNIQUE);
402 # identifiers can be used as a collating sequence. Collation is by text
410 # SELECT * FROM t6 ORDER BY a COLLATE unknown;
434 # There was a problem with realloc() in the OP_MemStore operation of
476 # of a current directory.
479 # Make sure a database connection still works after changing the
489 do_test misc1-14.2a {
490 execsql {UPDATE t1 SET a=a||'x' WHERE 0}
494 execsql {UPDATE t1 SET a=a||'y' WHERE 1}
532 # Test for memory leaks when a CREATE TABLE containing a primary key
538 CREATE TABLE test(a integer, primary key(a));
543 CREATE TABLE test(a integer, primary key(a));
548 CREATE TABLE test2(a text primary key, b text, primary key(a,b));
554 SELECT rowid, a FROM test;
560 SELECT rowid, a FROM test;
566 SELECT rowid, a FROM test;
596 # 2014-01-10: In a CREATE TABLE AS, if one or more of the column names
608 # 2015-05-20: CREATE TABLE AS should not store INT value is a TEXT
644 # 2015-03-22: NULL pointer dereference after a syntax error
658 # 2015-04-19: NULL pointer dereference on a corrupt schema
694 UPDATE sqlite_master SET sql='CREATE table y(a TEXT, a TEXT)';
702 # At one point, running this would read one byte passed the end of a
713 …a,b,c,d,e, PRIMARY KEY(a,b,c,d,c,a,b,b,c,d,c,a,b,c,e,c,d,c,a,b,b,c,d,c,a,b,c,e,d,d,c,a,b,b,c,d,c,d…
714 …a,b,b,c,a,b,c,e,d,d,c,a,b,b,c,d,d,c,a,b,c,e,d,c,d,c,a,b,c,e,c,d,c,d,c,a,b,b,c,d,c,a,b,c,e,c,d,c,a,…
715 } {1 {'k' is not a function}}
724 CREATE TABLE abc(a, b, c);
731 # are undocumented. <<--- Not so. There is a long-standing requirement
745 CREATE TABLE dup1(a,b,c);
746 INSERT INTO dup1(a,b,c,a,b,c) VALUES(1,2,3,4,5,6);
747 SELECT a,b,c FROM dup1;
750 UPDATE dup1 SET a=7, b=8, c=9, a=10, b=11, c=12;
751 SELECT a,b,c FROM dup1;