JDBC driver on Mariadb, creates empty tables when having Unicode characters in content
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 38/100
Research direction
No source file or test is named. Start by reproducing the reported JDBC-writer failure with a tab or other Unicode character in a VARCHAR value on MariaDB, then inspect the relevant writer path. Done means the table is created and populated without an unexpected column reference or SQLException.
Written by the indexing model from the issue text.
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
- Dominant language
- Java
- Stars
- 2k
- Forks
- 989
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 5
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from apache/drill
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 28/100
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
infinispan/infinispan#18150 ·
-
area/frontend
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
opensearch-project/k-NN#3597 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 88/100