Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
Description
This script:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a INT DEFAULT 10); |
DROP VIEW IF EXISTS v1,v2; |
CREATE VIEW v1 AS SELECT a AS a FROM t1; |
CREATE VIEW v2 AS SELECT DEFAULT(a) AS a FROM t1; |
normally creates VIEW v1, but returns an error for VIEW v2:
ERROR 1143 (42000): create view command denied to user 'root'@'localhost' for column 'a' in table 'v2'
|
The same error happes with VALUES(a) instead of DEFAULT(a):
CREATE VIEW v2 AS SELECT VALUES(a) AS a FROM t1; |
The last query is rather useless though.