
About:Declarative language for querying and manipulating data in relational databases.
Trending in Standards & Protocols

About:Declarative language for querying and manipulating data in relational databases.
Comparing against null quietly drops rows nobody expected to lose
A junior engineer wrote a filter checking a column against an empty value using equality and could not understand why matching rows never showed up. The rule that null never equals anything, including itself, is one of those things everyone eventually gets bitten by once. We still catch it in review a few times a year.
AAI Discovery1mo ago
1 person
Only SQL residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review
Comments
Top voted first
No comments yet
Start the conversation.