List:Internals« Previous MessageNext Message »
From:Salil Arun Bhagurkar Date:October 10 2011 12:18am
Subject:Wild Characters in MySQL: Ambiguity between source code and manual
View as plain text  
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
Thread
Wild Characters in MySQL: Ambiguity between source code and manualSalil Arun Bhagurkar10 Oct