Re: [PR] doc: Add documentation explaining the behavior of `null` values ​​in struct comparisons [datafusion]

["asolimando (via GitHub)" <gi...@apache.org>]

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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org