标签没找到alias，暂时标为开发环境
训练营显示：
select * from table_alias_1 t1, table_alias_2 t2 where t1.id <> t2.id;
- 13 | 81 | 28.7 | 33 | 55 | 42.6
- 13 | 81 | 28.7 | 37 | 46 | 96.2
- 13 | 81 | 28.7 | 45 | 1 | 26.4
- 13 | 81 | 28.7 | 67 | 8 | 85.3
- 13 | 81 | 28.7 | 77 | 22 | 24.9
- 13 | 81 | 28.7 | 86 | 3 | 49.9
- 13 | 81 | 28.7 | 88 | 13 | 19.2
- 13 | 81 | 28.7 | 89 | 83 | 91.7
- 14 | 7 | 44.8 | 33 | 55 | 42.6
- 14 | 7 | 44.8 | 37 | 46 | 96.2
- 14 | 7 | 44.8 | 45 | 1 | 26.4
- 14 | 7 | 44.8 | 67 | 8 | 85.3
- 14 | 7 | 44.8 | 77 | 22 | 24.9
– below are some requests executed before(partial) –
– init data
CREATE TABLE table_alias_1(id int, col1 int, feat1 float);
CREATE TABLE table_alias_2(id int, col2 int, feat2 float);
CREATE TABLE table_alias_3(id int, col3 int, feat3 float);
INSERT INTO table_alias_1 VALUES (14, 7, 44.8);
INSERT INTO table_alias_1 VALUES (72, 44, 75.2);
…
本地运行：
miniob > select * from table_alias_1 t1, table_alias_2 t2 where t1.id <> t2.id;
id | col1 | feat1 | id | col2 | feat2
36 | 5 | 12.7 | 33 | 55 | 42.6
36 | 5 | 12.7 | 37 | 46 | 96.2
36 | 5 | 12.7 | 45 | 1 | 26.4
14 | 7 | 44.8 | 33 | 55 | 42.6
14 | 7 | 44.8 | 37 | 46 | 96.2
14 | 7 | 44.8 | 45 | 1 | 26.4
72 | 44 | 75.2 | 33 | 55 | 42.6
72 | 44 | 75.2 | 37 | 46 | 96.2
72 | 44 | 75.2 | 45 | 1 | 26.4
本地只插入了部分数据，毕竟只有一部分
