drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2645) SQL Function page should specify return types in terms of SQL types
Date Wed, 01 Apr 2015 04:15:53 GMT
Daniel Barclay (Drill) created DRILL-2645:
---------------------------------------------

             Summary: SQL Function page should specify return types in terms of SQL types
                 Key: DRILL-2645
                 URL: https://issues.apache.org/jira/browse/DRILL-2645
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Daniel Barclay (Drill)


On the SQL Functions page currently at http://drill.apache.org/docs/sql-functions/, the return
type for string functions is specified in terms of "int", "text", and "byte array" instead
of being specified in terms of Drill SQL types (e.g., "INTEGER", "BYTE ARRAY", etc.)

Additionally, names of SQL types should be given in all uppercase, as they are used in the
SQL standard, as they are specified to appear in INFORMATION_SCHEMA.COLUMNS, and as they appear
in the JDBC equivalent of INFORMATION_SCHEMA.COLUMNS.  (Another reason is that it's not clear,
for example, which occurrence of "numeric" is the adjective "numeric" and which means the
proper noun (datatype name) "NUMERIC".)




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message