1
drop table if exists t1,t2,t3,t4,t5,t6;
2
drop database if exists mysqltest;
3
CREATE TABLE t1 (a varbinary(30) NOT NULL DEFAULT ' ',
4
b varbinary(1) NOT NULL DEFAULT ' ',
5
c varbinary(4) NOT NULL DEFAULT '0000',
19
q varbinary(30) NOT NULL DEFAULT ' ',
20
r varbinary(30) NOT NULL DEFAULT ' ',
22
t varbinary(4) NOT NULL DEFAULT ' ',
23
u varbinary(1) NOT NULL DEFAULT ' ',
24
v varbinary(30) NOT NULL DEFAULT ' ',
25
w varbinary(30) NOT NULL DEFAULT ' ',
27
y varbinary(5) NOT NULL DEFAULT ' ',
28
z varbinary(20) NOT NULL DEFAULT ' ',
29
a1 varbinary(30) NOT NULL DEFAULT ' ',
31
ENGINE=InnoDB DEFAULT COLLATE utf8_bin;
32
INSERT into t1 (b) values ('1');
36
a b c d e f g h i j k l m n o p q r s t u v w x y z a1 b1
37
1 0000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
38
CREATE TEMPORARY TABLE t2 (a varbinary(30) NOT NULL DEFAULT ' ',
39
b varbinary(1) NOT NULL DEFAULT ' ',
40
c varbinary(4) NOT NULL DEFAULT '0000',
54
q varbinary(30) NOT NULL DEFAULT ' ',
55
r varbinary(30) NOT NULL DEFAULT ' ',
57
t varbinary(4) NOT NULL DEFAULT ' ',
58
u varbinary(1) NOT NULL DEFAULT ' ',
59
v varbinary(30) NOT NULL DEFAULT ' ',
60
w varbinary(30) NOT NULL DEFAULT ' ',
62
y varbinary(5) NOT NULL DEFAULT ' ',
63
z varbinary(20) NOT NULL DEFAULT ' ',
64
a1 varbinary(30) NOT NULL DEFAULT ' ',
66
ENGINE=MyISAM DEFAULT COLLATE utf8_bin;
69
t2 CREATE TEMPORARY TABLE `t2` (
70
`a` varbinary(30) NOT NULL DEFAULT ' ',
71
`b` varbinary(1) NOT NULL DEFAULT ' ',
72
`c` varbinary(4) NOT NULL DEFAULT '0000',
86
`q` varbinary(30) NOT NULL DEFAULT ' ',
87
`r` varbinary(30) NOT NULL DEFAULT ' ',
89
`t` varbinary(4) NOT NULL DEFAULT ' ',
90
`u` varbinary(1) NOT NULL DEFAULT ' ',
91
`v` varbinary(30) NOT NULL DEFAULT ' ',
92
`w` varbinary(30) NOT NULL DEFAULT ' ',
94
`y` varbinary(5) NOT NULL DEFAULT ' ',
95
`z` varbinary(20) NOT NULL DEFAULT ' ',
96
`a1` varbinary(30) NOT NULL DEFAULT ' ',
99
INSERT into t2 (b) values ('1');
103
a b c d e f g h i j k l m n o p q r s t u v w x y z a1 b1
104
1 0000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
107
create table bug20691 (i int, d datetime NOT NULL, dn datetime NULL);
108
insert into bug20691 values (7, DEFAULT, DEFAULT), (7, '1975-07-10 07:10:03', '1978-01-13 14:08:51'), (7, DEFAULT, DEFAULT);
109
ERROR HY000: Field 'd' doesn't have a default value
110
insert into bug20691 values (7, '1975-07-10 07:10:03', DEFAULT);
111
select * from bug20691 order by i asc;
113
7 1975-07-10 07:10:03 NULL
115
create table bug20691 (
116
b enum('small', 'medium', 'large', 'enormous', 'ellisonego') not null,
123
insert into bug20691 values (3, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 1);
124
insert into bug20691 (x) values (2);
125
ERROR HY000: Field 'd' doesn't have a default value
126
insert into bug20691 values (3, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 3);
127
insert into bug20691 values (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, 4);
128
ERROR HY000: Field 'b' doesn't have a default value
129
select * from bug20691 order by x asc;
131
large 0007-01-01 11 17 0019-01-01 00:00:00 23 1
132
large 0007-01-01 11 17 0019-01-01 00:00:00 23 3
134
create table t1 (id int not null default 1);
135
insert into t1 values(default);