[MDEV-3944] Allow derived tables in VIEWS Created: 2012-12-17  Updated: 2017-03-29  Resolved: 2016-05-28

Status: Closed
Project: MariaDB Server
Component/s: Views
Fix Version/s: 10.2.1

Type: Task Priority: Major
Reporter: Arjen Lentz Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 8
Labels: None

Issue Links:
Blocks
is blocked by MDEV-9664 Test MDEV-3944 (Allow derived tables ... Closed
is blocked by MDEV-9669 Syntax error upon select from a view ... Closed
is blocked by MDEV-9671 Wrong result upon select from a view ... Closed
Duplicate
duplicates MDEV-12153 Subquery in FROM clause of views Closed
is duplicated by MDEV-9607 Remove restrictions on subqueries in ... Closed
Relates
relates to MDEV-9666 Allow derived tables update/insert Open
relates to MDEV-12379 Server crashes in TABLE_LIST::is_with... Closed
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
MDEV-9664 Test MDEV-3944 (Allow derived tables ... Technical task Closed Elena Stepanova  
Sprint: 10.2.0-6, 10.2.0-7, 10.2.0-8

 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.

 Comments   
Comment by Arjen Lentz [ 2013-04-29 ]

awesome, very happy to see this scheduled for fixing in 10.0.3

Comment by Oleksandr Byelkin [ 2013-05-07 ]

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.

Comment by Emmanuel Galland [ 2013-10-14 ]

Hello,
is there any hope for a fix in 10.0.5? (or at least 10.0.6?)
thx

Comment by Emmanuel Galland [ 2015-05-02 ]

Hello,
is there anything new about this problematic behaviour ?

Comment by Oleksandr Byelkin [ 2015-05-02 ]

It is more feature request, so bugs goes first, sorry.

Comment by Sergei Golubchik [ 2015-11-06 ]

5.7 has it now

Comment by Oleksandr Byelkin [ 2016-02-29 ]

revision-id: a6c0c01cec43731df3c58b4fdb68d3ac18e6c699 (mariadb-10.1.8-124-ga6c0c01)
parent(s): 0485328d030f4b742dac7b667e8ed099beb9e9f2
committer: Oleksandr Byelkin
timestamp: 2016-02-29 18:56:45 +0100
message:

MDEV-3944: Allow derived tables in VIEWS

—

Comment by Elena Stepanova [ 2016-02-29 ]

Tree: 10.2-MDEV-3944

Comment by Sergei Petrunia [ 2016-05-25 ]

Ok to push.

Generated at Thu Feb 08 06:52:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.