You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "david_hudavy (JIRA)" <ji...@apache.org> on 2016/01/21 03:21:39 UTC
[jira] [Commented] (DRILL-4290) Run select count(1) from
mysql.user,it throws error.Error: PARSE ERROR: Encountered ". user" at line
1
[ https://issues.apache.org/jira/browse/DRILL-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15109918#comment-15109918 ]
david_hudavy commented on DRILL-4290:
-------------------------------------
except User is a reserved word,are there any other reserved words?
> Run select count(1) from mysql.user,it throws error.Error: PARSE ERROR: Encountered ". user" at line 1
> ------------------------------------------------------------------------------------------------------
>
> Key: DRILL-4290
> URL: https://issues.apache.org/jira/browse/DRILL-4290
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.4.0
> Environment: drill1.4
> Reporter: david_hudavy
>
> I have performing some select commands tests of drill.
> Test case 1: user is mysql table, it is error.
> 0: jdbc:drill:zk=SC-1:6181,SC-2:6181,PL-3:618> select count(1) from mysql.user;
> Error: PARSE ERROR: Encountered ". user" at line 1, column 32.
> Was expecting one of:
> <EOF>
> "ORDER" ...
> while parsing SQL query:
> select count(1) from mysql.user
> ^
> [Error Id: 484485a4-6e0a-45cd-892a-099236319109 on SC-1:31010] (state=,code=0)
> Test case 2: user is mysql table, i add ` on user table. it is right.
> 0: jdbc:drill:zk=SC-1:6181,SC-2:6181,PL-3:618> select count(1) from mysql.`user`;
> +---------+
> | EXPR$0 |
> +---------+
> | 2 |
> +---------+
> 1 row selected (0.179 seconds)
> Test case 3: other mysql table,i don't add ' on the table,but it is right.
> 0: jdbc:drill:zk=SC-1:6181,SC-2:6181,PL-3:618> select count(1) from mysql.event;
> +---------+
> | EXPR$0 |
> +---------+
> | 0 |
> +---------+
> 1 row selected (0.128 seconds)
> 0: jdbc:drill:zk=SC-1:6181,SC-2:6181,PL-3:618> select * from performance_schema.users;
> +-------+----------------------+--------------------+
> | USER | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
> +-------+----------------------+--------------------+
> | null | 18 | 24 |
> | root | 5 | 130 |
> +-------+----------------------+--------------------+
> 2 rows selected (0.117 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)