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-5476) Calculate return type precision value for substring functions (substring. substr, left, right)
Date Fri, 05 May 2017 09:45:04 GMT
Arina Ielchiieva created DRILL-5476:
---------------------------------------

             Summary: Calculate return type precision value for substring functions (substring.
substr, left, right) 
                 Key: DRILL-5476
                 URL: https://issues.apache.org/jira/browse/DRILL-5476
             Project: Apache Drill
          Issue Type: Improvement
    Affects Versions: 1.10.0
            Reporter: Arina Ielchiieva
            Priority: Minor


Currently when applying substring / substr / left / right functions Drill doesn't calculate
return length. Since we know calculation rules for these functions, we can predict return
length.
For example:
substring(cast(col as varchar(10), 1, 5) -> varchar(5)
substring(cast(col as varchar(10), 5) -> varchar(5)

Similar changes has been done in DRILL-5419 for other string functions.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message