Starting Tests

mysql_client_test              [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysql_client_test.c:3571: check failed: '(int) i8_data == rc'

ps                             [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 670: query 'create table t1 (utext varchar(20) character set ucs2)' failed: 1115: Unknown character set: 'ucs2'

Failed 2/288 tests, 99.30% were successful.


Starting Tests

join                           [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/join.result	Mon Oct 10 01:54:59 2005
--- r/join.reject	Mon Nov 21 00:40:49 2005
***************
*** 267,276 ****
  INSERT INTO t2 VALUES ('rivercats','cust',20);
  SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE emp.emp_id = 'psmith' AND lr.siteid = 'rivercats';
  rate_code	base_rate
! cust	20
  SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE lr.siteid = 'rivercats' AND emp.emp_id = 'psmith';
  rate_code	base_rate
! cust	20
  drop table t1,t2;
  CREATE TABLE t1 (ID INTEGER NOT NULL PRIMARY KEY, Value1 VARCHAR(255));
  CREATE TABLE t2 (ID INTEGER NOT NULL PRIMARY KEY, Value2 VARCHAR(255));
--- 267,276 ----
  INSERT INTO t2 VALUES ('rivercats','cust',20);
  SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE emp.emp_id = 'psmith' AND lr.siteid = 'rivercats';
  rate_code	base_rate
! cust	-1.14103
  SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE lr.siteid = 'rivercats' AND emp.emp_id = 'psmith';
  rate_code	base_rate
! cust	-1.14103
  drop table t1,t2;
  CREATE TABLE t1 (ID INTEGER NOT NULL PRIMARY KEY, Value1 VARCHAR(255));
  CREATE TABLE t2 (ID INTEGER NOT NULL PRIMARY KEY, Value2 VARCHAR(255));
-------------------------------------------------------

mysql_client_test              [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysql_client_test.c:3571: check failed: '(int) i8_data == rc'
mysqltest: At line 10: command "$MYSQL_CLIENT_TEST" failed

ps                             [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 670: query 'create table t1 (utext varchar(20) character set ucs2)' failed: 1115: Unknown character set: 'ucs2'

ps_2myisam                     [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_2myisam.result	Mon Oct 10 01:54:59 2005
--- r/ps_2myisam.reject	Mon Nov 21 00:47:45 2005
***************
*** 1892,1899 ****
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	9	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
--- 1892,1899 ----
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	-1.38024	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	-1.38024	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
***************
*** 2420,2441 ****
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	20	20	20	20	20.0000
! 21	21	21	21	21	21	21	21	21	21	21.0000
! 22	22	22	22	22	22	22	22	22	22	22.0000
! 23	23	23	23	23	23	23	23	23	23	23.0000
! 30	30	30	30	30	30	30	30	30	30	30.0000
! 31	31	31	31	31	31	31	31	31	31	31.0000
! 32	32	32	32	32	32	32	32	32	32	32.0000
! 33	33	33	33	33	33	33	33	33	33	33.0000
! 40	40	40	40	40	40	40	40	40	40	40.0000
! 41	41	41	41	41	41	41	41	41	41	41.0000
! 42	42	42	42	42	42	42	42	42	42	42.0000
! 43	43	43	43	43	43	43	43	43	43	43.0000
! 50	50	50	50	50	50	50	50	50	50	50.0000
! 51	51	51	51	51	51	51	51	51	51	51.0000
! 52	52	52	52	52	52	52	52	52	52	52.0000
! 53	53	53	53	53	53	53	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--- 2420,2441 ----
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	-1.38024	20	20	20	20.0000
! 21	21	21	21	21	21	-1.38024	21	21	21	21.0000
! 22	22	22	22	22	22	-1.38024	22	22	22	22.0000
! 23	23	23	23	23	23	-1.38024	23	23	23	23.0000
! 30	30	30	30	30	30	-1.38024	30	30	30	30.0000
! 31	31	31	31	31	31	-1.38024	31	31	31	31.0000
! 32	32	32	32	32	32	-1.38024	32	32	32	32.0000
! 33	33	33	33	33	33	-1.38024	33	33	33	33.0000
! 40	40	40	40	40	40	-1.38024	40	40	40	40.0000
! 41	41	41	41	41	41	-1.38024	41	41	41	41.0000
! 42	42	42	42	42	42	-1.38024	42	42	42	42.0000
! 43	43	43	43	43	43	-1.38024	43	43	43	43.0000
! 50	50	50	50	50	50	-1.38024	50	50	50	50.0000
! 51	51	51	51	51	51	-1.38024	51	51	51	51.0000
! 52	52	52	52	52	52	-1.38024	52	52	52	52.0000
! 53	53	53	53	53	53	-1.38024	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-------------------------------------------------------

ps_3innodb                     [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_3innodb.result	Mon Oct 10 01:54:59 2005
--- r/ps_3innodb.reject	Mon Nov 21 00:48:01 2005
***************
*** 1875,1882 ****
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	9	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
--- 1875,1882 ----
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	-1.74825	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	-1.74825	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
***************
*** 2403,2424 ****
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	20	20	20	20	20.0000
! 21	21	21	21	21	21	21	21	21	21	21.0000
! 22	22	22	22	22	22	22	22	22	22	22.0000
! 23	23	23	23	23	23	23	23	23	23	23.0000
! 30	30	30	30	30	30	30	30	30	30	30.0000
! 31	31	31	31	31	31	31	31	31	31	31.0000
! 32	32	32	32	32	32	32	32	32	32	32.0000
! 33	33	33	33	33	33	33	33	33	33	33.0000
! 40	40	40	40	40	40	40	40	40	40	40.0000
! 41	41	41	41	41	41	41	41	41	41	41.0000
! 42	42	42	42	42	42	42	42	42	42	42.0000
! 43	43	43	43	43	43	43	43	43	43	43.0000
! 50	50	50	50	50	50	50	50	50	50	50.0000
! 51	51	51	51	51	51	51	51	51	51	51.0000
! 52	52	52	52	52	52	52	52	52	52	52.0000
! 53	53	53	53	53	53	53	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--- 2403,2424 ----
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	-1.74825	20	20	20	20.0000
! 21	21	21	21	21	21	-1.74825	21	21	21	21.0000
! 22	22	22	22	22	22	-1.74825	22	22	22	22.0000
! 23	23	23	23	23	23	-1.74825	23	23	23	23.0000
! 30	30	30	30	30	30	-1.74825	30	30	30	30.0000
! 31	31	31	31	31	31	-1.74825	31	31	31	31.0000
! 32	32	32	32	32	32	-1.74825	32	32	32	32.0000
! 33	33	33	33	33	33	-1.74825	33	33	33	33.0000
! 40	40	40	40	40	40	-1.74825	40	40	40	40.0000
! 41	41	41	41	41	41	-1.74825	41	41	41	41.0000
! 42	42	42	42	42	42	-1.74825	42	42	42	42.0000
! 43	43	43	43	43	43	-1.74825	43	43	43	43.0000
! 50	50	50	50	50	50	-1.74825	50	50	50	50.0000
! 51	51	51	51	51	51	-1.74825	51	51	51	51.0000
! 52	52	52	52	52	52	-1.74825	52	52	52	52.0000
! 53	53	53	53	53	53	-1.74825	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-------------------------------------------------------

ps_4heap                       [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_4heap.result	Mon Oct 10 01:54:59 2005
--- r/ps_4heap.reject	Mon Nov 21 00:48:14 2005
***************
*** 1876,1883 ****
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	9	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
--- 1876,1883 ----
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	-1.96475	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	-1.96475	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
***************
*** 2404,2425 ****
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	20	20	20	20	20.0000
! 21	21	21	21	21	21	21	21	21	21	21.0000
! 22	22	22	22	22	22	22	22	22	22	22.0000
! 23	23	23	23	23	23	23	23	23	23	23.0000
! 30	30	30	30	30	30	30	30	30	30	30.0000
! 31	31	31	31	31	31	31	31	31	31	31.0000
! 32	32	32	32	32	32	32	32	32	32	32.0000
! 33	33	33	33	33	33	33	33	33	33	33.0000
! 40	40	40	40	40	40	40	40	40	40	40.0000
! 41	41	41	41	41	41	41	41	41	41	41.0000
! 42	42	42	42	42	42	42	42	42	42	42.0000
! 43	43	43	43	43	43	43	43	43	43	43.0000
! 50	50	50	50	50	50	50	50	50	50	50.0000
! 51	51	51	51	51	51	51	51	51	51	51.0000
! 52	52	52	52	52	52	52	52	52	52	52.0000
! 53	53	53	53	53	53	53	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--- 2404,2425 ----
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	-1.96475	20	20	20	20.0000
! 21	21	21	21	21	21	-1.96475	21	21	21	21.0000
! 22	22	22	22	22	22	-1.96475	22	22	22	22.0000
! 23	23	23	23	23	23	-1.96475	23	23	23	23.0000
! 30	30	30	30	30	30	-1.96475	30	30	30	30.0000
! 31	31	31	31	31	31	-1.96475	31	31	31	31.0000
! 32	32	32	32	32	32	-1.96475	32	32	32	32.0000
! 33	33	33	33	33	33	-1.96475	33	33	33	33.0000
! 40	40	40	40	40	40	-1.96475	40	40	40	40.0000
! 41	41	41	41	41	41	-1.96475	41	41	41	41.0000
! 42	42	42	42	42	42	-1.96475	42	42	42	42.0000
! 43	43	43	43	43	43	-1.96475	43	43	43	43.0000
! 50	50	50	50	50	50	-1.96475	50	50	50	50.0000
! 51	51	51	51	51	51	-1.96475	51	51	51	51.0000
! 52	52	52	52	52	52	-1.96475	52	52	52	52.0000
! 53	53	53	53	53	53	-1.96475	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-------------------------------------------------------

ps_5merge                      [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_5merge.result	Mon Oct 10 01:54:59 2005
--- r/ps_5merge.reject	Mon Nov 21 00:48:27 2005
***************
*** 1812,1819 ****
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	9	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
--- 1812,1819 ----
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	-1.96578	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	-1.96578	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
***************
*** 2340,2361 ****
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	20	20	20	20	20.0000
! 21	21	21	21	21	21	21	21	21	21	21.0000
! 22	22	22	22	22	22	22	22	22	22	22.0000
! 23	23	23	23	23	23	23	23	23	23	23.0000
! 30	30	30	30	30	30	30	30	30	30	30.0000
! 31	31	31	31	31	31	31	31	31	31	31.0000
! 32	32	32	32	32	32	32	32	32	32	32.0000
! 33	33	33	33	33	33	33	33	33	33	33.0000
! 40	40	40	40	40	40	40	40	40	40	40.0000
! 41	41	41	41	41	41	41	41	41	41	41.0000
! 42	42	42	42	42	42	42	42	42	42	42.0000
! 43	43	43	43	43	43	43	43	43	43	43.0000
! 50	50	50	50	50	50	50	50	50	50	50.0000
! 51	51	51	51	51	51	51	51	51	51	51.0000
! 52	52	52	52	52	52	52	52	52	52	52.0000
! 53	53	53	53	53	53	53	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--- 2340,2361 ----
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	-1.96578	20	20	20	20.0000
! 21	21	21	21	21	21	-1.96578	21	21	21	21.0000
! 22	22	22	22	22	22	-1.96578	22	22	22	22.0000
! 23	23	23	23	23	23	-1.96578	23	23	23	23.0000
! 30	30	30	30	30	30	-1.96578	30	30	30	30.0000
! 31	31	31	31	31	31	-1.96578	31	31	31	31.0000
! 32	32	32	32	32	32	-1.96578	32	32	32	32.0000
! 33	33	33	33	33	33	-1.96578	33	33	33	33.0000
! 40	40	40	40	40	40	-1.96578	40	40	40	40.0000
! 41	41	41	41	41	41	-1.96578	41	41	41	41.0000
! 42	42	42	42	42	42	-1.96578	42	42	42	42.0000
! 43	43	43	43	43	43	-1.96578	43	43	43	43.0000
! 50	50	50	50	50	50	-1.96578	50	50	50	50.0000
! 51	51	51	51	51	51	-1.96578	51	51	51	51.0000
! 52	52	52	52	52	52	-1.96578	52	52	52	52.0000
! 53	53	53	53	53	53	-1.96578	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
***************
*** 4826,4833 ****
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	9	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
--- 4826,4833 ----
  select * from t9 order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
  0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
! 1	1	1	1	1	1	-1.96578	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
! 9	9	9	9	9	9	-1.96578	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
  test_sequence
  ------ select @parameter:= column ------
  prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
***************
*** 5354,5375 ****
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	20	20	20	20	20.0000
! 21	21	21	21	21	21	21	21	21	21	21.0000
! 22	22	22	22	22	22	22	22	22	22	22.0000
! 23	23	23	23	23	23	23	23	23	23	23.0000
! 30	30	30	30	30	30	30	30	30	30	30.0000
! 31	31	31	31	31	31	31	31	31	31	31.0000
! 32	32	32	32	32	32	32	32	32	32	32.0000
! 33	33	33	33	33	33	33	33	33	33	33.0000
! 40	40	40	40	40	40	40	40	40	40	40.0000
! 41	41	41	41	41	41	41	41	41	41	41.0000
! 42	42	42	42	42	42	42	42	42	42	42.0000
! 43	43	43	43	43	43	43	43	43	43	43.0000
! 50	50	50	50	50	50	50	50	50	50	50.0000
! 51	51	51	51	51	51	51	51	51	51	51.0000
! 52	52	52	52	52	52	52	52	52	52	52.0000
! 53	53	53	53	53	53	53	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--- 5354,5375 ----
  from t9 where c1 >= 20
  order by c1 ;
  c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c12
! 20	20	20	20	20	20	-1.96578	20	20	20	20.0000
! 21	21	21	21	21	21	-1.96578	21	21	21	21.0000
! 22	22	22	22	22	22	-1.96578	22	22	22	22.0000
! 23	23	23	23	23	23	-1.96578	23	23	23	23.0000
! 30	30	30	30	30	30	-1.96578	30	30	30	30.0000
! 31	31	31	31	31	31	-1.96578	31	31	31	31.0000
! 32	32	32	32	32	32	-1.96578	32	32	32	32.0000
! 33	33	33	33	33	33	-1.96578	33	33	33	33.0000
! 40	40	40	40	40	40	-1.96578	40	40	40	40.0000
! 41	41	41	41	41	41	-1.96578	41	41	41	41.0000
! 42	42	42	42	42	42	-1.96578	42	42	42	42.0000
! 43	43	43	43	43	43	-1.96578	43	43	43	43.0000
! 50	50	50	50	50	50	-1.96578	50	50	50	50.0000
! 51	51	51	51	51	51	-1.96578	51	51	51	51.0000
! 52	52	52	52	52	52	-1.96578	52	52	52	52.0000
! 53	53	53	53	53	53	-1.96578	53	53	53	53.0000
  60	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  61	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
  62	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-------------------------------------------------------

type_float                     [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/type_float.result	Mon Oct 10 01:54:59 2005
--- r/type_float.reject	Mon Nov 21 01:24:54 2005
***************
*** 29,49 ****
  insert into t1 values(-10,-10),(1e-5,1e-5),(1e-10,1e-10),(1e-15,1e-15),(1e-20,1e-20),(1e-50,1e-50),(1e-150,1e-150);
  select * from t1;
  f1	f2
! 10	10
! 100000	100000
! 1.23457e+9	1234567890
! 1e+10	10000000000
! 1e+15	1e+15
! 1e+20	1e+20
! 3.40282e+38	1e+50
! 3.40282e+38	1e+150
! -10	-10
! 1e-5	1e-5
! 1e-10	1e-10
! 1e-15	1e-15
! 1e-20	1e-20
! 0	1e-50
! 0	1e-150
  drop table t1;
  create table t1 (datum double);
  insert into t1 values (0.5),(1.0),(1.5),(2.0),(2.5);
--- 29,49 ----
  insert into t1 values(-10,-10),(1e-5,1e-5),(1e-10,1e-10),(1e-15,1e-15),(1e-20,1e-20),(1e-50,1e-50),(1e-150,1e-150);
  select * from t1;
  f1	f2
! -1.72369	10
! -1.72369	100000
! -1.72369	1234567890
! -1.72369	10000000000
! -1.72369	1e+15
! -1.72369	1e+20
! -1.72369	1e+50
! -1.72369	1e+150
! -1.72369	-10
! -1.72369	1e-5
! -1.72369	1e-10
! -1.72369	1e-15
! -1.72369	1e-20
! -1.72369	1e-50
! -1.72369	1e-150
  drop table t1;
  create table t1 (datum double);
  insert into t1 values (0.5),(1.0),(1.5),(2.0),(2.5);
***************
*** 101,107 ****
  insert into t1 values (1);
  select max(a),min(a),avg(a) from t1;
  max(a)	min(a)	avg(a)
! 1	1	1
  drop table t1;
  create table t1 (f float, f2 float(24), f3 float(6,2), d double, d2 float(53), d3 double(10,3), de decimal, de2 decimal(6), de3 decimal(5,2), n numeric, n2 numeric(8), n3 numeric(5,6));
  show full columns from t1;
--- 101,107 ----
  insert into t1 values (1);
  select max(a),min(a),avg(a) from t1;
  max(a)	min(a)	avg(a)
! -1.72369	1	1
  drop table t1;
  create table t1 (f float, f2 float(24), f3 float(6,2), d double, d2 float(53), d3 double(10,3), de decimal, de2 decimal(6), de3 decimal(5,2), n numeric, n2 numeric(8), n3 numeric(5,6));
  show full columns from t1;
***************
*** 136,142 ****
  insert t1 values (1.0, 2.0);
  select * from t1;
  a	b
! 1.000000000000000000000000000000	2.000000000000000000000000000000
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
--- 136,142 ----
  insert t1 values (1.0, 2.0);
  select * from t1;
  a	b
! -1.723687171936035156250000000000	2.000000000000000000000000000000
  show create table t1;
  Table	Create Table
  t1	CREATE TABLE `t1` (
***************
*** 175,186 ****
  Warning	1264	Data truncated; out of range for column 'f' at row 6
  select * from t1;
  f
! -9.999
! -9.999
! -9.999
! 9.999
! 9.999
! 9.999
  drop table if exists t1;
  create table t1 (f double(4,3));
  insert into t1 values (-11.0),(-11),("-11"),(11.0),(11),("11");
--- 175,186 ----
  Warning	1264	Data truncated; out of range for column 'f' at row 6
  select * from t1;
  f
! -1.724
! -1.724
! -1.724
! -1.724
! -1.724
! -1.724
  drop table if exists t1;
  create table t1 (f double(4,3));
  insert into t1 values (-11.0),(-11),("-11"),(11.0),(11),("11");
-------------------------------------------------------

type_ranges                    [ fail ]

Errors are (from /usr/src/blfs/mysql-4.1.15/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/type_ranges.result	Mon Oct 10 01:54:59 2005
--- r/type_ranges.reject	Mon Nov 21 01:25:12 2005
***************
*** 120,132 ****
  insert into t1 (tiny) values (1);
  select auto,string,tiny,short,medium,long_int,longlong,real_float,real_double,utiny,ushort,umedium,ulong,ulonglong,mod(floor(time_stamp/1000000),1000000)-mod(curdate(),1000000),date_field,time_field,date_time,blob_col,tinyblob_col,mediumblob_col,longblob_col from t1;
  auto	string	tiny	short	medium	long_int	longlong	real_float	real_double	utiny	ushort	umedium	ulong	ulonglong	mod(floor(time_stamp/1000000),1000000)-mod(curdate(),1000000)	date_field	time_field	date_time	blob_col	tinyblob_col	mediumblob_col	longblob_col
! 10	1	1	1	1	1	1	1.0	1.0000	1	00001	1	1	1	0	0000-00-00	00:00:00	0000-00-00 00:00:00	1	1	1	1
! 11	2	2	2	2	2	2	2.0	2.0000	2	00002	2	2	2	0	NULL	NULL	NULL	NULL	NULL	2	2
! 12	0.33	3	3	3	3	3	3.0	3.0000	3	00003	3	3	3	0	1997-03-03	10:10:10	1997-03-03 10:10:10				3
! 13	-1	-1	-1	-1	-1	-1	-1.0	-1.0000	0	00000	0	0	18446744073709551615	0	1997-08-07	08:07:06	1997-04-03 09:08:07	-1	-1	-1	-1
! 14	-429496729	-128	-32768	-8388608	-2147483648	-4294967295	-4294967296.0	-4294967295.0000	0	00000	0	0	18446744069414584321	0	0000-00-00	00:00:00	0000-00-00 00:00:00	-4294967295	-4294967295	-4294967295	-4294967295
! 15	4294967295	127	32767	8388607	2147483647	4294967295	4294967296.0	4294967295.0000	255	65535	16777215	4294967295	4294967295	0	0000-00-00	00:00:00	0000-00-00 00:00:00	4294967295	4294967295	4294967295	4294967295
! 16	hello	1	1	0	0	0	0.0	NULL	0	00000	0	0	0	0	NULL	NULL	NULL	NULL	NULL		
  ALTER TABLE t1
  add new_field char(10) default "new" not null,
  change blob_col new_blob_col varchar(20),
--- 120,132 ----
  insert into t1 (tiny) values (1);
  select auto,string,tiny,short,medium,long_int,longlong,real_float,real_double,utiny,ushort,umedium,ulong,ulonglong,mod(floor(time_stamp/1000000),1000000)-mod(curdate(),1000000),date_field,time_field,date_time,blob_col,tinyblob_col,mediumblob_col,longblob_col from t1;
  auto	string	tiny	short	medium	long_int	longlong	real_float	real_double	utiny	ushort	umedium	ulong	ulonglong	mod(floor(time_stamp/1000000),1000000)-mod(curdate(),1000000)	date_field	time_field	date_time	blob_col	tinyblob_col	mediumblob_col	longblob_col
! 10	1	1	1	1	1	1	-1.4	1.0000	1	00001	1	1	1	0	0000-00-00	00:00:00	0000-00-00 00:00:00	1	1	1	1
! 11	2	2	2	2	2	2	-1.4	2.0000	2	00002	2	2	2	0	NULL	NULL	NULL	NULL	NULL	2	2
! 12	0.33	3	3	3	3	3	-1.4	3.0000	3	00003	3	3	3	0	1997-03-03	10:10:10	1997-03-03 10:10:10				3
! 13	-1	-1	-1	-1	-1	-1	-1.4	-1.0000	0	00000	0	0	18446744073709551615	0	1997-08-07	08:07:06	1997-04-03 09:08:07	-1	-1	-1	-1
! 14	-429496729	-128	-32768	-8388608	-2147483648	-4294967295	-1.4	-4294967295.0000	0	00000	0	0	18446744069414584321	0	0000-00-00	00:00:00	0000-00-00 00:00:00	-4294967295	-4294967295	-4294967295	-4294967295
! 15	4294967295	127	32767	8388607	2147483647	4294967295	-1.4	4294967295.0000	255	65535	16777215	4294967295	4294967295	0	0000-00-00	00:00:00	0000-00-00 00:00:00	4294967295	4294967295	4294967295	4294967295
! 16	hello	1	1	0	0	0	-1.4	NULL	0	00000	0	0	0	0	NULL	NULL	NULL	NULL	NULL		
  ALTER TABLE t1
  add new_field char(10) default "new" not null,
  change blob_col new_blob_col varchar(20),
-------------------------------------------------------

Failed 9/288 tests, 96.87% were successful.