1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| [parsed sqlNode] SELECT `O`.`ID`, `O`.`GOODS`, `O`.`PRICE`, `O`.`AMOUNT`, `C`.`FIRSTNAME`, `C`.`LASTNAME` FROM `ORDERS` AS `O` LEFT JOIN `CONSUMERS` AS `C` ON `O`.`USER_ID` = `C`.`ID` WHERE `O`.`AMOUNT` > 30 ORDER BY `O`.`ID` FETCH NEXT 5 ROWS ONLY
[validated sqlNode] SELECT `O`.`ID`, `O`.`GOODS`, `O`.`PRICE`, `O`.`AMOUNT`, `C`.`FIRSTNAME`, `C`.`LASTNAME` FROM `ORDERS` AS `O` LEFT JOIN `CONSUMERS` AS `C` ON `O`.`user_id` = `C`.`id` WHERE CAST(`O`.`amount` AS INTEGER) > 30 ORDER BY `O`.`id` FETCH NEXT 5 ROWS ONLY
[Logical plan] LogicalSort(sort0=[$0], dir0=[ASC], fetch=[5]), id = 10 LogicalProject(ID=[$0], GOODS=[$1], PRICE=[$2], AMOUNT=[$3], FIRSTNAME=[$6], LASTNAME=[$7]), id = 9 LogicalFilter(condition=[>(CAST($3):INTEGER NOT NULL, 30)]), id = 6 LogicalJoin(condition=[=($4, $5)], joinType=[left]), id = 5 LogicalTableScan(table=[[orders]]), id = 1 LogicalTableScan(table=[[consumers]]), id = 3
[Physical plan] LogicalSort(sort0=[$0], dir0=[ASC], fetch=[5]), id = 19 LogicalProject(ID=[$0], GOODS=[$1], PRICE=[$2], AMOUNT=[$3], FIRSTNAME=[$6], LASTNAME=[$7]), id = 17 LogicalJoin(condition=[=($4, $5)], joinType=[left]), id = 24 LogicalFilter(condition=[>(CAST($3):INTEGER NOT NULL, 30)]), id = 21 LogicalTableScan(table=[[orders]]), id = 1 LogicalTableScan(table=[[consumers]]), id = 3
|