SQL database thunderdome

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > SQL database thunderdome

foxy boxing babe: Jan 17, 2010

Janitor Prime posted:

Also if you care about standards

If you're doing a group by and try to include a column in the select statement that isn't part of the group by then every other SQL backend complains, but MySQL will just helpfully return some value without complaining making it seem like it's correct and then later the query planner fucks you and actually returns a different unexpected value.

If you ask MySQL to return a null date column it will instead return 0000-00-00 which then breaks your Java code, hopefully your admin changed the mode of MySQL to not do this poo poo

lol at all of this

mysql: an rdbms for clowns

# ¿ May 14, 2016 02:49

Adbot: ADBOT LOVES YOU

# ¿ Apr 29, 2024 00:32

foxy boxing babe: Jan 17, 2010

one of our vendors uses mysql for a mission critical application and it's as much of a daily shitshow as you are imagining

# ¿ May 14, 2016 02:50

foxy boxing babe: Jan 17, 2010

spankmeister posted:

7 pages and nobody posted http://howfuckedismydatabase.com ?

# ¿ May 23, 2016 19:25

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > SQL database thunderdome