It's that time of the year again!

3 years ago by masimatutu to c/programmer_humor

files.mastodon.social/media_at…

GBU_28 74 points 3 years ago

No closing semicolon, anyone got any extras to throw on this thing?

save

path: 0 5921591, hotness: undefined, score: 74, children: 15

epyon22 29 points 3 years ago

; found this in the back for you should still work though

save

path: 0 5921591 5921725, hotness: undefined, score: 29, children: 1

db2 7 points 3 years ago

Can confirm.

save

path: 0 5921591 5921725 5921843, hotness: undefined, score: 7, children: 0

Moops 17 points 3 years ago

At the very least I'd try to clean up that fuzzy condition on behavior to anticipate any bad or inconsistent data entry.

WHERE UPPER(TRIM(behavior)) = 'NICE'

Depending on the possible values in behavior, adding a wildcard or two might be useful but would need to know more about that field to be certain. Personally I'd rather see if there was a methodology using code values or existing indicators instead of a string, but that's often just wishful thinking.

Edit: Also, why dafuq we doing a select all? What is this, intro to compsci? List out the values you need, ya heathen ;)

(This is my favorite Xmas meme lol)

save

path: 0 5921591 5922619, hotness: undefined, score: 17, children: 2

mp04610 12 points 3 years ago

behavior is an ENUM.

save

path: 0 5921591 5922619 5922935, hotness: undefined, score: 12, children: 0

moroni 4 points 3 years ago

That’s a table scan, right there. Naughty.

save

path: 0 5921591 5922619 5927814, hotness: undefined, score: 4, children: 0

pruwybn 7 points 3 years ago

Need to normalize the database. I would add a join to a BehaviorTypes table.

Edit: or, if the only options are naughty or nice, make it a boolean.

save

path: 0 5921591 5925604, hotness: undefined, score: 7, children: 0

krotti 4 points 3 years ago

Honest question, which ones wouldn't it work with? Most add a semicolon to the end automatically or have libraries and interfaces saved me a million times?

save

path: 0 5921591 5924747, hotness: undefined, score: 4, children: 4

GBU_28 4 points 3 years ago

Other reply s accurate but it's always a good practice to include the semicolon else you can get

"Bobby tables'ed" look that xkcd comic up

save

path: 0 5921591 5924747 5925182, hotness: undefined, score: 4, children: 2

docAvid 8 points 3 years ago

I'm not sure how including a final semicolon can protect against an injection attack. In fact, the "Bobby Tables" attack specifically adds in a semicolon, to be able to start a new command. If inputs are sanitized, or much better, passed as parameters rather than string concatenated, you should be fine - nothing can be injected, regardless of the semicolon. If you concatenate untrusted strings straight into your query, an injection can be crafted to take advantage, with or without a semicolon.

save

path: 0 5921591 5924747 5925182 5926424, hotness: undefined, score: 8, children: 1

GBU_28 2 points 3 years ago

Yep it would only work if you didn't sanitize a user input string in this case 'nice'

They could write ''; drop table blah;

save

path: 0 5921591 5924747 5925182 5926424 5927177, hotness: undefined, score: 2, children: 0

jaybone 1 point 3 years ago

Usually with libraries like jdbc or whatever and prepared statements you don’t need the semicolon.

save

path: 0 5921591 5924747 5924948, hotness: undefined, score: 1, children: 0

takeda 4 points 3 years ago

You need semicolons if it is a script with multiple commands to separate them. It is not needed for a single statement, like you would use in most language libraries.

save

path: 0 5921591 5926373, hotness: undefined, score: 4, children: 2

mellejwz 2 points 3 years ago

If you don't use a semicolon directly in MySQL it won't do anything until you add it.

save

path: 0 5921591 5926373 5939971, hotness: undefined, score: 2, children: 1

takeda 2 points 3 years ago

In the MySQL client console where you can run multiple commands.

If you add semicolon in language library commands such as fetch() you will get an error.

save

path: 0 5921591 5926373 5939971 5940323, hotness: undefined, score: 2, children: 0

fmstrat 2 points 3 years ago

Can we get a SIMILARITY?

save

path: 0 5921591 5930827, hotness: undefined, score: 2, children: 0

guy 35 points 3 years ago

Guess that settles the debate, we got to pronounce it "sequel" then to optimally match syllables

save

path: 0 5921546, hotness: undefined, score: 35, children: 17

RiikkaTheIcePrincess 23 points 3 years ago

Uuugghhh noooo! Ess Kyoo Ell!! ESS KYOO ELL!!! brandishes flaming pitchfork!

save

path: 0 5921546 5922315, hotness: undefined, score: 23, children: 0

db2 10 points 3 years ago

Squirrel works too though.

save

path: 0 5921546 5921837, hotness: undefined, score: 10, children: 5

squiblet 4 points 3 years ago

The Australian pronunciation works… “squi-rell”. Common American one is somehow just one syllable, “Skwurl”

save

path: 0 5921546 5921837 5923399, hotness: undefined, score: 4, children: 2

jaybone 1 point 3 years ago

How do you pronounce Smurf?

save

