select t1.id as num from table_alias_1 t1 where id in (select t2.id from table_alias_2 t2 where num > t2.id);
- FAILURE
-- 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 (54, 62, 15.0);
INSERT INTO table_alias_1 VALUES (72, 16, 23.4);
...
在本地测试是能输出结果并且没有报错的