apache / apache/drill

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

Open
#2,922 0 comments 0 reactions 0 assignees View on GitHub
bug
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**
![image](https://github.com/apache/drill/assets/10470236/9894de6f-5a8e-4532-9f31-1cdb3b6eb10c)

**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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.