~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/t/log_tables.test

  • Committer: Monty Taylor
  • Date: 2008-07-05 11:20:18 UTC
  • mto: This revision was merged to the branch mainline in revision 62.
  • Revision ID: monty@inaugust.com-20080705112018-fr12kkmgphtu7m29
Changes so that removal of duplicate curr_dir from my_sys.h work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
452
452
TRUNCATE TABLE mysql.general_log;
453
453
ALTER TABLE mysql.general_log ENGINE = MyISAM;
454
454
ALTER TABLE mysql.general_log
455
 
  ADD COLUMN seq BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY;
 
455
  ADD COLUMN seq BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
456
456
 
457
457
SET GLOBAL general_log = 1;
458
458
FLUSH LOGS;
483
483
ALTER TABLE mysql.slow_log ENGINE = MyISAM;
484
484
 
485
485
ALTER TABLE mysql.slow_log
486
 
  ADD COLUMN seq BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY;
 
486
  ADD COLUMN seq BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
487
487
 
488
488
SET SESSION long_query_time = 1;
489
489
SET GLOBAL slow_query_log = 1;