News for hackers. Stuff that matters.
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...
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.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by dartos on Tuesday February 04, 2025 @12:51AM (#42928547)
Never underestimate the amount of bad ideas in code produced by the lowest bidder.