[MDEV-12168] AUTO_INCREMENT with CYCLE support Created: 2017-03-03 Updated: 2017-03-03 Resolved: 2017-03-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Tadas BalaiĊĦis | Assignee: | Sergei Golubchik |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Need AUTO_INCREMENT with CYCLE support. There are tables that have high input rate and the rows are identified by AUTO_INCREMENT. Another process remove old rows. So it would by fine to CYCLE (get the lowest value) after max value reached. This could by done in Oracle with CYCLE SEQUENCE. Are you planning such feature support? Can you propose alternative workaround for automatic cycling in ID column? |
| Comments |
| Comment by Sergei Golubchik [ 2017-03-03 ] |
|
See |