You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2017/05/05 09:45:04 UTC
[jira] [Created] (DRILL-5476) Calculate return type precision value
for substring functions (substring. substr, left, right)
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)