[
https://issues.apache.org/jira/browse/TAJO-644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13946042#comment-13946042
]
Hyunsik Choi commented on TAJO-644:
-----------------------------------
The last patch provides quoted identifiers which preserve upper/lower
characters and allow non-ascii characters.
Without quotation marks, Tajo stores all identifiers as lowercase letters. Only
if quotation marks, it preserves lower, upper, and mixed cases letters in
catalog. The below shows an example of quoted/unquoted identifiers:
{code}
CREATE TABLE APACHE_TAJO (id INTEGER); -- ok, apache_tajo table created
CREATE TABLE "Apache_Tajo" (id INTEGER); -- ok, Apache_Tajo table created
CREATE TABLE "apache_tajo" (id INTEGER); -- fails: already exists
CREATE TABLE "APACHE_TAJO" (id INTEGER); -- ok, APACHE_TAJO table created
{code}
> Support quoted identifiers
> --------------------------
>
> Key: TAJO-644
> URL: https://issues.apache.org/jira/browse/TAJO-644
> Project: Tajo
> Issue Type: Improvement
> Affects Versions: 0.8-incubating, 1.0-incubating
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Attachments: TAJO-644.patch, TAJO-644_140325_104510.patch
>
>
> In SQL standards, non-ascii identifiers are supported by using double
> quotation as follows:
> {code}
> SELECT a, b, "씨", d from table1
> {code}
> We should support quoted identifiers.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
