Lines Matching refs:a
4 # a legal notice, here is a blessing:
125 CREATE TABLE hh(a, b, c);
133 CREATE INDEX hh_ab ON hh(a, b);
137 SELECT c FROM hh WHERE (a, b) = (SELECT 'abc', 1);
140 SELECT c FROM hh WHERE (a, b) = (SELECT 'abc' COLLATE nocase, 1);
143 SELECT c FROM hh WHERE a = (SELECT 'abc' COLLATE nocase) AND b = (SELECT 1);
146 SELECT c FROM hh WHERE +a = (SELECT 'abc' COLLATE nocase) AND b = (SELECT 1);
149 SELECT c FROM hh WHERE a = (SELECT 'abc') COLLATE nocase AND b = (SELECT 1);
152 SELECT c FROM hh WHERE (a, b) = (SELECT 'abc', 1) COLLATE nocase;
155 SELECT c FROM hh WHERE (a, b) = 1;
158 SELECT c FROM hh WHERE (a COLLATE nocase, b) = (SELECT 'def', 2);
161 SELECT c FROM hh WHERE (a COLLATE nocase, b) IS NOT (SELECT 'def', 2);
164 SELECT c FROM hh WHERE (b, a) = (SELECT 2, 'def');
198 CREATE TABLE j1(a);
201 SELECT * FROM j1 WHERE (select min(a) FROM j1) IN (?, ?, ?)
205 CREATE TABLE t2(a INTEGER PRIMARY KEY, b, c);
214 1 "(a, b) > (2, 1)" {2 3 4 5}
215 2 "(a, b) > (2, 2)" {3 4 5}
216 3 "(a, b) < (4, 5)" {1 2 3 4}
217 4 "(a, b) < (4, 3)" {1 2 3}
224 CREATE TABLE t3(a TEXT,b TEXT,c TEXT,d TEXT,e TEXT,f TEXT);
227 SELECT a FROM t3
229 AND (a,b,e) IN (SELECT 'a','b','d' FROM dual);
233 CREATE TABLE t11(a);
234 SELECT * FROM t11 WHERE (a,a)<=1;
237 SELECT * FROM t11 WHERE (a,a)<1;
240 SELECT * FROM t11 WHERE (a,a)>=1;
243 SELECT * FROM t11 WHERE (a,a)>1;
246 SELECT * FROM t11 WHERE (a,a)==1;
249 SELECT * FROM t11 WHERE (a,a)<>1;
252 SELECT * FROM t11 WHERE (a,a) IS 1;
255 SELECT * FROM t11 WHERE (a,a) IS NOT 1;
259 # Incorrect result from a LEFT JOIN with a row-value constraint
263 CREATE TABLE t1(a INT,b INT); INSERT INTO t1 VALUES(1,2);
266 SELECT *,'x' FROM t1 LEFT JOIN t2 ON (a,b)=(x,y);
270 SELECT t1.*, t2.* FROM t2 RIGHT JOIN t1 ON (a,b)=(x,y);
273 SELECT t1.*, t2.* FROM t1 FULL JOIN t2 ON (a,b)=(x,y)
274 ORDER BY coalesce(a,x);
310 CREATE TABLE x1(a PRIMARY KEY, b);
311 CREATE TABLE x2(a INTEGER PRIMARY KEY, b);
318 4 0 "SELECT * FROM (SELECT (a, b) AS c FROM x1), x2 WHERE c=a"
319 5 0 "SELECT * FROM (SELECT a AS c, (1, 2, 3) FROM x1), x2 WHERE c=a"
337 UPDATE x1 SET a=(SELECT * FROM (SELECT b,2))<3;
340 UPDATE x1 SET a=NULL WHERE a<(SELECT * FROM (SELECT b,2));
343 DELETE FROM x1 WHERE a<(SELECT * FROM (SELECT b,2));
346 INSERT INTO x1(a,b) VALUES(1,(SELECT * FROM (SELECT 1,2))<3);
355 CREATE TABLE t16a(a,b,c);
360 UPDATE t16a SET (a,b,c)=(SELECT new.x,new.x+1,new.x+2);
371 CREATE TABLE t16c(a, b, c, d, e);
372 INSERT INTO t16c VALUES(1, 'a', 'b', 'c', 'd');
375 WHERE a = new.a-1;
379 } {1 a b c d}
393 CREATE TRIGGER t16c1 AFTER UPDATE ON t16c WHEN new.a>1 BEGIN
395 SELECT b, c FROM t16c WHERE a = new.a-1
397 SELECT d, e FROM t16c WHERE a = new.a-1
398 ) WHERE a = new.a-1;
401 UPDATE t16c SET a=a WHERE a=3;
410 CREATE TABLE b1(a, b);
416 WHERE b2.x=b1.a AND (b1.a, 2)
421 CREATE TABLE b3 ( a, b, PRIMARY KEY (a, b) );
422 CREATE TABLE b4 ( a );
423 CREATE TABLE b5 ( a, b );
430 SELECT * FROM b3 WHERE (SELECT b3.a, b3.b) IN ( SELECT a, b FROM b5 )
433 SELECT * FROM b3 WHERE (VALUES(b3.a, b3.b)) IN ( SELECT a, b FROM b5 );
436 SELECT * FROM b3 WHERE (b3.a, b3.b) IN ( SELECT a, b FROM b5 );
439 SELECT * FROM b3 JOIN b4 ON b4.a = b3.a
440 WHERE (SELECT b3.a, b3.b) IN ( SELECT a, b FROM b5 );
443 SELECT * FROM b3 JOIN b4 ON b4.a = b3.a
444 WHERE (VALUES(b3.a, b3.b)) IN ( SELECT a, b FROM b5 );
447 SELECT * FROM b3 JOIN b4 ON b4.a = b3.a
448 WHERE (b3.a, b3.b) IN ( SELECT a, b FROM b5 );
453 # Incorrect result from a row-value comparison in the WHERE clause.
457 CREATE TABLE t1(a INTEGER PRIMARY KEY,b);
458 INSERT INTO t1(a,b) VALUES(1,11),(2,22),(3,33),(4,44);
459 SELECT * FROM t1 WHERE (a,b)>(0,0) ORDER BY a;
462 SELECT * FROM t1 WHERE (a,b)>=(0,0) ORDER BY a;
465 SELECT * FROM t1 WHERE (a,b)<(5,0) ORDER BY a DESC;
468 SELECT * FROM t1 WHERE (a,b)<=(5,0) ORDER BY a DESC;
471 SELECT * FROM t1 WHERE (a,b)>(3,0) ORDER BY a;
474 SELECT * FROM t1 WHERE (a,b)>=(3,0) ORDER BY a;
477 SELECT * FROM t1 WHERE (a,b)<(3,0) ORDER BY a DESC;
480 SELECT * FROM t1 WHERE (a,b)<=(3,0) ORDER BY a DESC;
483 SELECT * FROM t1 WHERE (a,b)>(3,32) ORDER BY a;
486 SELECT * FROM t1 WHERE (a,b)>(3,33) ORDER BY a;
489 SELECT * FROM t1 WHERE (a,b)>=(3,33) ORDER BY a;
492 SELECT * FROM t1 WHERE (a,b)>=(3,34) ORDER BY a;
495 SELECT * FROM t1 WHERE (a,b)<(3,34) ORDER BY a DESC;
498 SELECT * FROM t1 WHERE (a,b)<(3,33) ORDER BY a DESC;
501 SELECT * FROM t1 WHERE (a,b)<=(3,33) ORDER BY a DESC;
504 SELECT * FROM t1 WHERE (a,b)<=(3,32) ORDER BY a DESC;
507 SELECT * FROM t1 WHERE (0,0)<(a,b) ORDER BY a;
510 SELECT * FROM t1 WHERE (0,0)<=(a,b) ORDER BY a;
513 SELECT * FROM t1 WHERE (5,0)>(a,b) ORDER BY a DESC;
516 SELECT * FROM t1 WHERE (5,0)>=(a,b) ORDER BY a DESC;
519 SELECT * FROM t1 WHERE (3,0)<(a,b) ORDER BY a;
522 SELECT * FROM t1 WHERE (3,0)<=(a,b) ORDER BY a;
525 SELECT * FROM t1 WHERE (3,0)>(a,b) ORDER BY a DESC;
528 SELECT * FROM t1 WHERE (3,0)>=(a,b) ORDER BY a DESC;
531 SELECT * FROM t1 WHERE (3,32)<(a,b) ORDER BY a;
534 SELECT * FROM t1 WHERE (3,33)<(a,b) ORDER BY a;
537 SELECT * FROM t1 WHERE (3,33)<=(a,b) ORDER BY a;
540 SELECT * FROM t1 WHERE (3,34)<=(a,b) ORDER BY a;
543 SELECT * FROM t1 WHERE (3,34)>(a,b) ORDER BY a DESC;
546 SELECT * FROM t1 WHERE (3,33)>(a,b) ORDER BY a DESC;
549 SELECT * FROM t1 WHERE (3,33)>=(a,b) ORDER BY a DESC;
552 SELECT * FROM t1 WHERE (3,32)>=(a,b) ORDER BY a DESC;
562 # Assertion fault when doing row-value operations on a primary key
567 CREATE TABLE t1(a,b,PRIMARY KEY(b,b));
569 SELECT * FROM t1 WHERE (a,b) IN (VALUES(1,2));
590 INSERT INTO t0 VALUES('a', 'A');
614 INSERT INTO t0(c0) VALUES('a');
679 # dbsqlfuzz find of a NEVER().
688 CREATE TABLE t2(a, b);
695 UPDATE t2 SET (a,b)=(
708 CREATE TABLE t2(a,b,c,d,e,PRIMARY KEY(a,b))WITHOUT ROWID;
710 …a)=(SELECT EXISTS(SELECT 1 IN(SELECT max( 1 IN(SELECT x ORDER BY 1)) OVER(PARTITION BY sum((SELECT…
716 CREATE TABLE a(a1 PRIMARY KEY,a2);
717 INSERT INTO a VALUES(1,5);
719 SELECT * FROM a LEFT JOIN b ON b2=NULL AND b2=5 WHERE (b1,substr(b.b1,1,1))==(SELECT 1024,'b');
722 SELECT * FROM b RIGHT JOIN a ON b2=NULL AND b2=5 WHERE (b1,substr(b.b1,1,1))==(SELECT 1024,'b');
725 CREATE TABLE t1(a);
729 SELECT * FROM t1 LEFT JOIN t2 ON b=NULL WHERE (c,d)==(SELECT 123, 456+a);
732 SELECT * FROM t2 RIGHT JOIN t1 ON b=NULL WHERE (c,d)==(SELECT 123, 456+a);
738 CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c INT);
740 INSERT INTO t1(a,b,c) VALUES(500,654,456);
741 INSERT INTO t1(a,b,c) VALUES(501,655,456);
742 INSERT INTO t1(a,b,c) VALUES(502,654,122);
743 INSERT INTO t1(a,b,c) VALUES(503,654,221);
744 INSERT INTO t1(a,b,c) VALUES(601,654,122);
747 SELECT a FROM (
748 SELECT t1.a FROM t2, t1
751 WHERE a=1234 OR a<=567;
759 CREATE TABLE t1(a INT, b INT PRIMARY KEY) WITHOUT ROWID;
760 INSERT INTO t1(a, b) VALUES (0, 1),(15,-7),(3,100);
764 SELECT * FROM t1 WHERE (b,a) BETWEEN (0,5) AND (99,-2);
767 SELECT * FROM t1 WHERE (b,a) BETWEEN (-8,5) AND (0,-2);
770 SELECT * FROM t1 WHERE (b,a) BETWEEN (3,5) AND (100,4);
773 SELECT * FROM t1 WHERE (b,a) BETWEEN (3,5) AND (100,2);
776 SELECT * FROM t1 WHERE (a,b) BETWEEN (-2,99) AND (1,0);
779 SELECT * FROM t1 WHERE (a,b) BETWEEN (14,99) AND (16,0);
782 SELECT * FROM t1 WHERE (a,b) BETWEEN (2,99) AND (4,0);