← Back to branch summary

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

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/myisampack.result
87
87
128
88
88
DROP TABLE mysql_db1.t1;
89
89
DROP DATABASE mysql_db1;
 
90
#
 
91
# BUG#11761180 - 53646: MYISAMPACK CORRUPTS TABLES WITH FULLTEXT INDEXES
 
92
#
 
93
CREATE TABLE t1(a CHAR(4), FULLTEXT(a));
 
94
INSERT INTO t1 VALUES('aaaa'),('bbbb'),('cccc');
 
95
FLUSH TABLE t1;
 
96
CHECK TABLE t1;
 
97
Table   Op      Msg_type        Msg_text
 
98
test.t1 check   status  OK
 
99
SELECT * FROM t1 WHERE MATCH(a) AGAINST('aaaa' IN BOOLEAN MODE);
 
100
a
 
101
aaaa
 
102
SELECT * FROM t1 WHERE MATCH(a) AGAINST('aaaa');
 
103
a
 
104
aaaa
 
105
DROP TABLE t1;
 
106
# Test table with key_reflength > rec_reflength
 
107
CREATE TABLE t1(a CHAR(30), FULLTEXT(a));
 
108
# Populating a table, so it's index file exceeds 65K
 
109
# Populating a table, so index file has second level fulltext tree
 
110
FLUSH TABLE t1;
 
111
# Compressing table
 
112
# Fixing index (repair by sort)
 
113
CHECK TABLE t1;
 
114
Table   Op      Msg_type        Msg_text
 
115
test.t1 check   status  OK
 
116
FLUSH TABLE t1;
 
117
# Fixing index (repair with keycache)
 
118
CHECK TABLE t1;
 
119
Table   Op      Msg_type        Msg_text
 
120
test.t1 check   status  OK
 
121
DROP TABLE t1;