← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/myisam.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/myisam.result
2412
2412
DROP TABLE t1;
2413
2413
SET myisam_sort_buffer_size=@@global.myisam_sort_buffer_size;
2414
2414
SET myisam_repair_threads=@@global.myisam_repair_threads;
 
2415
#
 
2416
# BUG#11757032 - 49030: OPTIMIZE TABLE BREAKS MYISAM TABLE WHEN
 
2417
#                USING MYISAM_USE_MMAP ON WINDOWS
 
2418
#
 
2419
SET GLOBAL myisam_use_mmap=1;
 
2420
CREATE TABLE t1(a INT);
 
2421
INSERT INTO t1 VALUES(1),(2);
 
2422
DELETE FROM t1 WHERE a=1;
 
2423
FLUSH TABLE t1;
 
2424
LOCK TABLE t1 WRITE;
 
2425
OPTIMIZE TABLE t1;
 
2426
Table   Op      Msg_type        Msg_text
 
2427
test.t1 optimize        status  OK
 
2428
INSERT INTO t1 VALUES(3);
 
2429
UNLOCK TABLES;
 
2430
SELECT * FROM t1;
 
2431
a
 
2432
2
 
2433
3
 
2434
CHECK TABLE t1;
 
2435
Table   Op      Msg_type        Msg_text
 
2436
test.t1 check   status  OK
 
2437
DROP TABLE t1;
 
2438
SET GLOBAL myisam_use_mmap=default;
2415
2439
End of 5.1 tests