top | item 40166940

(no title)

luciusdomitius | 1 year ago

"SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax near '' at line 21."

when line 21 is 175 characters long. also, the fact that anything other than InnoDB is barely real ACID. also, the stuck development and lack of support for json, uuid and many other things.

mysql being user-friendly (and especially beginner-friendly) is a massive hoax.

discuss

order

aerzen|1 year ago

This should instead be something like this:

    SQL Error (1064):
      20 |
      21 |  ...ROM my_table JOIN other_table ON GROUP BY
      22 |                                      ^^^^^

This should not be hard. Both MySQL and Postgres do have the span of the parsing error and they do have the original query somewhere.