| Bug #6077 | Problem with make test from 4.1.7 and bk | ||
|---|---|---|---|
| Submitted: | 13 Oct 2004 23:33 | Modified: | 8 Dec 2004 6:07 |
| Reporter: | Boyd GERBER | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1.8 bk/4.1.7 release and 4.1.6 bk | OS: | UnixWare 7.1.3 and UnixWare 7.1.4 |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[13 Oct 2004 23:58]
Boyd GERBER
Trying to get this resolved before mysql-4.1.6 is released.
[15 Oct 2004 1:51]
Matthew Lord
I was able to verify this on the same machine, uw713.zenez.com.
[21 Oct 2004 19:49]
Boyd GERBER
Released version has these errors when build with...
CC="cc" CFLAGS="-I/usr/local/include" CXX="CC" CFLAGS="-I/usr/local/include" ./c
onfigure --prefix=/usr/local/mysql --enable-thread-safe-client --with-berkeley-d
b=./bdb --with-innodb --with-openssl --with-extra-charsets=complex --with-vio
It Failed 6/269 tests, 97.76% successful
func_crypt [ fail ]
Errors are (from /home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/mysql-te
st/var/log/mysqltest-time) :
/home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/client/.libs/mysqltest: A
t line 7: query 'select length(encrypt('foo', 'ff')) <> 0' failed: 2013: Lost co
nnection to MySQL server during query
(the last lines may be the most important ones)
Ending Tests
Shutting-down MySQL daemon
master not cooperating with mysqladmin, will try manual kill
UX:kill (mysql-test-run): ERROR: No such process
master refused to die. Sending SIGKILL
UX:kill (mysql-test-run): ERROR: No such process
Master shutdown finished
Slave shutdown finished
Resuming Tests
...
ps_2myisam [ fail ]
Errors are (from /home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/mysql-te
st/var/log/mysqltest-time) :
/home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/client/.libs/mysqltest: A
t line 42: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_2myisam.result Wed Oct 13 09:30:52 2004
--- r/ps_2myisam.reject Thu Oct 21 22:22:23 2004
***************
*** 2286,2291 ****
--- 2286,2293 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2292,2297 ****
--- 2294,2301 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2298,2303 ****
--- 2302,2309 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2305,2310 ****
--- 2311,2318 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2415,2424 ****
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
--- 2423,2432 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
ps_3innodb [ fail ]
Errors are (from /home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/mysql-te
st/var/log/mysqltest-time) :
/home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/client/.libs/mysqltest: A
t line 25: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_3innodb.result Wed Oct 13 09:30:52 2004
--- r/ps_3innodb.reject Thu Oct 21 22:22:30 2004
***************
*** 2269,2274 ****
--- 2269,2276 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2275,2280 ****
--- 2277,2284 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2281,2286 ****
--- 2285,2292 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2288,2293 ****
--- 2294,2301 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2398,2407 ****
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
--- 2406,2415 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
ps_4heap [ fail ]
Errors are (from /home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/mysql-te
st/var/log/mysqltest-time) :
/home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/client/.libs/mysqltest: A
t line 50: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_4heap.result Wed Oct 13 09:30:52 2004
--- r/ps_4heap.reject Thu Oct 21 22:22:38 2004
***************
*** 2270,2275 ****
--- 2270,2277 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2276,2281 ****
--- 2278,2285 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2282,2287 ****
--- 2286,2293 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2289,2294 ****
--- 2295,2302 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2399,2408 ****
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
--- 2407,2416 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
ps_5merge [ fail ]
Errors are (from /home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/mysql-te
st/var/log/mysqltest-time) :
/home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/client/.libs/mysqltest: A
t line 85: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_5merge.result Wed Oct 13 09:30:52 2004
--- r/ps_5merge.reject Thu Oct 21 22:22:45 2004
***************
*** 2209,2214 ****
--- 2209,2216 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2215,2220 ****
--- 2217,2224 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2221,2226 ****
--- 2225,2232 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2228,2233 ****
--- 2234,2241 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2338,2347 ****
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
--- 2346,2355 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
***************
*** 5217,5222 ****
--- 5225,5232 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 5223,5228 ****
--- 5233,5240 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 5229,5234 ****
--- 5241,5248 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 5236,5241 ****
--- 5250,5257 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 5346,5355 ****
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
--- 5362,5371 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
ps_6bdb [ fail ]
Errors are (from /home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/mysql-te
st/var/log/mysqltest-time) :
/home/mount/uw713/zenez1/build/uw713/mysql-4.1.6-gamma/client/.libs/mysqltest: A
t line 24: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_6bdb.result Wed Oct 13 09:30:52 2004
--- r/ps_6bdb.reject Thu Oct 21 22:22:52 2004
***************
*** 2269,2274 ****
--- 2269,2276 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2275,2280 ****
--- 2277,2284 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2281,2286 ****
--- 2285,2292 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2288,2293 ****
--- 2294,2301 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2398,2407 ****
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
--- 2406,2415 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
...
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Failed 6/269 tests, 97.76% successful.
[31 Oct 2004 21:46]
Boyd GERBER
Also with the release of 4.1.7. More make test problems
[10 Nov 2004 14:00]
Sergei Glukhov
I sent portability fixes for ps_... tests and key_cache.test. See commit: ChangeSet 1.2090 04/11/10 Fix for bug #6077: Problem with make test from 4.1.7 and bk portability fix(UnixWare) Also I found out the problem with func_crypt test. The crash happens when system function crypt() calls(in Item_strfunc.cc, Item_func_encrypt::val_str). To avoid this situation crypt library should be placed before crypto library in sql/Makefile. It can be done by using CXXLDFLAGS environment variables (see example) example: CC=cc CXX=CC CXXLDFLAGS=-lcrypt ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --with-innodb --with-debug --with-extra-charsets=complex --with-openssl --with-vio But another problem still presents. If I compile MySQL with bdb, mysqld crashes on berkeley_init(void). it happens on line: db_env->set_noticecall(db_env, berkeley_noticecall); Seems to me the problem is in bdb but I don't know how to resolve it yet. Additional info: it was tested on uw713.zenez.com host.
[10 Nov 2004 15:56]
Boyd GERBER
I found I needed to use CC="cc" CFLAGS="-I/usr/local/include" CXX="CC" CFLAGS="-I/usr/local/include" CXXLDFLAGS=-lcrypt ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --with-berkeley-db=./bdb --with-innodb --with-openssl --with-extra-charsets=complex --with-vio I guess the patches on the internals list have not made it into to public bk tree yet because I still see the problems. I did manually add the patches and they do fix most things. I still see problem with ps even though the patch set is applied. Thanks
[6 Dec 2004 20:41]
Boyd GERBER
These tests are failing with bk from 12/06/2004 at 12:00 MDT.
From mysql-test-run
...
unc_crypt [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 7: query 'select length(encrypt('foo', 'ff')) <> 0' failed: 2013: Lost conn
ection to MySQL server during query
(the last lines may be the most important ones)
Ending Tests
...
key_cache [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 170: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/key_cache.result Thu Nov 18 00:07:21 2004
--- r/key_cache.reject Mon Dec 6 23:26:37 2004
***************
*** 90,96 ****
Key_blocks_used 0
show status like 'key_blocks_unused';
Variable_name Value
! Key_blocks_unused KEY_BLOCKS_UNUSED
insert into t1 values (1, 'qqqq'), (11, 'yyyy');
insert into t2 values (1, 1, 'qqqq'), (2, 1, 'pppp'),
(3, 1, 'yyyy'), (4, 3, 'zzzz');
--- 90,96 ----
Key_blocks_used 0
show status like 'key_blocks_unused';
Variable_name Value
! Key_blocks_unused 1824
insert into t1 values (1, 'qqqq'), (11, 'yyyy');
insert into t2 values (1, 1, 'qqqq'), (2, 1, 'pppp'),
(3, 1, 'yyyy'), (4, 3, 'zzzz');
***************
*** 111,117 ****
Key_blocks_used 4
show status like 'key_blocks_unused';
Variable_name Value
! Key_blocks_unused KEY_BLOCKS_UNUSED
cache index t1 key (`primary`) in keycache1;
Table Op Msg_type Msg_text
test.t1 assign_to_keycache status OK
--- 111,117 ----
Key_blocks_used 4
show status like 'key_blocks_unused';
Variable_name Value
! Key_blocks_unused 1820
cache index t1 key (`primary`) in keycache1;
Table Op Msg_type Msg_text
test.t1 assign_to_keycache status OK
***************
*** 273,279 ****
Key_blocks_used 4
show status like 'key_blocks_unused';
Variable_name Value
! Key_blocks_unused KEY_BLOCKS_UNUSED
set global keycache2.key_buffer_size=0;
set global keycache3.key_buffer_size=100;
set global keycache3.key_buffer_size=0;
--- 273,279 ----
Key_blocks_used 4
show status like 'key_blocks_unused';
Variable_name Value
! Key_blocks_unused 1824
set global keycache2.key_buffer_size=0;
set global keycache3.key_buffer_size=100;
set global keycache3.key_buffer_size=0;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
...
ps_2myisam [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 43: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_2myisam.result Mon Dec 6 21:46:05 2004
--- r/ps_2myisam.reject Mon Dec 6 23:29:54 2004
***************
*** 2288,2293 ****
--- 2288,2295 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2294,2299 ****
--- 2296,2303 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2300,2305 ****
--- 2304,2311 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2307,2312 ****
--- 2313,2320 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2417,2426 ****
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
--- 2425,2434 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
...
ps_3innodb [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 25: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_3innodb.result Mon Dec 6 21:46:05 2004
--- r/ps_3innodb.reject Mon Dec 6 23:30:02 2004
***************
*** 2271,2276 ****
--- 2271,2278 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2277,2282 ****
--- 2279,2286 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2283,2288 ****
--- 2287,2294 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2290,2295 ****
--- 2296,2303 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2400,2409 ****
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
--- 2408,2417 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
...
ps_4heap [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 50: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_4heap.result Mon Dec 6 21:46:05 2004
--- r/ps_4heap.reject Mon Dec 6 23:30:09 2004
***************
*** 2272,2277 ****
--- 2272,2279 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2278,2283 ****
--- 2280,2287 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2284,2289 ****
--- 2288,2295 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2291,2296 ****
--- 2297,2304 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2401,2410 ****
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
--- 2409,2418 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
...
ps_5merge [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 85: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_5merge.result Mon Dec 6 21:46:05 2004
--- r/ps_5merge.reject Mon Dec 6 23:30:16 2004
***************
*** 2211,2216 ****
--- 2211,2218 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2217,2222 ****
--- 2219,2226 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2223,2228 ****
--- 2227,2234 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2230,2235 ****
--- 2236,2243 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2340,2349 ****
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
--- 2348,2357 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
***************
*** 5221,5226 ****
--- 5229,5236 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 5227,5232 ****
--- 5237,5244 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 5233,5238 ****
--- 5245,5252 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 5240,5245 ****
--- 5254,5261 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 5350,5359 ****
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
--- 5366,5375 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
...
ps_6bdb [ fail ]
Errors are (from /home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/mysql-test
/var/log/mysqltest-time) :
/home/mount/uw714/zenez1/build/uw714/mysql/mysql-4.1/client/.libs/mysqltest: At
line 24: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_6bdb.result Mon Dec 6 21:46:05 2004
--- r/ps_6bdb.reject Mon Dec 6 23:30:23 2004
***************
*** 2271,2276 ****
--- 2271,2278 ----
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0,
30.0, 30.0, 30.0 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 31.0 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2277,2282 ****
--- 2279,2286 ----
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2283,2288 ****
--- 2287,2294 ----
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0,
32.0, 32.0, 32.0 )" ;
execute stmt1 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
***************
*** 2290,2295 ****
--- 2296,2303 ----
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
+ Warnings:
+ Warning 1264 Data truncated; out of range for column 'c6' at row 1
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
***************
*** 2400,2409 ****
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
--- 2408,2417 ----
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 9223372036854775807 30 30
30 30 30.0000
! 31 31 31 31 31 9223372036854775807 31 31
31 31 31.0000
! 32 32 32 32 32 9223372036854775807 32 32
32 32 32.0000
! 33 33 33 33 33 9223372036854775807 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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
...
-------------------------------------------------------
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Failed 7/276 tests, 97.46% successful.
...
mysql-test-run: *** Failing the test(s): func_crypt key_cache ps_2myisam ps_3inn
odb ps_4heap ps_5merge ps_6bdb
[8 Dec 2004 5:43]
Boyd GERBER
A bk of mysql-4.1 at 9:45 MDT now passes all tests. Thanks, This can not be closed.
[8 Dec 2004 5:46]
Boyd GERBER
Now resolved.
Description: Make test failes with... ps_2myisam [ fail ] Errors are (from /home/mysqldev/uw713/test/mysql-debug-4.1.6-gamma-unknown-sysv5UnixWare7.1.3-i686/mysql-test/var/log/mysqltest-time) : /home/mysqldev/uw713/test/mysql-debug-4.1.6-gamma-unknown-sysv5UnixWare7.1.3-i686/bin/mysqltest: At line 42: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/ps_2myisam.result Wed Oct 13 09:30:52 2004 --- r/ps_2myisam.reject Wed Oct 13 10:24:07 2004 *************** *** 2286,2291 **** --- 2286,2293 ---- values ( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0 ) ; + Warnings: + Warning 1264 Data truncated; out of range for column 'c6' at row 1 set @arg00= 31.0 ; insert into t9 ( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 ) *************** *** 2292,2297 **** --- 2294,2301 ---- values ( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ) ; + Warnings: + Warning 1264 Data truncated; out of range for column 'c6' at row 1 prepare stmt1 from "insert into t9 ( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 ) values *************** *** 2298,2303 **** --- 2302,2309 ---- ( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0 )" ; execute stmt1 ; + Warnings: + Warning 1264 Data truncated; out of range for column 'c6' at row 1 set @arg00= 33.0; prepare stmt2 from "insert into t9 ( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 ) *************** *** 2305,2310 **** --- 2311,2318 ---- ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ; execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; + Warnings: + Warning 1264 Data truncated; out of range for column 'c6' at row 1 insert into t9 ( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 ) values *************** *** 2415,2424 **** 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 --- 2423,2432 ---- 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 9223372036854775807 30 30 30 30 30.0000 ! 31 31 31 31 31 9223372036854775807 31 31 31 31 31.0000 ! 32 32 32 32 32 9223372036854775807 32 32 32 32 32.0000 ! 33 33 33 33 33 9223372036854775807 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 ------------------------------------------------------- How to repeat: run make test.