| Bug #34142 | Failed make test On view | ||
|---|---|---|---|
| Submitted: | 29 Jan 2008 18:27 | Modified: | 30 Jan 2008 3:35 |
| Reporter: | imacat . (Basic Quality Contributor) | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S7 (Test Cases) |
| Version: | 5.0.51a | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[29 Jan 2008 20:14]
Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Duplicate of bug #25359
[30 Jan 2008 3:33]
imacat .
Hi. This is imacat from Taiwan. Thank you for your reply.
But I do not understand. Bug #25359 is tagged as "closed". But my bug report said that that "closed" bug is still there. Shouldn't this a new report? Or do you wish me to discuss this issue on the discussion of bug #25359?
Also if this bug#34142 is really a duplicated, bug #25359 was filed in the beginning of 2007. Will this happen again in the beginnings of 2008, 2009, 2010? Will there be any real fix for this?
[30 Jan 2008 3:35]
imacat .
Sorry, I see now. I shall move to bug #25359 from now on.
Description: Dear all, Hi. This is imacat from Taiwan. I downloaded and compiled the newly-released MySQL 5.0.51a, but failed make test at the test "view". My build environments are: Debain GNU/Linux 4.0 Etch r2, Linux kernel 2.6.22.10, gcc 4.1.2, glibc 2.3.6, i386 and x86_64. The terminal log is attached below. Hope that this helps. Please tell me if you need any more information. Thank you. imacat@rinse src/mysql-5.0.51a % make test Logging: ./mysql-test-run.pl MySQL Version 5.0.51 Skipping ndbcluster, mysqld not compiled with ndbcluster Skipping SSL, mysqld not compiled with SSL Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Using IM_PORT = 9312 Using IM_MYSQLD1_PORT = 9313 Using IM_MYSQLD2_PORT = 9314 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database Installing Slave1 Database ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- alias [ pass ] 117 alter_table-big [ skipped ] Test need 'big-test' option ... variables-big [ skipped ] Test need 'big-test' option variables [ pass ] 129 view [ fail ] --- /usr/local/src/mysql-5.0.51a/mysql-test/r/view.result 2008-01-11 18:23:42.000000000 +0300 +++ /usr/local/src/mysql-5.0.51a/mysql-test/var/log/view.reject 2008-01-29 20:27:49.000000000 +0300 @@ -2719,12 +2719,12 @@ v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75) SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75; Age -43 -39 +44 +40 SELECT * FROM v1; Age -43 -39 +44 +40 DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx'); mysqltest: Result content mismatch Aborting: view failed in default mode. To continue, re-run with '--force'. Stopping All Servers make: *** [test-ns] Error 1 You have new mail. imacat@rinse src/mysql-5.0.51a % How to repeat: On Debian GNU/Linux 4.0 Etch r2, % ./configure % make % make test