----- On 15 May, 2015, at 8:05 PM, Sergei Golubchik serg@mariadb.org wrote:
Are query cache results actually predictable if they have the same statement running in a different session character set/collation?
Yes, of course. See in sql_cache.{h,cc} the structure Query_cache_query_flags and what's in there.
But query_cache_info plugin doesn't show flags.
Ah, thanks for the tip.
Anyone see a work around to get the restore file usable on all queries?
Perhaps, extending query_cache_info plugin to show flags?
Yep, almost got there ( https://github.com/MariaDB/server/pull/67 ) until I realised this has been done already in MDEV-4682 / https://github.com/MariaDB/server/pull/6 Been in review for over 6 months.
Your script will need to restore a lot more than just a collation. Some flags cannot be set from the sql script whatsoever - but you can skip these entries in your "select concat" query.
yep. easily. -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.