[MDEV-26667] Persistent Temporary tables Created: 2021-09-23 Updated: 2021-12-20 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Tadas Balaišis | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Would be great to CREATE TEMPORARY TABLE not just session-long living, but persistent, like Oracle temporary tables. That could be used in views queries. For now I have to create regular table with connection_id() default value in column and then create editable view to mimic Oracle temporary table behavior. But this gives a headache to manage old connections data. I cannot create FK to information_schema.processlist table, so I have to build background task to delete regular table rows of non-existent connection ids. |
| Comments |
| Comment by Tadas Balaišis [ 2021-09-23 ] |
|
Sorry, of cause it's not a Bug. It's a Feature request. |
| Comment by Sergei Golubchik [ 2021-12-20 ] |
|
Changed to a Task |
| Comment by Sergei Golubchik [ 2021-12-20 ] |
|
Note that the SQL Standard has does not seem to have CREATE TEMPORARY TABLE, it has CREATE { GLOBAL | LOCAL } TEMPORARY TABLE and the current MariaDB behavior is neither global nor local. |