MySQL Bugs: #20290: Event mechanism incompatible with embedded server, but tests tried

Bug #20290	Event mechanism incompatible with embedded server, but tests tried
Submitted:	6 Jun 2006 12:04	Modified:	26 Jun 2006 18:51
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1.11-beta	OS:	Any (all)
Assigned to:	Andrey Hristov	CPU Architecture:	Any

Description:
Build of 5.1.11-beta, based on ChangeSet
  1.2184.1.2 06/05/26 17:11:21 elliot@mysql.com +2 -0
  BUG#15868 InnoDB thread thrashing
  Restoring default innodb_thread_concurrency to 8
  This default now matches 5.0

All platforms fail all tests of the event mechanism when running "embedded":

=====
events                         [ fail ]

Errors are (from /PATH/mysqltest-time) :
YYMMDD HH:MM:SS [Warning] mysql_embedded: unknown variable 'loose-binlog-show-xid=0'

YYMMDD HH:MM:SS [Warning] mysql_embedded: unknown variable 'loose-binlog-show-xid=0'

mysqltest: At line NNN: query 'SET GLOBAL event_scheduler=1' failed: 1290: The MySQL server is running with the --event-scheduler=0 option so it cannot execute this statement
(the last lines may be the most important ones)
Result from queries before failure can be found in r/events.log
=====

Similar failures in the other event-related tests.

How to repeat:
Build + test the embedded server.

Suggested fix:
Disable tests of the event mechanism when testing the embedded server.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8125

The fixed test cases has been tested by pushbuild and have passed.