[jira] [Resolved] (DRILL-2645) SQL Functions page should specify return types in terms of SQL types

["Kristine Hahn (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristine Hahn resolved DRILL-2645.
----------------------------------
    Resolution: Fixed

Data type naming and capitalization changes have been made, mainly on these pages http://tshiran.github.io/drill/docs/sql-functions, but also made changes to these pages: 

* http://tshiran.github.io/drill/docs/json-data-model/
* http://tshiran.github.io/drill/docs/lexical-structure/
* http://tshiran.github.io/drill/docs/handling-different-data-types/

Some lowercase data type names have probably not been found yet and editing will be ongoing.

> SQL Functions 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
>          Components: Documentation
>            Reporter: Daniel Barclay (Drill)
>            Assignee: Kristine Hahn
>
> 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)