Bug #15706 Test case 'subselect' fails in --ps-protocol mode
Submitted: 13 Dec 2005 8:08 Modified: 28 Feb 2006 0:55
Reporter: Kristian Nielsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S3 (Non-critical)
Version:bk mysql-5.0 tree OS:Linux (Linux/x86)
Assigned to: Evgeny Potemkin CPU Architecture:Any

[13 Dec 2005 8:08] Kristian Nielsen
Description:
Test case failure:

> ./mysql-test-run --ps-protocol --tmpdir=/tmp/knielsen subselect

TEST                            RESULT
-------------------------------------------------------
subselect                      [ fail ]

Errors are (from /users/knielsen/pb/mysql-5.0/push-knielsen@mysql.com-20051213025133.info/mysql-5.0.18-standard/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 1989: query 'SELECT a FROM t1 GROUP BY a
HAVING a IN (SELECT c FROM t2 WHERE MAX(b)>20)' failed: 1111: Invalid use of group function

Error is repeatable, but only occurs in --ps-protocol mode.

How to repeat:
Run test case as above
[15 Dec 2005 16:26] Bugs System
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/commits/184
[21 Dec 2005 17:27] Bugs System
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/commits/331
[10 Feb 2006 14:47] Bugs System
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/commits/2448
[15 Feb 2006 16:44] Bugs System
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/commits/2663
[17 Feb 2006 14:30] Evgeny Potemkin
If item->cached_table is set, find_field_in_tables() returns found field
even if it doesn't belong to current select. Because Item_field::fix_fields
doesn't expect such behaviour, reported bug occurs.

Fixed in 5.0.19, cset 1.1974.9.1
[28 Feb 2006 0:55] Paul Dubois
Unreleased version only. No changelog entry needed.