asolimando commented on code in PR #21226: URL: https://github.com/apache/datafusion/pull/21226#discussion_r3005836265
########## docs/source/user-guide/sql/subqueries.md: ########## @@ -102,6 +102,15 @@ SELECT * FROM x WHERE column_1 NOT IN (1,3); +----------+----------+ ``` +#### `IN` with tuple-like values and `NULL` + +For tuple-like values, `IN` uses DataFusion's struct equality semantics: + +```sql +SELECT (7521, 30) IN ((7521, NULL)); Review Comment: Maybe an example retuning `true` involving a comparison with `NULL` elements (like that of line 227 above), which is probably the most surprising result if one expects standard SQL semantics. WDYT? -- 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]
