Friday, January 19, 2018

Friday: And that's when I discovered that mysql 5.7 is incompatible with a good chunk of our sql codebase.

If I googled correctly, I can set a sql-mode variable that tells 5.7 to back off and stop being a syntax jerk, but I didn't want to sort that out at 6:30 on a Friday.  If not, then I guess I'm spending a chunk of next week rewriting everything so that

SELECT DISTINCT a,b FROM table JOIN other_table USING(a) ORDER BY other_table.c DESC;

becomes

SELECT a,b FROM (SELECT DISTINCT a,b,c FROM table JOIN other_table USING(a) ORDER BY other_table.c DESC) AS V;

Ugh.

I did find this friend while looking through old notebooks to try and remember something.

No comments:

Post a Comment