Re:A 'Null' License Plate Landed One Hacker in Ticket Hell (...
by bell-cot on Tuesday April 19, 2022 @11:58AM
(#31084920)
Generic wishful suggestion for courts, regarding any sort of computer-processed data which is a basis for legal action: Coin some fancy-sounding Latin phrase meaning "obvious computer failure", and make liberal use of that phrase in curtly dismissing legal actions (with prejudice) where some key piece of the assertion is clearly a product of "garbage in, garbage out".
That might at least give some incentive to those running GIGO-excreting computer systems to clean up their sh*t.
Re:A 'Null' License Plate Landed One Hacker in Ticket Hell (...
by karmakaze on Tuesday April 19, 2022 @02:05PM
(#31086615)
Exactly.
> “null” is also a text string that in many programming languages signifies a value that is empty or undefined.
I can't think of a single language that does this. A null interpolated into a string or concatenated with an empty one could produce such a string. If that string value is then used to signify an empty/undefined value is misuse of the language.
Re:A 'Null' License Plate Landed One Hacker in Ticket Hell (...
by cestith on Tuesday April 19, 2022 @02:40PM
(#31087132)
SQL is more of a data language, but things like T-SQL or P-SQL I guess count. Lots of programming languages interacting with SQL databases mistreat NULL values. This guy's plate should never be "IS NULL" but should be a string that "plate = 'NULL'".
Re:A 'Null' License Plate Landed One Hacker in Ticket Hell (...
by karmakaze on Tuesday April 19, 2022 @03:43PM
(#31087983)
I think it would be more the case that specific programs (or stored procedures) mistreat NULL values, rather than a language or library not providing a way to properly handle them.
Re:A 'Null' License Plate Landed One Hacker in Ticket Hell (...
by tpoindex on Tuesday April 19, 2022 @11:29AM
(#31084467)
For those who like podcasts, Radiolab also had this story recently, along with a few other cases of bad programming (“Are you suggesting I change my name to “quote N-U-L-L quote”, to match the databases you’re working with?”)
Re:A 'Null' License Plate Landed One Hacker in Ticket Hell (...
by gunshai on Tuesday April 19, 2022 @12:27PM
(#31085353)
I'm surprised that NULLs weren't filtered out with what ever stored procedure is running on the database that sent the workload for mail ticket dispersal.
Although I suppose it is an edge case because NULL is supposed to not ever get joined with an address or UID.
That might at least give some incentive to those running GIGO-excreting computer systems to clean up their sh*t.
> “null” is also a text string that in many programming languages signifies a value that is empty or undefined.
I can't think of a single language that does this. A null interpolated into a string or concatenated with an empty one could produce such a string. If that string value is then used to signify an empty/undefined value is misuse of the language.
https://www.wnycstudios.org/podcasts/radiolab/articles/null
Although I suppose it is an edge case because NULL is supposed to not ever get joined with an address or UID.