[Bug][Data Overview] SQL Syntax Error When Inserting Results into MySQL

[KONGHOA]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

When running the data overview for a specific table, the operation fails with a SQL syntax error when trying to insert the results into a MySQL database. Upon investigation, it was found that the issue is caused by data containing quotes (' or "). Multiple quotes in the data result in malformed SQL queries, leading to the syntax error.

DataVines Version

dev

DataVines Config

default

Running Command

default

Error Exception

SQLSyntaxErrorException: 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'column_min',''658888888888', 'count', '2025-01-15', '2025-01-15 06:00:08') ON DUPLICATE K' at line 1

Engine Type

local

Java Version

1.8.0

Screenshots

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!