EVOLUTION-MANAGER

Edit File: unsigned.result

# # Testing unsigned types # DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.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; Warnings: Warning 1105 No file name. Table will use t1.fix DESCRIBE t1; Field Type Null Key Default Extra a tinyint(3) unsigned NO NULL b smallint(5) unsigned zerofill NO NULL c int(10) unsigned NO NULL d bigint(20) unsigned NO NULL e char(32) NO ??? INSERT INTO t1(a,b,c,d) VALUES(255,65535,4294967295,18446744073709551615); SELECT * FROM t1; a b c d e 255 65535 4294967295 18446744073709551615 ??? UPDATE t1 SET e = d; SELECT * FROM t1; a b c d e 255 65535 4294967295 18446744073709551615 18446744073709551615 UPDATE IGNORE t1 SET c = d; Warnings: Warning 1264 Out of range value for column 'c' at row 1 SELECT * FROM t1; a b c d e 255 65535 4294967295 18446744073709551615 18446744073709551615 UPDATE IGNORE t1 SET c = e; Warnings: Warning 1264 Out of range value for column 'c' at row 1 SELECT * FROM t1; a b c d e 255 65535 4294967295 18446744073709551615 18446744073709551615 UPDATE t1 SET d = e; SELECT * FROM t1; a b c d e 255 65535 4294967295 18446744073709551615 18446744073709551615 DROP TABLE IF EXISTS t2; Warnings: Note 1051 Unknown table 'test.t2' CREATE TABLE t2 ENGINE=CONNECT TABLE_TYPE=PROXY TABNAME=t1; DESCRIBE t2; Field Type Null Key Default Extra a tinyint(3) unsigned NO NULL b smallint(5) unsigned zerofill NO NULL c int(10) unsigned NO NULL d bigint(20) unsigned NO NULL e char(32) NO NULL SELECT * FROM t2; a b c d e 255 65535 4294967295 18446744073709551615 18446744073709551615 DROP TABLE t2; DROP TABLE t1;