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)

Reply via email to