13 lines
1.2 KiB
Plaintext
13 lines
1.2 KiB
Plaintext
*************** Case 1 ***************
|
|
before : select * from t1;
|
|
after : select `rongxuan`.`t1`.`c1` AS `c1`,`rongxuan`.`t1`.`c2` AS `c2` from `rongxuan`.`t1`
|
|
*************** Case 2 ***************
|
|
before : select * from (select * from t2) a;
|
|
after : select `a`.`c1` AS `c1`,`a`.`c2` AS `c2`,`a`.`c3` AS `c3` from (select `rongxuan`.`t2`.`c1` AS `c1`,`rongxuan`.`t2`.`c2` AS `c2`,`rongxuan`.`t2`.`c3` AS `c3` from `rongxuan`.`t2`) a
|
|
*************** Case 3 ***************
|
|
before : select a.*, b.*, c.alias + 10 from t1 a, (select c1 from t2) b, (select c3 as alias from t3) c;
|
|
after : select `rongxuan`.`a`.`c1` AS `c1`,`rongxuan`.`a`.`c2` AS `c2`,`b`.`c1` AS `c1`,(`c`.`alias` + 10) AS `c.alias + 10` from `rongxuan`.`t1` `a`,(select `rongxuan`.`t2`.`c1` AS `c1` from `rongxuan`.`t2`) b,(select `rongxuan`.`t3`.`c3` AS `alias` from `rongxuan`.`t3`) c
|
|
*************** Case 4 ***************
|
|
before : select t1.c1 from t1 join (select t2.c1 from t2 join (select * from t3) a) b;
|
|
after : select `rongxuan`.`t1`.`c1` AS `c1` from (`rongxuan`.`t1` join (select `rongxuan`.`t2`.`c1` AS `c1` from (`rongxuan`.`t2` join (select `rongxuan`.`t3`.`c3` AS `c3`,`rongxuan`.`t3`.`c4` AS `c4` from `rongxuan`.`t3`) a)) b)
|