JDBC driver on Mariadb, creates empty tables when having Unicode characters in content
- Dominant language
- Java
- Stars
- 2k
- Forks
- 990
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 5
Description
**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
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.