MySQL 4.1.0 dies on Subselect in Select-Expression

Hello,

I'm running mysql 4.1.0-alpha-max-nt on Windows 2000, SP3.

The SQL-Script

DROP DATABASE IF EXISTS test;
CREATE DATABASE test;
CREATE TABLE test.nodes (
id BIGINT NOT NULL,
INDEX (id),
PRIMARY KEY (id)) TYPE=MYISAM;

INSERT INTO test.nodes VALUES (1),(2);

SELECT * FROM test.nodes;

CREATE TABLE test.strings (
node BIGINT NOT NULL,
meta INTEGER NOT NULL,
count INTEGER NOT NULL,
revision INTEGER NOT NULL,
deleted DATETIME DEFAULT NULL,
val VARCHAR(255) NOT NULL,
INDEX (node),
UNIQUE (node,revision,count,meta)) TYPE=MYISAM;

INSERT INTO test.strings VALUES
(1,2,0,1,NULL,'String 1'),
(2,1,0,1,NULL,'String 2');

SELECT * FROM test.strings;

SELECT n.id,(SELECT val FROM test.strings WHERE node=n.id AND meta=2 AND count=0 AND deleted IS NULL) AS val FROM test.nodes n WHERE
id=2;

produces the following Output:

id
1
2
node meta count revision deleted val
1 2 0 1 NULL String 1
2 1 0 1 NULL String 2
ERROR 2013 at line 28: Lost connection to MySQL server during query

The Server has to restarted after running the above script.
Any attempt to simplify the script made the bug disapear.

Kind Regards
Jan Langhans




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1.0 dies on Subselect in Select-Expression

Jan Langhans writes:
> Hello,
>
> I'm running mysql 4.1.0-alpha-max-nt on Windows 2000, SP3.
>
> The SQL-Script
>

[skip]

> produces the following Output:
>
> id
> 1
> 2
> node meta count revision deleted val
> 1 2 0 1 NULL String 1
> 2 1 0 1 NULL String 2
> ERROR 2013 at line 28: Lost connection to MySQL server during query
>
> The Server has to restarted after running the above script.
> Any attempt to simplify the script made the bug disapear.
>
> Kind Regards
> Jan Langhans
>

I get the following results from 4.1.1:
id
1
2
node meta count revision deleted val
1 2 0 1 NULL String 1
2 1 0 1 NULL String 2
id val
2 NULL


and no errors.

4.1.1 should be out before the end of this year.


--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org