|
1638.10.23
by Stewart Smith
add SHOW CREATE TABLE test for VARBINARY columns (especially with default values). |
1 |
CREATE TABLE t1 (a varbinary(4) default ''); |
2 |
show create table t1; |
|
3 |
drop table t1; |
|
4 |
||
5 |
create table t2 (a varbinary(4) default 'foo'); |
|
6 |
show create table t2; |
|
7 |
drop table t2; |
|
8 |
||
9 |
create table t3 (a varbinary(4) default 0x01020304); |
|
10 |
show create table t3; |
|
11 |
drop table t3; |
|
|
1638.10.24
by Stewart Smith
fix display of VARBINARY default values in SHOW CREATE TABLE. Always use printable characters by encoding in hex. |
12 |
|
13 |
create table t4 (a varbinary(4) default '\n'); |
|
14 |
show create table t4; |
|
15 |
drop table t4; |
|
16 |
||
17 |
CREATE TABLE `t4` ( |
|
18 |
`a` varbinary(4) DEFAULT 0x0A |
|
19 |
) ENGINE=InnoDB; |
|
20 |
SHOW CREATE TABLE t4; |
|
21 |
DROP TABLE t4; |
|
22 |