"trim": does not work correctly on Postgresql
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
Research direction
Reproduce SELECT TRIM(' ') against PostgreSQL 14.6 through Drill 1.21.1, then compare the result with Drill 1.19.0. Trace the TRIM expression and JDBC/PostgreSQL result handling; done means the query returns an empty string rather than null for the single-row case.
Written by the indexing model from the issue text.
Description
Drill 1.21.1
Postgresql 14.6
DrillBit storage configuration:
{
"type": "jdbc",
"driver": "org.postgresql.Driver",
"url": "jdbc:postgresql://<host>/<db_name>",
"username": "<username>",
"password": "<password>",
"authMode": "SHARED_USER",
"writerBatchSize": 10000,
"enabled": true
}
Run this query
SELECT TRIM( ' ') AS x FROM path_to_any_table
Asume that the table has only one row.
The actual result:
x
null
The expected result
x
x should be an empty string.
The issue doesn't happen in Drill 1.19.0
- Dominant language
- Java
- Stars
- 2k
- Forks
- 989
- Avg merge
- 1d 14h
- Merged PRs (30d)
- 4
Getting set up
- Ships a Dockerfile or Docker Compose file
- Has a pull request template
- No contributing guide
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
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
liquid-java/liquidjava#321 ·
Maintainers usually reply within 2 days
-
Difficulty 1/5 Under an hour Newbie friendliness 88/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
OpenConext/OpenConext-access#1015 ·
Maintainers usually reply within 1 day
-
68000: FDBcc branch target is 2 bytes too low (uses inst_start+2 instead of the displacement word)Open
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
NationalSecurityAgency/ghidra#9702 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
apache/rocketmq-dashboard#5358 ·
Maintainers usually reply within 3 days