Bug #8022 mysql crashes on nested row
Submitted: 19 Jan 2005 21:31 Modified: 4 Feb 2005 20:57
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.9/BK Source 4.1.10 OS:FreeBSD (freebsd)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[19 Jan 2005 21:31] Martin Friebe 
Description:
for some reason mysql allows rows to be nested.

the below statements are crashing are mysql 4.1.9 server build from freebsd ports (probably any other too)

How to repeat:
CREATE TABLE t1 ( b1 int(11),  b2 int(11) ) ;

select  row(1,(2,2)) = any (select * from t1 );

select  row(1,(2,2)) = any (select * from t1 ) ;

Suggested fix:
fix, or disable nested rows
[19 Jan 2005 22:00] MySQL Verification Team 
Thank you for the bug report I was able to repeat on Slackware BK source.
[24 Jan 2005 13:59] Oleksandr Byelkin 
ChangeSet
  1.2165 05/01/24 15:56:57 bell@sanja.is.com.ua +3 -0
  check that row elements have the same dimention that SELECT list elements in comporison between rows and subqueries added (BUG#8022)
[1 Feb 2005 12:04] Oleksandr Byelkin 
Thank you for bugreport. Bugfix is pushed into 4.1.10 (5.0.3) source repository
[4 Feb 2005 20:57] Paul DuBois 
Mentioned in 4.1.10 and 5.0.3 change notes.