path: 0 5921546 5921837 5923399 5924988, hotness: undefined, score: 1, children: 1

squiblet 1 point 3 years ago

I'm not Australian.

save

path: 0 5921546 5921837 5923399 5924988 5926418, hotness: undefined, score: 1, children: 0

Doug 2 points 3 years ago

Yes but he serves a different community

save

path: 0 5921546 5921837 5922954, hotness: undefined, score: 2, children: 1

jadero 3 points 3 years ago

!squirrels@lemmy.ca

save

path: 0 5921546 5921837 5922954 5923368, hotness: undefined, score: 3, children: 0

threelonmusketeers 7 points 3 years ago

"Squill"

save

path: 0 5921546 5923436, hotness: undefined, score: 7, children: 0

pythonoob 3 points 3 years ago

Sequel to what?

save

path: 0 5921546 5943617, hotness: undefined, score: 3, children: 0

_danny 1 point 3 years ago

The only people I know who actually call it ess queue ell are either too new to know the "sequel" pronunciation, or the type of person you generally smell before you see.

save

path: 0 5921546 5922308, hotness: undefined, score: 1, children: 7

SpeakinTelnet 7 points 3 years ago

I say ess cue ell for the sake of uniformity because it's not Mysequel nor Postgresequel and the language changed from Sequel to the acronym SQL in the 70s so not really in the "too new" ballpark anymore.

save

path: 0 5921546 5922308 5923114, hotness: undefined, score: 7, children: 2

_danny 1 point 3 years ago

I think those make sense as deviations. I've heard "my sequel" but you're absolutely right about postgresql.

The name is kinda irrelevant like hard vs soft g in gif. People know what you mean when you say either.

But in that same vein, the creator of the "graphics interchange format" says the pronunciation is soft g, but basically everyone says hard g... So "official" pronunciation is kinda irrelevant.

I don't judge anyone who uses whichever term they want, but I've just noticed the general trend in my smallish interaction bubble.

save

path: 0 5921546 5922308 5923114 5923923, hotness: undefined, score: 1, children: 1

hakunawazo 0 points 3 years ago

Don't start the gif war again.

save

path: 0 5921546 5922308 5923114 5923923 6048108, hotness: undefined, score: 0, children: 0

relevants 3 points 3 years ago

Here in Germany everyone I know pronounces the letters individually – as German letters that is, which means the Q is pronounced "coo" rather than "cue". I don't mind it, it's not quite as clunky as in English.

I do say sequel when speaking English though.

save

path: 0 5921546 5922308 5922839, hotness: undefined, score: 3, children: 1

mctoasterson 1 point 3 years ago

Do you get irritated when Americans refer to the famous Austrian bullpup rifle as the Steyr "Ogg"?

save

path: 0 5921546 5922308 5922839 5942620, hotness: undefined, score: 1, children: 0

cm0002 2 points 3 years ago

I'm neither, I refuse to pronounce acronyms if it doesn't make sense to do so.

Same thing with 'gooey' for GUI, except I hate that even more because that straight up elicits feelings of disgust, I don't want anything gooey anywhere near any electronics

save

path: 0 5921546 5922308 5925778, hotness: undefined, score: 2, children: 1

_danny 2 points 3 years ago

I've literally never heard GUI said as "gee ewe eye" before.

You could just say UI, avoids the gooey phobia and sounds less weird than g u i.

save

path: 0 5921546 5922308 5925778 5928002, hotness: undefined, score: 2, children: 0

aspitzer 28 points 3 years ago

wait until it hits little bobby tables...

https://xkcd.com/327/

save

path: 0 5922706, hotness: undefined, score: 28, children: 3

JohnDClay 29 points 3 years ago

Her daughter is named Help I'm trapped in a driver's license facility

save

path: 0 5922706 5923161, hotness: undefined, score: 29, children: 0

jaybone 8 points 3 years ago

He drops when you are sleeping. He drops when you’re awake.

save

path: 0 5922706 5925080, hotness: undefined, score: 8, children: 1

rufus 2 points 3 years ago

Come they told me, pa rum pum pum pum A new born King to see, pa rum pum pum pum Our finest gifts we bring, pa rum pum pum pum To lay before the King, pa rum pum pum pum, rum pum pum pum, rum pum pum pum,

So to honor Him, pa rum pum pum pum, When we come.

Little Bobby, pa rum pum pum pum I am a poor boy too, pa rum pum pum pum I have no gift to bring, pa rum pum pum pum That's fit to give the King, pa rum pum pum pum, rum pum pum pum, rum pum pum pum,

Shall I play for you, pa rum pum pum pum, On my unsanitized database inputs?

...

save

path: 0 5922706 5925080 5925552, hotness: undefined, score: 2, children: 0

cupcakezealot 28 points 3 years ago

dammit bobby tables is on the naughty list again

save

path: 0 5926114, hotness: undefined, score: 28, children: 0

ApexHunter 25 points 3 years ago

I can't be the only one disappointed by the lack of an order by clause after being told the list was being sorted (twice!)...

save

path: 0 5934714, hotness: undefined, score: 25, children: 0