Vu The Anh created DRILL-8441:
---------------------------------
Summary: Drill pushs "PI" not "PI()" to Postgres JDBC storage
plugin for Drill PI
Key: DRILL-8441
URL: https://issues.apache.org/jira/browse/DRILL-8441
Project: Apache Drill
Issue Type: Bug
Components: Storage - JDBC
Affects Versions: 1.19.0
Reporter: Vu The Anh
Given this query
{code:java}
SELECT PI
from `postgres`.`the_table` limit 1
{code}
Then
{*}Expected{*}: return a result
{*}Actual{*}: throw an error
{code:java}
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL
query.
Sql: SELECT PI AS "PI"
FROM "postgres"."the_table"
FETCH NEXT 501 ROWS ONLY
Plugin: postgres
Fragment: 0:0
Error Id: f3d24536-deee-4439-9607-3a96dfc46d9e {code}
Looking at the SQL, it should be PI(), not PI
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
