apache
JDBC driver on Mariadb, creates empty tables when having Unicode characters in content
Describe the bug using JDBC driver on Mariadb, creates empty tables and references a column 'u' that is not in the query. it just creates an empty table in mariadb and gives a java.sql.SQLException (cfr screenshot below)
It looks like Drill's JDBC writer needs to gain support for Unicode escape sequences in its input data.
To Reproduce Steps to reproduce the behavior:
- inject a 'tab' character (or any other unicode character) are present in the content cfr query in screenshot
Expected behavior when there are unicode characters in varchar columns written to a table via a JDBC connection, it should create the table and populate that table by supporting unicode data loading into the sql database table
Error detail, log output or screenshots
Drill version using drill : apache-drill-1.21.1
Additional context https://apache-drill.slack.com/archives/CG380K519/p1719081685217149
