You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2017/04/06 13:24:41 UTC

[jira] [Created] (DRILL-5419) Return correct varchar length when cast is applied

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.

Changes:
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
(v6.3.15#6346)