[GitHub] [incubator-doris] Astralidea commented on issue #4331: Doris对DataGrip的元数据的兼容

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

Astralidea commented on issue #4331:
URL: https://github.com/apache/incubator-doris/issues/4331#issuecomment-674123469


   > First of all, thanks for your contribution.
   > 
   > To support `is_default collate utf8_general_ci = 'Yes' as is_default`, this will added in our SQL syntax.
   > You can easily supported in SQL syntax and ignore the input "collate utf8_general_ci" inormation. In this way, Doris will support this SQL.
   
   提了个PR #4354 支持了这种方式的SQL，然后DataGrip下一个报错的SQL是这样的。
   """
   select table_name,
               index_name, /* */null index_comment,
               index_type,
               group_concat(replace(replace(column_name, '\\', '\\\\'), '\n', '\\n') order by seq_in_index separator '\n') as column_names,
               non_unique /* from (select * */
          from information_schema.statistics
         where table_schema = 'dtest'
           and index_schema = 'dtest'
           and index_name collate utf8_general_ci /* index_name */ <> 'PRIMARY' /* order by table_catalog, table_schema, table_name, index_name, index_type, non_unique, seq_in_index) s */
         group by table_catalog,
                  table_schema,
                  table_name,
                  index_name,
                  index_comment,
                  index_type,
                  non_unique
   """
   想问一下官方觉得是否应该支持这种SQL呢，这个主要是2部分。
   1.是要不要提供 information_schema.statistics这个表？
   2.是group_concat(replace(replace(这块的语法可能解析有点问题，是不是要支持？


----------------------------------------------------------------
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