Alias 本地输出正确训练营报错

标签没找到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

本地只插入了部分数据,毕竟只有一部分

1 个赞

没看懂同学的意思

问题我自己解决了,是代码问题,麻烦了