mariadb/mysql-test/suite/sql_sequence
Thirunarayanan Balathandayuthapani 6a2afb42ba MDEV-36487 Fix ha_innobase::check() for sequences
InnoDB does the following check for sequence table during check
table command:
- There should be only one index should exist on sequence table
- There should be only one row should exist on sequence table
- The leaf page must be the root page for the sequence table
- Delete marked record should not exist
- DB_TRX_ID and DB_ROLL_PTR of the record should be 0 and 1U << 55
2025-06-09 13:52:44 +05:30
..
alter.opt MDEV-36038 ALTER TABLE…SEQUENCE does not work correctly with InnoDB 2025-02-18 16:38:18 +01:00
alter.result MDEV-36032 Check whether a table can be a sequence when ALTERed with SEQUENCE=1 2025-06-06 18:42:16 +05:30
alter.test MDEV-36032 Check whether a table can be a sequence when ALTERed with SEQUENCE=1 2025-06-06 18:42:16 +05:30
alter_notembedded.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
alter_notembedded.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
aria.result MDEV-22491 Support mariadb-check and CHECK TABLE with SEQUENCE 2025-05-05 11:36:55 +10:00
aria.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
auto_increment.result MDEV-33836 Compute modulus correctly in sequence 2024-08-19 11:16:32 +10:00
auto_increment.test MDEV-33836 Compute modulus correctly in sequence 2024-08-19 11:16:32 +10:00
binlog.result MDEV-22491 Support mariadb-check and CHECK TABLE with SEQUENCE 2025-05-05 11:36:55 +10:00
binlog.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
check.result MDEV-36487 Fix ha_innobase::check() for sequences 2025-06-09 13:52:44 +05:30
check.test MDEV-36487 Fix ha_innobase::check() for sequences 2025-06-09 13:52:44 +05:30
concurrent_create.result MDEV-33836 Fix version markers in tests relating to MDEV-28152 2024-08-19 11:16:31 +10:00
concurrent_create.test MDEV-33836 Fix version markers in tests relating to MDEV-28152 2024-08-19 11:16:31 +10:00
create.result MariaDB 11.4.4 release 2024-11-08 07:17:00 +01:00
create.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
debug_sync.opt sql_sequence.debug_sync fails upon server startup 2018-05-09 02:05:25 +03:00
debug_sync.result Added test case for MDEV-13029 2018-05-08 13:29:41 +03:00
debug_sync.test Added test case for MDEV-13029 2018-05-08 13:29:41 +03:00
default.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
default.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
disabled.def Make SEQUENCE working with replication 2017-05-23 21:12:27 +03:00
grant.result MDEV-36380 User has unauthorized access to a sequence through a view with security invoker 2025-04-17 17:18:55 +02:00
grant.test MDEV-36380 User has unauthorized access to a sequence through a view with security invoker 2025-04-17 17:18:55 +02:00
gtid-master.opt MDEV-10139 Support for SEQUENCE objects 2017-04-07 18:09:56 +04:00
gtid-slave.opt MDEV-36425 Extend read_only to also block share locks and super user 2025-04-28 12:59:39 +03:00
gtid.result Merge branch '11.8' into 12.0 2025-05-22 09:22:55 +02:00
gtid.test Merge branch '10.9' into 10.10 2023-08-05 20:34:09 +02:00
kill.result MDEV-16929 Assertion ... in close_thread_tables upon killing connection 2020-07-21 15:12:53 +03:00
kill.test MDEV-16929 Assertion ... in close_thread_tables upon killing connection 2020-07-21 15:12:53 +03:00
lock.result MDEV-15970 Crash when doing truncate on locked sequence 2018-05-14 10:08:05 +03:00
lock.test MDEV-15970 Crash when doing truncate on locked sequence 2018-05-14 10:08:05 +03:00
mysqldump.result Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
mysqldump.test MDEV-32250 Enable --no-autocommit by default in mysqldump 2024-12-03 20:25:04 +05:30
next.result MariaDB 11.4.4 release 2024-11-08 07:17:00 +01:00
next.test MDEV-33836 Fix version markers in tests relating to MDEV-28152 2024-08-19 11:16:31 +10:00
other.result Merge branch '11.8' into 12.0 2025-05-22 09:22:55 +02:00
other.test Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
partition.result MDEV-13715 Server crashes in ha_partition::engine_name 2017-10-22 20:20:32 +03:00
partition.test MDEV-13715 Server crashes in ha_partition::engine_name 2017-10-22 20:20:32 +03:00
read_only.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
read_only.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
rebuild.result Merge branch 10.3 into 10.4 2021-07-02 17:17:33 +10:00
rebuild.test Merge 10.4 into 10.5 2020-04-29 15:40:51 +03:00
rename.result Fix for MDEV-15105 (memory loss with LOCK sequence) 2018-02-19 11:27:21 +02:00
rename.test Fix for MDEV-15105 (memory loss with LOCK sequence) 2018-02-19 11:27:21 +02:00
replication-master.opt MDEV-10139 Support for SEQUENCE objects 2017-04-07 18:09:56 +04:00
replication-slave.opt MDEV-36425 Extend read_only to also block share locks and super user 2025-04-28 12:59:39 +03:00
replication.result Merge branch '11.8' into 12.0 2025-05-22 09:22:55 +02:00
replication.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
replication_drop.result Fix for MDEV-15812 Assert in SEQUENCE when forcing STATEMEMT format 2018-05-06 19:39:48 +03:00
replication_drop.test Fix for MDEV-15812 Assert in SEQUENCE when forcing STATEMEMT format 2018-05-06 19:39:48 +03:00
replication_mixed.result MDEV-16234 CREATE TABLE .. SELECT LASTVAL breaks replication 2018-05-22 18:33:18 +03:00
replication_mixed.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
setval.result MDEV-33836 Compute modulus correctly in sequence 2024-08-19 11:16:32 +10:00
setval.test MDEV-33836 Compute modulus correctly in sequence 2024-08-19 11:16:32 +10:00
slave_nextval.result MDEV-14092 NEXTVAL fails on slave 2017-10-19 13:25:02 +03:00
slave_nextval.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
temporary.result MDEV-31298 Assertion !check_foreigns' failed in trx_mod_table_time_t* trx_t::check_bulk_buffer(dict_table_t*), Assertion table->skip_alter_undo || !check_unique_secondary' failed in trx_t::check_bulk_buffer 2025-01-20 18:13:16 +01:00
temporary.test MDEV-31298 Assertion !check_foreigns' failed in trx_mod_table_time_t* trx_t::check_bulk_buffer(dict_table_t*), Assertion table->skip_alter_undo || !check_unique_secondary' failed in trx_t::check_bulk_buffer 2025-01-20 18:13:16 +01:00
view.result Merge pull request #1261 from robertbindar/mdev-17978 2019-12-05 18:26:52 +02:00
view.test MDEV-36380 User has unauthorized access to a sequence through a view with security invoker 2025-04-17 17:18:55 +02:00