summaryrefslogtreecommitdiff
path: root/mysql-test/lib/init_db.sql
diff options
context:
space:
mode:
authorunknown <andrey@lmy004.>2006-05-29 10:39:45 +0200
committerunknown <andrey@lmy004.>2006-05-29 10:39:45 +0200
commitbdda01167579c5b846524d595b35027522d0f1ff (patch)
treeb5f8f9d86c6ec5a1912796534ba3ae361f6f2d8b /mysql-test/lib/init_db.sql
parentc4c26017c95ad50024c249168a803f6b6940e23b (diff)
downloadmariadb-git-bdda01167579c5b846524d595b35027522d0f1ff.tar.gz
Fix for bug #17394 - Events namespace is wrong
mysql-test/lib/init_db.sql: remove definer from PK mysql-test/r/events.result: update results mysql-test/r/system_mysql_db.result: update results mysql-test/t/events.test: remove I_S.EVENTS test and move it to events_grant.test scripts/mysql_fix_privilege_tables.sql: change table definition sql/event.cc: make events non-user specific (namespace change) sql/event.h: make events non-user specific (namespace change) sql/event_priv.h: make events non-user specific (namespace change) sql/event_scheduler.cc: make events non-user specific (namespace change) sql/event_timed.cc: make events non-user specific (namespace change) sql/sql_parse.cc: make events non-user specific (namespace change) sql/sql_show.cc: SHOW EVENTS is available to everyone who has EVENT on specific schema. No additional privileges are needed to see others' events. - user A has events in db1 and db2 - user B has events in db1 and db3 A will see all his events from db1 and db2 as well as B's events from db1 but not from db3. B will see her events from db1 and db3. In addition B will see only A's events from db1 but not db2.
Diffstat (limited to 'mysql-test/lib/init_db.sql')
-rw-r--r--mysql-test/lib/init_db.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/lib/init_db.sql b/mysql-test/lib/init_db.sql
index a7079b0ac33..a5736ed4b9b 100644
--- a/mysql-test/lib/init_db.sql
+++ b/mysql-test/lib/init_db.sql
@@ -631,7 +631,7 @@ CREATE TABLE event (
'HIGH_NOT_PRECEDENCE'
) DEFAULT '' NOT NULL,
comment char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
- PRIMARY KEY (definer, db, name)
+ PRIMARY KEY (db, name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT 'Events';
CREATE DATABASE IF NOT EXISTS cluster;