~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

insert into t1 values ('abc'),('abc\'def\\hij\"klm\0opq'),('\''),('\"'),('\\'),('a\0'),('b\''),('c\"'),('d\\'),('\'b'),('\"c'),('\\d'),('a\0\0\0b'),('a\'\'\'\'b'),('a\"\"\"\"b'),('a\\\\\\\\b'),('\'\0\\\"'),('\'\''),('\"\"'),('\\\\'),('The\ZEnd');

select * from t1 procedure analyse();

drop table t1;

#decimal-related test

create table t1 (df decimal(5,1));

insert into t1 values(1.1);

insert into t1 values(2.2);

select * from t1 procedure analyse();

drop table t1;

# Bug#10716 - Procedure Analyse results in wrong values for optimal field type

create table t1 (d double);

insert into t1 values (100000);

select * from t1 procedure analyse (1,1);

drop table t1;

# Bug #14138 ROLLUP and PROCEDURE ANALYSE() hang server

create table t1 (product varchar(32), country_id int not null, year int,

profit int);

insert into t1 values ( 'Computer', 2,2000, 1200),

( 'TV', 1, 1999, 150),

( 'Calculator', 1, 1999,50),

( 'Computer', 1, 1999,1500),

( 'Computer', 1, 2000,1500),

( 'TV', 1, 2000, 150),

( 'TV', 2, 2000, 100),

( 'Calculator', 1, 2000,75),

( 'Calculator', 2, 2000,75),

( 'TV', 1, 1999, 100),

( 'Computer', 1, 1999,1200),

( 'Computer', 2, 2000,1500),

( 'Calculator', 2, 2000,75),

( 'Phone', 3, 2003,10)

;

create table t2 (country_id int primary key, country char(20) not null);

insert into t2 values (1, 'USA'),(2,'India'), (3,'Finland');

select product, sum(profit),avg(profit) from t1 group by product with rollup procedure analyse();

drop table t1,t2;

# Bug #20305 PROCEDURE ANALYSE() returns wrong M for FLOAT(M, D) and DOUBLE(M, D)

create table t1 (f1 double(10,5), f2 char(10), f3 double(10,5));

insert into t1 values (5.999, "5.9999", 5.99999), (9.555, "9.5555", 9.55555);

select f1 from t1 procedure analyse(1, 1);

select f2 from t1 procedure analyse(1, 1);

select f3 from t1 procedure analyse(1, 1);

drop table t1;

# Bug#46184 Crash, SELECT ... FROM derived table procedure analyze

CREATE TABLE t1(a INT,b INT,c INT,d INT,e INT,f INT,g INT,h INT,i INT,j INT,k INT);

INSERT INTO t1 VALUES ();

--error ER_WRONG_USAGE

SELECT * FROM (SELECT * FROM t1) d PROCEDURE ANALYSE();

DROP TABLE t1;

--echo End of 4.1 tests

--echo #

--echo # Bug #48293: crash with procedure analyse, view with > 10 columns,

--echo # having clause...

--echo #

CREATE TABLE t1(a INT, b INT, c INT, d INT, e INT,

100

f INT, g INT, h INT, i INT, j INT,k INT);

101

INSERT INTO t1 VALUES (),();

102

103

CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1;

104

--echo #should have a derived table

105

EXPLAIN SELECT * FROM v1;

106

--echo #should not crash

107

--error ER_WRONG_USAGE

108

SELECT * FROM v1 PROCEDURE analyse();

109

--echo #should not crash

110

--error ER_WRONG_USAGE

111

SELECT * FROM t1 a, v1, t1 b PROCEDURE analyse();

112

--echo #should not crash

113

--error ER_WRONG_USAGE

114

SELECT * FROM (SELECT * FROM t1 having a > 1) x PROCEDURE analyse();

115

--echo #should not crash

116

--error ER_WRONG_USAGE

117

SELECT * FROM t1 a, (SELECT * FROM t1 having a > 1) x, t1 b PROCEDURE analyse();

118

--echo #should not crash

119

--error ER_ORDER_WITH_PROC

120

SELECT 1 FROM t1 group by a having a > 1 order by 1 PROCEDURE analyse();

121

122

DROP VIEW v1;

123

DROP TABLE t1;

124

125

CREATE TABLE t1(a INT);

126

INSERT INTO t1 VALUES (1),(2);

127

128

--echo # should not crash

129

--error ER_WRONG_USAGE

130

CREATE TABLE t2 SELECT 1 FROM t1, t1 t3 GROUP BY t3.a PROCEDURE ANALYSE();

131

132

DROP TABLE t1;

133

134

135

--echo End of 5.0 tests

Older »