drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arina Ielchiieva (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5419) Return correct varchar length when cast is applied
Date Thu, 06 Apr 2017 13:24:41 GMT
Arina Ielchiieva created DRILL-5419:

             Summary: Return correct varchar length when cast is applied
                 Key: DRILL-5419
                 URL: https://issues.apache.org/jira/browse/DRILL-5419
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.9.0
            Reporter: Arina Ielchiieva
            Assignee: Arina Ielchiieva

Though Drill is schema-less and cannot determine in advance what the length of the column
should be but if query has an explicit type/length specified, Drill should return correct
column length.

For example, JDBC / ODBC Driver is ALWAYS returning 64K as the length of a varchar or char
even if casts are applied.

1. If casts are applied in query, Drill will return length which matches length indicated
in cast expression.
2. If casts are not applied and varchar length is not defined, Drill will return varchar length
as undefined (set to 0) (before Drill returned max - 64K).

This message was sent by Atlassian JIRA

View raw message