mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-13 12:28:30 +00:00
406 lines
9.1 KiB
Plaintext
406 lines
9.1 KiB
Plaintext
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 INNER JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 LEFT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
INNER JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
LEFT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
INNER JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
LEFT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|
|
|
|
SELECT *
|
|
FROM t1 RIGHT JOIN t2 ON true
|
|
RIGHT JOIN t3 ON t2.y IS NOT NULL
|
|
RIGHT JOIN t4 ON true
|
|
WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)
|
|
ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
|
|
|