Disaster When Your Last Name Is Null, Nothing Works - The word, used by computer scientists to mean ‘no value,’ has created long-running challenges

nool.jpg
Nontra Yantaprasert couldn’t wait to take her husband’s shorter and easier-to-pronounce last name. She didn’t know what kinds of problems it would cause.

His last name is Null, the same word used by computer scientists to mean “no value” or “invalid value.” The Nulls of the world, it turns out, endure a lifetime of website bouncebacks, processing errors and declarations by customer-service representatives that their accounts don’t exist.

After becoming a Null, she was due to travel to India in 2014 on a nonrefundable flight for a friend’s marriage, but her visa hadn’t arrived in the mail.

The Indian consulate told her it had tried multiple times but the computer system couldn’t process her last name, she said. A week before the wedding, she was still waiting.

nontra.png

Nontra Null has come up with some workarounds.

“I had to mentally come to terms with not being able to go,” said Nontra, a 41-year-old clothing designer in Burbank, Calif. She finally received the documents the day before her flight. Since then, she has come up with workarounds to ease the burden of being a Null.

Null was first programmed 60 years ago by a British computer scientist named Tony Hoare. It has since been incorporated into many of the systems that make American commerce run, from hotel reservation sites to government agency forms. Some progress has been made toward addressing the long-running glitch, but Nulls still face challenges. Just last year, officials learned that the revamped Free Application for Federal Student Aid couldn’t process applications for people with the last name Null. The issue was fixed in October.

In some computer systems, blocking the word is a security feature, says Vahid Behzadan, a computer science professor at the University of New Haven. In these cases, the system perceives the word as a potential attack or attempt at sabotage and will block its entry, he said. For the user, this could look like an error warning or not being able to progress past the first step of a form.

Hoare probably wasn’t thinking about people with the 4,910th most common surname. He later called it his billion-dollar mistake, given the amount of programmer time it has used up and the damage it has inflicted on the user experience.

“It’s a difficult problem to solve because it’s so widespread,” said Daan Leijen, a researcher at Microsoft, who says the company avoids use of null values in its software.

These days, Nontra Null sometimes uses her maiden name instead of her last name. Other times she puts a hyphen between the two. But she still gets packages and letters delivered to her at work for people who aren’t in the company system. The names are automatically assigned as “null”—which is associated with Nontra in the system so the mail gets sent to her desk.

Jan Null, a 75-year-old meteorologist in Half Moon Bay, Calif., now adds his first initial to his last name when making online hotel reservations. Sometimes that’s the only way to trick the system into reading “null” as a series of individual letters instead of a code.

Years ago, he struggled to reserve a room. He would type his first name, last name and email, then get bounced back to the first step like he hadn’t entered anything at all. When he called for help, hotel workers were stumped, he said.

“Let’s try making your last name something different,” Jan remembers them suggesting.

Even those without the last name Null are finding themselves caught in the void. Joseph Tartaro got a license plate with the word “NULL” on it nearly 10 years ago. The 36-year-old security auditor thought it would be funny to drive around with the symbol for an empty value. Maybe a police officer who tried to give him a ticket would end up writing null into the system and not be able to process it, he joked to himself.

In 2018 he paid a $35 parking ticket. Soon afterward, he said, his mailbox was flooded with hundreds of traffic tickets for incidents he hadn’t been involved in. Tickets were from other counties and cities for vehicles of different colors, makes and models. A database had associated the word “null” with his personal information and citations were sent to Tartaro, who lives in Los Angeles.

Tartaro spoke about his experience at an annual hacker convention and Wired wrote a story about it. After the article came out, the private citation company that had sent him over $12,000 worth of fines left him alone, he said. But Tartaro said he is still getting dinged for incidents he wasn’t involved in.

In December, his car insurance company called him saying he had been part of two separate car accidents in two different cities within 48 hours. A few days later, an insurance adjuster called him asking to inspect his car for damages.

