~drizzle-trunk/drizzle/development : contents of tests/r/default.result at revision 779.3.53

~drizzle-trunk/drizzle/development : (revision 779.3.53)

drop table if exists t1,t2,t3,t4,t5,t6;
drop database if exists mysqltest;
CREATE TABLE t1 (a varbinary(30) NOT NULL DEFAULT ' ',
b varbinary(1) NOT NULL DEFAULT ' ',
c varbinary(4) NOT NULL DEFAULT '0000',
d blob NULL,
e blob NULL,
f blob NULL,
g blob NULL,
h blob NULL,
i blob NULL,
j blob NULL,
k blob NULL,
l blob NULL,
m blob NULL,
n blob NULL,
o blob NULL,
p blob NULL,
q varbinary(30) NOT NULL DEFAULT ' ',
r varbinary(30) NOT NULL DEFAULT ' ',
s blob NULL,
t varbinary(4) NOT NULL DEFAULT ' ',
u varbinary(1) NOT NULL DEFAULT ' ',
v varbinary(30) NOT NULL DEFAULT ' ',
w varbinary(30) NOT NULL DEFAULT ' ',
x blob NULL,
y varbinary(5) NOT NULL DEFAULT ' ',
z varbinary(20) NOT NULL DEFAULT ' ',
a1 varbinary(30) NOT NULL DEFAULT ' ',
b1 blob NULL)
ENGINE=InnoDB DEFAULT COLLATE utf8_bin;
INSERT into t1 (b) values ('1');
SHOW WARNINGS;
Level	Code	Message
SELECT * from t1;
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
 	1	0000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	 	 	NULL	 	 	 	 	NULL	 	 	 	NULL
CREATE TABLE t2 (a varbinary(30) NOT NULL DEFAULT ' ',
b varbinary(1) NOT NULL DEFAULT ' ',
c varbinary(4) NOT NULL DEFAULT '0000',
d blob NULL,
e blob NULL,
f blob NULL,
g blob NULL,
h blob NULL,
i blob NULL,
j blob NULL,
k blob NULL,
l blob NULL,
m blob NULL,
n blob NULL,
o blob NULL,
p blob NULL,
q varbinary(30) NOT NULL DEFAULT ' ',
r varbinary(30) NOT NULL DEFAULT ' ',
s blob NULL,
t varbinary(4) NOT NULL DEFAULT ' ',
u varbinary(1) NOT NULL DEFAULT ' ',
v varbinary(30) NOT NULL DEFAULT ' ',
w varbinary(30) NOT NULL DEFAULT ' ',
x blob NULL,
y varbinary(5) NOT NULL DEFAULT ' ',
z varbinary(20) NOT NULL DEFAULT ' ',
a1 varbinary(30) NOT NULL DEFAULT ' ',
b1 blob NULL)
ENGINE=MyISAM DEFAULT COLLATE utf8_bin;
SHOW CREATE TABLE t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `a` varbinary(30) NOT NULL,
  `b` varbinary(1) NOT NULL,
  `c` varbinary(4) NOT NULL,
  `d` blob,
  `e` blob,
  `f` blob,
  `g` blob,
  `h` blob,
  `i` blob,
  `j` blob,
  `k` blob,
  `l` blob,
  `m` blob,
  `n` blob,
  `o` blob,
  `p` blob,
  `q` varbinary(30) NOT NULL,
  `r` varbinary(30) NOT NULL,
  `s` blob,
  `t` varbinary(4) NOT NULL,
  `u` varbinary(1) NOT NULL,
  `v` varbinary(30) NOT NULL,
  `w` varbinary(30) NOT NULL,
  `x` blob,
  `y` varbinary(5) NOT NULL,
  `z` varbinary(20) NOT NULL,
  `a1` varbinary(30) NOT NULL,
  `b1` blob
) ENGINE=MyISAM
INSERT into t2 (b) values ('1');
SHOW WARNINGS;
Level	Code	Message
SELECT * from t2;
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
 	1	0000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	 	 	NULL	 	 	 	 	NULL	 	 	 	NULL
drop table t1;
drop table t2;
create table bug20691 (i int, d datetime NOT NULL, dn datetime not null default '0000-00-00 00:00:00');
insert into bug20691 values (7, DEFAULT, DEFAULT), (7, '1975-07-10 07:10:03', '1978-01-13 14:08:51'), (7, DEFAULT, DEFAULT);
ERROR HY000: Field 'd' doesn't have a default value
insert into bug20691 values (7, '1975-07-10 07:10:03', DEFAULT);
select * from bug20691 order by i asc;
i	d	dn
7	1975-07-10 07:10:03	0000-00-00 00:00:00
drop table bug20691;
create table bug20691 (
b enum('small', 'medium', 'large', 'enormous', 'ellisonego') not null,
c time not null,
d date not null,
e int not null,
g blob not null,
h datetime not null,
i decimal not null,
x int);
insert into bug20691 values (3, 5, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 1);
insert into bug20691 (x) values (2);
ERROR HY000: Field 'c' doesn't have a default value
insert into bug20691 values (3, 5, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 3);
insert into bug20691 values (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, 4);
ERROR HY000: Field 'b' doesn't have a default value
select * from bug20691 order by x asc;
b	c	d	e	g	h	i	x
large	00:00:05	0007-01-01	11	17	0019-01-01 00:00:00	23	1
large	00:00:05	0007-01-01	11	17	0019-01-01 00:00:00	23	3
drop table bug20691;
create table t1 (id int not null default 1);
insert into t1 values(default);
drop table t1;

