Bug #38960 subselect_sj test case fails
Submitted: 22 Aug 2008 11:31 Modified: 24 Nov 2008 3:57
Reporter: Daniel Fischer Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:6.0 OS:Solaris
Assigned to: CPU Architecture:Any

[22 Aug 2008 11:31] Daniel Fischer
Description:
The subselect_sj test case fails. This binary was built with gcc 3.4.5 on Solaris 10 x86_64.

main.subselect_sj [ fail ]

--- /export/home/pb2/test/sourcebuilder-build-4940-1219357808.52/mysql-6.0.7-alpha-solaris10-i386-test/mysql-test/r/subselect_sj.result	Fri Aug 22 00:04:16 2008
+++ /export/home/pb2/test/sourcebuilder-build-4940-1219357808.52/mysql-6.0.7-alpha-solaris10-i386-test/mysql-test/r/subselect_sj.reject	Fri Aug 22 02:12:57 2008
@@ -130,25 +130,25 @@
 1	PRIMARY	s28	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s29	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s30	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s31	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s49	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s32	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s33	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s34	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s31	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s35	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s36	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s34	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s37	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s38	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s39	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s40	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s38	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s41	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s42	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s40	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s43	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s44	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s42	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s45	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s46	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s47	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 1	PRIMARY	s48	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
-1	PRIMARY	s49	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
+1	PRIMARY	s44	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 2	DEPENDENT SUBQUERY	m00	ALL	NULL	NULL	NULL	NULL	3	Using where
 2	DEPENDENT SUBQUERY	m01	ALL	NULL	NULL	NULL	NULL	3	Using join buffer
 2	DEPENDENT SUBQUERY	m02	ALL	NULL	NULL	NULL	NULL	3	Using join buffer

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

How to repeat:
Build MySQL 6.0 with gcc on Solaris 10 x86_64 and run the subselect_sj test case.
[22 Aug 2008 17:53] Valeriy Kravchuk
Not repeatable on 32-bit Linux.
[24 Oct 2008 3:57] Valeriy Kravchuk
Is this still repeatable with 6.0.7?
[25 Nov 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".