Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by calibas on Monday February 03, 2025 @03:24PM
(#42922537)
Which systems use the string "null" to represent a null value? That seems like a bad idea...
[ Parent
| on HN ]
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by threeducks on Monday February 03, 2025 @03:40PM
(#42922777)
A common source of "NULL" strings are CSVs. I personally had to deal with a database that only understood NULLs correctly when using QUOTE_NOTNULL, which was added to Python just last year: https://github.com/python/cpython/issues/113732
I've also heard of a fun database where the user "Geoffrey" was truncated to "G". I wonder why? (Hint: End of file)
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by driggs on Monday February 03, 2025 @04:01PM
(#42923059)
> I've also heard of a fun database where the user "Geoffrey" was truncated to "G". I wonder why? (Hint: End of file)
Sorry, I don't buy that one. There's no way the ascii string "eof" - especially lower-cased - would be interpreted as the C macro EOF, which is typically represented as the int -1. Sounds like a tall tale unless you've got proof.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by snailmailstare on Monday February 03, 2025 @04:18PM
(#42923298)
I first had to figure out why the G stayed put if it was being treated as last line... I've seen some terrible things and wouldn't doubt that a lot of pages in say the travel industry have a 2%+ failure rate at recording a signup.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by somat on Monday February 03, 2025 @04:11PM
(#42923205)
I could see a poorly coded stringly parsed interface (think sql) triggering on a mid span character sequence. but I agree, it would have to be a real mess of an interface. For example the client uses "eof" to separate or end queries.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by NoMoreNicksLeft on Monday February 03, 2025 @04:29PM
(#42923468)
There are more than a few legacy databases where a person's first name wouldn't be lowercased. I worked for a university awhile back, this is post-2010, and names were stored uppercase.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by threeducks on Wednesday February 05, 2025 @02:21PM
(#42953695)
Sorry, I don't have first-hand proof. But it seems that this issue is not rare: https://old.reddit.com/r/programminghorror/comments/4g70lj/s...
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by Sohcahtoa82 on Monday February 03, 2025 @07:37PM
(#42925664)
CSV will go down as one of the greatest mistakes in computer programming.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by jazzyjackson on Monday February 03, 2025 @03:36PM
(#42922720)
I could see it happening with clumsy JSON parsing. in javascript, JSON.parse("null") would return null, and the string null would have to be JSON.parse('"null"').
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput...
by robin_reala on Monday February 03, 2025 @03:50PM
(#42922904)
ColdFusion, if I remember correctly.