The Terrible Mistake of Choosing 'Null' as a License Plate

Поделиться
HTML-код
  • Опубликовано: 24 ноя 2024

Комментарии • 6 тыс.

  • @halfasinteresting
    @halfasinteresting  4 года назад +4994

    inb4 everyone puts their name as "null" in the HAI suggestions form. But if you do, just make sure to include a quality topic suggestion along with that, because not only do these suggestions help fuel the channel, they also get you "the viewer" a free HAI t-shirt if we use your suggestion. Submit here: docs.google.com/forms/d/e/1FAIpQLSfUdlvw6YgU44J8AnM2U_ZvRMyvh_CUM51LYSqF5nYJB9d1-w/viewform?usp=sf_link

    • @leakd
      @leakd 4 года назад +13

      hi

    • @thenickstrikebetter
      @thenickstrikebetter 4 года назад +31

      Llun is Null but backwards

    • @VincentFarides1776
      @VincentFarides1776 4 года назад +12

      I predict that Sam will respond to this.

    • @nikhii
      @nikhii 4 года назад

      .

    • @chedidkamal837
      @chedidkamal837 4 года назад +20

      Email address *null@null.null
      Name null
      Suggested topic *null
      Websites/articles to learn more about this topic null

  • @zuccx99
    @zuccx99 4 года назад +21079

    You know ur database is bad when null (the value) is confused with "null" (the string).

    • @dailygtyler
      @dailygtyler 4 года назад +348

      lol if you could try using an escape sequence or comment that would be so much worse

    • @onradioactivewaves
      @onradioactivewaves 4 года назад +126

      But.... what about the bull ascii character? 🤔 0x00 vs not entering a value, may not not yield the same results.

    • @maxm745
      @maxm745 4 года назад +351

      I literally just started learning about databases in my coding school yesterday, and we already covered how to differentiate between a protected word like "null" or "sum" or "select" or anything like that, and the string version of that word smh

    • @spambot7110
      @spambot7110 4 года назад +74

      strictly speaking, "null (the value)" is a meaningless statement, since both the things we're talking about are values. a string is a type of value. you could say "null (the type)" and be correct for most languages

    • @Symbiatch
      @Symbiatch 4 года назад +421

      Exactly. The video is hugely false saying things wrong. A bad programmer wrote bad code. Databases don’t usually confuse these things at all. Nor does location come up as “null, null” from GPS or anything else. Only if you don’t know what you’re doing it may be converted to such thing.

  • @toto_feather8732
    @toto_feather8732 4 года назад +5233

    "The requested human does not exist"
    I want that line on my gravestone...

  • @benjaminclehmann
    @benjaminclehmann 4 года назад +3331

    "There is no easy fix"
    Yeah there is. Everytime this issue shows up it is a mistake. QA should always test true null input (i.e. nothing) and string null (i.e. the string literal "null"). They should never be confused unless you have impressively stupid type coercion or you are using query strings instead of parameterized queries, which is bad practice, as without proper sanitization you have security issues far larger than this one.

    • @pitaya4151
      @pitaya4151 4 года назад +122

      Or, use string literals, but make the string something that can never be on a plate - "NULLNULLNULLNULL" for example!

    • @lm1338
      @lm1338 4 года назад +238

      @@pitaya4151 No, the correct solution is definitely to have a strong type system. A lot of people are blaming the programmers / QA testers, but I don't know if that's really right if languages have such implicit type systems where you have to be on your toes all the time

    • @dismiggo
      @dismiggo 4 года назад +119

      Thinking of it, that would be a great way of doing SQL injection on police servers

    • @toasterr4238
      @toasterr4238 4 года назад +24

      @@pitaya4151 yeah, what could go wrong?

    • @camiscooked
      @camiscooked 4 года назад +8

      @@pitaya4151 What?

  • @traildoggy
    @traildoggy 2 года назад +479

    My brother told me of a co worker at his store named J B Jones. Literally that was his entire legal name. He needed to get a name tag and somehow the computer terminal submission form kept rejecting the single letters as valid names so he wrote J (only) B (only) on there thinking someone would figure it out.
    Next week he received a name tag for Jonly Bonly Jones which he proudly wore. Somehow it messed up his payroll and he did not get paid for several weeks before they figured it all out. 😀

    • @Thebiggestgordon
      @Thebiggestgordon 2 года назад +67

      Jonly Bonly Bones is a hilarious ID lol. I used to know a kid just called H, pronounced “haich”. No idea what happened to him.

    • @quillclock
      @quillclock 2 года назад +7

      that's a Henry Cho joke... "Jonly Bonly from boldly go"
      probably a common thing to happen

    • @tashaedwards
      @tashaedwards 2 года назад +24

      My Great great grandfathers name was JT. When he went to join the Army, they told him he needed a real name. He made up John Thomas on the spot.

    • @outspokengenius
      @outspokengenius 9 месяцев назад +3

      Under federal law your employer is required to get you paid on time. At my last job I accidentally filled out my direct deposit info wrong. I didn't get my first check deposited. I went into work and was told payroll was in another state and I'd have to wait until the following payday. I stood right in the HR office and called an attorney. That attorney contacted my state attorniey general. A private courier brought me my check before noon the next day from half the country away.

  • @unclestarwarssatchmo9848
    @unclestarwarssatchmo9848 4 года назад +3878

    "I bless the rains down in [NULL ISLAND]"

    • @pqbdwmnu
      @pqbdwmnu 4 года назад +94

      My stand 「Null Island」is undefeated!

    • @sandeater1133
      @sandeater1133 4 года назад +21

      Someone, get the anti weeb spray!

    • @Incognito_Blazer
      @Incognito_Blazer 4 года назад +17

      @@sandeater1133 Nah, too lazy being a resident of Null Island

    • @Jc27uhh4h4h4
      @Jc27uhh4h4h4 4 года назад +18

      I live in [redacted] road

    • @Blank55600
      @Blank55600 4 года назад +15

      How the fuck is this funny?
      Oh right... We now laugh at stock images of chairs..

  • @hoangtran4736
    @hoangtran4736 4 года назад +1019

    "there is no easy fix"
    the fix is called not being lazy and actually treating literal string "null" as a literal string. this is the stuff they teach within the first month of a cs program.

    • @howardbaxter2514
      @howardbaxter2514 4 года назад +42

      And is a two second fix

    • @samuelmellars7855
      @samuelmellars7855 4 года назад +56

      Yeah, but you now need to fix that lazy mistake in... well, almost everywhere. Without bricking whatever systems are running on the code you are fixing. That's the tricky part, not "not making the mistake"

    • @Ian-bt8dz
      @Ian-bt8dz 4 года назад +7

      Just like the self retweeting tweet lol, lazy programming

    • @dmartk
      @dmartk 4 года назад +1

      Amen

    • @photonicpizza1466
      @photonicpizza1466 4 года назад +32

      @@samuelmellars7855 Or you could just, y'know, keep it in mind when building a database like any half-decent programmer, as opposed to fixing it with a bodge a decade or two down the line.
      Always sanitise your inputs, people. *Especially* when dealing with SQL and/or PHP.

  • @alexwolfeboy
    @alexwolfeboy 4 года назад +4826

    If your database can’t handle “null”, the string, you need to seriously reconsider your hiring choices. Like, sanitising inputs to prevent the string “null” from becoming null, is like, a must know for working on a database. Makes me laugh, thinking you could preform something like a SQL Injection, through something as silly as a license plate.

    • @joemck85
      @joemck85 4 года назад +256

      Sanitizing inputs is important, but it isn't even needed to prevent this sort of screw-up. In SQL, NULL is the value, "NULL" is the string, and they aren't equal. When searching for values, == "NULL" will find the string "NULL", while to find actual null values, you have to say IS NULL. I'm guessing what they've done is read a bunch of values, feed them through some processing that destroys the distinction between strings and null values, then scanned through it. The problem isn't something they've forgotten to do, it's something stupid they're adding.

    • @molly3237
      @molly3237 4 года назад +131

      @@joemck85 as it said before, they are filing everything the cops missed under something called "NULL". My guess is instead of actually assigning it a null value they made a fake registration called NULL for all their filing errors. Now instead of editing that fake registration's values, they were accidentally editing this real persons record.

    • @anotheraggieburneraccount
      @anotheraggieburneraccount 4 года назад +76

      just wait until they hear about bobby tables

    • @niravko
      @niravko 4 года назад +10

      They're probably still using COBOL...

    • @crazedvidmaker
      @crazedvidmaker 4 года назад +11

      Or, since somehow the only evidence we have is apparently that he went to talk shows and said this happened, he just lied because that doesn't make any sense. Even if there was a careless cast to string, I'm certain most languages, assuming they didn't just error, would turn a Null/None into an empty string ""

  • @MYJ61
    @MYJ61 4 года назад +455

    I knew a man who had “NO TAG” as his plates some 30years age. At that time Virginia Police used that phrase for ANY vehicle not displaying a valid state license plate. He as well changed it after receiving thousands of parking tickets and fines.

    • @43Cubes
      @43Cubes 4 года назад +3

      lol

    • @melkiorwiseman5234
      @melkiorwiseman5234 4 года назад +16

      That sounds like the man who got a "NO PLATE" set of plates. Story in my comment above.

    • @RandyA7
      @RandyA7 2 года назад +6

      Same with NA or N/A

    • @MDFerriit
      @MDFerriit 10 месяцев назад

      @@RandyA7 You know that "NA" or "N/A" will be stored as a string and not a value, right?

    • @snowiblind
      @snowiblind 3 месяца назад

      ​@@MDFerriitbros a nerd 🤓

  • @TheBestYTPer
    @TheBestYTPer 4 года назад +4458

    People with the surname "Null": *Exist*
    Computer databases: I'm gonna pretend I didn't see that.

    • @stepha7102
      @stepha7102 4 года назад +30

      Off topic, but I really like your profile picture.

    • @ballkicker931
      @ballkicker931 4 года назад +22

      Imagine spawning at 0,0

    • @costin88boss74
      @costin88boss74 4 года назад +9

      You guys are wrong.
      Variables are used.
      So a String can hold anything, even null.
      Just that unicode normaly is not supported.

    • @bertie9653
      @bertie9653 4 года назад

      Johnetta Erty morgana in this comment section, ** i never saw that comiiiiiing**

    • @sleepyinnuendo
      @sleepyinnuendo 4 года назад +1

      my science teachers last name is null🗿

  • @taguetrash
    @taguetrash 4 года назад +345

    The string "NULL" is distinct from the actual value "NULL" in any well-designed system. These are the consequence of poor design, not an innocent mistake.

    • @sumbuddy4088
      @sumbuddy4088 4 года назад +2

      Either that or some sort of sick prank.

    • @BladeOfLight16
      @BladeOfLight16 4 года назад +5

      In fact, it's the default in virtually every database and programming language. Someone would have to actively write code to treat them the same in any system I know of, even if the developer is incompetent enough to be creating SQL injections.

    • @Chrischi3TutorialLPs
      @Chrischi3TutorialLPs 4 года назад +1

      Just wait until you learn how many websites regularily fall victim to SQL Injections even though SQL has a command specifically dedicated to preventing that.

    • @taguetrash
      @taguetrash 4 года назад +1

      @@Chrischi3TutorialLPs I'm well aware of that, believe me. That, as well, is a consequence of poor design and/or dumbassery

  • @kalenmeisner9966
    @kalenmeisner9966 4 года назад +6961

    "Coordinates 0,0"
    Ah yes in the oldest anarchy server on minecraft

    • @stefangog2852
      @stefangog2852 4 года назад +320

      2B2T

    • @bradendolphinsfan1960
      @bradendolphinsfan1960 4 года назад +135

      THE OLDEST ANARCHY SERVER IN MINECRAFT

    • @KaNoot_
      @KaNoot_ 4 года назад +168

      WHAT IF I TOLD YOU THAT ON THE OLDEST ANARCHY SERVER IN MINECRAFT

    • @InvalidOS
      @InvalidOS 4 года назад +115

      what if we are on the oldest anarchy server in minecraft 😳😳

    • @buchitomilx474
      @buchitomilx474 4 года назад +49

      fitMC will throw a fit over this comment

  • @lilacdoe7945
    @lilacdoe7945 3 года назад +1209

    "You can't change your last name Mr. John Null."
    "Why not?"
    "I have to enter your current name before you can choose a new one."
    "But it's Null."
    "Sorry, my computer won't let me enter that. You can always try calling our central office. It's the one that puts you on hold for hours before randomly disconnecting."

    • @Sonicbro-xx6sg
      @Sonicbro-xx6sg 3 года назад +16

      Bruh I spent all day working on this name and all week getting the money for it, please let me change it! Null isn't the same as "null"
      . Null is a value, "null" is a string! Lemme change it!

    • @LRM12o8
      @LRM12o8 3 года назад +33

      _"can't change because current name does not exist"_
      Ah gotta love these errors only a computer can make. The fact they can't deal with paradoxa gives me confidence that us humans are still the masters.

    • @NikkieRoxxx
      @NikkieRoxxx 5 месяцев назад

      Aah yeah, like most "help"desks nowadays!!

  • @df1ned
    @df1ned 4 года назад +11778

    If your system confuses `null` and `"null"` it's pretty trash to be honest

    • @michaelmoses8745
      @michaelmoses8745 4 года назад +607

      It's good enough for government work though.
      What else were you expecting.

    • @nicholas_scott
      @nicholas_scott 4 года назад +578

      You would be surprised. I see this all the time. Plus, there is a whole section of hacking devoted to text injection, where programs expect ordinary text, but actually get code that is tricked into running. Bad programming is the cause, and there is no easy fix for bad programmers.

    • @denny-lp1qb
      @denny-lp1qb 4 года назад +312

      if(value == null) then value = "NULL"; probably they did this LOL

    • @krozareq
      @krozareq 4 года назад +150

      ASCII 00 = null
      This is an issue of not sanitizing input to a database which could open it up for other exploits such as SQL injection attacks.

    • @KuK137
      @KuK137 4 года назад +29

      @Jonathan Williams You mean corporate scumbags hiring interns to pocket all the profits they can to buy tenth Ferrari because morons like you bought 'gubmint is bad' propaganda and let the IT systems be outsourced to incompetent private parasites instead of having proper in house IT workers? Because it works in countries who actually let government to do it instead of drinking 1% kool aid that private is da best and it will trickle down...

  • @hydrochloricacid2146
    @hydrochloricacid2146 4 года назад +2679

    Database programming 101: ALWAYS sanitize your inputs

    • @neeneko
      @neeneko 4 года назад +93

      Sanitizing inputs does not really help this class of problem. DBs can handle nulls. If the string 'null' is making its way it, that means something upstream in the workflow is sanitizing its inputs, maybe even passing through some intermediate format that doesn't have an explicit null. But by the time it is hitting the DB, it is already a string.

    • @benson3955
      @benson3955 4 года назад +20

      neeneko What he said

    • @undefinedchannel9916
      @undefinedchannel9916 4 года назад +31

      you dont want your inputs to catch COVID!

    • @colin-campbell
      @colin-campbell 4 года назад +18

      neeneko
      That could potentially lead to problems down the road. Best to sanitise inputs/use whitelisting in line with best security practice.

    • @DavidAbyssal
      @DavidAbyssal 4 года назад

      Dear mister/miss HCl, thank you...

  • @Araitik
    @Araitik 4 года назад +2919

    To be fair, the string value "NULL" and the *_actual real true_* NULL are two very different things. A well-built database and software can handle "NULL" just as fine as things like "1 = 1" or " ';--"
    But that would imply competent programming and data management which is a fairy tale given the reality of software in the world.
    The silver lining is at least we get videos with terrible jokes thanks to them !

    • @johngaltline9933
      @johngaltline9933 4 года назад +19

      agree mostly, but it's just lazy not to check the data type. ex: if you wanna be real lazy about it, if null: check data type.

    • @prithvirajb1953
      @prithvirajb1953 4 года назад +1

      What is it with 1=1

    • @pxolqopt3597
      @pxolqopt3597 4 года назад +28

      @@prithvirajb1953 destruction and death

    • @fredyy
      @fredyy 4 года назад +5

      came here to add this comment but, you were faster than me. null

    • @bersl2
      @bersl2 4 года назад +9

      "true NULL"
      Whoa there! This got unnecessarily kinky quickly...

  • @h-0058
    @h-0058 3 года назад +445

    Why would a police database consider "null" the same thing as null...? Like, wtf?

    • @h-0058
      @h-0058 3 года назад +56

      @@mymo_in_Bb Yeah, but it's a police database, not your average shitty project that you do on your own and get bored of it in 2 weeks...

    • @fluxx2875
      @fluxx2875 3 года назад +9

      @@h-0058 When you get bored of a project after 2 weeks, then you've definitely done a wrong project ...

    • @richardlarge9181
      @richardlarge9181 3 года назад +12

      Government software is usually contracted out to cheap firms I believe

    • @Julianna.Domina
      @Julianna.Domina 3 года назад +18

      @@h-0058 Every government contract goes to the lowest bidder. Including that bridge you drive over to get to work every day.
      Sleep well!

    • @LRM12o8
      @LRM12o8 3 года назад +13

      The question isn't so much _why,_ it's _how._
      To my knowledge any database management program these days, be it Microsoft SQL, MySQL, Maria DB, etc., would treat the user input "Null" different from an actual Null, so seriously: *_HOW?_*

  • @dominykaszakrys3373
    @dominykaszakrys3373 4 года назад +1013

    -programmer sees a "NULL" plate while driving
    -brains: *null.pointer.exception*
    -proceeds to crash into a tree

    • @JohnMarkIsaacMadison
      @JohnMarkIsaacMadison 3 года назад +27

      You'll be okay. Just don't de-reference it. Okay. Maybe dereference it. But definitely don't try to invoke it after you de-reference.

    • @maknyc1539
      @maknyc1539 3 года назад +2

      rip tree

    • @iMonZ00
      @iMonZ00 3 года назад +1

      @@steel.croissant yep

    • @Kevin-ht1st
      @Kevin-ht1st 3 года назад +5

      My Asian girlfriend must have ‘Null’ embedded in her eyes lol

    • @baconboy486
      @baconboy486 3 года назад +1

      @@maknyc1539 yeah lol

  • @raccooncafe5689
    @raccooncafe5689 4 года назад +794

    Great, now I HAVE to try it out.

  • @wantedbonbon6443
    @wantedbonbon6443 4 года назад +263

    Last name: Null
    Computers: I have never met this man in my life

    • @charleswesthoff5954
      @charleswesthoff5954 4 года назад +1

      True

    • @e.6z1
      @e.6z1 4 года назад

      @@charleswesthoff5954 false, any well-built database/program can differenciate the string "Null" and the actual Null type, they just had shit devs

  • @0raj0
    @0raj0 3 года назад +743

    As a programmer myself, I can't imagine how one can write an application in such a stupid way that it doesn't distinguish a TEXT STRING with the value "NULL" from an actual NULL value. While it is relatively easy to mistake an EMPTY text string (one that does not contain any character) with the NULL value, as under some circumstances they can be both evaluated as "nothing", I can't imagine how one can mistake the "NULL" string, which consists of four characters and certainly doesn't look like an empty string, with the NULL value which is actually nothing and NEVER converts to the text "NULL".

    • @Keldor314
      @Keldor314 2 года назад +114

      I guess you haven't encountered Javascript implicit conversion. See, in their infinite genious, the developers of the language decided that it would be a *good* idea to automatically convert between textual strings and numbers, so if you, for instance, try to add the number 7 to the string "13", it will automatically convert the string to a number, add 7, and give you a final answer of 20. It can be supposed that this was convenient for developers of spreadsheet websites that would otherwise have to explicitly call a conversion method for every single binding, but this has nasty potential consequences.
      The one relavent to the video is what happens if you try to use a NULL to look up an entry in a string dictionary, the interpreter will detect that there's a type mismatch and try to implicitly convert NULL to a string to match the types. This results in the NULL turning into the string "NULL", and if an entry in the dictionary happens to have "NULL" as its key, well, congratulations, you have reproduced the circumstances leading to the bug in the video.

    • @BPlank64
      @BPlank64 2 года назад +22

      Any software engineer who confuses a null (ASCII(0)) with an empty string needs to rethink their career choices.

    • @PauxloE
      @PauxloE 2 года назад +22

      That can happen when exporting data to a format which doesn't have an explicit NULL value (e.g. CSV), and then importing it again. Of course, it shouldn't happen if you are careful, but it can happen without actual ill intent.

    • @rollanddev
      @rollanddev 2 года назад +9

      Here's a simple answer for ya...
      The software was most likely written in COBOL. :D

    • @tyaty
      @tyaty 2 года назад

      @The Mystic Savages
      ORM-s are much slower than native SQL queries.

  • @maotingdew
    @maotingdew 4 года назад +368

    Requests for the “Null” license plate has increased dramatically.

  • @s0lati
    @s0lati 4 года назад +937

    Now, someone needs to put '
    ' as their license plate.

    • @CoderShare
      @CoderShare 4 года назад +157

      yEeT'; DROP ALL TABLES; --

    • @miraflynn8935
      @miraflynn8935 4 года назад +84

      CooCooWizard You say that as if that exact vulnerability isn’t all over the place...

    • @CoderShare
      @CoderShare 4 года назад +44

      @CooCooWizard Especially on government programs designed specifically for bureaucracy.

    • @franchufranchu119
      @franchufranchu119 4 года назад +40

      @@CoderShare Little table-yeeter, we call him

    • @melody_florum
      @melody_florum 4 года назад +30

      CooCooWizard honestly
      seems more likely to break things than ‘null’ as a string, and null did break things

  • @stephenwaldron2748
    @stephenwaldron2748 4 года назад +1860

    RUclips: Here's why you can't have NULL as a licence number.
    Me who lives in a country where the plate format makes NULL impossible: Sure, why not.

    • @veryinactiveukmapping
      @veryinactiveukmapping 4 года назад +5

      the UK?

    • @georgiykireev9678
      @georgiykireev9678 4 года назад +78

      @@veryinactiveukmapping Most of the world, really. For example, the Russian license plates follow this pattern: 1 letter, 3 numbers, 2 letters. The city code is added at the end in the form of 2 slightly smaller numbers. While you can still pick the letters and numbers for your plate if you pay the price, you can't just use a word.

    • @abhishekanil99
      @abhishekanil99 4 года назад +9

      In my country it's SS xx ABC xxxx where ss is state code, xx two digit regn office code within the said state, ABC any no of alphabets in a sequence that increases after xxxx the 4 digit number reaches 9999 for eg: KA 56 AA 5623... And the only thing you can get is the last 4 nos that you can pre book before you register your vehicle. Once a registration is assigned, that vehicle carries it till it's end

    • @stephenwaldron2748
      @stephenwaldron2748 4 года назад +4

      @@veryinactiveukmapping Caribbean. It's different by island state but here it's PAA xxxx, where P represents the parish/function, AA is 1-2 optional letters added for larger parishes where there are not enough numbers for the population, or for extra function info (e.g. Z means "taxi", ZR means "route taxi"), then a 1 - 4 digit registration number.
      e.g. O 357, MA 1027, XM 4

    • @nq2c
      @nq2c 4 года назад +1

      Pretty sure you can get it anywhere when you get a private plate, you can choose

  • @whateverrandomnumber
    @whateverrandomnumber 3 года назад +270

    Even better would a license plate saying
    '); DROP TABLE *;

    • @j0code
      @j0code 3 года назад +14

      outplayed the mysql system

    • @InsomniaCast
      @InsomniaCast 3 года назад +43

      I prefer TRUNCATE TABLE. See then all the data is gone and they wont know right away. With DROP TABLE someone will know right away from query errors and they can run a quick backup :P

    • @Ikebot
      @Ikebot 3 года назад +50

      "Oh yes, little Bobby Tables we call him."

    • @shaunavalon843
      @shaunavalon843 3 года назад +5

      EXEC sp_MSForEachTable 'TRUNCATE TABLE ?'

    • @edwardsmith7131
      @edwardsmith7131 3 года назад +5

      @guilherme mauricio - thank you for the xkcd reference

  • @LyricWulf
    @LyricWulf 4 года назад +162

    _It might not be a vulnerability._ The dmv violation submitter might put the literal string "NULL" as a default plate# if the input is empty.
    Literally anything is possible, considering *the system let them submit empty license plates for traffic violations* in the first place…
    *Edit: When I say "submitter" I mean the machine that submits it to the database, sorry for any confusion on that.*

    • @atk05003
      @atk05003 4 года назад +11

      Most vulnerabilities are caused directly by human error (as opposed to software bugs). If you're training people to enter "NULL" for an empty plate# and then you allow someone to get a plate that says "NULL", then you have a problem. It may not be caused by the developers, but poorly trained employees (or bad business processes) are the most commonly exploited vulnerabilities. That's why phishing scams work.

    • @SecuR0M
      @SecuR0M 4 года назад

      The system should be flexible so you can enter whatever. You can exclude bad inputs by not letting people buy those plates and fining ones who have them, before taking them to court with a wad of traffic tickets thicker than a New York City phone book. This is much more efficient than trying to use some non-existent crystal ball wizardry to determine what stupid novelty plates someone will acquire 10-20 years down the road as part of a self-congratulatory TED talk or whatever.

    • @phillipsusi1791
      @phillipsusi1791 4 года назад +6

      @@atk05003 You don't train people to enter "NULL" for an empty plate. You leave the field empty. i.e. you don't type anything at all. It is a bug if the program confuses the two.

    • @branfreeze720
      @branfreeze720 4 года назад

      Alright furry.

    • @blakedurston
      @blakedurston 4 года назад +2

      Yooo LyricWulf! Funny seeing you here. I remember you from sheet music boss’s 1 million subscriber special
      Was incredible

  • @safebox36
    @safebox36 4 года назад +1116

    As a software developer, I would apologise but this is testing 101 nowadays.
    Someone fucked up, and it made it's way from development to signoff without anyone checking.

    • @ashtenlastname4045
      @ashtenlastname4045 4 года назад

      null

    • @its_chris_cross
      @its_chris_cross 4 года назад +7

      ' or 1=1 --

    • @hermit7290
      @hermit7290 4 года назад +26

      As a software developer, do you really thing the dmv pays a competitive wage or do they just get software developers who couldn't get a high paying job? Or if they use a third party company on a contract, do you think that third party is trying to make the most rock solid software, or just trying to finish it as quick as possible to move on to the next contract and make $$$?

    • @clark523
      @clark523 4 года назад +10

      Yeah I sorta hate the implication that this is a universal issue that hasn't been widely solved by sanitizing inputs, etc

    • @myownsite
      @myownsite 4 года назад +1

      These systems are very much legacy, though.

  • @Baddino45
    @Baddino45 4 года назад +1432

    People now: Null is scary.
    People before: What are you gonna do? Hack my free minecraft acount?

    • @torquetheprisoner
      @torquetheprisoner 4 года назад +26

      im not scared of any thing but null that scares me

    • @karlturner5678
      @karlturner5678 4 года назад +14

      @Shakhbulat Gazgireev yes, just because you don't get it doesn't mean it isn't a joke.

    • @eyks8562
      @eyks8562 4 года назад +3

      Good times.

    • @tornadomash00
      @tornadomash00 4 года назад +8

      null the Minecraft creepypasta: allow me to introduce myself

    • @karlturner5678
      @karlturner5678 4 года назад +5

      @Shakhbulat Gazgireev so you're familiar with the subject matter then? Do you know what the concept of an inside joke is? Even if it's a large scale one, if you don't get the subject matter, you won't find it funny

  • @dynpallomah
    @dynpallomah 3 года назад +822

    null is not the same as "null"
    null is a value, "null" is a string

    • @tehalexy
      @tehalexy 3 года назад +43

      you're wrong, "null" is a value, null isnt ...
      knowledge throws nullpointer
      :D

    • @Aidiakapi
      @Aidiakapi 3 года назад +41

      They're both values, just of different types, depending on the language, null can be untyped (like in C#), a special type (like in JS), or just a special value (like in C). Whereas "null" is of some string type.

    • @InsomniaCast
      @InsomniaCast 3 года назад +7

      Null is a data type of NULL and "null" is a data type of string :P They are both values.

    • @nullnull3517
      @nullnull3517 3 года назад +2

      i am but null as a human

    • @lorenzo42p
      @lorenzo42p 3 года назад +1

      @@Aidiakapi "null" is a string of values, hence the name string. it's more than one value, which can itself contain a null value or use null as the ending marker.

  • @PHCuber
    @PHCuber 4 года назад +1012

    *Simple: differentiate “null” and null value.*

    • @xwtek3505
      @xwtek3505 4 года назад +16

      I see you're not a programmer, then.

    • @gg-sr6ju
      @gg-sr6ju 4 года назад +84

      "null" = string
      null = Null
      If you all using c++ don't use null as a pointer

    • @raptorm8242
      @raptorm8242 4 года назад +28

      permanent and can't be changed later The comma placement in your comment really pisses me off.

    • @Monk-E
      @Monk-E 4 года назад +8

      @@raptorm8242 bruh, moment

    • @rx7241
      @rx7241 4 года назад +4

      @@Monk-E But that would ruin the lives of atleast hundreds of extra megabytes

  • @MetalDeviltv
    @MetalDeviltv 4 года назад +665

    "no easy fix"
    NULL
    "NULL"
    Tadaaa.. Who is going to wire me millions of dollars now?

    • @imadrifter
      @imadrifter 4 года назад +7

      ✌Null✌

    • @matta6011
      @matta6011 4 года назад +9

      @@alessandrohidalgo25 I was too, one means it is undefined while the other is the string "null".

    • @howardbaxter2514
      @howardbaxter2514 4 года назад +12

      What are they storing these names in? If it's anything other than a String or char array, then there are more underlying problems than simply mishandling null.

    • @blackwersus
      @blackwersus 4 года назад +8

      It's amazing how many bad programmers there are out there

    • @blackasthesky
      @blackasthesky 4 года назад +1

      Still not easy to change each and every system out there. Many database systems out there are old. I mean, ooooooold. At least over here where I live.

  • @Operative13
    @Operative13 4 года назад +890

    People who didn't even pass basic programming 101 getting jobs to code entire police databases meanwhile I'm out working minimum wage as an intern doing mundane tasks with a college degree and years of crippling debt.
    Economic efficiency at its finest.

    • @klexfire4384
      @klexfire4384 4 года назад +6

      @Cant think of a name Well in Switzerland you get a start wage of 9,5k CHF as a web dev

    • @wandererreece9540
      @wandererreece9540 4 года назад +53

      Tell me about it. I once tried to get a minimum wage job at kohls. I was told I couldn't have it because I had no BS degree. Meanwhile, the greeter literally can't talk, the sales person is making everyone mad, and the cashier is literally yelling, "I CAN HELP YOU OVER HERE!" to literally no one.
      Once I accidentally agreed to an interview at a gas station. I wasn't interested in the job, so I basically did the opposite of what they teach you to do in an interview. I was hired on the spot!
      The truth is, companies don't want to hire smart people. They want to hire dum people.

    • @TheNapalmFTW
      @TheNapalmFTW 4 года назад +8

      @@wandererreece9540 that's literally the plot of Ted.

    • @SomethingUnremarkable
      @SomethingUnremarkable 4 года назад +5

      Don't make yourself a victim to this world. There's a reason that some people are successful and some aren't, and it isn't how well you can follow orders 😉

    • @Chrischi3TutorialLPs
      @Chrischi3TutorialLPs 4 года назад +8

      And for that matter, the countless SQL Injections that still happen every year even though SQL comes with a command built specifically to make those ineffective.

  • @HDTomo
    @HDTomo 3 года назад +87

    Thanks Sam! This actually seriously helped. I nearly did it and couldve been cost thousands! I'll choose NaN now after my grand mother!

  • @PhilDaw
    @PhilDaw 4 года назад +171

    "There is no easy fix" As if database engineers haven't been sanitising inputs since injection was discovered

    • @denny-lp1qb
      @denny-lp1qb 4 года назад +14

      Yeah but then there's people that code in php...

    • @NovemberOrWhatever
      @NovemberOrWhatever 4 года назад +4

      *As if database engineers haven't been told to sanitise inputs since injection was discovered

    • @yerdude
      @yerdude 4 года назад +3

      ikr, had they sanitized the input data, this wouldn't have happened, It's so sad that the world is full of stupid people. real engineers know how to use nulls in their code.

    • @polyhistorphilomath
      @polyhistorphilomath 4 года назад +1

      If you hook your database straight to the inter webs without anything in between... that’s a problem already.

  • @cubbyrubenstein945
    @cubbyrubenstein945 4 года назад +300

    "Ah, yes, we call him little Bobby Drop Tables."

    • @FurryWrecker911
      @FurryWrecker911 4 года назад +6

      That is such a wonderful comic.

    • @BladeOfLight16
      @BladeOfLight16 4 года назад

      Actually, as useful as that comic is, the code that allows those injections wouldn't cause this behavior.

    • @daryfitrady7590
      @daryfitrady7590 4 года назад +8

      I bet Bobby Tables' mother has that Null license plate as well.

  • @ktheveg
    @ktheveg 2 года назад +60

    There's a pretty big difference between writing "6E 75 6C 6C" in your database than to write "00" in your database

    • @BusinessWolf1
      @BusinessWolf1 Год назад +4

      javascript.

    • @keiyakins
      @keiyakins 10 месяцев назад

      00 is a valid string. You need to record the difference in *type*.

  • @Nchinnam
    @Nchinnam 4 года назад +480

    There goes my plans to change my name to null

    • @Prajwal.K
      @Prajwal.K 4 года назад +1

      was Ur name null before or u change it?

    • @spiderthecat
      @spiderthecat 4 года назад +6

      @@Prajwal.K ???

    • @haoqw
      @haoqw 4 года назад +2

      Prajwal Kumar ?????

    • @maskettaman1488
      @maskettaman1488 4 года назад +13

      It'd be better than that absolute disaster you have right now

    • @integralboi2900
      @integralboi2900 4 года назад +1

      Prajwal Kumar ???????

  • @BlueOvals24
    @BlueOvals24 4 года назад +472

    I guess this explains how the character "Null" came to be in No Mans Sky.

    • @KyloGwen
      @KyloGwen 4 года назад +46

      A comment about no man's sky was the last thing I expected to see here and that's why I love it

    • @angelparkley2716
      @angelparkley2716 4 года назад

      Blue_ JayC Frl you know how much I had to hyperjump to look for shit

    • @musicalspoon7219
      @musicalspoon7219 4 года назад +2

      @fireballdick I don't know about him, but I once found a system made entirely out of pink temperate planets. water was pink, clouds and sky were pink, the grass was either blue or green, but the majority was ocean anyways.

    • @BlueOvals24
      @BlueOvals24 4 года назад

      @Austin David Holy shit, I never even realized that!

    • @stellarsealin9561
      @stellarsealin9561 4 года назад

      MusicalSpoon Bro that literally sounds like the perfect system. Blue grass planets ftw

  • @dankthefranktank1926
    @dankthefranktank1926 4 года назад +426

    When you name your son "Robert'); Drop TABLE Students;--"

    • @d9zirable
      @d9zirable 4 года назад +44

      xkcd moment

    • @madelinejester633
      @madelinejester633 4 года назад +79

      little Bobby Tables, we call him

    • @adamsfusion
      @adamsfusion 4 года назад +27

      He's going to grow up to destroy great things.

    • @jeffkinney2852
      @jeffkinney2852 4 года назад +1

      Omg
      ruclips.net/video/nXrvWCkgVdA/видео.html

    • @Bryan-qd4fk
      @Bryan-qd4fk 4 года назад

      I was talking to my coworker today about that comic

  • @nn26376
    @nn26376 3 года назад +17

    I recall reading a news article some years ago about someone who had the one-digit vanity license plate "0" in Illinois, which law enforcement from around the state (not thinking it could be a real plate) had routinely used as a dummy plate when testing systems. As I recall, the actual owner lived in Chicago and found out about the problem when his car was booted for tens of thousands of dollars in unpaid citations (which obviously weren't his).

    • @koenven7012
      @koenven7012 4 месяца назад +1

      That a street cop doesn't know one doesn't test systems in the production database I can understand, but the developers of said systems should know this and make sure proper checks are in place to prevent this from happening.
      In my company someone did this by accident once and the amount of paperwork we had to fill in and the checks we had to put in place were insane.

  • @ScottMaday
    @ScottMaday 4 года назад +250

    Me, a Computer Science student clicking on this video: *oh no*

  • @DoUrden09
    @DoUrden09 4 года назад +104

    HAI: NULL breaks everything
    All programmer and database admin: Badly managed DB or bad code.

    • @HirokaAkita
      @HirokaAkita 3 года назад +1

      Default option:
      A third-world country where they won't pay their programmers enough.

    • @M1mer
      @M1mer 3 года назад +2

      @@bbunk22 comparing his plate, 'null', to null, and returning equal is bad code

  • @ShadowGamer507
    @ShadowGamer507 4 года назад +453

    Some wannabe tough guy: "Don't mess with me, I'm pretty good in a fight"
    Some dude whose last name is Null: "oh yeah? My very existence destroys every database known to man."

    • @ihateloudbitches
      @ihateloudbitches 4 года назад +13

      He is the chosen one

    • @Kutchy7765
      @Kutchy7765 4 года назад +5

      @Haley Fucking Halcyon - Gaming Channel 90% databases known to man

    • @HECKproductions
      @HECKproductions 2 года назад +1

      *every database constructed by a mentally challenged 5 year old who knows literally nothing about computers

  • @Viper-dz2kw
    @Viper-dz2kw 3 года назад +91

    Interesting that you can’t put “Samsucks” but I’ve literally seen a “cops suck” plate, it was over 10 years ago, but I remember it strikingly because of how dumb of an idea for a plate it was

    • @LRM12o8
      @LRM12o8 3 года назад +21

      lol!
      The best thing about this story is the thought that because of that anti cop plate, the cops won't be all that nice to him, which reinforces his anti cop attitude with each traffic stop! 🤣

    • @hoghuhaghu8506
      @hoghuhaghu8506 Год назад

      @@LRM12o8 Time to get a pro-cop license plate

    • @juanin200
      @juanin200 Год назад

      Cops do suck though

  • @imassassinn
    @imassassinn 4 года назад +108

    I like how the video shifted from a romantic gift to a bouy in the ocean.

  • @JJCUBER
    @JJCUBER 4 года назад +276

    Why the hell would null map to the string “null” and vis versa? This makes little to no sense and whoever programmed this wasn’t thinking straight.

    • @paskky913
      @paskky913 4 года назад +24

      They probably programmed it in a way that if no license plate was found, it automatically put the string "NULL" to fill the void.

    • @JJCUBER
      @JJCUBER 4 года назад +29

      Paskky Pask which is a horrible idea, considering people could choose that name

    • @scrabblehandforaname
      @scrabblehandforaname 4 года назад +5

      Type conversions most likely.

    • @paskky913
      @paskky913 4 года назад +3

      @@JJCUBER But it's way more understandeable than just randomly casting null to a string.

    • @user-lk2vo8fo2q
      @user-lk2vo8fo2q 4 года назад +5

      this is so batshit i can only assume it's somehow php's fault.

  • @alexlandherr
    @alexlandherr 4 года назад +226

    “You should learn to sanitize your database inputs.”
    Read xkcd’s “Exploits of a Mom”.

  • @randolpho-
    @randolpho- 3 года назад +13

    In another state (I forget which)some had '0000000' as their license plate number and that's their unknown plate default and this person also had tens of thousands of dollars in fines.

  • @cat-.-
    @cat-.- 4 года назад +304

    I know how to configure my database to not confuse "null" the string with null the empty value in my freshman year in college for computer science :/

    • @nullnull3517
      @nullnull3517 3 года назад +8

      good

    • @xn85d2
      @xn85d2 3 года назад +15

      I mean, in MSSQL you literally cannot use "null" as null the value. You need to use == "null" as a comparator for the string and is null as a comparator for the value.
      My guess is that the reason this happened in that the police database was defaulting to putting in "null" as a string as something the programmers added intentionally as a placeholder when the license plate was unknown.

    • @CodeKujo
      @CodeKujo 3 года назад +2

      The only thing that makes sense to me is if there's a step in-between (like in javascript or something) that is blindly coercing the result to a string and then using it in subsequent queries. Nit: Also, "null" would be an object name in most DBs, like `select null from "null" where "null" = 'null'`

    • @joshua43214
      @joshua43214 3 года назад

      R enters the chat:
      > null null+null
      [1] 10
      R is stupid

    • @cat-.-
      @cat-.- 3 года назад +2

      @@joshua43214 R's null is NULL so...
      and you definitely can't NULL

  • @DeltaJim
    @DeltaJim 4 года назад +126

    Fun fact: Illinois apparently doesn't ban Russian curse words on vanity plates. I used to have a neighbor who had "Blyat" as his plate and no one seemed to know what that word meant.

    • @ashathlok829
      @ashathlok829 4 года назад +13

      That's the only good thing about Illinois tbh

    • @melkiorwiseman5234
      @melkiorwiseman5234 4 года назад +26

      "Cyka Blyat" is the Russian god of bad driving. The Russians invoke her name every time they have a crash. ;)

    • @denyraw
      @denyraw 3 года назад

      ruclips.net/video/Qb3DkYZvzjU/видео.html

    • @fordprefect1587
      @fordprefect1587 3 года назад +2

      @@melkiorwiseman5234 that is... oddly specific.

    • @melkiorwiseman5234
      @melkiorwiseman5234 3 года назад

      @@fordprefect1587 Just in case you (or anyone else) doesn't get it, it's a joke.
      A rough (very) translation of Cyka Blyat is actually closer to "dirty whore" (putting it politely).

  • @ONW4V3R
    @ONW4V3R 4 года назад +339

    To be fair it's just laziness from the developpers.
    "NULL", "Null" or "null" as caracter chains (or strings) are not the same as the NULL marker of databases.
    Even the C from the late 70's knows how to manage strings and markers.

    • @peterbonnema8913
      @peterbonnema8913 4 года назад +6

      Yes of course. That's a given... Kinda the whole premise of the story

    • @NathanVoge
      @NathanVoge 4 года назад +4

      You're assuming the database was the issue and not cops manually (or their software automatically) entering "Null" as the license plate string into the database.

    • @ONW4V3R
      @ONW4V3R 4 года назад +4

      @@NathanVoge none of what I said fault the database tho?
      Everything I said put blame on lazy devs, being the ones in charge of the DB or the application. And it's more likely the app team's fault.
      Even if a DB isn't made to support null fields you can work around it just fine and still avoid problems like that.

    • @Richybabes
      @Richybabes 4 года назад +8

      Yeah any system that falls prey to this error is just poorly designed. It's not difficult to avoid. That said, it doesn't surprise me that there's poorly written code doing this in plenty of places.

    • @naphackDT
      @naphackDT 4 года назад

      A lot of scripting languages don't... And you don't know what the police's system runs on.

  • @stumiles86
    @stumiles86 3 года назад +15

    There's an identical story to this where the plate was "No Tag" so every time there was a car parked with no plates the cop wrote no tag on the ticket

  • @decline6561
    @decline6561 4 года назад +330

    My mom named me ";DROP TABLE Students"
    i've been having so much trouble getting a school to accept me into their program :(

  • @random8149
    @random8149 4 года назад +507

    Fun fact: Null is also a german word and means zero.

    • @dasaleks6480
      @dasaleks6480 4 года назад +25

      Der Grund warum ich das Video angeklickt habe. 😂

    • @admiralradish
      @admiralradish 4 года назад +9

      only a millenial wouldnt know that.

    • @bangtanza4208
      @bangtanza4208 4 года назад +11

      Random Vids it’s also zero in dutch

    • @dudewtfyoudoin6522
      @dudewtfyoudoin6522 4 года назад +20

      Das Raddiche and people that don’t speak German

    • @Kylora2112
      @Kylora2112 4 года назад +10

      In American English, we use "null" to mean a piece of data that doesn't exist rather than a value of zero.

  • @teunjojo
    @teunjojo 4 года назад +1610

    “They run the risk of breaking every modern database”
    No they don’t

    • @melkiorwiseman5234
      @melkiorwiseman5234 4 года назад +150

      Correct. Idiot is just quoting an urban legend, possibly based on a real case which I outlined in my comment.

    • @jonathanzimmer8143
      @jonathanzimmer8143 3 года назад +71

      Remember Y2-K? Yeah. Me neither.

    • @smraddebeli
      @smraddebeli 3 года назад +11

      Hacking without hacking

    • @NickRoman
      @NickRoman 3 года назад +42

      @@jonathanzimmer8143 , Y2K, yeah I remember. We weren't sure what would happen. And I had to update firmware on some computers to prevent the otherwise inevitable problem.

    • @troodon1096
      @troodon1096 3 года назад +59

      @@NickRoman The money to solve the problem wasn't wasted, because the computers would have to be updated anyway. Fire insurance is not a waste of money just because your house didn't burn down.

  • @michaelmorris4515
    @michaelmorris4515 4 года назад +5

    I've worked on software that handles and issues license plates in Tennessee, so I have some insight into how this might happen.
    These days clerk's offices are using web apps on county and state intranets built to purpose. These use browsers, and the datatype of all inputs from a browser is a string. So what you have is a programmer who made a wrong assumption about people choosing the word "null" as a vanity plate name - or rather they likely didn't give it any thought until the bug came up.
    I had a similar snafu crop up where I was working where the original programming team assumed no 2 plates could ever have the same value. A reasonable assumption until someone let a vanity plate expire, then successfully appealed to the state to have the name opened back up for them for the second plate from 2 years ago. Our system wasn't having any part of it - until I backdoored the system and deleted the original expired plate because I didn't have the time to do a proper fix of altering the system to use a true primary key on auto-increment as it should have been doing in the first place. Besides, I was only altering the county's local copy of the record - the state official record still had the original expired plate's existence on file in the unlikely event anyone ever needs to know about it.

    • @BusinessWolf1
      @BusinessWolf1 Год назад +1

      That is the longest way of saying "javascript" I've ever seen.

  • @lilyydotdev
    @lilyydotdev 4 года назад +322

    Programmers be clicking on this like "oh no i know exactly what happened here"

    • @danieltabrizian
      @danieltabrizian 4 года назад +14

      How did you know, like this was exactly what i tought

    • @pitaya4151
      @pitaya4151 4 года назад +29

      I don't get it though. Why is the Californian police DB storing "null" as a string, a string that can be matched against the plate "null"? Couldn't they use something like "PLATE-NA" - that is 8 characters, so that means it will never be a valid plate in the entire state (with the limit being 7). Or even better, just have the word null multiple times, as in "NULL-NULL-NULL-NULL"?

    • @CodeKujo
      @CodeKujo 4 года назад +7

      Good 'ol Bobby Tables.

    • @WombatSteve
      @WombatSteve 4 года назад +3

      reddit

    • @pitaya4151
      @pitaya4151 4 года назад

      @@CodeKujo what

  • @Pellbort
    @Pellbort 4 года назад +189

    Wendover: Says "days" when it's really years
    Confirmed- Sam runs AliExpress shipping

  • @ccityplanner1217
    @ccityplanner1217 4 года назад +208

    The fines should not be his liability. Police officers should be diligent & note down the numberplate.

    • @Oridemic
      @Oridemic 4 года назад +14

      ccityplanner12 : The government doesn’t care. More money for them.

    • @petersansgaming8783
      @petersansgaming8783 4 года назад +10

      @@odysseyguyperson something like that won't be done because null is a wide spread programming convention. Their database is just poorly written when 'null' can be confused with ' "null" '.

    • @odysseyguyperson
      @odysseyguyperson 4 года назад +1

      DuesenJeff ok.

    • @TeemoQuinton
      @TeemoQuinton 4 года назад +3

      @@petersansgaming8783 Which shouldn't happen, period.

    • @99xara99
      @99xara99 4 года назад

      Police officers are only humans too. Their database system needs the fixing.

  • @vinceramces
    @vinceramces 3 года назад +17

    This happens to Ms. True where she can't access her apple account due to her last name.

  • @ttomasarias3719
    @ttomasarias3719 4 года назад +161

    Good morning, yes, I'd like to request the droptables license plate.
    Why would I like that license plate?
    It was... Umm... My grandfather's nickname, yes, Bob Droptables...

    • @michaeledmunds7266
      @michaeledmunds7266 4 года назад +20

      When he was younger, they would call him "little Bobby tables"

    • @UmbraMG
      @UmbraMG 4 года назад +11

      @Gustav 123 @Gustav 123 DROP [database name] is used to delete a database.

    • @maheepsingh3612
      @maheepsingh3612 4 года назад +3

      Ah, xkcd :)

  • @DarkSolidity
    @DarkSolidity 4 года назад +324

    But “Null” and dbnull.value are completely different things. Someone isn’t sanitizing their queries.

    • @ecamiran4004
      @ecamiran4004 4 года назад +27

      The problem (not for maps or automated contact systems, but for license plate issues) is not that they are confusing the two. The problem is that it would be manually written in as "NULL". And because of how the process is simplified, not even a car make and model os verified against the system's database (done for a variety of reasons), meaning every time a PO would write "NULL", then it would be redirected to the existing plate with that name, meaning it was redirected to the guy who thought it would be smart to try and use that license plate name.
      This comment's section is full of people assuming the database is holding 0=value:null="NULL" to be a true statement or something similar. When all it is doing, because of how it gets input, is going "NULL"="NULL".

    • @Stoner_Jesus
      @Stoner_Jesus 4 года назад +4

      Ecamiran you clearly understand this more than me

    • @drakemorin5727
      @drakemorin5727 4 года назад +3

      @@ecamiran4004 I must say I didn't consider that. I was likewise confused that it must be a pretty poorly written piece of software to convert "Null" to the SQL representation of a null value.Thank you for pointing out a much more logical reason this would be difficult to fix. Cheers to you!

    • @Shyuthrosnaevin
      @Shyuthrosnaevin 4 года назад

      .

    • @vindalowd1107
      @vindalowd1107 4 года назад

      @@ecamiran4004 I was confused why everyone was talking about programming.

  • @billylardner
    @billylardner 4 года назад +411

    Ima call my son “Charlie DROP TABLE users;” and watch the havoc unfold.

    • @tirtagttech512
      @tirtagttech512 4 года назад +40

      @Gustav 123 DROP [database name] is used to delete a database.
      Usually its used for deleting database on server by using the vulnerability on some SQL databases (the newest version has a patch to prevent this)

    • @EternalDensity
      @EternalDensity 4 года назад +29

      2012 called.
      It wants bobby-tables.com back

    • @Zantreful
      @Zantreful 4 года назад +7

      You forgot two important details... What you mean to input into the user field is " Charlie' union drop table users /* "

    • @timerertim
      @timerertim 4 года назад +3

      @@Zantreful Union is used to fuse the output of two Select Statements together. Correct me if I'm wrong, but you should replace Union with ;

    • @iLikeTheUDK
      @iLikeTheUDK 4 года назад +7

      Imagine the reactions when first registering that at the national registry - it'd be the bureaucratic equivalent of a blue shell

  • @josephiroth89
    @josephiroth89 2 года назад +1

    I heard about someone doing something similar with their license plate but theirs was “NO TAGS.”

  • @maggie12md18
    @maggie12md18 4 года назад +235

    So let’s say that someone called “Noah Body” punches you at school. Then when you have to tell who punched you, you say “Noah Body” but it sounds like “nobody”, so Noah Body gets off scott free for punching you. ^ the whole video in a nutshell

    • @octogonSmuggler
      @octogonSmuggler 4 года назад +20

      You could have just used the Cyclops bit from the odessy... That's where this comes from..

    • @dogmechanix
      @dogmechanix 4 года назад +1

      Uh huh...

    • @IceBlueLugia
      @IceBlueLugia 4 года назад +5

      Octogon Smuggler That’s exactly what I was thinking lmao

    • @maggie12md18
      @maggie12md18 4 года назад +2

      Octogon Smuggler that’s what I was going at. In English I had to read up on the Epic poems by Homer and this was one of the short stories within. Poor guy got blinded as a result :(

    • @Andres183_
      @Andres183_ 3 года назад +6

      Or that's what Joseph Tartaro expected, but rather anytime nobody knew who punched someone, it got tracked to him. So he gets charged for punching several people.

  • @theblasko
    @theblasko 4 года назад +196

    And that's why my license plate reads "ILUVHAX'); DROP TABLE tag;--"

    • @J_E_N_T
      @J_E_N_T 4 года назад +5

      Gottem

    • @gooball2005
      @gooball2005 4 года назад +32

      the ol' bobby tables

    • @hydrochloricacid2146
      @hydrochloricacid2146 4 года назад +4

      A fellow man of culture I see

    • @juhotuho10
      @juhotuho10 4 года назад +23

      ^ xkcd in question xkcd.com/327/

    • @falk2009
      @falk2009 4 года назад +1

      What would that function do?

  • @ixinfamous1412
    @ixinfamous1412 4 года назад +512

    You can't choose null as yours.
    Me, a bigbrain: uses i's instead of L's

    • @KilosFoxo
      @KilosFoxo 4 года назад +13

      Nuii

    • @masterzillagaming2963
      @masterzillagaming2963 4 года назад +26

      NuII

    • @dannyp204
      @dannyp204 4 года назад +13

      Fun fact. They don't let you do that. If there's a plate NULL you can't to NUII or NUIL. Or other things that replace it. So if PENIS is taken which it never can be, you can't take P3N1S

    • @benjaminrobledo5466
      @benjaminrobledo5466 4 года назад +2

      NuII

    • @mhrn.1309
      @mhrn.1309 4 года назад +7

      Its NULL, not Null. License plates are always capitalized.

  • @ahotdj07
    @ahotdj07 3 года назад +5

    I had “OMYPUSE” as plates in Dallas TX for years until they caught on what it sounds like when pronounced.

    • @melkiorwiseman5234
      @melkiorwiseman5234 3 месяца назад

      They have less of a sense of humour than the British. Something like that has been a joke ever since Mrs Slocum from the Are You Being Served series.

  • @Zeytrixx
    @Zeytrixx 4 года назад +164

    I remember when “Null” used to be a Minecraft creepy-pasta. It was like Herobrine, because people did sighting videos about it.

  • @DylansLapplandSimping
    @DylansLapplandSimping 4 года назад +44

    "Breaking news: florida man hacks police database using his license plate"

    • @martinyzfr
      @martinyzfr 4 года назад +1

      That *Florida man* makes it alot better

  • @rockett6578
    @rockett6578 4 года назад +391

    Guy on roblox: types null
    Roblox chat filter: *this user has said a word that to our archives does not exist*

    • @teonyi
      @teonyi 4 года назад +6

      Zap Zack Your English is Null

    • @oscarword775
      @oscarword775 4 года назад +7

      @@teonyi I don't see anything wrong there. It has some missing punctuation, I guess, but I assume that's not the issue.

    • @Alphawolvess
      @Alphawolvess 4 года назад +2

      They use Nil

    • @generpicado7838
      @generpicado7838 4 года назад +5

      Roblox chat filter ##### so ###

    • @43Cubes
      @43Cubes 4 года назад

      null

  • @FireyDeath4
    @FireyDeath4 3 года назад +5

    This is why it's very important to distinguish strings and senselessly labelled values such as true, false, null and undefined. In fact, as I was typing this, I just put quote marks around them to label them, and then I realised they were strings and removed them. Be careful out there, programmers

  • @abedozier4212
    @abedozier4212 4 года назад +20

    So I went to 0,0 on google maps after watching this and there’s a ton of those little blue dots where you should be able to have street view but there’s nothing there, I assume the pictures were submitted without coordinates so thank you for showing me another useless piece of interesting information

  • @____7460
    @____7460 4 года назад +55

    Editor: so how many stock images do you want
    HaI: yes

  • @djvelocity
    @djvelocity 4 года назад +33

    I’m going to use “Anthony Null” for every singe website I sign up for now 😅

    • @temppenguin9633
      @temppenguin9633 4 года назад +8

      You should legally name yourself Null Null.

    • @coalescipede
      @coalescipede 4 года назад +3

      or Null Void

    • @tabnk2
      @tabnk2 4 года назад +4

      8legs Void Null is better, since Void means “nothing”, and some BAD databases can confuse “Void Null” for “a variable of type Void named Null”; this may or may not crash the program

  • @sircompliments5380
    @sircompliments5380 3 года назад +21

    I'm making my license plate "your" because I think it would be funny.

  • @dragicorns8833
    @dragicorns8833 4 года назад +46

    Ahh, my neighbor has the license plate of "sux2beu"
    0:40

    • @macgyver5108
      @macgyver5108 3 года назад +1

      My buddy had a plate that said X35 L4R0 for several years...

  • @annabelleharvey6730
    @annabelleharvey6730 4 года назад +30

    soo i could, technically make my license plate "yeet"?

  • @mememan9890
    @mememan9890 4 года назад +54

    I feel like issues like this should've been fixed long ago

    • @amshermansen
      @amshermansen 4 года назад +12

      They should - This is programming 101. Unit testing against the most common and obvious mistakes. Like leaving an entry field empty or putting letters in a field only intended for letters.

    • @johngaltline9933
      @johngaltline9933 4 года назад +10

      You can't fix lazy. Aside from SQL being a horrid mess of trash even today, most of these government agencies are running on databases created 30+ years ago.

    • @nitehawk86
      @nitehawk86 4 года назад +7

      I was fixing Y2K bugs in banking software in 2005, so... yeah...

    • @neeneko
      @neeneko 4 года назад +1

      It can not be fixed, not in a general sense. The problem is not the database itself, or even the access layer, but a problem of how data errors can creep in during the workflow. Unless you can lock down access to only be done through a strictly controlled application (so no API, and no web based interface, just direct desktop application), there are going to be places where inputs are being converted and changed, which introduces chances for 'make it safe' code to backfire and introduce a string where there should not be one. And once it is in the data flow, the DB has no way to distinguish an invalid null from a valid one.

    • @slaythevirus
      @slaythevirus 4 года назад

      @@nitehawk86 banking software is atrocious and outdated. The amount of security vulnerabilities are ridiculous. There was even a software that could only be interfaced with via internet explorer because it was programed for trident engine. I can guarantee that if some of that software got leaked to the major public it would be bad news for the entire banking community.

  • @PepperMarioYT
    @PepperMarioYT 8 месяцев назад +1

    the matpatify extension made the perfect text (who's the killer) with GTLIVE on the opposite side of the HAI logo

  • @TWOOOOO2
    @TWOOOOO2 4 года назад +57

    Instead of using "Null", modern databases should use "Crazy Chicken Maze Express III: Horny Edition Super"

    • @Thetankracer
      @Thetankracer 4 года назад

      Ummmmmm, Ok

    • @LeapyLad
      @LeapyLad 4 года назад +7

      Gonna change my name to that

    • @1sdani
      @1sdani 4 года назад +2

      +El Lapras It's been four days

    • @micaelstarfire8639
      @micaelstarfire8639 4 года назад +2

      Or just have a separate PlateExists flag for the ticketing software

    • @LeapyLad
      @LeapyLad 4 года назад +3

      @@1sdani my REAL name i mean

  • @jeraimie
    @jeraimie 4 года назад +33

    Saw a plate with "oh ffs" thought it was pretty clever.

  • @LukiSurkraBlade
    @LukiSurkraBlade 4 года назад +63

    People with null in there names: break databases
    Me with my long full name: breaks school computer system due to a character limit.

    • @comic12558
      @comic12558 4 года назад

      Waittt is this a joke orrrr

    • @LukiSurkraBlade
      @LukiSurkraBlade 4 года назад +4

      @@comic12558 not a joke, my real full name is 30 characters long, which back in early 2000s broke some character limits because some people who made programs for schools didn't think kids would have more than 3 names/words in their full names. In highschool there was even a kid with a 43 character fill name, which i believe was was 4 names/words and one combined name.

    • @couldntsetpass2901
      @couldntsetpass2901 4 года назад +3

      @@LukiSurkraBlade Would you mind telling your full name?

    • @zekchomenko2927
      @zekchomenko2927 3 года назад

      @@LukiSurkraBlade just marking my spot here

    • @kimberleysunchuk2909
      @kimberleysunchuk2909 3 года назад

      my full name is not on my medical insurance for that reason

  • @momoniji6439
    @momoniji6439 8 месяцев назад +1

    Imagine trying to break the system and getting mad when you break the system.

  • @Ilikeminecraft57
    @Ilikeminecraft57 4 года назад +21

    5:30
    Voice-over: "Final Days"
    Screen: *"Final Years"*

  • @vysernius
    @vysernius 4 года назад +31

    vsauce: *heavy breathing*

  • @penumbra0182
    @penumbra0182 4 года назад +82

    Last time I was this early, Sam wasn’t obsessed with planes.

  • @hai1touch
    @hai1touch 2 года назад +4

    Sam: “There is no easy fix.”
    literally everyone who knows one (1) thing about computers: “If you’re *_STUPID.”_*

    • @algotkristoffersson15
      @algotkristoffersson15 3 дня назад

      There actually is no easy fix.
      The tickets are printed and then scanned in again. So if you have the actual null value leave the physical ticket empty then you have no way of knowing if the ticket being empty was because of it being fed a null value or because of a printer error.
      They could of course have null values result in the printing of a non ASCII symbol, for example 💀but then they would need to update the detection software to support Unicode which would be a medium difficulty task, not easy.

  • @NonRandomUser
    @NonRandomUser 4 года назад +15

    Narrator: "The Final Days of Majuro"
    Text on Screen: "The Final Years of Majuro"
    Ah, so I've slipped into an alternate dimension.

    • @HappyBeezerStudios
      @HappyBeezerStudios 4 года назад

      The final days are at the end of the final years!
      Damn time travellers

  • @callbettersaul
    @callbettersaul 4 года назад +525

    Fun fact: Null is number 0 in Estonian.

    • @fyz6034
      @fyz6034 4 года назад +45

      funier fact: null is equal to zero in lower level languages

    • @Goldenhawk583
      @Goldenhawk583 4 года назад +21

      @@fyz6034 funier... So, which language is that? I know it resembles English, but the spelling of that word in English , is "funnier".
      Since the op spelled all his words correctly ( Null means zzero in Norwegian too by the way ;) ), I must assume that, not only is your language low level, but it is lower level than the English you attempted using.
      Since all our languages has ancient roots, and since some of us still hold more true to the original source where words had a lot more meaning, and were far more complex than now, we must assume that our languages, that retain more of the original words, are of a superior, rather than inferior level, than the constructed languages ( like English), of modern times.
      Modern English is a language constructed to confuse and obfuscate, rather than enlighten and expand the users knowledge.
      null (adj.)
      "void of legal force, invalid," 1560s, from Middle French nul, from Latin nullus "not any, none," from ne- "not, no" (from PIE root *ne- "not") + illus "any," diminutive of unus "one" (from PIE root *oi-no- "one, unique").

    • @TheoTungsten
      @TheoTungsten 4 года назад +20

      Same in Dutch, except it's "nul".

    • @Brickmaster202
      @Brickmaster202 4 года назад +70

      German too

    • @Newbyte
      @Newbyte 4 года назад +16

      In C++ NULL is defined as 0.

  • @MidnightSt
    @MidnightSt 4 года назад +239

    Buddy, I like you, but it kind of feels like since you're doing stuff for nebula, the quality of your youtube videos is declining. In this specific case, it's very visible to me as a programmer, and apparently also to many other people complaining in the comments about the same thing. The fact that you glossed over the explanation of why NULL causes trouble is... fine, I guess? But the fact that you glossed over it by telling a wholly incorrect claim that databases and computer systems around the world can't distinguish between a string "NULL" and a literal value NULL (which is basically the same kind of difference as between the string "100" and literal number 100)... that was... well... bad.

    • @Arterexius
      @Arterexius 4 года назад +17

      Or as a translation to non-programmers. It's like saying it's impossible to distinguish between a Great Dane and a Chihuahua. Which, of course, isn't the case.

    • @cerulean22b69
      @cerulean22b69 4 года назад +8

      Im only a week into my programming course but i actually understand this.

    • @MidnightSt
      @MidnightSt 4 года назад +19

      @@Arterexius that's a... weird simile.
      and incorrect. correct one (even though even weirder and forced) would be that it's like saying it's impossible to distinguish between a kennel containing a dog of a breed called No Dog, and a kennel in which there is no dog.

    • @KnakuanaRka
      @KnakuanaRka 4 года назад +2

      Yeah, he definitely should have explained that better. It is perfectly possible to distinguish null from “null”, but this mistake can happen in sloppy code.

    • @kvozart8437
      @kvozart8437 4 года назад

      Just like with millennium error. Everyone was afraid of falling planes at 00:00 of 2000/01/01

  • @KimmoVirtanen
    @KimmoVirtanen 3 года назад +3

    1:27 Love how in the background stock video our G-Man is dealing with a screen he mistakenly thinks is touch-enabled.

  • @Bongs237
    @Bongs237 4 года назад +13

    Next video: Someone names their license plate "drop table LicensePlates"

  • @horntx
    @horntx 4 года назад +45

    my next licence plate: ; "DROP * FROM *"

    • @0x8badf00d
      @0x8badf00d 4 года назад +2

      @GunsOfThePhoenix They needed a fix?!

    • @gorkskoal9315
      @gorkskoal9315 4 года назад +1

      well nuking everything after someone ran one stop...probably something like: you. are. so. fired! LOL

    • @gorkskoal9315
      @gorkskoal9315 4 года назад

      yeah I think they like crack. :P

    • @zlot555
      @zlot555 4 года назад

      @GunsOfThePhoenix Do you have a source for that? It sounds unrealistic as it doesn't even fit the Ukrainian number plate format AB1234CD (en.wikipedia.org/wiki/Vehicle_registration_plates_of_Ukraine)

  • @JoshSweetvale
    @JoshSweetvale 4 года назад +41

    Is this a "Timmy ;; drop tables" thing? Like from XKCD.
    EDIT - Yes, yes it is

  • @anybudz
    @anybudz 3 года назад +4

    0:46 "suggestions that you're a cop"
    I'm from New Zealand, but a friend of my parents has a license plate that is literally "IMACOP"
    (*His reason for the plate is because he drives a Holden Commodore which cops in our country use as cop cars*)

  • @doctadoom6265
    @doctadoom6265 4 года назад +65

    Another terrible potentially fatal mistake is putting a little trees air freshener in your car. Look up the video “this little tree air freshener is covering up something foul”

    • @waysidetundra3352
      @waysidetundra3352 4 года назад

      Coconut

    • @oriolesfan61
      @oriolesfan61 4 года назад +1

      A cluster of pine tree air fresheners is called a Felony Forest by police

  • @vinnt_tnniv
    @vinnt_tnniv 4 года назад +15

    Just by the title I knew it
    Null is basically you saying to the database:
    you:hey database, this is what i want
    db: that's nothing
    you: no, it's a word
    db: no, it's nothing
    you: okay, I'll just put a string on the old plate then

    • @SolaceCafe
      @SolaceCafe 4 года назад +3

      VinnT- -TnniV it's because of shitty code. My discord bots can easily tell the difference between python "None" and " 'None' "

  • @jano979797
    @jano979797 4 года назад +134

    where licence_pate='NULL'
    - will return his licence plate
    where licence_plate is null
    - will return empty licence plates.
    SQL and i fixed it

    • @robertlinke2666
      @robertlinke2666 4 года назад +10

      except for the typo in the first line, this indeed would work.

    • @TheAkashicTraveller
      @TheAkashicTraveller 4 года назад +16

      @UCK1YrLTWBZ1_pQexyAgCVIA Don't worry that's a legacy typo made when the database was first made.

    • @AbstractJJJ
      @AbstractJJJ 4 года назад +2

      @@TheAkashicTraveller oh god, I hate legacy typos. Especially if it's some ID (like this hypothetical one) I have to refer to in code, and then the typo propogates until there's dozens of usages and it never changes

  • @BusinessWolf1
    @BusinessWolf1 Год назад +1

    My license plate is " DROP TABLES *