| Bug #7915 | crash,JOIN VIEW, subquery, SELECT .. FROM INFORMATION_SCHEMA.COLUMNS | ||
|---|---|---|---|
| Submitted: | 14 Jan 2005 18:11 | Modified: | 16 Feb 2005 8:56 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0 | OS: | |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[14 Jan 2005 18:13]
Matthias Leich
test case
Attachment: nistx.test (application/test, text), 2.05 KiB.
[20 Jan 2005 13:56]
Aleksey Kishkin
verified on linux slackware 10 mysql Ver 5.0.3-alpha for pc-linux on i686 (Source distribution) TEST RESULT ------------------------------------------------------- nistx [ fail ] Errors are (from /opt/sand/50/mysql-test/var/log/mysqltest-time) : /opt/sand/50/client/mysqltest: At line 42: query 'set @got_val= (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS)' failed: 2013: Lost connection to MySQL server during query /opt/sand/50/client/mysqltest: At line 45: unable to send query 'SELECT 'HELLO' FROM ( SELECT 1 as my_col) AS MY_TAB WHERE 0 < (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS)' (mysql_errno=2002 , errno=111) (the last lines may be the most important ones) Aborting: nistx failed in default mode. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon master not cooperating with mysqladmin, will try manual kill ./mysql-test-run: line 1293: kill: (9516) - No such process master refused to die. Sending SIGKILL ./mysql-test-run: line 1297: kill: (9516) - No such process Master shutdown finished Slave shutdown finished
[16 Feb 2005 8:56]
Sergei Glukhov
Fixed in 5.0.3 tree
Description: I get under the following conditions a crash. - There exists a JOIN VIEW. - A statement containing a subquery on INFORMATION_SCHEMA.COLUMNS is executed. The test case is dervied from NIST test dml130 This bug has nothing to do with bug#7476. I get the crash with and without an unofficial bug fix for bug#7476. My environment: - Intel PC with Linux(SuSE 9.1) - MySQL compiled from source Version 5.0 ChangeSet@1.1783, 2005-01-14 How to repeat: Please use my test file nistx.test , copy it to mysql-test/t ./mysql-test-run nistx