|
2008.2.3
by Brian Aker
Fixing up a, somewhat, hidden unsigned type to solve a few issues around |
1 |
# Test that we generate unsigned tables. |
2 |
CREATE TABLE t1 (A INTEGER UNSIGNED); |
|
3 |
CREATE TABLE t2 (A INTEGER UNSIGNED); |
|
4 |
||
5 |
CREATE TABLE t3 (A BIGINT UNSIGNED); |
|
6 |
CREATE TABLE t4 (A BIGINT UNSIGNED); |
|
7 |
||
8 |
SHOW CREATE TABLE t1; |
|
9 |
SHOW CREATE TABLE t2; |
|
10 |
SHOW CREATE TABLE t3; |
|
11 |
SHOW CREATE TABLE t4; |
|
12 |
||
13 |
--error ER_WARN_DATA_OUT_OF_RANGE
|
|
14 |
INSERT INTO t1 VALUES (-1); |
|
15 |
SELECT A FROM t1; |
|
16 |
||
17 |
DROP TABLE t1; |
|
18 |
DROP TABLE t2; |
|
19 |
DROP TABLE t3; |
|
20 |
DROP TABLE t4; |