Bug #15533 crash, information_schema, function, view
Submitted: 6 Dec 2005 17:54 Modified: 4 Jan 2006 21:26
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:
Assigned to: Sergei Glukhov CPU Architecture:Any

[6 Dec 2005 17:54] Matthias Leich
Description:
I have  a nice testcase where a SELECT with function 
(using a table of the information_schema) crashes the server.

Please have a look into the attached files.

My environment:
   - Intel PC with Linux(SuSE 9.3)
   - MySQL compiled from source
        Version ChangeSet@1.1975.3.1, 2005-12-06

How to repeat:
Please use my attached testscript ml001.test
  copy it to mysql-test/t
  echo "Dummy" > r/ml001.result   # Produce a dummy file with 
                                                   # expected results
  ./mysql-test-run ml001
[6 Dec 2005 17:55] Matthias Leich
testcase

Attachment: ml001.test (application/test, text), 1.21 KiB.

[6 Dec 2005 17:56] Matthias Leich
trace file

Attachment: ml001.trace (application/octet-stream, text), 5.93 KiB.

[26 Dec 2005 12: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/416
[26 Dec 2005 12:52] Alexander Barkov
Looks ok to push.
[3 Jan 2006 10:22] Sergei Glukhov
Fixed in 5.0.19
[3 Jan 2006 10:24] 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/534
[4 Jan 2006 21:26] Mike Hillyer
Added note to 5.0.19 changelog:

   <listitem>
        <para>
          A <literal>SELECT</literal> of a stored function that
          references the <literal>INFORMATION_SCHEMA</literal> could
          crash the server. (Bug #15533)
        </para>
      </listitem>