1 by brian clean slate	1	drop table if exists t1,t2,t3,t4,t5,t6;
1 by brian clean slate	2	drop database if exists mysqltest;
722.2.26 by Monty Taylor Enabled default.test.	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',
	6	d blob NULL,
	7	e blob NULL,
	8	f blob NULL,
	9	g blob NULL,
	10	h blob NULL,
	11	i blob NULL,
	12	j blob NULL,
	13	k blob NULL,
	14	l blob NULL,
	15	m blob NULL,
	16	n blob NULL,
	17	o blob NULL,
	18	p blob NULL,
	19	q varbinary(30) NOT NULL DEFAULT ' ',
	20	r varbinary(30) NOT NULL DEFAULT ' ',
	21	s blob NULL,
	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 ' ',
	26	x blob NULL,
	27	y varbinary(5) NOT NULL DEFAULT ' ',
	28	z varbinary(20) NOT NULL DEFAULT ' ',
	29	a1 varbinary(30) NOT NULL DEFAULT ' ',
	30	b1 blob NULL)
	31	ENGINE=InnoDB DEFAULT COLLATE utf8_bin;
1 by brian clean slate	32	INSERT into t1 (b) values ('1');
	33	SHOW WARNINGS;
	34	Level Code Message
	35	SELECT * from t1;
	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
722.2.26 by Monty Taylor Enabled default.test.	38	CREATE TABLE t2 (a varbinary(30) NOT NULL DEFAULT ' ',
	39	b varbinary(1) NOT NULL DEFAULT ' ',
	40	c varbinary(4) NOT NULL DEFAULT '0000',
	41	d blob NULL,
	42	e blob NULL,
	43	f blob NULL,
	44	g blob NULL,
	45	h blob NULL,
	46	i blob NULL,
	47	j blob NULL,
	48	k blob NULL,
	49	l blob NULL,
	50	m blob NULL,
	51	n blob NULL,
	52	o blob NULL,
	53	p blob NULL,
	54	q varbinary(30) NOT NULL DEFAULT ' ',
	55	r varbinary(30) NOT NULL DEFAULT ' ',
	56	s blob NULL,
	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 ' ',
	61	x blob NULL,
	62	y varbinary(5) NOT NULL DEFAULT ' ',
	63	z varbinary(20) NOT NULL DEFAULT ' ',
	64	a1 varbinary(30) NOT NULL DEFAULT ' ',
	65	b1 blob NULL)
	66	ENGINE=MyISAM DEFAULT COLLATE utf8_bin;
1 by brian clean slate	67	SHOW CREATE TABLE t2;
	68	Table Create Table
	69	t2 CREATE TABLE `t2` (
722.2.26 by Monty Taylor Enabled default.test.	70	`a` varbinary(30) NOT NULL,
	71	`b` varbinary(1) NOT NULL,
	72	`c` varbinary(4) NOT NULL,
	73	`d` blob,
	74	`e` blob,
	75	`f` blob,
	76	`g` blob,
	77	`h` blob,
	78	`i` blob,
	79	`j` blob,
	80	`k` blob,
	81	`l` blob,
	82	`m` blob,
	83	`n` blob,
	84	`o` blob,
	85	`p` blob,
	86	`q` varbinary(30) NOT NULL,
	87	`r` varbinary(30) NOT NULL,
	88	`s` blob,
	89	`t` varbinary(4) NOT NULL,
	90	`u` varbinary(1) NOT NULL,
	91	`v` varbinary(30) NOT NULL,
	92	`w` varbinary(30) NOT NULL,
	93	`x` blob,
	94	`y` varbinary(5) NOT NULL,
	95	`z` varbinary(20) NOT NULL,
	96	`a1` varbinary(30) NOT NULL,
	97	`b1` blob
	98	) ENGINE=MyISAM
1 by brian clean slate	99	INSERT into t2 (b) values ('1');
	100	SHOW WARNINGS;
	101	Level Code Message
	102	SELECT * from t2;
	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
	105	drop table t1;
	106	drop table t2;
	107	create table bug20691 (i int, d datetime NOT NULL, dn datetime not null default '0000-00-00 00:00:00');
	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
722.2.26 by Monty Taylor Enabled default.test.	110	insert into bug20691 values (7, '1975-07-10 07:10:03', DEFAULT);
1 by brian clean slate	111	select * from bug20691 order by i asc;
1 by brian clean slate	112	i d dn
722.2.26 by Monty Taylor Enabled default.test.	113	7 1975-07-10 07:10:03 0000-00-00 00:00:00
1 by brian clean slate	114	drop table bug20691;
	115	create table bug20691 (
	116	b enum('small', 'medium', 'large', 'enormous', 'ellisonego') not null,
	117	c time not null,
	118	d date not null,
	119	e int not null,
	120	g blob not null,
	121	h datetime not null,
	122	i decimal not null,
	123	x int);
722.2.26 by Monty Taylor Enabled default.test.	124	insert into bug20691 values (3, 5, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 1);
1 by brian clean slate	125	insert into bug20691 (x) values (2);
722.2.26 by Monty Taylor Enabled default.test.	126	ERROR HY000: Field 'c' doesn't have a default value
	127	insert into bug20691 values (3, 5, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 3);
	128	insert into bug20691 values (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, 4);
	129	ERROR HY000: Field 'b' doesn't have a default value
1 by brian clean slate	130	select * from bug20691 order by x asc;
722.2.26 by Monty Taylor Enabled default.test.	131	b c d e g h i x
	132	large 00:00:05 0007-01-01 11 17 0019-01-01 00:00:00 23 1
	133	large 00:00:05 0007-01-01 11 17 0019-01-01 00:00:00 23 3
1 by brian clean slate	134	drop table bug20691;
722.2.26 by Monty Taylor Enabled default.test.	135	create table t1 (id int not null default 1);
722.2.26 by Monty Taylor Enabled default.test.	136	insert into t1 values(default);
1 by brian clean slate	137	drop table t1;