Bug #5066 embedded server,select after failed subquery provides wrong result
Submitted: 16 Aug 2004 21:06 Modified: 24 Aug 2004 12:14
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S2 (Serious)
Version:4.1 OS:
Assigned to: Alexey Botchkov CPU Architecture:Any

[16 Aug 2004 21:06] Matthias Leich
Description:
I have a table t1 containing two records.
If I sent a  "select 1 < (select a from t1)" to the server I get the
correct error message "1242: Subquery returns more than 1 row".

But the next select delivers now a wrong result set with
one additional record (all columns NULL ).

Please have a look into my tests case I wrote several simple
variations of  the bug. They show a little bit different but wrong effects.

My environment:
   - Intel PC with Linux(SuSE 9.0)
   - MySQL 4.1 source distrib. 
     (last ChangeSet@1.1944.1.7, 2004-08-13 17:14:36-07:00)

How to repeat:
Please use my test file, copy it to mysql-test/t
  ./mysql-test-run ml_err25
[16 Aug 2004 21:11] Matthias Leich
test case

Attachment: ml_err25.test (application/octet-stream, text), 868 bytes.

[16 Aug 2004 21:15] Matthias Leich
the expected results(generated with the NON embedded server)

Attachment: ml_err25.result (application/octet-stream, text), 793 bytes.

[23 Aug 2004 10:05] Alexey Botchkov
bk commit - 4.1 tree (hf:1.1963) BUG#5066
[24 Aug 2004 12:14] Alexey Botchkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html