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

  • 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/t/analyse.test
1
1
#
2
2
# Test of procedure analyse
3
3
#
 
4
-- source include/have_innodb.inc
4
5
 
5
6
--disable_warnings
6
7
drop table if exists t1,t2;
133
134
 
134
135
 
135
136
--echo End of 5.0 tests
 
137
 
 
138
--echo #
 
139
--echo # Bug#11765202: Dbug_violation_helper::~Dbug_violation_helper(): Assertion `!_entered' failed.
 
140
--echo #
 
141
 
 
142
DROP TABLE IF EXISTS t1;
 
143
CREATE TABLE t1 (a VARCHAR(2) CHARSET UTF8 NOT NULL);
 
144
INSERT INTO t1 VALUES ('e'),('e'),('e-');
 
145
SELECT * FROM t1 PROCEDURE ANALYSE();
 
146
DROP TABLE t1;
 
147
 
 
148
--echo #
 
149
--echo # Bug#11756242  48137: PROCEDURE ANALYSE() LEAKS MEMORY WHEN RETURNING NULL
 
150
--echo #
 
151
 
 
152
CREATE TABLE t1(f1 INT) ENGINE=MYISAM;
 
153
CREATE TABLE t2(f2 INT) ENGINE=INNODB;
 
154
INSERT INTO t2 VALUES (1);
 
155
SELECT DISTINCTROW f1 FROM t1 NATURAL RIGHT OUTER JOIN t2 PROCEDURE ANALYSE();
 
156
SELECT * FROM t2 LIMIT 1 PROCEDURE ANALYSE();
 
157
DROP TABLE t1, t2;
 
158
 
 
159
--echo End of 5.1 tests