Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

JDBC driver on Mariadb, creates empty tables when having Unicode characters in content #2922

Open
hermygithub opened this issue Jul 7, 2024 · 0 comments
Labels

Comments

@hermygithub
Copy link

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
image

Drill version
using drill : apache-drill-1.21.1

Additional context
https://apache-drill.slack.com/archives/CG380K519/p1719081685217149

@hermygithub hermygithub added the bug label Jul 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant