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:33]
Boyd GERBER
[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.