Lines Matching refs:LEFT
249 SELECT * FROM t1 NATURAL LEFT JOIN t2;
253 # EVIDENCE-OF: R-52129-05406 you can say things like "OUTER LEFT NATURAL
254 # JOIN" which means the same as "NATURAL LEFT OUTER JOIN".
257 SELECT * FROM t1 OUTER LEFT NATURAL JOIN t2;
262 SELECT * FROM t1 NATURAL LEFT OUTER JOIN t2;
269 SELECT * FROM t1 NATURAL LEFT JOIN t2;
274 SELECT t1.* FROM t1 NATURAL LEFT JOIN t2;
279 SELECT t2.* FROM t1 NATURAL LEFT JOIN t2;
285 SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
297 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
302 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
307 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
364 SELECT * FROM t1 LEFT BOGUS JOIN t2;
366 } {1 {unknown join type: LEFT BOGUS}}
479 SELECT coalesce(t8.a,999) from t7 LEFT JOIN t8 on y=a;
501 SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
507 SELECT * FROM t9 LEFT JOIN (SELECT x, q FROM t10, t11 WHERE t10.y=t11.p)
514 SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );
519 # LEFT JOIN evaluate to NULL for rows where the LEFT JOIN does not
523 SELECT * FROM t9 LEFT JOIN (SELECT 44, p, q FROM t11) AS sub1 ON p=a
529 # Ticket #350 describes a scenario where LEFT OUTER JOIN does not
533 # To test the problem, we generate the same LEFT OUTER JOIN in two
555 SELECT * FROM t12 NATURAL LEFT JOIN t13
557 SELECT * FROM t12 NATURAL LEFT JOIN (SELECT * FROM t13 WHERE b>0);
565 SELECT * FROM t12 NATURAL LEFT JOIN t13
567 SELECT * FROM t12 NATURAL LEFT JOIN v13;
582 SELECT a FROM t21 LEFT JOIN t22 ON b=p WHERE q=
587 # Test a LEFT JOIN when the right-hand side of hte join is an empty
597 SELECT * FROM t23 LEFT JOIN t24;
602 SELECT * FROM t23 LEFT JOIN (SELECT * FROM t24);
716 # Test a problem with reordering tables following a LEFT JOIN.
729 SELECT * FROM aa LEFT JOIN bb, cc WHERE cc.c=aa.a;
736 SELECT * FROM aa LEFT JOIN bb, cc WHERE cc.c=aa.a;
746 LEFT JOIN (SELECT 1, * FROM (SELECT * FROM (SELECT 1)));
751 LEFT JOIN (SELECT 1, * FROM (SELECT * FROM (SELECT * FROM (SELECT 1)))) AS y
757 LEFT JOIN (SELECT cc+222, * FROM (SELECT * FROM (SELECT 333 cc)));
763 SELECT * FROM (SELECT 111) LEFT JOIN (SELECT c+222 FROM t1) GROUP BY 1;
766 SELECT * FROM (SELECT 111) LEFT JOIN (SELECT c+222 FROM t1);
770 LEFT JOIN (SELECT c+333 AS y FROM t1) ON x=y GROUP BY 1;
775 LEFT JOIN (SELECT c+333 AS y FROM t1) ON x=y;
784 LEFT JOIN (SELECT c+333 AS y FROM t1) ON x=y GROUP BY 1;
788 LEFT JOIN (SELECT c+333 AS y FROM t1) ON x=y GROUP BY 1;
793 LEFT JOIN (SELECT c+333 AS y FROM t1) ON x=y GROUP BY 1;
798 SELECT * FROM (SELECT 111) LEFT JOIN (SELECT c+222 FROM t1) GROUP BY 1;
812 SELECT *, '|' FROM t3 LEFT JOIN v2 ON a=x WHERE b=1;
815 SELECT *, '|' FROM t3 LEFT JOIN v2 ON a=x WHERE b+1=x;
818 SELECT *, '|' FROM t3 LEFT JOIN v2 ON a=x ORDER BY b;
834 LEFT JOIN (SELECT * FROM t2) AS x2 ON t1.id=x2.c2
835 LEFT JOIN t3 AS x3 ON x2.id=x3.c3;
839 # E.Pasma discovered that the LEFT JOIN strength reduction optimization
856 FROM t1 LEFT JOIN t2
861 FROM t1 LEFT JOIN t2
866 FROM t1 LEFT JOIN t2
871 FROM t1 LEFT JOIN t2
876 FROM t1 LEFT JOIN t2
890 LEFT JOIN (SELECT a AS a2, b AS b2 FROM t1)
894 LEFT JOIN (SELECT a AS a3, b AS b3 FROM t1)
898 LEFT JOIN (SELECT a AS a4, b AS b4 FROM t1)
902 LEFT JOIN (SELECT a AS a5, b AS b5 FROM t1)
908 # Error in join due to the LEFT JOIN strength reduction optimization.
917 FROM t1 LEFT JOIN t2 ON 0
922 # Ensure that constants that derive from the right-hand table of a LEFT JOIN
929 SELECT * FROM t1 LEFT JOIN (SELECT abs(1) AS y FROM t1) ON x WHERE NOT(y='a');
932 SELECT * FROM t1 LEFT JOIN (SELECT abs(1)+2 AS y FROM t1) ON x
941 CREATE VIEW v0 AS SELECT a FROM t1 LEFT JOIN t0;
950 SELECT * FROM t1 LEFT JOIN t0 WHERE NOT(a IS FALSE);
963 CREATE VIEW v0(c) AS SELECT t2.b FROM t1 LEFT JOIN t2;
971 SELECT * FROM t1 LEFT JOIN t2
975 SELECT * FROM t1 LEFT JOIN t2 WHERE (b IS NOT NULL) IS NOT NULL;
979 SELECT (b IS NOT NULL) IS NOT NULL FROM t1 LEFT JOIN t2
983 SELECT * FROM t1 LEFT JOIN t2 WHERE
990 # of the table of the index is the right-hand table of a LEFT JOIN.
998 SELECT * FROM t0 LEFT JOIN t1 WHERE NULL IN (c1);
1002 SELECT * FROM t0 LEFT JOIN t1 WHERE NULL IN (c1);
1007 # right table of a LEFT JOIN.
1016 SELECT 11, * FROM t1 LEFT JOIN t0 WHERE aa ISNULL;
1017 SELECT 12, * FROM t1 LEFT JOIN t0 WHERE +aa ISNULL;
1018 SELECT 13, * FROM t1 LEFT JOIN t0 ON aa ISNULL;
1019 SELECT 14, * FROM t1 LEFT JOIN t0 ON +aa ISNULL;
1021 SELECT 21, * FROM t1 LEFT JOIN t0 WHERE aa ISNULL;
1022 SELECT 22, * FROM t1 LEFT JOIN t0 WHERE +aa ISNULL;
1023 SELECT 23, * FROM t1 LEFT JOIN t0 ON aa ISNULL;
1024 SELECT 24, * FROM t1 LEFT JOIN t0 ON +aa ISNULL;
1027 # 2019-12-18 problem with a LEFT JOIN where the RHS is a view.
1037 SELECT DISTINCT c FROM t0 LEFT JOIN (SELECT a+1 AS c FROM t0) ORDER BY c ;
1049 FROM v0, t0 LEFT JOIN pragma_table_info('t0') AS vt0
1074 SELECT * FROM t2 LEFT JOIN t1 ON a=0 WHERE (x='x' OR x IS NULL);
1080 # of a LEFT JOIN.
1087 SELECT count(*) FROM v0 LEFT JOIN t0 ON v0.c0;
1112 SELECT b FROM t2 LEFT JOIN t1 ON c IN (SELECT x FROM t3)
1118 SELECT b FROM t2 LEFT JOIN t1 ON c IN (SELECT x FROM t3)
1123 WITH t99(b) AS (SELECT b FROM t2 LEFT JOIN t1 ON c IN (SELECT x FROM t3))
1129 SELECT b FROM t2 LEFT JOIN t1 ON c IN (SELECT x FROM t3)
1138 SELECT coalesce(b,3) FROM t2 AS x LEFT JOIN t1 ON c IN (SELECT x FROM t3)
1145 JOIN (SELECT coalesce(b,3) AS b2 FROM t2 AS x LEFT JOIN t1
1154 SELECT * FROM t2 JOIN (SELECT b FROM t2 LEFT JOIN t1
1165 SELECT * FROM t2 JOIN (SELECT b FROM t2 LEFT JOIN t1
1170 SELECT b FROM t2 AS x LEFT JOIN t1 ON c IN (SELECT x FROM t3)
1186 CREATE VIEW t3(a,b,c,d,e) AS SELECT * FROM t1 LEFT JOIN t2 ON d=c;
1206 # | `--SEARCH t2 USING INTEGER PRIMARY KEY (rowid=?) LEFT-JOIN