summaryrefslogtreecommitdiff
path: root/mysql-test/suite/bugs/combinations
diff options
context:
space:
mode:
authorYuchen Pei <yuchen.pei@mariadb.com>2023-02-08 12:29:52 +1100
committerYuchen Pei <yuchen.pei@mariadb.com>2023-03-21 18:25:46 +1100
commit30425c431c5ac09ecc1c38d331b1253995dd12b3 (patch)
treebf3aa8ccdc3c472eb8d177cb7504d04c6d04bac3 /mysql-test/suite/bugs/combinations
parentce4a289f1c367987977f1a02bbb8d8b8e8e6bb53 (diff)
downloadmariadb-git-bb-11.0-mdev-28152.tar.gz
MDEV-28152 Features for sequencesbb-11.0-mdev-28152
- Add `as <int_type>` to sequence creation options - int_type can be signed or unsigned integer types, including tinyint, smallint, mediumint, int and bigint - Limitation: when alter sequence as <new_int_type>, cannot have any other alter options in the same statement - Limitation: increment remains signed longlong, and the hidden constraint (cache_size x abs(increment) < longlong_max) stays for unsigned types. This means for bigint unsigned, neither abs(increment) nor (cache_size x abs(increment)) can be between longlong_max and ulonglong_max - Truncating maxvalue and minvalue from user input to the nearest max or min value of the type, plus or minus 1. When the truncation happens, a warning is emitted - Information schema table for sequences
Diffstat (limited to 'mysql-test/suite/bugs/combinations')
0 files changed, 0 insertions, 0 deletions