2221.12.2
by Stewart Smith
add a test case for some CREATE TABLE errors around ER_TOO_BIG_FIELDWIDTH - turns out we had only 1 |
1 |
CREATE TABLE t1 (a varchar(40000)); |
2 |
ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead |
|
3 |
CREATE TABLE t1 (a varchar(40000) default 'hello world'); |
|
4 |
ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead |
|
5 |
CREATE TABLE t1 (a varchar(99999)); |
|
6 |
ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead |
|
2221.12.3
by Stewart Smith
add a test case for CREATE TABLE with auto_increment on a decimal column (which isn't supported). |
7 |
create table t1 (a decimal auto_increment); |
8 |
ERROR 42000: Incorrect column specifier for column 'a' |