[GitHub] [incubator-doris] wutiangan opened a new issue #3586: [MySQL compatibility] Naviate query with hints throw null exception

[GitBox <gi...@apache.org>]

wutiangan opened a new issue #3586:
URL: https://github.com/apache/incubator-doris/issues/3586


   This phenomenon only occur when using Navicat to query with hints,
   But It doesn't happen when you query with MySQL client。
   
   ### The Query：
   select /*+ FULL(t1)*/ * from t t1, t t2;
   
   ### Navicat results:
   [SQL]select /*+ FULL(t1)*/ * from t t1, t t2;
   [Err] 1064 - Unexpected exception: null
   
   
   ### MySQL result:
   mysql> select /*+ FULL(t1)*/ * from t t1, t t2;
   +------+------+------+------+------+------+
   | i    | j    | k    | i    | j    | k    |
   +------+------+------+------+------+------+
   |    5 |    5 |    5 |    1 |    1 |    1 |
   |    5 |    5 |    5 |    1 |    2 |    1 |
   |    5 |    5 |    5 |    2 |    1 |    1 |
   ...


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org