iwanttobepowerful commented on PR #4598:
URL: https://github.com/apache/calcite/pull/4598#issuecomment-3441706686
For example:
```sql
select e.deptno, e.deptno < some (select deptno from emp where emp.ename =
e.ename) as v from emp as e;
```
```
LogicalProject(DEPTNO=[$1], V=[OR(AND(IS TRUE(<($1, $3)), IS NOT TRUE(OR(IS
NULL($6), =($4, 0)))), AND(IS TRUE(>($4, $5)), null, IS NOT TRUE(OR(IS
NULL($6), =($4, 0))), IS NOT TRUE(<($1, $3))), AND(<($1, $3), IS NOT TRUE(OR(IS
NULL($6), =($4, 0))), IS NOT TRUE(<($1, $3)), IS NOT TRUE(>($4, $5))))]), id =
7108
LogicalJoin(condition=[IS NOT DISTINCT FROM($0, $2)], joinType=[left]), id
= 7106
LogicalProject(ename=[$1], deptno=[$8]), id = 7088
LogicalTableScan(table=[[scott, emp]]), id = 7017
LogicalProject(ename=[$0], m=[$2], c=[CASE(IS NOT NULL($3), $3, 0)],
d=[CASE(IS NOT NULL($4), $4, 0)], trueLiteral=[$5]), id = 7104
LogicalJoin(condition=[IS NOT DISTINCT FROM($0, $1)],
joinType=[left]), id = 7102
LogicalAggregate(group=[{0}]), id = 7093
LogicalProject(ename=[$1]), id = 7091
LogicalTableScan(table=[[scott, emp]]), id = 7017
LogicalAggregate(group=[{0}], m=[MAX($1)], c=[COUNT()],
d=[COUNT($1)], trueLiteral=[LITERAL_AGG(true)]), id = 7100
LogicalProject(ename=[$1], DEPTNO=[$8]), id = 7098
LogicalFilter(condition=[IS NOT NULL($1)]), id = 7096
LogicalTableScan(table=[[scott, emp]]), id = 7017
I20251024 08:00:51.245133 767227 RuleEventLogger.java:45]
7b4b20a3988a9436:cf9ea6a600000000] call#1505: Apply rule [ExtractLiteralAgg] to
[rel#7116:LogicalAggregate]
I20251024 08:00:51.245357 767227 RuleEventLogger.java:45]
7b4b20a3988a9436:cf9ea6a600000000] call#1506: Apply rule [ExtractLiteralAgg] to
[rel#7123:LogicalAggregate]
I20251024 08:00:51.245544 767227 RuleEventLogger.java:54]
7b4b20a3988a9436:cf9ea6a600000000] call#1506: Full plan for rule input
[rel#7123:LogicalAggregate]:
LogicalAggregate(group=[{0}], m=[MAX($1)], c=[COUNT()], d=[COUNT($1)],
trueLiteral=[LITERAL_AGG(true)])
LogicalProject(ename=[$1], DEPTNO=[$8])
LogicalFilter(condition=[IS NOT NULL($1)])
LogicalTableScan(table=[[scott, emp]])
I20251024 08:00:51.245569 767227 RuleEventLogger.java:60]
7b4b20a3988a9436:cf9ea6a600000000] call#1506: Rule [ExtractLiteralAgg] produced
[rel#7134:LogicalProject]
I20251024 08:00:51.245609 767227 RuleEventLogger.java:62]
7b4b20a3988a9436:cf9ea6a600000000] call#1506: Full plan for
[rel#7134:LogicalProject]:
LogicalProject(ename=[$0], m=[$1], c=[$2], d=[$3], trueLiteral=[true])
LogicalAggregate(group=[{0}], m=[MAX($1)], c=[COUNT()], d=[COUNT($1)])
LogicalProject(ename=[$1], DEPTNO=[$8])
LogicalFilter(condition=[IS NOT NULL($1)])
LogicalTableScan(table=[[scott, emp]])
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
