drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5649) Drill pushed invalid SQL to SQL Server when trim scalar function used
Date Sun, 02 Jul 2017 12:27:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-5649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

N Campbell updated DRILL-5649:
------------------------------
    Component/s:     (was:  Server)
                 Storage - JDBC

> Drill pushed invalid SQL to SQL Server when trim scalar function used
> ---------------------------------------------------------------------
>
>                 Key: DRILL-5649
>                 URL: https://issues.apache.org/jira/browse/DRILL-5649
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JDBC
>    Affects Versions: 1.10.0
>         Environment: Drill 1.10
> SQL Server 2016
>            Reporter: N Campbell
>
> plugin defined to access SQL Server via JDBC
> following statement is sent to Drill which fails due to invalid SQL sent to SQL Server
> select trim(TJOIN1.C2) from certsqlserver.dbo.TJOIN1
> Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

> SELECT TRIM(BOTH ' ' FROM "C2") AS "EXPR$0"
> FROM "dbo"."TJOIN1"
> plugin certsqlserver
> https://docs.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message