Details
-
Type:
Task
-
Status: Stalled
-
Priority:
Major
-
Resolution: Unresolved
-
Fix Version/s: 10.2
-
Component/s: None
-
Labels:None
Description
mysql> CREATE VIEW v3 AS SELECT * FROM (SELECT s1 FROM t1) AS x;
ERROR 1349 (HY000): View's SELECT contains a subquery in the FROM clause
See http://bugs.mysql.com/bug.php?id=16757
and http://bugs.mysql.com/bug.php?id=12755
specifically Eric Bergen's comments about the complexity of removing this restriction. It should be doable without too much hassle, and as we can see from the comments, it would resolve a lot of issues for people.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
In MariaDB there is no so much work should be done, but still derived tables of view should be processed correctly to build its field translation table and privilages should be read also.
Hello,
is there any hope for a fix in 10.0.5? (or at least 10.0.6?)
thx
Hello,
is there anything new about this problematic behaviour ?
It is more feature request, so bugs goes first, sorry.
awesome, very happy to see this scheduled for fixing in 10.0.3