Better error report (MySQL near to)

Hi,

Today when building SQL queries that has an error I’ll just get a general “error in your SQL syntax”.
Just to help to find the forgotten comma sign :wink: I would love to get MySQL error reporting in. Where it will say “right syntax to use near xxxxx on line xxx”.

It would make the user friendliness much better and save me from helping people find errors in their SQL syntax.

Hi @Norty
Which version of Metabase?
If I run a command like this:

SELECT * FROM orders WHERE fakecolumn=1

Then I get the following error:

Unknown column 'fakecolumn' in 'where clause'

Hi,

Sorry I was meaning when you have a syntax error. For example.

SELECT * F,ROM 'faketable' Where fake = '1'

Then you normaly gets:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'F,ROM 'faketable' Where fake = '1'' at line 2

But in Metabase I just get:
(conn=86803) You have an error in your SQL syntax

Okay, now I understand. Did it use to return the full error on earlier versions? If yes, can you remember which?
It looks very similar to this Postgres issue, but most of the changes in that PR, are specific to Postgres, so it should probably be created as a new issue:
https://github.com/metabase/metabase/issues/9942

I don’t know. I’m new to Metabase since this version :smiley:

@Norty Which version of MySQL are you using?
Edit: I would recommend that you create a new issue and include the example you posted.
https://github.com/metabase/metabase/issues/new