Wild Characters in MySQL: Ambiguity between source code and manual
"Bhagurkar, Salil Arun" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.devel |
|---|---|
| Message-ID | <26426DED714A5D4C97FCB32458A29C320BBD6425@CH1PRD0302MB128.namprd03.prod.outlook.com> |
Hello, As mentioned at http://dev.mysql.com/doc/refman/5.1/en/account-names.html it is possible to mention host names as wild character containing strings using characters like '%' and '_'. But if you check the source code, which loads the privileges from the grant tables into the acl_users, acl_dbs.. etc arrays, the sorting function (get_sort) which is called to sort the entries in these tables, uses the wild characters '*' and '?'. For reference, the acl_load() function is in sql_acl.cc and is called at load time which then calls get_sort in the same file to compute a sorting value used to quicksort the entries in user, host and db tables. Thanks, Salil Bhagurkar -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/[email protected]