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

Allow derived tables in VIEWS

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2.1
    • Views
    • None
    • 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

          duplicates

          Task - A task that needs to be done. MDEV-12153 Subquery in FROM clause of views

          • Major - Major loss of function.
          • Closed
          is blocked by

          Technical task - A technical task. MDEV-9664 Test MDEV-3944 (Allow derived tables in views)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9669 Syntax error upon select from a view with a FROM subquery

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9671 Wrong result upon select from a view with a FROM subquery

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9607 Remove restrictions on subqueries in VIEWs FROM clause

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-9666 Allow derived tables update/insert

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12379 Server crashes in TABLE_LIST::is_with_table on SHOW CREATE VIEW

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 4 older comments
            sanja Oleksandr Byelkin added a comment -

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

            sanja Oleksandr Byelkin added a comment - It is more feature request, so bugs goes first, sorry.
            serg Sergei Golubchik added a comment -

            5.7 has it now

            serg Sergei Golubchik added a comment - 5.7 has it now
            sanja Oleksandr Byelkin added a comment -

            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

            —

            sanja Oleksandr Byelkin added a comment - 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 —
            elenst Elena Stepanova added a comment -

            Tree: 10.2-MDEV-3944

            elenst Elena Stepanova added a comment - Tree: 10.2- MDEV-3944
            psergei Sergei Petrunia added a comment -

            Ok to push.

            psergei Sergei Petrunia added a comment - Ok to push.

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.