# MySQL Bugs: #33198
# View Corruptted When Created Using "CHAR()" Function
# http://bugs.mysql.com/bug.php?id=33198

--disable_warnings
DROP TABLE IF EXISTS t1;
DROP VIEW IF EXISTS t1;
--enable_warnings

CREATE VIEW t1 AS SELECT 'A';
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CONVERT('A' USING binary);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CONVERT('A' USING latin1);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CONVERT('A' USING utf8);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CONVERT('A' USING ucs2);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CHAR(0x41);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CHAR(0x41 USING binary);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CHAR(0x41 USING latin1);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CHAR(0x41 USING utf8);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;

CREATE VIEW t1 AS SELECT CHAR(0x00, 0x41 USING ucs2);
SHOW FULL COLUMNS FROM t1;
SELECT * FROM t1;
DROP VIEW IF EXISTS t1;