Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3944

Allow derived tables in VIEWS

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.2.1
    • Component/s: Views
    • Labels:
      None
    • 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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              arjen Arjen Lentz
              Votes:
              8 Vote for this issue
              Watchers:
              14 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: