MySQL Bugs: #10041: 'view' test fails in --ps-protocol test suite on multiple build hosts

Bug #10041	'view' test fails in --ps-protocol test suite on multiple build hosts
Submitted:	20 Apr 2005 19:55	Modified:	18 May 2005 4:15
Reporter:	Matt Wagner
Status:	Closed
Category:	Server	Severity:	S2 (Serious)
Version:	5.0.5 test build	OS:	Many
Assigned to:	Bugs System	Target Version:

Description:
The 'view' test is failing on multiple build hosts when running the test suite in
--ps-protocol mode. Here is the rejection diff:

10562: Below are the diffs between actual and expected results:
10563: -------------------------------------------------------
10564: *** r/view.result        Wed Apr 20 01:07:49 2005
10565: --- r/view.reject        Wed Apr 20 02:59:31 2005
10566: ***************
10567: *** 1667,1680 ****
10568:   WHERE b.col2 IS NULL OR
10569:   b.col2=(SELECT MAX(col2) FROM v2 b WHERE b.col1=a.col1);
10570:   col1   col2    col2    col3
10571: - 1      trudy   2       y
10572: - 2      peter   1       n
10573: - 3      sanja   1       n
10574:   4      monty   3       n
10575:   5      david   NULL    NULL
10576: - 6      kent    1       n
10577:   7      carsten NULL    NULL
10578: - 8      ranger  1       y
10579:   10     matt    NULL    NULL
10580:   SELECT a.col1,a.col2,b.col2,b.col3
10581:   FROM v2 b RIGHT JOIN v1 a ON a.col1=b.col1
10582: --- 1667,1675 ----
10583: ***************
10584: *** 1682,1688 ****
10585:   (b.col2 IS NULL OR
10586:   b.col2=(SELECT MAX(col2) FROM v2 b WHERE b.col1=a.col1));
10587:   col1   col2    col2    col3
10588: - 1      trudy   2       y
10589:   5      david   NULL    NULL
10590:   CREATE VIEW v3 AS SELECT * FROM t1 WHERE col1 IN (1,5,9);
10591:   SELECT a.col1,a.col2,b.col2,b.col3
10592: --- 1677,1682 ----
10593: ***************
10594: *** 1690,1696 ****
10595:   WHERE b.col2 IS NULL OR
10596:   b.col2=(SELECT MAX(col2) FROM v2 b WHERE b.col1=a.col1);
10597:   col1   col2    col2    col3
10598: - 1      trudy   2       y
10599:   5      david   NULL    NULL
10600:   DROP VIEW v1,v2,v3;
10601:   DROP TABLE t1,t2;
10602: --- 1684,1689 ----
10603: -------------------------------------------------------

How to repeat:
Run the test suite in --ps-protocol mode on affect build hosts.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24468

ChangeSet
  1.1849 05/04/29 02:43:56 bell@sanja.is.com.ua +4 -0
  if outer refernce (identifier) was resolved with help of cache all subqueries and
resolved item itseld have to be correctly marked as dependent
  (BUG#10041)

Noted in 5.0.6 changelog.