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

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

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 TEMPORARY 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 TEMPORARY TABLE `t2` (
  `a` VARBINARY(30) NOT NULL DEFAULT 0x20,
  `b` VARBINARY(1) NOT NULL DEFAULT 0x20,
  `c` VARBINARY(4) NOT NULL DEFAULT 0x30303030,
  `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 DEFAULT 0x20,
  `r` VARBINARY(30) NOT NULL DEFAULT 0x20,
  `s` BLOB,
  `t` VARBINARY(4) NOT NULL DEFAULT 0x20,
  `u` VARBINARY(1) NOT NULL DEFAULT 0x20,
  `v` VARBINARY(30) NOT NULL DEFAULT 0x20,
  `w` VARBINARY(30) NOT NULL DEFAULT 0x20,
  `x` BLOB,
  `y` VARBINARY(5) NOT NULL DEFAULT 0x20,
  `z` VARBINARY(20) NOT NULL DEFAULT 0x20,
  `a1` VARBINARY(30) NOT NULL DEFAULT 0x20,
  `b1` BLOB
) ENGINE=MyISAM COLLATE = utf8_bin
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 NULL);
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	NULL
drop table bug20691;
create table bug20691 (
b enum('small', 'medium', 'large', 'enormous', 'ellisonego') 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, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 1);
insert into bug20691 (x) values (2);
ERROR HY000: Field 'd' doesn't have a default value
insert into bug20691 values (3, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 3);
insert into bug20691 values (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	d	e	g	h	i	x
large	0007-01-01	11	17	0019-01-01 00:00:00	23	1
large	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)
1245.3.4 by Stewart Smith make the equals of KEY=VALUE required for CREATE TABLE options	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
1063.9.3 by Brian Aker Partial fix for tests for tmp	38	CREATE TEMPORARY TABLE t2 (a varbinary(30) NOT NULL DEFAULT ' ',
722.2.26 by Monty Taylor Enabled default.test.	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)
1245.3.4 by Stewart Smith make the equals of KEY=VALUE required for CREATE TABLE options	66	ENGINE=MyISAM DEFAULT COLLATE=utf8_bin;
1 by brian clean slate	67	SHOW CREATE TABLE t2;
1 by brian clean slate	68	Table Create Table
1063.9.3 by Brian Aker Partial fix for tests for tmp	69	t2 CREATE TEMPORARY TABLE `t2` (
1743.5.2 by LinuxJedi Alter many test cases for the new SHOW CREATE TABLE output	70	`a` VARBINARY(30) NOT NULL DEFAULT 0x20,
	71	`b` VARBINARY(1) NOT NULL DEFAULT 0x20,
	72	`c` VARBINARY(4) NOT NULL DEFAULT 0x30303030,
	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 DEFAULT 0x20,
	87	`r` VARBINARY(30) NOT NULL DEFAULT 0x20,
	88	`s` BLOB,
	89	`t` VARBINARY(4) NOT NULL DEFAULT 0x20,
	90	`u` VARBINARY(1) NOT NULL DEFAULT 0x20,
	91	`v` VARBINARY(30) NOT NULL DEFAULT 0x20,
	92	`w` VARBINARY(30) NOT NULL DEFAULT 0x20,
	93	`x` BLOB,
	94	`y` VARBINARY(5) NOT NULL DEFAULT 0x20,
	95	`z` VARBINARY(20) NOT NULL DEFAULT 0x20,
	96	`a1` VARBINARY(30) NOT NULL DEFAULT 0x20,
	97	`b1` BLOB
1638.10.66 by Stewart Smith default.result with explicit COLLATE in SHOW CREATE TABLE	98	) ENGINE=MyISAM COLLATE = utf8_bin
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;
873.1.2 by Jay Pipes Fixed Field_datetime to never accept any bad datetimes as a string. This broke	107	create table bug20691 (i int, d datetime NOT NULL, dn datetime NULL);
1 by brian clean slate	108	insert into bug20691 values (7, DEFAULT, DEFAULT), (7, '1975-07-10 07:10:03', '1978-01-13 14:08:51'), (7, DEFAULT, DEFAULT);
1 by brian clean slate	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
873.1.2 by Jay Pipes Fixed Field_datetime to never accept any bad datetimes as a string. This broke	113	7 1975-07-10 07:10:03 NULL
1 by brian clean slate	114	drop table bug20691;
	115	create table bug20691 (
	116	b enum('small', 'medium', 'large', 'enormous', 'ellisonego') not null,
	117	d date not null,
	118	e int not null,
	119	g blob not null,
	120	h datetime not null,
	121	i decimal not null,
	122	x int);
896.5.1 by Jay Pipes Removes the TIME column type and related time functions.	123	insert into bug20691 values (3, '0007-01-01', 11, 17, '0019-01-01 00:00:00', 23, 1);
1 by brian clean slate	124	insert into bug20691 (x) values (2);
896.5.1 by Jay Pipes Removes the TIME column type and related time functions.	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);
722.2.26 by Monty Taylor Enabled default.test.	128	ERROR HY000: Field 'b' doesn't have a default value
1 by brian clean slate	129	select * from bug20691 order by x asc;
896.5.1 by Jay Pipes Removes the TIME column type and related time functions.	130	b d e g h i x
	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
1 by brian clean slate	133	drop table bug20691;
722.2.26 by Monty Taylor Enabled default.test.	134	create table t1 (id int not null default 1);
722.2.26 by Monty Taylor Enabled default.test.	135	insert into t1 values(default);
1 by brian clean slate	136	drop table t1;