“It hasn’t left my driveway in a month,” Tartaro told them. They eventually stopped calling him. “My wife gets super pissed off about it and she hates that I still have the license plate.”

Computer software systems have evolved to avoid “null,” said Leijen from Microsoft, who contributed research to one of these systems. But companies are sometimes hesitant to adopt new systems and give up the convenience of their old ones, he said.

morgan.png
Morgan Null, a 26-year-old attorney in Pittsburgh, said her cousin had struggled to get her teaching license because of their shared last name.

So Morgan wasn’t surprised when Null presented problems in a recent move.

Representatives for the internet provider she had used in her old apartment initially told her they couldn’t cancel her account because there was no last name associated with it.

She had been paying the company for months. She has since switched internet providers.


source: https://www.wsj.com/lifestyle/null-last-name-computer-scientists-forms-f0a43b08
archive: https://archive.md/KxNNu
 
I still don't understand why Josh Moon chose the most generic-sounding username, 'null,' over something referencing his last name, like "moon knight" or "moonman."
 
  • Thunk-Provoking
Reactions: indomitable snowman
Fun fact, you aren't allowed to create a file or folder with a name of "nul" on Windows because it's some kind of reserved system word. I learned this trying to make a character sheet for my friend's D&D character who was named Nul and I got an error that I'd never seen before when trying to save Nul.pdf
 
His last name is Null, the same word used by computer scientists to mean “no value” or “invalid value.”
I'm sure the word precedes computers.

I still don't understand why Josh Moon chose the most generic-sounding username, 'null,' over something referencing his last name, like "moon knight" or "moonman."
Same reason as the comic above your post I'd say.
 
What kind of shitty pajeetware signifies null values with the string "null"? That's like the sort of mistake your grandma would make if you forced her to sit down and write a program with no instruction. I know the first example is literally in India so it makes sense, but the rest of them aren't. Even a first year CS student should know the difference between "null" and null.
Yeah that was my thought too, this signifies a lot of software is just trash
 
I still don't understand why Josh Moon chose the most generic-sounding username, 'null,' over something referencing his last name, like "moon knight" or "moonman."
Probably to make himself harder to look up. Memory serves me right nobody knew who Josh was before the farms got sued for the first time.

It’s always funny when he shows up on an interview or something and the video calls him null Kiwifarms like that’s the dear feeders legal name.
 
  • Like
Reactions: Marsh Rabbit
I had heard of the guy with the Null license plate. Some say he should just change it, but why should he change when it's the shitty parking ticket companies that suck?

Also he apparently noticed one company changing the information on a ticket when he told them that the ticket listed a completely different car from what he owned, so fuck em.
 
Last edited:
  • Like
Reactions: Marvin and Aidan
How bad does a program have to be to take the string "Null" and interpret it as a null value? That's got to be intentional behavior. Why? Who decided that the way to remove a value would be to manually rename it to "Null"?
 
After becoming a Null, she was due to travel to India in 2014 on a nonrefundable flight for a friend’s marriage, but her visa hadn’t arrived in the mail.

The Indian consulate told her it had tried multiple times but the computer system couldn’t process her last name, she said. A week before the wedding, she was still waiting.
This is because jeets can't fucking code. They can be completely aware of the issue and too stupid to fix it so will instead insist there's nothing they can do as it's a fancy computer thing you wouldn't understand.
How bad does a program have to be to take the string "Null" and interpret it as a null value? That's got to be intentional behavior. Why? Who decided that the way to remove a value would be to manually rename it to "Null"?
Covered earlier but the tl;dr is that this is due to injection where the Null is getting passed into a query which is usually just a string and then the back end figures everything out. The solution to this is basic parameterization but the truth is, injection attacks are still commonly successful meaning developers, often web developers, aren't doing their due diligence.

Data validation can be difficult but just passing on "Null" as is or rejecting it outright is lazy. The former is outright irresponsible.
 
Back