Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3944 Allow derived tables in VIEWS
  3. MDEV-9664

Test MDEV-3944 (Allow derived tables in views)

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • N/A
    • Tests
    • None
    • 10.2.0-6, 10.2.0-7, 10.2.0-8

    Attachments

      Issue Links

        blocks

        Task - A task that needs to be done. MDEV-3944 Allow derived tables in VIEWS

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

        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

        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
          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

          —

          revision-id: f072d1672a067da09e7a5dc18d2c227992f0d672 (mariadb-10.1.8-125-gf072d16)
          parent(s): a6c0c01cec43731df3c58b4fdb68d3ac18e6c699
          committer: Oleksandr Byelkin
          timestamp: 2016-03-03 17:42:15 +0100
          message:

          MDEV-9671 Wrong result upon select from a view with a FROM subquery

          do not take marker OIN_TYPE_OUTER as a LEFT JOIN on print

          —

          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 — revision-id: f072d1672a067da09e7a5dc18d2c227992f0d672 (mariadb-10.1.8-125-gf072d16) parent(s): a6c0c01cec43731df3c58b4fdb68d3ac18e6c699 committer: Oleksandr Byelkin timestamp: 2016-03-03 17:42:15 +0100 message: MDEV-9671 Wrong result upon select from a view with a FROM subquery do not take marker OIN_TYPE_OUTER as a LEFT JOIN on print —
          elenst Elena Stepanova added a comment -

          Ran several sets of optimizer tests with ExecuteAsView enabled on f072d1672a067da09e7a5dc18d2c227992f0d672 .
          There are a few known bugs which affect the tests (crashes and wrong results), but nothing that would be related to this change so far.
          Valgrind tests are queued.

          elenst Elena Stepanova added a comment - Ran several sets of optimizer tests with ExecuteAsView enabled on f072d1672a067da09e7a5dc18d2c227992f0d672 . There are a few known bugs which affect the tests (crashes and wrong results), but nothing that would be related to this change so far. Valgrind tests are queued.
          elenst Elena Stepanova added a comment -

          The development task is still in review, tests might need to be repeated if there are any significant changes after the review.

          elenst Elena Stepanova added a comment - The development task is still in review, tests might need to be repeated if there are any significant changes after the review.

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.