| Bug #10261 | INFORMATION_SCHEMA.COLUMNS, incomplete result for non root user | ||
|---|---|---|---|
| Submitted: | 29 Apr 2005 12:40 | Modified: | 8 May 2005 23: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 |
[29 Apr 2005 12:41]
Matthias Leich
test case with comments
Attachment: ml62.test (application/test, text), 1.20 KiB.
[7 May 2005 10:17]
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/internals/24659
[7 May 2005 10:30]
Sergei Glukhov
Fixed in 5.0.6 tree
[8 May 2005 23:56]
Paul DuBois
Noted in 5.0.6 changelog.
Description: A non root user is not able to get informations about the columns of the INFORMATION_SCHEMA tables via SELECT .... FROM INFORMATION_SCHEMA.COLUMNS The result set does not contain any record for the tables INFORMATION_SCHEMA.COLUMNS, INFORMATION_SCHEMA.TABLES ... though he is for example able to get informations about the columns of INFORMATION_SCHEMA.TABLES via SELECT ... FROM INFORMATION_SCHEMA.TABLES or DESCRIBE INFORMATION_SCHEMA.TABLES; My environment: - Intel PC with Linux(SuSE 9.1) - MySQL compiled from source Version 5.0 ChangeSet@1.1914, 2005-04-29 I have the strong feeling, that this bug was introduced by changes made around 5. April. That's the day where several NIST INFORMATION_SCHEMA tests started to show many changed and sometimes clear wrong results. How to repeat: Please use the attached test case ml62.test with same additional statements/observations. copy it to mysql-test/t touch r/ml62.result # Produce a dummy file with # expected results ./mysql-test-run ml62 inspect r/ml62.reject # The protocol of the execution.