contrib/sqlite3/sqlite3.c

3632 **    SELECT eval('DELETE FROM t1') FROM t2;
71363     u64 t2 = t1;
71364     swapMixedEndianFloat(t2);
71365     assert( sizeof(r1)==sizeof(t2) && memcmp(&r1, &t2, sizeof(r1))==0 );
91033 **   sqlite_rename_parent('CREATE TABLE t1(a REFERENCES t2)', 't2', 't3')
102760 **   CREATE TABLE t2(b REFERENCES t1(a);
102764 ** "t2". Calling this function with "t2" as the argument would return a
102765 ** NULL pointer (as there are no FK constraints for which t2 is the parent
110866 **    SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.b AND t1.x=5
110869 ** term until after the t2 loop of the join.  In that way, a
110870 ** NULL t2 row will be inserted whenever t1.x!=5.  If we do not
112676 **     SELECT a FROM t1 UNION SELECT b FROM t2 UNION SELECT c FROM t3
112682 **      `----->  SELECT b FROM t2
112688 ** pPrior will be the t2 query.  p->op will be TK_UNION in this case.
113917   **         t1 LEFT OUTER JOIN (t2 JOIN t3)
113921   **         (t1 LEFT OUTER JOIN t2) JOIN t3
113930   **         t1 LEFT OUTER JOIN (SELECT * FROM t2 WHERE t2.x>0)
113934   **         (t1 LEFT OUTER JOIN t2) WHERE t2.x>0
113936   ** But the t2.x>0 test will always fail on a NULL row of t2, which
114420 **    SELECT ... FROM t1 EXCEPT SELECT ... FROM t2 ORDER BY .. COLLATE ...
114424 **    SELECT * FROM (SELECT ... FROM t1 EXCEPT SELECT ... FROM t2)
117076     **     INSERT OR REPLACE INTO t2 VALUES(new.a, new.b);
117079     **   INSERT INTO t1 ... ;            -- insert into t2 uses REPLACE policy
117080     **   INSERT OR IGNORE INTO t1 ... ;  -- insert into t2 uses IGNORE policy
120659 ** Consider the term t2.z='ok' in the following queries:
120661 **   (1)  SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.x WHERE t2.z='ok'
120662 **   (2)  SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.x AND t2.z='ok'
120663 **   (3)  SELECT * FROM t1, t2 WHERE t1.a=t2.x AND t2.z='ok'
120665 ** The t2.z='ok' is disabled in the in (2) because it originates
120876 **   SELECT ... FROM t1 AS t2, t1 WHERE t1.a = t2.b;
120879 ** the right hand side of the equality constraint (t2.b) has BLOB/NONE affinity,
120880 ** no conversion should be attempted before using a t2.b value as part of
122128   ** Example: If the WHERE clause contains "t1.a=t2.b" and "t2.b=123"
122129   ** and we are coding the t1 loop and the t2 loop has not yet coded,
122130   ** then we cannot use the "t1.a=t2.b" constraint, but we can code
122626 **     (A)     t1.x=t2.y OR t1.x=t2.z OR t1.y=15 OR t1.z=t3.a+5
122628 **     (C)     t1.x=t2.y OR (t1.x=t2.z AND t1.y=15)
122851           /* This term must be of the form t1.a==t2.b where t2 is in the
122853           ** or follwed by an inverted copy (t2.b==t1.a).  Skip this term
126479 **   ... FROM t1, t2 LEFT JOIN t3, t4, vt CROSS JOIN t5, t6;
126481 ** then mPrereq corresponds to (t1, t2) and mUnusable to (t5, t6).
127576 **       SELECT * FROM t1, t2, t3 WHERE ...;
127581 **        foreach row2 in t2 do      |-- by sqlite3WhereBegin()
127595 ** number pTabList->a[0].iCursor.  t2 uses the cursor pTabList->a[1].iCursor.
127620 ** An outer join of tables t1 and t2 is conceptally coded as follows:
127624 **      foreach row2 in t2 do
162335 **     "data0123_t2" -> "t2"