summaryrefslogtreecommitdiff
path: root/mysql-test/main/plugin_auth.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2022-09-02 17:32:14 +0400
committerAlexander Barkov <bar@mariadb.com>2022-09-12 22:10:39 +0400
commitf1544424de2b8c9d1c3faefbbdd15543db7dfd12 (patch)
treeebac7186e67915f333a5e9fec2e801ae45c8eccc /mysql-test/main/plugin_auth.result
parent667df98c3e0f32d391af4eb65c618043720b6a2f (diff)
downloadmariadb-git-f1544424de2b8c9d1c3faefbbdd15543db7dfd12.tar.gz
MDEV-29446 Change SHOW CREATE TABLE to display default collation
Diffstat (limited to 'mysql-test/main/plugin_auth.result')
-rw-r--r--mysql-test/main/plugin_auth.result10
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/main/plugin_auth.result b/mysql-test/main/plugin_auth.result
index 66495da65e7..bbcd13402d9 100644
--- a/mysql-test/main/plugin_auth.result
+++ b/mysql-test/main/plugin_auth.result
@@ -21,12 +21,12 @@ test mysql.proxies_priv;
SHOW CREATE TABLE mysql.proxies_priv;
Table Create Table
proxies_priv CREATE TABLE `proxies_priv` (
- `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
- `User` char(80) COLLATE utf8_bin NOT NULL DEFAULT '',
- `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
- `Proxied_user` char(80) COLLATE utf8_bin NOT NULL DEFAULT '',
+ `Host` char(60) NOT NULL DEFAULT '',
+ `User` char(80) NOT NULL DEFAULT '',
+ `Proxied_host` char(60) NOT NULL DEFAULT '',
+ `Proxied_user` char(80) NOT NULL DEFAULT '',
`With_grant` tinyint(1) NOT NULL DEFAULT 0,
- `Grantor` char(141) COLLATE utf8_bin NOT NULL DEFAULT '',
+ `Grantor` char(141) NOT NULL DEFAULT '',
`Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
KEY `Grantor` (`Grantor`)