diff options
| author | unknown <konstantin@mysql.com> | 2006-03-15 20:21:59 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2006-03-15 20:21:59 +0300 |
| commit | 271d20ba970deb14e847010dffbb7d3db73777a4 (patch) | |
| tree | 2b75601ce6d80a1838c7abe2743ef1ef3fea2d7c /mysql-test/r/events.result | |
| parent | d38785aa6a77afd942aebbff64e234ffbcd7da25 (diff) | |
| download | mariadb-git-271d20ba970deb14e847010dffbb7d3db73777a4.tar.gz | |
A fix and test case for Bug#16164 "Easter egg":
SHOW AUTHORS caused 'Packets out of order' in stored functions:
add the corresponding SQLCOM to sp_get_flags_for_command so that
it'd return sp-related flags for it.
Fix Bug#17403 "Events: packets out of order with show create event"
in the same chaneset.
mysql-test/r/events.result:
Update the results (Bug#17403)
mysql-test/r/sp-error.result:
Test results fixed (Bug#16164)
mysql-test/t/events.test:
Add a test case for Bug#17403 "Events: packets out of order with
show create event"
mysql-test/t/sp-error.test:
Add a test case for Bug#16164 "Easter egg"
sql/sp_head.cc:
Add SHOW AUTHORS to the list of commands that return a result
set: such commands are not allowed in stored functions and
triggers. Add SHOW CREATE EVENT for the same reason.
Diffstat (limited to 'mysql-test/r/events.result')
| -rw-r--r-- | mysql-test/r/events.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/events.result b/mysql-test/r/events.result index ecaf1ec252e..ced21440686 100644 --- a/mysql-test/r/events.result +++ b/mysql-test/r/events.result @@ -465,4 +465,10 @@ select event_schema, event_name, definer, event_body from information_schema.eve event_schema event_name definer event_body events_test white_space root@localhost select 3 drop event white_space; +create event e1 on schedule every 1 year do set @a = 5; +create table t1 (s1 int); +create trigger t1_ai after insert on t1 for each row show create event e1; +ERROR 0A000: Not allowed to return a result set from a trigger +drop table t1; +drop event e1; drop database events_test; |