[MDEV-25247] CREATE VIEW SELECT ... [NOWAIT|WAIT] Created: 2021-03-25 Updated: 2022-06-20 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | compat80 | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
support the NOWAIT, WAIT clauses in a view NOWAIT works in MySQL-8.0 |
| Comments |
| Comment by Daniel Black [ 2021-03-25 ] |
|
same with stored procedures |
| Comment by Daniel Black [ 2021-03-25 ] |
|
svoj was unsafe replication in statement mode the only reason WAIT/NOWAIT weren't allowed on VIEWs/STORED PROCEDURES? |
| Comment by Sergey Vojtovich [ 2021-03-26 ] |
|
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. |
| Comment by Daniel Black [ 2021-03-26 ] |
|
Thanks for the tips. |