385 lines
13 KiB
Plaintext
385 lines
13 KiB
Plaintext
--source include/no_valgrind_without_big.inc
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1;
|
|
--enable_warnings
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'a'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'a';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'b'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'b';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'c'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'c';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'd'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'd';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'e'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'f'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'f';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test CHAR 'y'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'y';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'a'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'a';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'b'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'b';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'c'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'c';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'd'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'd';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'e'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'f'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'f';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARCHAR 'y'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'y';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'a'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'a';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'b'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'b';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'c'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'c';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'd'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'd';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'e'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'f'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'f';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BINARY 'y'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'y';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'a'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'a';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'b'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'b';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'c'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'c';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'd'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'd';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'e'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'f'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'f';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test VARBINARY 'y'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'y';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'a'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'a';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'b'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'b';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'c'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'c';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'd'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'd';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'e'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'f'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'f';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test BLOB 'y'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'y';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'a'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'a';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'b'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'b';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'c'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'c';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'd'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'd';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'e'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'f'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'f';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|
|
--echo #------------------------------
|
|
--echo # Test TEXT 'y'
|
|
--echo #------------------------------
|
|
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
|
|
--source suite/engines/funcs/t/data1.inc
|
|
set @value := 'e';
|
|
--source suite/engines/funcs/t/se_string_groupby_statements.inc
|
|
DROP TABLE t1;
|
|
|