Live data from Hacker News

NULL license plate not such a bright idea

knrs.iheart.com

91–100 of 484 posts

Re: NULL license plate not such a bright idea

#91
post #43

I read years ago in comp.risks about a similar story. A guy in 1979(!) requested a personalized plate "SAILING", with second choice "BOATING". He didn't want a customized plate if he couldn't get those, so for his third choice he put down "NO PLATE". Of course, he ended up with "NO PLATE". He ended up getting 2500 parking tickets, since cars with no plate had "NO PLATE" written on the ticket. References: http://www.m…

I remember a different story where the guy had to fight every ticket in court

Re: NULL license plate not such a bright idea

#92

I have a family member who's license plate started with "&". The DMV accepts it, plates were ordered online fine, but police systems can't handle it apparently, to my family members ultimate discomfort. I commonly joke it probably gets the individual out of automated tickers for speeding and red lights, but when an officer pulls them over we sometimes need to explain that the "&" is dropped in the system (or so we've…

Any word on whether the plate without the preceding '&' is in circulation? I'd be curious if your records in the police systems would be merged with the records of the owner of that plate.

The rules for california are the special symbols (which don't include &) are non-significant. Everything but the plate itself ignores them. Washington doesn't have special symbols, but does have an optional dash, which is also not significant.

Re: NULL license plate not such a bright idea

#93
post #13

Shout out to all the Python programmers from the other frontpage thread who are responsible for bugs like this with their crappy scripting languages.

Ignoring the lack of 'NULL' in Python for a moment, this wasn't even an issue with the code lacking an invalid input. If you read the article, you might have realized that.

Re: NULL license plate not such a bright idea

#94
post #66
post #42

Earlier quoted context omitted.

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.

At some point, can you not file some kind of harassment lawsuit? Is it legal to continue to send someone bills for which they aren't liable?

Re: NULL license plate not such a bright idea

#95

This isn't even a coding error, NULL is apparently valid license plate, and for some reason there is a private processing center typing it in to the government system. First of all they are accidentally committing fraud (libel?) against this guy. But more importantly, why is there a private processing center? Don't the officers type this in as they fill out the ticket? or even just scan the plates? If there aren't pl…

It's not fraud or libel, it's an unavoidable problem with in-band signalling [1].

I assume the government entry system doesn't have an explicit way to set the data as missing, so they work around it like this.

[1] https://en.wikipedia.org/wiki/In-band_signaling

Re: NULL license plate not such a bright idea

#96
Moral of the story: Test at your own risk!

At least his story brings to light the poor quality of software the DMV is using.

I'm curious about the other, unintended consequences of naming things null in other web applications; maybe its time to explore ...

Re: NULL license plate not such a bright idea

#97
post #24

Earlier quoted context omitted.

Nah, because it's not unsanitized SQL at fault, but people writing a literal NULL in the license plate field when there isn't one.

Actually, I think it's doubtful the folks at the private processing facility are actually writing 'NULL', but my guess is the DB field is just not set (i.e. left as NULL), and then when the info is read out somewhere it's just printed as the string literal value.

Wouldn't their license plate be in quotes, though? 'NULL' != NULL

Re: NULL license plate not such a bright idea

#98
post #60

Earlier quoted context omitted.

Relevant xkcd comic https://xkcd.com/1105/

In the Starcraft 2 community it is called barcoding. Basically, I 1 | l are all accepted characters for a name and I think some do look actually identical on most fonts used in the game. So yeah, one person doing that you call "barcode", 2 persons doing that, you already have deniability. Be more than 10, and that's a crowd.

Google's AlphaStar StarCraft bot did just this under different accounts. Along with some other fingerprinting, many of the accounts and replays were found by the SC2 community.

Re: NULL license plate not such a bright idea

#99
post #32

Earlier quoted context omitted.

Court isn't cheap. You're paying for it with a lawyer or with your own time

> Droogie contacted the DMV who told him to change his plate. He refused because he didn't do anything wrong. While they wiped the fines off his record, unfortunately for him, they didn't fix the problem in the system so once again, Droogie has accrued another $6,000 in tickets that he had nothing to do with. He says he won't be paying those either. Except he just contacted the DMV. No lawyers necessary.

Knowing the California DMV, that contact probably took at least two hours.

Re: NULL license plate not such a bright idea

#100

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…

Hmm, is this just because it is so few digits? I've had plenty of classic cars that have commission numbers with between six and twelve digits instead of VINs, and haven't ever had any issue with the DMV here in MA.
Post reply on HN