← Back to branch summary

~drizzle-trunk/drizzle/development 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

# Test that we generate unsigned tables.
CREATE TABLE t1 (A INTEGER UNSIGNED);
CREATE TABLE t2 (A INTEGER UNSIGNED);

CREATE TABLE t3 (A BIGINT UNSIGNED);
CREATE TABLE t4 (A BIGINT UNSIGNED);

SHOW CREATE TABLE t1;
SHOW CREATE TABLE t2;
SHOW CREATE TABLE t3;
SHOW CREATE TABLE t4;

--error ER_WARN_DATA_OUT_OF_RANGE
INSERT INTO t1 VALUES (-1);
SELECT A FROM t1;

DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
DROP TABLE t4;