[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@3.137.182.201: ~ $ 
--disable_warnings
DROP TABLE IF EXISTS t4,t5;
--enable_warnings
CREATE TABLE t4(c1 DECIMAL(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 DEC(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 DEC(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 FIXED(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 FIXED(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;
CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
--sorted_result
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt4 USING @a,@b;
SET @a=1.0;
SET @b=0;
EXECUTE stmt4 USING @a,@b;
SET @a=-9.0;
SET @b=7.0;
EXECUTE stmt4 USING @a,@b;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt4 USING @a;
SET @a=1.0;
EXECUTE stmt4 USING @a;
SET @a=-9.0;
EXECUTE stmt4 USING @a;
DEALLOCATE PREPARE stmt4;
--sorted_result
SELECT * FROM t4;
--sorted_result
SELECT COUNT(c1) AS total_rows FROM t4;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
DROP TABLE t4;
CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
--sorted_result
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
SET @a=0;
SET @b=1.0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.0;
SET @a=0;
EXECUTE stmt5 USING @a,@b;
SET @a=1.2345;
SET @a=3.5432;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.0;
SET @a=-9.1;
EXECUTE stmt5 USING @a,@b;
SET @a=-9.12345;
SET @a=-8.54321;
EXECUTE stmt5 USING @a,@b;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
SET @a=0;
EXECUTE stmt5 USING @a;
SET @a=1.0;
EXECUTE stmt5 USING @a;
SET @a=1.2345;
EXECUTE stmt5 USING @a;
SET @a=-9.0;
EXECUTE stmt5 USING @a;
SET @a=-9.12345;
EXECUTE stmt5 USING @a;
--sorted_result
SELECT * FROM t5;
--sorted_result
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
--sorted_result
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
--sorted_result
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
DEALLOCATE PREPARE stmt5;
DROP TABLE t5;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ engines/ funcs/ t/
Name Type Size Permission Actions
ai_init_alter_table.test File 24.9 KB 0644
ai_init_create_table.test File 23.97 KB 0644
ai_init_insert.test File 8.87 KB 0644
ai_init_insert_id.test File 24.08 KB 0644
ai_overflow_error.test File 29.24 KB 0644
ai_reset_by_truncate.test File 54.02 KB 0644
ai_sql_auto_is_null.test File 13.48 KB 0644
an_calendar.test File 873 B 0644
an_number.test File 1.97 KB 0644
an_string.test File 1.08 KB 0644
comment_column.test File 29.09 KB 0644
comment_column2.test File 131.05 KB 0644
comment_index.test File 22.29 KB 0644
comment_table.test File 14.05 KB 0644
crash_manycolumns_number.test File 12.73 KB 0644
crash_manycolumns_string.test File 16.64 KB 0644
crash_manyindexes_number.test File 8.18 KB 0644
crash_manyindexes_string.test File 9.94 KB 0644
crash_manytables_number.cnf File 67 B 0644
crash_manytables_number.test File 77.05 KB 0644
crash_manytables_string.cnf File 67 B 0644
crash_manytables_string.test File 82.91 KB 0644
data1.inc File 5.24 KB 0644
data2.inc File 2.34 KB 0644
date_function.test File 13.33 KB 0644
datetime_function.test File 1008 B 0644
db_alter_character_set.test File 4.17 KB 0644
db_alter_character_set_collate.test File 1.75 KB 0644
db_alter_collate_ascii.test File 1.97 KB 0644
db_alter_collate_utf8.test File 20.04 KB 0644
db_create_character_set.test File 1.26 KB 0644
db_create_character_set_collate.test File 957 B 0644
db_create_drop.test File 282 B 0644
db_create_error.test File 169 B 0644
db_create_error_reserved.test File 69 B 0644
db_create_if_not_exists.test File 306 B 0644
db_drop_error.test File 170 B 0644
db_use_error.test File 169 B 0644
de_autoinc.test File 2.4 KB 0644
de_calendar_range.test File 2.11 KB 0644
de_ignore.test File 2.81 KB 0644
de_limit.test File 1.62 KB 0644
de_multi_db_table.test File 21.87 KB 0644
de_multi_db_table_using.test File 22.06 KB 0644
de_multi_table.test File 17.43 KB 0644
de_multi_table_using.test File 17.62 KB 0644
de_number_range.test File 46.54 KB 0644
de_quick.test File 2.8 KB 0644
de_string_range.test File 17.72 KB 0644
de_truncate.test File 1.46 KB 0644
de_truncate_autoinc.test File 3.19 KB 0644
disabled.def File 5.81 KB 0644
fu_aggregate_avg_number.test File 86.45 KB 0644
fu_aggregate_count_number.test File 87.86 KB 0644
fu_aggregate_max_number.test File 86.45 KB 0644
fu_aggregate_max_subquery.test File 2.8 KB 0644
fu_aggregate_min_number.test File 86.55 KB 0644
fu_aggregate_sum_number.test File 86.45 KB 0644
general_no_data.test File 8.81 KB 0644
general_not_null.test File 13.44 KB 0644
general_null.test File 14.92 KB 0644
in_calendar_2_unique_constraints_duplicate_update.test File 4.43 KB 0644
in_calendar_pk_constraint_duplicate_update.test File 2.37 KB 0644
in_calendar_pk_constraint_error.test File 2.07 KB 0644
in_calendar_pk_constraint_ignore.test File 2.07 KB 0644
in_calendar_unique_constraint_duplicate_update.test File 2.3 KB 0644
in_calendar_unique_constraint_error.test File 2 KB 0644
in_calendar_unique_constraint_ignore.test File 1.88 KB 0644
in_enum_null.test File 548 B 0644
in_enum_null_boundary_error.test File 551 B 0644
in_enum_null_large_error.test File 32.66 KB 0644
in_insert_select.test File 2.09 KB 0644
in_insert_select_autoinc.test File 2.16 KB 0644
in_insert_select_unique_violation.test File 1.99 KB 0644
in_lob_boundary_error.test File 2.64 KB 0644
in_multicolumn_calendar_pk_constraint_duplicate_update.test File 5.41 KB 0644
in_multicolumn_calendar_pk_constraint_error.test File 4.48 KB 0644
in_multicolumn_calendar_pk_constraint_ignore.test File 4.48 KB 0644
in_multicolumn_calendar_unique_constraint_duplicate_update.test File 5.28 KB 0644
in_multicolumn_calendar_unique_constraint_error.test File 4.34 KB 0644
in_multicolumn_calendar_unique_constraint_ignore.test File 4.25 KB 0644
in_multicolumn_number_pk_constraint_duplicate_update.test File 5.54 KB 0644
in_multicolumn_number_pk_constraint_error.test File 9 KB 0644
in_multicolumn_number_pk_constraint_ignore.test File 9 KB 0644
in_multicolumn_number_unique_constraint_duplicate_update.test File 9.56 KB 0644
in_multicolumn_number_unique_constraint_error.test File 8.77 KB 0644
in_multicolumn_number_unique_constraint_ignore.test File 8.2 KB 0644
in_multicolumn_string_pk_constraint_duplicate_update.test File 3.43 KB 0644
in_multicolumn_string_pk_constraint_error.test File 3.07 KB 0644
in_multicolumn_string_pk_constraint_ignore.test File 3.03 KB 0644
in_multicolumn_string_unique_constraint_duplicate_update.test File 3.36 KB 0644
in_multicolumn_string_unique_constraint_error.test File 2.96 KB 0644
in_multicolumn_string_unique_constraint_ignore.test File 2.78 KB 0644
in_number_2_unique_constraints_duplicate_update.test File 7.98 KB 0644
in_number_boundary_error.test File 2.58 KB 0644
in_number_decimal_boundary_error.test File 1.83 KB 0644
in_number_length.test File 6.32 KB 0644
in_number_null.test File 2.34 KB 0644
in_number_pk_constraint_duplicate_update.test File 3.15 KB 0644
in_number_pk_constraint_error.test File 2.79 KB 0644
in_number_pk_constraint_ignore.test File 2.6 KB 0644
in_number_unique_constraint_duplicate_update.test File 3.02 KB 0644
in_number_unique_constraint_error.test File 2.67 KB 0644
in_number_unique_constraint_ignore.test File 2.48 KB 0644
in_set_null.test File 631 B 0644
in_set_null_boundary_error.test File 677 B 0644
in_set_null_large.test File 98.11 KB 0644
in_string_2_unique_constraints_duplicate_update.test File 2.35 KB 0644
in_string_boundary_error.test File 1.95 KB 0644
in_string_not_null.test File 2.59 KB 0644
in_string_null.test File 2.78 KB 0644
in_string_pk_constraint_duplicate_update.test File 977 B 0644
in_string_pk_constraint_error.test File 925 B 0644
in_string_pk_constraint_ignore.test File 857 B 0644
in_string_set_enum_fail.test File 788 B 0644
in_string_unique_constraint_duplicate_update.test File 941 B 0644
in_string_unique_constraint_error.test File 890 B 0644
in_string_unique_constraint_ignore.test File 821 B 0644
ix_drop.test File 177 B 0644
ix_drop_error.test File 163 B 0644
ix_index_decimals.test File 5.94 KB 0644
ix_index_lob.test File 4.79 KB 0644
ix_index_non_string.test File 9.31 KB 0644
ix_index_string.test File 2.41 KB 0644
ix_index_string_length.test File 2.44 KB 0644
ix_unique_decimals.test File 6.08 KB 0644
ix_unique_lob.test File 4.9 KB 0644
ix_unique_non_string.test File 9.52 KB 0644
ix_unique_string.test File 2.48 KB 0644
ix_unique_string_length.test File 2.5 KB 0644
ix_using_order.test File 2.6 KB 0644
jp_comment_column.test File 47.87 KB 0644
jp_comment_index.test File 38.09 KB 0644
jp_comment_older_compatibility1.test File 2.64 KB 0644
jp_comment_table.test File 21.88 KB 0644
ld_all_number_string_calendar_types.test File 505.15 KB 0644
ld_bit.test File 712 B 0644
ld_enum_set.test File 599 B 0644
ld_less_columns.test File 641 B 0644
ld_more_columns_truncated.test File 641 B 0644
ld_null.test File 1.17 KB 0644
ld_quote.test File 671 B 0644
ld_simple.test File 508 B 0644
ld_starting.test File 592 B 0644
ld_unique_error1.test File 875 B 0644
ld_unique_error1_local.test File 800 B 0644
ld_unique_error2.test File 983 B 0644
ld_unique_error2_local.test File 890 B 0644
ld_unique_error3.test File 1.11 KB 0644
ld_unique_error3_local.test File 878 B 0644
load_bit.inc File 82 B 0644
load_enum_set.inc File 59 B 0644
load_less_columns.inc File 20 B 0644
load_more_columns.inc File 26 B 0644
load_null.inc File 24 B 0644
load_null2.inc File 24 B 0644
load_quote.inc File 34 B 0644
load_simple.inc File 78 B 0644
load_starting.inc File 93 B 0644
load_unique_error1.inc File 30 B 0644
load_unique_error2.inc File 24 B 0644
load_unique_error3.inc File 23 B 0644
ps_number_length.test File 29.21 KB 0644
ps_number_null.test File 10.62 KB 0644
ps_string_not_null.test File 8.21 KB 0644
ps_string_null.test File 8.92 KB 0644
re_number_range.test File 56.02 KB 0644
re_number_range_set.test File 56.02 KB 0644
re_number_select.test File 419 B 0644
re_string_range.test File 20.76 KB 0644
re_string_range_set.test File 20.67 KB 0644
rpl000010-slave.opt File 34 B 0644
rpl000010.test File 455 B 0644
rpl000011.test File 320 B 0644
rpl000013.test File 1.62 KB 0644
rpl000017-slave.opt File 19 B 0644
rpl000017.test File 588 B 0644
rpl_000015.test File 3.65 KB 0644
rpl_LD_INFILE.test File 1.13 KB 0644
rpl_REDIRECT.test File 970 B 0644
rpl_alter.test File 616 B 0644
rpl_alter_db.test File 309 B 0644
rpl_bit.test File 3.44 KB 0644
rpl_bit_npk.test File 4.12 KB 0644
rpl_change_master.test File 2.08 KB 0644
rpl_create_database-master.opt File 69 B 0644
rpl_create_database-slave.opt File 75 B 0644
rpl_create_database.test File 1.84 KB 0644
rpl_do_grant.test File 2.9 KB 0644
rpl_drop.test File 353 B 0644
rpl_drop_db.test File 1.29 KB 0644
rpl_dual_pos_advance-master.opt File 16 B 0644
rpl_dual_pos_advance.test File 2.06 KB 0644
rpl_empty_master_crash-master.opt File 16 B 0644
rpl_empty_master_crash.test File 225 B 0644
rpl_err_ignoredtable-slave.opt File 99 B 0644
rpl_err_ignoredtable.test File 2.01 KB 0644
rpl_flushlog_loop.test File 1.66 KB 0644
rpl_free_items-slave.opt File 37 B 0644
rpl_free_items.test File 489 B 0644
rpl_get_lock.test File 1.38 KB 0644
rpl_ignore_grant-slave.opt File 38 B 0644
rpl_ignore_grant.test File 2.05 KB 0644
rpl_ignore_revoke-slave.opt File 38 B 0644
rpl_ignore_revoke.test File 1.58 KB 0644
rpl_ignore_table_update-slave.opt File 44 B 0644
rpl_ignore_table_update.test File 947 B 0644
rpl_init_slave-slave.opt File 46 B 0644
rpl_init_slave.test File 735 B 0644
rpl_insert.test File 1.05 KB 0644
rpl_insert_select.test File 465 B 0644
rpl_loaddata2.test File 302 B 0644
rpl_loaddata_m-master.opt File 24 B 0644
rpl_loaddata_m.test File 1.3 KB 0644
rpl_loaddata_s-slave.opt File 24 B 0644
rpl_loaddata_s.test File 931 B 0644
rpl_loaddatalocal.test File 2.14 KB 0644
rpl_loadfile.test File 1.76 KB 0644
rpl_log_pos.test File 1.37 KB 0644
rpl_many_optimize.test File 533 B 0644
rpl_master_pos_wait.test File 579 B 0644
rpl_misc_functions.test File 1.71 KB 0644
rpl_multi_delete-slave.opt File 33 B 0644
rpl_multi_delete.test File 433 B 0644
rpl_multi_delete2-slave.opt File 90 B 0644
rpl_multi_delete2.test File 1.2 KB 0644
rpl_multi_update4-slave.opt File 31 B 0644
rpl_multi_update4.test File 976 B 0644
rpl_ps.test File 1022 B 0644
rpl_rbr_to_sbr.test File 1.88 KB 0644
rpl_relayspace-slave.opt File 27 B 0644
rpl_relayspace.test File 1.04 KB 0644
rpl_replicate_ignore_db-slave.opt File 33 B 0644
rpl_replicate_ignore_db.test File 618 B 0644
rpl_row_NOW.test File 2.51 KB 0644
rpl_row_USER.test File 1.71 KB 0644
rpl_row_drop.test File 1.2 KB 0644
rpl_row_func001.test File 1.37 KB 0644
rpl_row_inexist_tbl-slave.opt File 33 B 0644
rpl_row_inexist_tbl.test File 866 B 0644
rpl_row_max_relay_size.test File 360 B 0644
rpl_row_reset_slave.test File 221 B 0644
rpl_row_sp001.test File 3.95 KB 0644
rpl_row_sp005.test File 3.1 KB 0644
rpl_row_sp008.test File 1.51 KB 0644
rpl_row_sp009.test File 2.64 KB 0644
rpl_row_sp010.test File 2 KB 0644
rpl_row_sp011.test File 3.49 KB 0644
rpl_row_sp012.test File 2.19 KB 0644
rpl_row_stop_middle.test File 1.37 KB 0644
rpl_row_trig001.test File 3.15 KB 0644
rpl_row_trig002.test File 2.62 KB 0644
rpl_row_trig003.test File 5.66 KB 0644
rpl_row_until.test File 4.57 KB 0644
rpl_row_view01.test File 3.33 KB 0644
rpl_server_id1.test File 1.61 KB 0644
rpl_server_id2-slave.opt File 55 B 0644
rpl_server_id2.test File 1.34 KB 0644
rpl_session_var.test File 1.32 KB 0644
rpl_sf.test File 1.09 KB 0644
rpl_skip_error-slave.opt File 34 B 0644
rpl_skip_error.test File 669 B 0644
rpl_slave_status.test File 1.79 KB 0644
rpl_sp-master.opt File 36 B 0644
rpl_sp-slave.opt File 36 B 0644
rpl_sp.test File 11.02 KB 0644
rpl_sp004.test File 2.79 KB 0644
rpl_sp_effects-master.opt File 36 B 0644
rpl_sp_effects-slave.opt File 36 B 0644
rpl_sp_effects.test File 3.81 KB 0644
rpl_start_stop_slave.test File 502 B 0644
rpl_stm_max_relay_size.test File 365 B 0644
rpl_stm_mystery22.test File 2.07 KB 0644
rpl_stm_no_op.test File 2.22 KB 0644
rpl_stm_reset_slave.test File 169 B 0644
rpl_switch_stm_row_mixed.test File 16.92 KB 0644
rpl_temp_table.test File 1.55 KB 0644
rpl_temporary.test File 6.25 KB 0644
rpl_trigger.test File 10.46 KB 0644
rpl_trunc_temp.test File 834 B 0644
rpl_user_variables.test File 2.04 KB 0644
rpl_variables-master.opt File 39 B 0644
rpl_variables.test File 776 B 0644
rpl_view-slave.opt File 34 B 0644
rpl_view.test File 2.94 KB 0644
se_join_cross.test File 157.23 KB 0644
se_join_default.test File 122.37 KB 0644
se_join_inner.test File 157.23 KB 0644
se_join_left.test File 169.54 KB 0644
se_join_left_outer.test File 153.54 KB 0644
se_join_natural_left.test File 147.59 KB 0644
se_join_natural_left_outer.test File 150.06 KB 0644
se_join_natural_right.test File 139.39 KB 0644
se_join_natural_right_outer.test File 141.85 KB 0644
se_join_right.test File 142.88 KB 0644
se_join_right_outer.test File 145.34 KB 0644
se_join_straight.test File 144.11 KB 0644
se_rowid.test File 1.11 KB 0644
se_string_distinct.test File 40.53 KB 0644
se_string_from.test File 22.81 KB 0644
se_string_groupby.test File 32.56 KB 0644
se_string_having.test File 169.53 KB 0644
se_string_limit.test File 29.98 KB 0644
se_string_orderby.test File 9.34 KB 0644
se_string_union.test File 34.81 KB 0644
se_string_where.test File 9.26 KB 0644
se_string_where_and.test File 8.24 KB 0644
se_string_where_or.test File 8.2 KB 0644
sf_alter.test File 82.16 KB 0644
sf_cursor.test File 1.4 KB 0644
sf_simple1.test File 118.01 KB 0644
sp_alter.test File 57.14 KB 0644
sp_cursor.test File 1000 B 0644
sp_simple1.test File 67.39 KB 0644
sq_all.test File 2.47 KB 0644
sq_any.test File 2.47 KB 0644
sq_corr.test File 1.69 KB 0644
sq_error.test File 2.67 KB 0644
sq_exists.test File 2.32 KB 0644
sq_from.test File 2.22 KB 0644
sq_in.test File 1.81 KB 0644
sq_row.test File 2.12 KB 0644
sq_scalar.test File 2.42 KB 0644
sq_some.test File 2.49 KB 0644
ta_2part_column_to_pk.test File 8.49 KB 0644
ta_2part_diff_string_to_pk.test File 9.23 KB 0644
ta_2part_diff_to_pk.test File 144.47 KB 0644
ta_2part_string_to_pk.test File 2.21 KB 0644
ta_3part_column_to_pk.test File 8.85 KB 0644
ta_3part_string_to_pk.test File 2.3 KB 0644
ta_add_column.test File 581.62 KB 0644
ta_add_column2.test File 97.73 KB 0644
ta_add_column_first.test File 563.74 KB 0644
ta_add_column_first2.test File 98.85 KB 0644
ta_add_column_middle.test File 645.04 KB 0644
ta_add_column_middle2.test File 109.44 KB 0644
ta_add_string.test File 16.5 KB 0644
ta_add_string2.test File 97.54 KB 0644
ta_add_string_first.test File 16.66 KB 0644
ta_add_string_first2.test File 98.66 KB 0644
ta_add_string_middle.test File 18.36 KB 0644
ta_add_string_middle2.test File 72.79 KB 0644
ta_add_string_unique_index.test File 37.51 KB 0644
ta_add_unique_index.test File 148.56 KB 0644
ta_column_from_unsigned.test File 22.79 KB 0644
ta_column_from_zerofill.test File 46.47 KB 0644
ta_column_to_index.test File 97.68 KB 0644
ta_column_to_not_null.test File 24.45 KB 0644
ta_column_to_null.test File 24.45 KB 0644
ta_column_to_pk.test File 8.14 KB 0644
ta_column_to_unsigned.test File 22.79 KB 0644
ta_column_to_zerofill.test File 46.47 KB 0644
ta_drop_column.test File 17.14 KB 0644
ta_drop_index.test File 49.17 KB 0644
ta_drop_pk_autoincrement.test File 6.74 KB 0644
ta_drop_pk_number.test File 8.26 KB 0644
ta_drop_pk_string.test File 2.13 KB 0644
ta_drop_string_index.test File 12.45 KB 0644
ta_orderby.test File 3.13 KB 0644
ta_rename.test File 17.1 KB 0644
ta_set_drop_default.test File 19.17 KB 0644
ta_string_drop_column.test File 4.41 KB 0644
ta_string_to_index.test File 24.69 KB 0644
ta_string_to_not_null.test File 4.21 KB 0644
ta_string_to_null.test File 4.21 KB 0644
ta_string_to_pk.test File 2.1 KB 0644
tc_column_autoincrement.test File 1.8 KB 0644
tc_column_comment.test File 8.27 KB 0644
tc_column_comment_string.test File 1.25 KB 0644
tc_column_default_decimal.test File 4.57 KB 0644
tc_column_default_number.test File 3.39 KB 0644
tc_column_default_string.test File 2.3 KB 0644
tc_column_enum.test File 619 B 0644
tc_column_enum_long.test File 71.75 KB 0644
tc_column_key.test File 5.4 KB 0644
tc_column_key_length.test File 1.15 KB 0644
tc_column_length.test File 5.87 KB 0644
tc_column_length_decimals.test File 4.33 KB 0644
tc_column_length_zero.test File 1.11 KB 0644
tc_column_not_null.test File 7.43 KB 0644
tc_column_null.test File 7.32 KB 0644
tc_column_primary_key_number.test File 5.55 KB 0644
tc_column_primary_key_string.test File 1.18 KB 0644
tc_column_serial.test File 323 B 0644
tc_column_set.test File 617 B 0644
tc_column_set_long.test File 71.75 KB 0644
tc_column_unique_key.test File 5.54 KB 0644
tc_column_unique_key_string.test File 1.17 KB 0644
tc_column_unsigned.test File 7.63 KB 0644
tc_column_zerofill.test File 15.49 KB 0644
tc_drop_table.test File 2.88 KB 0644
tc_multicolumn_different.test File 785.28 KB 0644
tc_multicolumn_same.test File 7.2 KB 0644
tc_multicolumn_same_string.test File 1.56 KB 0644
tc_partition_analyze.test File 971 B 0644
tc_partition_change_from_range_to_hash_key.test File 10.88 KB 0644
tc_partition_check.test File 969 B 0644
tc_partition_hash.test File 24.6 KB 0644
tc_partition_hash_date_function.test File 14.31 KB 0644
tc_partition_key.test File 14.08 KB 0644
tc_partition_linear_key.test File 14.4 KB 0644
tc_partition_list_directory.test File 2.3 KB 0644
tc_partition_list_error.test File 2.66 KB 0644
tc_partition_optimize.test File 1.04 KB 0644
tc_partition_rebuild.test File 971 B 0644
tc_partition_remove.test File 8.14 KB 0644
tc_partition_reorg_divide.test File 8.13 KB 0644
tc_partition_reorg_hash_key.test File 18.11 KB 0644
tc_partition_reorg_merge.test File 7.5 KB 0644
tc_partition_repair.test File 1.03 KB 0644
tc_partition_sub1.test File 6.81 KB 0644
tc_partition_sub2.test File 7.91 KB 0644
tc_partition_value.test File 2.67 KB 0644
tc_partition_value_error.test File 2.89 KB 0644
tc_partition_value_specific.test File 2.42 KB 0644
tc_rename.test File 566 B 0644
tc_rename_across_database.test File 1.2 KB 0644
tc_rename_error.test File 905 B 0644
tc_structure_comment.test File 7.63 KB 0644
tc_structure_create_like.test File 8.92 KB 0644
tc_structure_create_like_string.test File 1.5 KB 0644
tc_structure_create_select.test File 14.53 KB 0644
tc_structure_create_select_string.test File 2.4 KB 0644
tc_structure_string_comment.test File 1.29 KB 0644
tc_temporary_column.test File 15.3 KB 0644
tc_temporary_column_length.test File 6.1 KB 0644
time_function.test File 288 B 0644
tr_all_type_triggers.test File 26.44 KB 0644
tr_delete.test File 21.87 KB 0644
tr_delete_new_error.test File 22.36 KB 0644
tr_insert.test File 17.59 KB 0644
tr_insert_after_error.test File 11.49 KB 0644
tr_insert_old_error.test File 12.8 KB 0644
tr_update.test File 18.13 KB 0644
tr_update_after_error.test File 11.86 KB 0644
up_calendar_range.test File 2.23 KB 0644
up_ignore.test File 2.99 KB 0644
up_limit.test File 1.71 KB 0644
up_multi_db_table.test File 9.07 KB 0644
up_multi_table.test File 6.97 KB 0644
up_nullcheck.test File 1.52 KB 0644
up_number_range.test File 53.79 KB 0644
up_string_range.test File 19.92 KB 0644
wait_show_pattern.inc File 1.11 KB 0644
wait_slave_status.inc File 4.46 KB 0644