Live data from Hacker News

NULL license plate not such a bright idea

knrs.iheart.com

61–70 of 484 posts

Re: NULL license plate not such a bright idea

#61
post #42
post #21

Earlier quoted context omitted.

Die on? But how - he can challenge the fines in a court of law. Since it's a vanity plate, adding an extra notoriety won't hurt.

On top of that, if anything, forcing the government to fix it's bad code ( insert snarky ambiguity between software code and legal code ) can't be a bad thing. I'd buy the guy a beer.

Except they won't fix it, and he will have to keep filing protests

Re: NULL license plate not such a bright idea

#62
post #21

I love when people double down out of principle, when the only person getting hurt is themselves. He refuses to change it because he did nothing wrong...sure, but you are also the only one being hurt by it. Is this really the hill to die on?

Die on? But how - he can challenge the fines in a court of law. Since it's a vanity plate, adding an extra notoriety won't hurt.

>he can challenge the fines in a court of law.

If he sees spending time and effort expunging his record every few weeks as worth the trade-off for the 'extra notoriety', then power to him. I wouldn't do that.

Re: NULL license plate not such a bright idea

#63

Is this actually possible? Aren't strings at least surrounded by quotation marks ('NULL') while NULL isn't?

The 'NULL' string was being entered by the private company:

> Apparently, when they didn't have the right data for a vehicle, a privately operated citation processing center used the word NULL in the license plate field for many tickets.

Re: NULL license plate not such a bright idea

#64

Is this actually possible? Aren't strings at least surrounded by quotation marks ('NULL') while NULL isn't?

It's not a database sanitization issue. The problem is that for cars that don't have a plate or the plate wasn't entered for whatever reason, in some cases people were entering "NULL" (the string). That then ended up matching his plate.

Re: NULL license plate not such a bright idea

#66
post #42
post #21

Earlier quoted context omitted.

Die on? But how - he can challenge the fines in a court of law. Since it's a vanity plate, adding an extra notoriety won't hurt.

On top of that, if anything, forcing the government to fix it's bad code ( insert snarky ambiguity between software code and legal code ) can't be a bad thing. I'd buy the guy a beer.

The problem is it's a "a privately operated citation processing center" that's causing the problem. They might even be instructed to hand-enter a NULL for these cases.

I'm don't really see an incentive for the govt agency to do anything about it. It's no skin off their nose. They'll just keep sending the tickets.

Re: NULL license plate not such a bright idea

#67

That's a bit curious though. If the code relies on a magic value, you'd think it's in order to skip trying to get data it doesn't have, like the address of the unidentifiable cars. Even if NULL then does have this address attached, why does it take the branch where it looks for the data? I suppose it would be in a relational DB, perhaps there's a join that drops missing entries, but if they aren't missing they show u…

The code doesn't rely on a magic value, the humans have decided that an empty value will be typed, by hand, into their terminals as the characters "NULL".

The problem is that the employees with access to the system are required to enter a 'valid' value. But in some cases there is no value. So the 'valid' value they've come up with is the string "NULL" - they can't use "~~NULL~~" because ~ isn't allowed on a license plate. So because A) anyone can request a valid value on a plate, and B) nonce values must also be "valid" within the system, the tax payer is capable of ordering a nonce value on a plate.

Re: NULL license plate not such a bright idea

#70
I own a rare collector car with a three-digit VIN. This has caused endless hassles at the DMV as well as the insurance office. Sometimes we find success by prepending the necessary number of zeros, before the VIN. Other instances in the same system require appending zeros after the VIN. The true VIN has a hyphen but that never makes it into the DMV's system. One time I got stuck in a particularly nasty loop where the DMV mailed over thirty notices claiming the register would expire on 01/01/0000.
Post reply on HN