Omega359 commented on PR #22545:
URL: https://github.com/apache/datafusion/pull/22545#issuecomment-4549218901

   I do not see any slt tests as part of this pr? I had codex write some and 
they seem to fail on the branch with "Schema error: Schema contains duplicate 
unqualified field name mark" in optimize_projections.
   
   ```
   # Allow prepare $1 = ANY (subquery)
   statement ok
   PREPARE my_plan AS SELECT id FROM person WHERE $1 = ANY (SELECT age FROM 
person);
   
   query I rowsort
   EXECUTE my_plan(20);
   ----
   1
   
   query I rowsort
   EXECUTE my_plan(99);
   ----
   
   statement ok
   DEALLOCATE my_plan
   
   # Allow prepare $1 <> ALL (subquery)
   statement ok
   PREPARE my_plan AS SELECT id FROM person WHERE $1 <> ALL (SELECT age FROM 
person);
   
   query I rowsort
   EXECUTE my_plan(99);
   ----
   1
   
   query I rowsort
   EXECUTE my_plan(20);
   ----
   
   statement ok
   DEALLOCATE my_plan
   ```


-- 
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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to