You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/04/01 06:15:53 UTC
[jira] [Created] (DRILL-2645) SQL Function page should specify
return types in terms of SQL types
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)