Lines Matching refs:b

162     CREATE TABLE t3(a,b);
165     UPDATE t3 SET a=0 WHEREwww b=2;
214       b TYPE PRIMARY KEY
222       b TYPE PRIMARY KEY
228     CREATE TABLE t5(a,b,c,PRIMARY KEY(a,b));
237 } {1 {UNIQUE constraint failed: t5.a, t5.b}}
271     CREATE TABLE t1(a unique not null, b unique not null);
273     INSERT INTO t1 VALUES('b',1234567891123456789);
277 } {0 {a 1234567890123456789 b 1234567891123456789 c 1234567892123456789}}
361     CREATE TABLE t6(a INT UNIQUE, b TEXT UNIQUE);
493   do_test misc1-14.2b {
548     CREATE TABLE test2(a text primary key, b text, primary key(a,b));
713 …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,c…
714 …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,b,…
724   CREATE TABLE abc(a, b, c);
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;