You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
1299 lines
57 KiB
Plaintext
1299 lines
57 KiB
Plaintext
DROP DATABASE IF EXISTS mcol641_joins_db;
|
|
CREATE DATABASE mcol641_joins_db;
|
|
USE mcol641_joins_db;
|
|
CREATE TABLE cs1 (d1 DECIMAL(38), d2 DECIMAL(37), id TINYINT);
|
|
CREATE TABLE cs2 (i1 SMALLINT, i2 MEDIUMINT, i3 INT, i4 BIGINT);
|
|
INSERT INTO cs1 VALUES
|
|
(99,0,1),
|
|
(255,254,2),
|
|
(254,253,3),
|
|
(252,253,4),
|
|
(65535,2147483647,5),
|
|
(65534,2147483646,6),
|
|
(65533,65532,7),
|
|
(2147483647,2147483636,8),
|
|
(2147483646,2147483635,9),
|
|
(2147483645,2147483634,10),
|
|
(2147483645,9223372036854775804,11),
|
|
(9223372036854775807,0,12),
|
|
(9223372036854775807,2147483627,13),
|
|
(9223372036854775806,2147483626,14),
|
|
(9223372036854775805,9223372036854775704,15);
|
|
INSERT INTO cs2 VALUES
|
|
(255,254,NULL,NULL),
|
|
(254,253,NULL,NULL),
|
|
(251,251,NULL,NULL),
|
|
(NULL,65535,NULL,NULL),
|
|
(NULL,65535,2147483647,NULL),
|
|
(NULL,65534,2147483646,NULL),
|
|
(NULL,0,2147483641,NULL),
|
|
(NULL,NULL,2147483647,NULL),
|
|
(NULL,NULL,2147483647,2147483636),
|
|
(NULL,NULL,2147483646,2147483635),
|
|
(NULL,NULL,0,2147483641),
|
|
(NULL,NULL,NULL,9223372036854775807),
|
|
(NULL,NULL,2147483627,9223372036854775807),
|
|
(NULL,NULL,2147483626,9223372036854775806),
|
|
(NULL,NULL,0,1);
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i2 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i2 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i3 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i3 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i4 AND cs2.i3 IS NOT NULL ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i4 AND cs2.i3 IS NOT NULL ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i1 AND cs1.d2 = cs2.i2 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i1 AND cs1.d2 = cs2.i2 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i2 AND cs1.d2 = cs2.i3 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i2 AND cs1.d2 = cs2.i3 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i3 AND cs1.d2 = cs2.i4 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i3 AND cs1.d2 = cs2.i4 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1 = cs2.i4 AND cs1.d2 = cs2.i3 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1 = cs2.i4 AND cs1.d2 = cs2.i3 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i1 ORDER BY id,i2;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i1 ORDER BY id,i2;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i2 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i2 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i3 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i3 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i4 AND s2.i3 IS NOT NULL ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i4 AND s2.i3 IS NOT NULL ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1 = cs2.i1-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1 = cs2.i1-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1 = cs2.i2-1 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1 = cs2.i2-1 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1 = cs2.i3-1 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1 = cs2.i3-1 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1 = cs2.i4-1 AND cs2.i3 IS NOT NULL ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1 = cs2.i4-1 AND cs2.i3 IS NOT NULL ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1= cs2.i1-1 AND cs1.d2-1= cs2.i2-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1= cs2.i1-1 AND cs1.d2-1= cs2.i2-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1= cs2.i2-1 AND cs1.d2-1= cs2.i3-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1= cs2.i2-1 AND cs1.d2-1= cs2.i3-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1= cs2.i3-1 AND cs1.d2-1= cs2.i4-1 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1= cs2.i3-1 AND cs1.d2-1= cs2.i4-1 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
SELECT cs1.*, cs2.* FROM cs1 INNER JOIN cs2 ON cs1.d1-1= cs2.i4-1 AND cs1.d2-1= cs2.i3-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT cs1.*, cs2.* FROM cs2 INNER JOIN cs1 ON cs1.d1-1= cs2.i4-1 AND cs1.d2-1= cs2.i3-1 ORDER BY id;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i1-1 ORDER BY id,i2;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i1-1 ORDER BY id,i2;
|
|
d1 d2 id i1 i2 i3 i4
|
|
255 254 2 255 254 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i2-1 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i2-1 ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i3-1 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i3-1 ORDER BY id,i2,i4;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 INNER JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i4-1 AND s2.i3 IS NOT NULL ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 INNER JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i4-1 AND s2.i3 IS NOT NULL ORDER BY id,i3;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
TRUNCATE cs1;
|
|
TRUNCATE cs2;
|
|
INSERT INTO cs1 VALUES
|
|
(99,0,1),
|
|
(255,254,2),
|
|
(254,253,3),
|
|
(252,253,4),
|
|
(-252,253,5),
|
|
(65535,2147483647,5),
|
|
(65534,2147483646,6),
|
|
(65533,65532,7),
|
|
(2147483647,2147483636,8),
|
|
(2147483646,2147483635,9),
|
|
(2147483645,2147483634,10),
|
|
(2147483645,9223372036854775804,11),
|
|
(9223372036854775807,0,12),
|
|
(9223372036854775807,2147483627,13),
|
|
(9223372036854775806,2147483626,14),
|
|
(9223372036854775805,9223372036854775704,15);
|
|
INSERT INTO cs2 VALUES
|
|
(255,254,NULL,NULL),
|
|
(254,253,NULL,NULL),
|
|
(251,251,NULL,NULL),
|
|
(-252,253,NULL,NULL),
|
|
(-250,253,NULL,NULL),
|
|
(NULL,65535,NULL,NULL),
|
|
(NULL,65535,2147483647,NULL),
|
|
(NULL,65534,2147483646,NULL),
|
|
(NULL,0,2147483641,NULL),
|
|
(NULL,NULL,2147483647,NULL),
|
|
(NULL,NULL,2147483647,2147483636),
|
|
(NULL,NULL,2147483646,2147483635),
|
|
(NULL,NULL,0,2147483641),
|
|
(NULL,NULL,NULL,9223372036854775807),
|
|
(NULL,NULL,2147483627,9223372036854775807),
|
|
(NULL,NULL,2147483626,9223372036854775806),
|
|
(NULL,NULL,0,1);
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i2 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 255 254 NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i2 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i4 AND cs2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i4 AND cs2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i1 AND cs1.d2 = cs2.i2 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i1 AND cs1.d2 = cs2.i2 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i2 AND cs1.d2 = cs2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i2 AND cs1.d2 = cs2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i3 AND cs1.d2 = cs2.i4 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i3 AND cs1.d2 = cs2.i4 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1 = cs2.i4 AND cs1.d2 = cs2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1 = cs2.i4 AND cs1.d2 = cs2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i2 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 255 254 NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i2 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i3 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1=s2.i4 AND s2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1=s2.i4 AND s2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1 = cs2.i1-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1 = cs2.i1-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1 = cs2.i2-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 255 254 NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1 = cs2.i2-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1 = cs2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1 = cs2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1 = cs2.i4-1 AND cs2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1 = cs2.i4-1 AND cs2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1= cs2.i1-1 AND cs1.d2-1= cs2.i2-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1= cs2.i1-1 AND cs1.d2-1= cs2.i2-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1= cs2.i2-1 AND cs1.d2-1= cs2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1= cs2.i2-1 AND cs1.d2-1= cs2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1= cs2.i3-1 AND cs1.d2-1= cs2.i4-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1= cs2.i3-1 AND cs1.d2-1= cs2.i4-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT cs1.*, cs2.* FROM cs1 LEFT JOIN cs2 ON cs1.d1-1= cs2.i4-1 AND cs1.d2-1= cs2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT cs1.*, cs2.* FROM cs2 LEFT JOIN cs1 ON cs1.d1-1= cs2.i4-1 AND cs1.d2-1= cs2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i1-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i1-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 -252 253 NULL NULL
|
|
254 253 3 254 253 NULL NULL
|
|
255 254 2 255 254 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i2-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 255 254 NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i2-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
254 253 3 255 254 NULL NULL
|
|
65534 2147483646 6 NULL 65534 2147483646 NULL
|
|
65535 2147483647 5 NULL 65535 2147483647 NULL
|
|
65535 2147483647 5 NULL 65535 NULL NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL NULL NULL
|
|
9223372036854775807 0 12 NULL NULL NULL NULL
|
|
9223372036854775807 2147483627 13 NULL NULL NULL NULL
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i3-1 ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
2147483646 2147483635 9 NULL 65534 2147483646 NULL
|
|
2147483646 2147483635 9 NULL NULL 2147483646 2147483635
|
|
2147483647 2147483636 8 NULL 65535 2147483647 NULL
|
|
2147483647 2147483636 8 NULL NULL 2147483647 2147483636
|
|
2147483647 2147483636 8 NULL NULL 2147483647 NULL
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483626 9223372036854775806
|
|
NULL NULL NULL NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs1)s1 LEFT JOIN (SELECT * FROM cs2)s2 ON s1.d1-1=s2.i4-1 AND s2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
-252 253 5 NULL NULL NULL NULL
|
|
2147483645 2147483634 10 NULL NULL NULL NULL
|
|
2147483645 9223372036854775804 11 NULL NULL NULL NULL
|
|
2147483646 2147483635 9 NULL NULL NULL NULL
|
|
2147483647 2147483636 8 NULL NULL NULL NULL
|
|
252 253 4 NULL NULL NULL NULL
|
|
254 253 3 NULL NULL NULL NULL
|
|
255 254 2 NULL NULL NULL NULL
|
|
65533 65532 7 NULL NULL NULL NULL
|
|
65534 2147483646 6 NULL NULL NULL NULL
|
|
65535 2147483647 5 NULL NULL NULL NULL
|
|
9223372036854775805 9223372036854775704 15 NULL NULL NULL NULL
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
99 0 1 NULL NULL NULL NULL
|
|
SELECT s1.*,s2.* FROM (SELECT * FROM cs2)s2 LEFT JOIN (SELECT * FROM cs1)s1 ON s1.d1-1=s2.i4-1 AND s2.i3 IS NOT NULL ;
|
|
d1 d2 id i1 i2 i3 i4
|
|
9223372036854775806 2147483626 14 NULL NULL 2147483626 9223372036854775806
|
|
9223372036854775807 0 12 NULL NULL 2147483627 9223372036854775807
|
|
9223372036854775807 2147483627 13 NULL NULL 2147483627 9223372036854775807
|
|
NULL NULL NULL -250 253 NULL NULL
|
|
NULL NULL NULL -252 253 NULL NULL
|
|
NULL NULL NULL 251 251 NULL NULL
|
|
NULL NULL NULL 254 253 NULL NULL
|
|
NULL NULL NULL 255 254 NULL NULL
|
|
NULL NULL NULL NULL 0 2147483641 NULL
|
|
NULL NULL NULL NULL 65534 2147483646 NULL
|
|
NULL NULL NULL NULL 65535 2147483647 NULL
|
|
NULL NULL NULL NULL 65535 NULL NULL
|
|
NULL NULL NULL NULL NULL 0 1
|
|
NULL NULL NULL NULL NULL 0 2147483641
|
|
NULL NULL NULL NULL NULL 2147483646 2147483635
|
|
NULL NULL NULL NULL NULL 2147483647 2147483636
|
|
NULL NULL NULL NULL NULL 2147483647 NULL
|
|
NULL NULL NULL NULL NULL NULL 9223372036854775807
|
|
CREATE TABLE t1 (a DECIMAL(10,1), b DECIMAL(20,1));
|
|
INSERT INTO t1 VALUES (10.1,20.1);
|
|
CREATE TABLE t2 (a DECIMAL(20,1), b DECIMAL(10,1));
|
|
INSERT INTO t2 VALUES (10.1,20.1);
|
|
SELECT * FROM t1,t2 WHERE t1.a=t2.a AND t1.b=t2.b;
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
DROP TABLE t1,t2;
|
|
CREATE TABLE t1 (a CHAR(10), b DECIMAL(10,1));
|
|
INSERT INTO t1 VALUES (10.1,20.1);
|
|
CREATE TABLE t2 (a CHAR(10), b DECIMAL(20,1));
|
|
INSERT INTO t2 VALUES (10.1,20.1);
|
|
SELECT * FROM t1,t2 WHERE t1.a=t2.a AND t1.b=t2.b;
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
SELECT * FROM t2,t1 WHERE t1.a=t2.a AND t1.b=t2.b;
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
DROP TABLE t1,t2;
|
|
CREATE TABLE t1 (a DECIMAL(10,1), b CHAR(10));
|
|
INSERT INTO t1 VALUES (10.1,20.1);
|
|
CREATE TABLE t2 (a DECIMAL(20,1), b CHAR(10));
|
|
INSERT INTO t2 VALUES (10.1,20.1);
|
|
SELECT * FROM t1,t2 WHERE t1.a=t2.a AND t1.b=t2.b;
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
SELECT * FROM t2,t1 WHERE t1.a=t2.a AND t1.b=t2.b;
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
SELECT * FROM t2,t1 WHERE (t1.a,t1.b)=(t2.a,t2.b);
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,t2.b);
|
|
a b a b
|
|
10.1 20.1 10.1 20.1
|
|
SELECT * FROM t1 JOIN t2 USING (a,b);
|
|
a b
|
|
10.1 20.1
|
|
SELECT * FROM t2 JOIN t1 USING (a,b);
|
|
a b
|
|
10.1 20.1
|
|
DROP TABLE t1,t2;
|
|
CREATE TABLE t1 (a DECIMAL(10,1), b DECIMAL(20,1),a1 DECIMAL(10,1), b1 DECIMAL(20,1),a2 DECIMAL(10,1), b2 DECIMAL(20,1),a3 DECIMAL(10,1), b3 DECIMAL(20,1),a4 DECIMAL(10,1), b4 DECIMAL(20,1),a5 DECIMAL(10,1));
|
|
INSERT INTO t1 VALUES (10.1,20.1,10.1,20.1,10.1,20.1,10.1,20.1,10.1,20.1,10.1);
|
|
CREATE TABLE t2 (a DECIMAL(20,1), b DECIMAL(10,1),a1 DECIMAL(20,1), b1 DECIMAL(10,1),a2 DECIMAL(20,1), b2 DECIMAL(10,1),a3 DECIMAL(20,1), b3 DECIMAL(10,1),a4 DECIMAL(20,1), b4 DECIMAL(10,1),a5 DECIMAL(20,1));
|
|
INSERT INTO t2 VALUES (10.1,20.1,10.1,20.1,10.1,20.1,10.1,20.1,10.1,20.1,10.1);
|
|
SELECT * FROM t1 INNER JOIN t2 USING(a,b,a1,b1,a2,b2,a3,b3,a4);
|
|
a b a1 b1 a2 b2 a3 b3 a4 b4 a5 b4 a5
|
|
10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1
|
|
SELECT * FROM t2 INNER JOIN t1 USING(a,b,a1,b1,a2,b2,a3,b3,a4);
|
|
a b a1 b1 a2 b2 a3 b3 a4 b4 a5 b4 a5
|
|
10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1
|
|
DROP TABLE t1,t2;
|
|
CREATE TABLE t1 (a DECIMAL(10,1), t text, b DECIMAL(20,1), i1 int, a1 DECIMAL(10,1), b1 DECIMAL(20,1),a2 DECIMAL(10,1), b2 DECIMAL(20,1),a3 DECIMAL(10,1), b3 DECIMAL(20,1),a4 DECIMAL(10,1), b4 DECIMAL(20,1),a5 DECIMAL(10,1));
|
|
INSERT INTO t1 VALUES (10.1,'some',20.1,42,10.1,20.1,10.1,20.1,10.1,20.1,10.1,20.1,10.1);
|
|
CREATE TABLE t2 (a DECIMAL(20,1), b DECIMAL(10,1), t text, a1 DECIMAL(20,1), i1 int, b1 DECIMAL(10,1),a2 DECIMAL(20,1), b2 DECIMAL(10,1),a3 DECIMAL(20,1), b3 DECIMAL(10,1),a4 DECIMAL(20,1), b4 DECIMAL(10,1),a5 DECIMAL(20,1));
|
|
INSERT INTO t2 VALUES (10.1,20.1,'some',10.1,42,20.1,10.1,20.1,10.1,20.1,10.1,20.1,10.1);
|
|
SELECT * FROM t1 INNER JOIN t2 USING(a,b,a1,b1,a2,b2,a3,b3,a4,b4,t,i1);
|
|
a t b i1 a1 b1 a2 b2 a3 b3 a4 b4 a5 a5
|
|
10.1 some 20.1 42 10.1 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1 10.1
|
|
SELECT * FROM t2 INNER JOIN t1 USING(a,b,a1,b1,a2,b2,a3,b3,a4,b4,t,i1);
|
|
a b t a1 i1 b1 a2 b2 a3 b3 a4 b4 a5 a5
|
|
10.1 20.1 some 10.1 42 20.1 10.1 20.1 10.1 20.1 10.1 20.1 10.1 10.1
|
|
SELECT t1.a,t1.t,t1.i1 FROM t1 INNER JOIN (SELECT * from t2) s1 USING(a,b);
|
|
a t i1
|
|
10.1 some 42
|
|
SELECT t2.a,t2.t,s1.i1 FROM t2 INNER JOIN (SELECT * from t1) s1 USING(a,b);
|
|
a t i1
|
|
10.1 some 42
|
|
SELECT t1.a,t1.t,t1.i1 FROM t1 INNER JOIN (SELECT * from t2) s1 where t1.a+1=s1.a+1 and t1.b+1=s1.b+1;
|
|
a t i1
|
|
10.1 some 42
|
|
SELECT t2.a,t2.t,t2.i1 FROM t2 INNER JOIN (SELECT * from t1) s1 where t2.a+1=s1.a+1 and t2.b+1=s1.b+1;
|
|
a t i1
|
|
10.1 some 42
|
|
DROP DATABASE mcol641_joins_db;
|