| Bug #50421 | Two related CREATE VIEW in one connection lead to 1142 error | ||
|---|---|---|---|
| Submitted: | 18 Jan 2010 16:18 | Modified: | 18 Feb 2010 20:06 |
| Reporter: | FaZend Team | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S1 (Critical) |
| Version: | 5.1.37 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | 1142, VIEW | ||
[18 Jan 2010 20:06]
Sveta Smirnova
Thank you for the report. Please provide complete PHP script demonstrating error. Please also provide output of SHOW GRANTS for user which you use in PHP.
[19 Feb 2010 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: This is what I have in PHP: $db->query('CREATE TABLE user (id INT, name VARCHAR(50))'); $db->query('CREATE VIEW v1 AS SELECT * FROM user'); $db->query('CREATE VIEW v2 AS SELECT * FROM v1'); The third QUERY leads to: Syntax error or access violation: 1142 ANY command denied to user 'test'@'localhost' for table '/var/tmp/#sql85_4b6b_0' When I'm doing the same queries one by one in a standalone MySQL client - everything works fine. How to repeat: See queries above