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

CREATE VIEW SELECT ... [NOWAIT|WAIT]

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None

    Description

      support the NOWAIT, WAIT clauses in a view

      NOWAIT works in MySQL-8.0
      https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=5f1ca5d535511ed835148120d61ce015

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

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

          Task - A task that needs to be done. MDEV-11379 AliSQL: [Feature] Issue#8: SELECT FOR UPDATE WAIT

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black created issue -
            danblack Daniel Black made changes -
            Field Original Value New Value
            danblack Daniel Black added a comment -

            same with stored procedures

            danblack Daniel Black added a comment - same with stored procedures
            danblack Daniel Black added a comment -

            svoj was unsafe replication in statement mode the only reason WAIT/NOWAIT weren't allowed on VIEWs/STORED PROCEDURES?

            danblack Daniel Black added a comment - svoj was unsafe replication in statement mode the only reason WAIT/NOWAIT weren't allowed on VIEWs/STORED PROCEDURES?
            svoj Sergey Vojtovich added a comment -

            I vaguely remember there were some low-level issues with WAIT/NOWAIT under view/sp/ps. Probably something connected to thd->mem_root or query arena. Or restriction of SET STATEMENT in general? Anyway, SBR wasn't an issue, at least not a direct one.

            svoj Sergey Vojtovich added a comment - I vaguely remember there were some low-level issues with WAIT/NOWAIT under view/sp/ps. Probably something connected to thd->mem_root or query arena. Or restriction of SET STATEMENT in general? Anyway, SBR wasn't an issue, at least not a direct one.
            danblack Daniel Black added a comment -

            Thanks for the tips.

            danblack Daniel Black added a comment - Thanks for the tips.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 120467 ] MariaDB v4 [ 131467 ]
            greenman Ian Gilfillan made changes -
            Labels compat80
            monty Michael Widenius made changes -

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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