When I try to write GROUP_CONCAT command in the SQL query editor, the autocomplete mechanism, completes to GROUPBY_CONCAT instead. See attached screenshot for details
We use a third party library CodeMirror for autocomplete and the bug is in this library. I have sent a pull request fixing this https://github.com/codemirror/CodeMirror/pull/3269. Corrected version of the library will be part of future phpMyAdmin releases (> 4.5).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
summary: GROUP_CONCAT is as GROUPBY_CONCAT in the autocomplete in SQL Query editor --> (ok 4.5) GROUP_CONCAT is as GROUPBY_CONCAT in the autocomplete in SQL Query editor
status: open --> resolved
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We use a third party library CodeMirror for autocomplete and the bug is in this library. I have sent a pull request fixing this https://github.com/codemirror/CodeMirror/pull/3269. Corrected version of the library will be part of future phpMyAdmin releases (> 4.5).
Great and forgive me for the broken English in the subject title. I was too eager to describe the bug :P Anyways, great job with the autocomplete!
CodeMirror has already release version 5.3.0 containing the fix. Updated to the latest version in https://github.com/phpmyadmin/phpmyadmin/commit/f0838d4080e6cfbb3a90b682802119bdd7347bb6