EVOLUTION-MANAGER

Edit File: unsigned.test

--echo # --echo # Testing unsigned types --echo # DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( a TINYINT UNSIGNED NOT NULL, b SMALLINT ZEROFILL NOT NULL, c INT UNSIGNED NOT NULL, d BIGINT UNSIGNED NOT NULL, e CHAR(32) NOT NULL DEFAULT '???') ENGINE=CONNECT TABLE_TYPE=FIX; DESCRIBE t1; INSERT INTO t1(a,b,c,d) VALUES(255,65535,4294967295,18446744073709551615); SELECT * FROM t1; UPDATE t1 SET e = d; SELECT * FROM t1; UPDATE IGNORE t1 SET c = d; SELECT * FROM t1; UPDATE IGNORE t1 SET c = e; SELECT * FROM t1; UPDATE t1 SET d = e; SELECT * FROM t1; DROP TABLE IF EXISTS t2; CREATE TABLE t2 ENGINE=CONNECT TABLE_TYPE=PROXY TABNAME=t1; DESCRIBE t2; SELECT * FROM t2; # Moved to mysql.test (cannot be executed if embedded) #DROP TABLE t2; #CREATE TABLE t2 ENGINE=CONNECT TABLE_TYPE=MYSQL TABNAME=t1; #DESCRIBE t2; #SELECT * FROM t2; DROP TABLE t2; DROP TABLE t1;