Lines Matching refs:t2
201 proc te_tbljoin {db t1 t2 args} {
202 te_join [te_read_tbl $db $t1] [te_read_tbl $db $t2] {*}$args
257 set t2 [lindex $row2 $idx2 0]
262 te_apply_affinity $affinity t2 v2
264 if {$t1 == "NULL" || $t2 == "NULL"} { return 0 }
266 if {$nocase && $t2 == "TEXT"} { set v2 [string tolower $v2] }
269 set res [expr {$t1 == $t2 && [string equal $v1 $v2]}]
315 CREATE TABLE t2(a, b);
324 INSERT INTO t2 VALUES(1, 'A');
325 INSERT INTO t2 VALUES(2, NULL);
326 INSERT INTO t2 VALUES(5, 'E');
327 INSERT INTO t2 VALUES(NULL, NULL);
328 INSERT INTO t2 VALUES(3, 'C');
338 e_select-2.1.3 { CREATE INDEX i1 ON t2(a) }
358 test_join $tn.1.1 "t1, t2" {t1 t2}
359 test_join $tn.1.2 "t1 INNER JOIN t2" {t1 t2}
360 test_join $tn.1.3 "t1 CROSS JOIN t2" {t1 t2}
361 test_join $tn.1.4 "t1 JOIN t2" {t1 t2}
362 test_join $tn.1.5 "t2, t3" {t2 t3}
363 test_join $tn.1.6 "t2 INNER JOIN t3" {t2 t3}
364 test_join $tn.1.7 "t2 CROSS JOIN t3" {t2 t3}
365 test_join $tn.1.8 "t2 JOIN t3" {t2 t3}
366 test_join $tn.1.9 "t2, t2 AS x" {t2 t2}
367 test_join $tn.1.10 "t2 INNER JOIN t2 AS x" {t2 t2}
368 test_join $tn.1.11 "t2 CROSS JOIN t2 AS x" {t2 t2}
369 test_join $tn.1.12 "t2 JOIN t2 AS x" {t2 t2}
376 test_join $tn.2.1 "t1, t2 ON (t1.a=t2.a)" {t1 t2 -on {te_equals a a}}
377 test_join $tn.2.2 "t2, t1 ON (t1.a=t2.a)" {t2 t1 -on {te_equals a a}}
378 test_join $tn.2.3 "t2, t1 ON (1)" {t2 t1 -on te_true}
379 test_join $tn.2.4 "t2, t1 ON (NULL)" {t2 t1 -on te_false}
380 test_join $tn.2.5 "t2, t1 ON (1.1-1.1)" {t2 t1 -on te_false}
381 test_join $tn.2.6 "t1, t2 ON (1.1-1.0)" {t1 t2 -on te_true}
384 test_join $tn.3 "t1 LEFT JOIN t2 ON (t1.a=t2.a)" {t1 t2 -left -on {te_equals a a}}
385 test_join $tn.4 "t1 LEFT JOIN t2 USING (a)" {
386 t1 t2 -left -using a -on {te_equals a a}
388 test_join $tn.5 "t1 CROSS JOIN t2 USING(b, a)" {
389 t1 t2 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
391 test_join $tn.6 "t1 NATURAL JOIN t2" {
392 t1 t2 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
394 test_join $tn.7 "t1 NATURAL INNER JOIN t2" {
395 t1 t2 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
397 test_join $tn.8 "t1 NATURAL CROSS JOIN t2" {
398 t1 t2 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
400 test_join $tn.9 "t1 NATURAL INNER JOIN t2" {
401 t1 t2 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
403 test_join $tn.10 "t1 NATURAL LEFT JOIN t2" {
404 t1 t2 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
406 test_join $tn.11 "t1 NATURAL LEFT OUTER JOIN t2" {
407 t1 t2 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
409 test_join $tn.12 "t2 NATURAL JOIN t1" {
410 t2 t1 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
412 test_join $tn.13 "t2 NATURAL INNER JOIN t1" {
413 t2 t1 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
415 test_join $tn.14 "t2 NATURAL CROSS JOIN t1" {
416 t2 t1 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
418 test_join $tn.15 "t2 NATURAL INNER JOIN t1" {
419 t2 t1 -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
421 test_join $tn.16 "t2 NATURAL LEFT JOIN t1" {
422 t2 t1 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
424 test_join $tn.17 "t2 NATURAL LEFT OUTER JOIN t1" {
425 t2 t1 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
427 test_join $tn.18 "t1 LEFT JOIN t2 USING (b)" {
428 t1 t2 -left -using b -on {te_equals b b}
466 te_tbljoin db t3 t2 -left -using {b} -on {te_equals -nocase b b}
470 te_read_sql db "SELECT * FROM t3 NATURAL LEFT JOIN t2 NATURAL JOIN t1"
476 te_read_sql db "SELECT * FROM (t3 NATURAL LEFT JOIN t2) NATURAL JOIN t1"
482 te_read_sql db "SELECT * FROM (t3 NATURAL LEFT JOIN t2) NATURAL JOIN t1"
484 te_read_sql db "SELECT * FROM t3 NATURAL LEFT JOIN (t2 NATURAL JOIN t1)"
487 set t2_natural_join_t1 [te_tbljoin db t2 t1 -using {a b} \
492 te_read_sql db "SELECT * FROM t3 NATURAL LEFT JOIN (t2 NATURAL JOIN t1)"
517 1 "SELECT * FROM t2" "SELECT * FROM t1 JOIN %ss%"
520 2 "SELECT * FROM t2" "SELECT * FROM t1 JOIN %ss% AS x ON (t1.a=x.a)"
523 3 "SELECT * FROM t2" "SELECT * FROM %ss% AS x JOIN t1 ON (t1.a=x.a)"
526 4 "SELECT * FROM t1, t2" "SELECT * FROM %ss% AS x JOIN t3"
529 5 "SELECT * FROM t1, t2" "SELECT * FROM %ss% NATURAL JOIN t3"
532 6 "SELECT * FROM t1, t2" "SELECT * FROM t3 NATURAL JOIN %ss%"
535 7 "SELECT * FROM t1, t2" "SELECT * FROM t3 NATURAL LEFT JOIN %ss%"