← 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/t/myisampack.test

  • 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/t/myisampack.test
107
107
#
108
108
DROP TABLE mysql_db1.t1;
109
109
DROP DATABASE mysql_db1;
 
110
 
 
111
--echo #
 
112
--echo # BUG#11761180 - 53646: MYISAMPACK CORRUPTS TABLES WITH FULLTEXT INDEXES
 
113
--echo #
 
114
CREATE TABLE t1(a CHAR(4), FULLTEXT(a));
 
115
INSERT INTO t1 VALUES('aaaa'),('bbbb'),('cccc');
 
116
FLUSH TABLE t1;
 
117
--exec $MYISAMPACK -sf $MYSQLD_DATADIR/test/t1
 
118
--exec $MYISAMCHK -srq $MYSQLD_DATADIR/test/t1
 
119
CHECK TABLE t1;
 
120
SELECT * FROM t1 WHERE MATCH(a) AGAINST('aaaa' IN BOOLEAN MODE);
 
121
SELECT * FROM t1 WHERE MATCH(a) AGAINST('aaaa');
 
122
DROP TABLE t1;
 
123
 
 
124
--echo # Test table with key_reflength > rec_reflength
 
125
CREATE TABLE t1(a CHAR(30), FULLTEXT(a));
 
126
--disable_query_log
 
127
--echo # Populating a table, so it's index file exceeds 65K
 
128
let $1=1700;
 
129
while ($1)
 
130
{
 
131
  eval INSERT INTO t1 VALUES('$1aaaaaaaaaaaaaaaaaaaaaaaaaa');
 
132
  dec $1;
 
133
}
 
134
 
 
135
--echo # Populating a table, so index file has second level fulltext tree
 
136
let $1=60;
 
137
while ($1)
 
138
{
 
139
  eval INSERT INTO t1 VALUES('aaaa'),('aaaa'),('aaaa'),('aaaa'),('aaaa');
 
140
  dec $1;
 
141
}
 
142
--enable_query_log
 
143
 
 
144
FLUSH TABLE t1;
 
145
--echo # Compressing table
 
146
--exec $MYISAMPACK -sf $MYSQLD_DATADIR/test/t1
 
147
--echo # Fixing index (repair by sort)
 
148
--exec $MYISAMCHK -srnq $MYSQLD_DATADIR/test/t1
 
149
CHECK TABLE t1;
 
150
FLUSH TABLE t1;
 
151
--echo # Fixing index (repair with keycache)
 
152
--exec $MYISAMCHK -soq $MYSQLD_DATADIR/test/t1
 
153
CHECK TABLE t1;
 
154
DROP TABLE t1;