| 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: | |
| Category: | MySQL Server | Severity: | S2 (Serious) | 
| Version: | 5.0 | OS: | |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any | 
   [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>
 

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