News for hackers. Stuff that matters.
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.