My query stops works from 2025/1/6.

Live Connectivity CData Connect AI
, ,
1

Hi, CData team,  we found that the following query text stops works from 2025/1/26.

SELECT [[char\]] FROM [SQL_KrewTestDB].[krewtestdb].[bug2149] LIMIT 500

My table as following, the data source is My SQL. You can see that the column name is [char], it has the special char “[”, “]”, before it works well, but from 2025/1/26, it stop working.

3ba99c06-6536-42e2-ab0d-e31bb66b1f7e.png
3ba99c06-6536-42e2-ab0d-e31bb66b1f7e.png702×625 13.9 KB

2

Hi ​ @daryluo ,

What happens if you wrap the name of the column in backticks as in the following example?

SELECT `[char]` FROM FROM [SQL_KrewTestDB].[krewtestdb].[bug2149] LIMIT 500

Backticks are used as quote identifiers in MySQL, so you might want to give this a try and see if it helps getting around the issue you are facing.

Otherwise, I would suggest you grab a few details like the CData MySQL version in use, and Verbosity=5 logs from the MySQL connection and submit a support ticket  here so that one of our support specialists can further assist you with troubleshooting the issue.

3

Hi, ​ @Ethem_Q  
We know the workaround, but we don’t know whether it also works well for MS SQL SERVER(Before, we have subscription for MS SQL SERVER, but now we don’t have subscription for MS SQL SERVER).

We should make sure that the query string both works well for MY SQL and MS SQL SERVER.

We use MY SQL 9.4.0, your code works well at MY SQL 9.4.0.