qpmodel icon indicating copy to clipboard operation
qpmodel copied to clipboard

[Algebrizer/Rewriter] [bug] introduced alias table__# confused table alias matching

Open zhouqingqing opened this issue 4 years ago • 0 comments

        // disable it for now due to introduce table alias (a__1) confusing matching
        // sql = "select a2 from a where a1 in (select a2 from a where exists (select * from a b where b.a3>=a.a1+b.a1+1));"; TU.ExecuteSQL(sql, "2;3");
        // sql = "select a2 from a where a1 in (select a2 from a a1 where exists (select * from a b where b.a3>=a1.a1+b.a1+1));"; //2,3
        // sql = "select a2 from a where a1 in (select a2 from a where exists (select * from a b where b.a3>=a.a1+b.a1+1));"; //2,3
        // sql = "select a2 from a where a1 in (select a2 from a where exists (select * from a b where b.a3>a1+b.a1+1));"; //2,3, ok
        // sql = "select a2 from a where a1 in (select a2 from a a1 where exists (select * from a b where b.a3>=a.a1+b.a1+1));"; // 2
        // sql = "select a2 from a where a1 in (select a2 from a where exists(select * from a b where b.a3 >= a.a1 + b.a1 + 1));";

zhouqingqing avatar Jan 10 '20 21:01 zhouqingqing