[
https://issues.apache.org/jira/browse/DRILL-8441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vu The Anh updated DRILL-8441:
------------------------------
Description:
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 1 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
was:
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
> 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
> Priority: Major
>
> 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 1 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)
