apache / apache/drill

"trim": does not work correctly on Postgresql

Open
#2,832 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

Drill 1.21.1
Postgresql 14.6

DrillBit storage configuration:
```javascript
{
"type": "jdbc",
"driver": "org.postgresql.Driver",
"url": "jdbc:postgresql:///",
"username": "",
"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

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.