mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-11-05 21:36:12 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/sql_sequence
History
Exact
Oleksandr Byelkin eb1d0112be MDEV-36380 User has unauthorized access to a sequence through a view with security invoker 
The problem was that view rely on later checking column level privileges
for underlying tables but sequences do not need checks of its column
level privileges, only table level (sequence is one unit for SQL level).

Solution is to check table level privileges for sequences when we
create view structures (mysql_make_view).
2025-04-11 13:26:28 +02:00
..
alter.opt MDEV-36038 ALTER TABLE…SEQUENCE does not work correctly with InnoDB 2025-02-18 16:38:18 +01:00
alter.result MDEV-36038 ALTER TABLE…SEQUENCE does not work correctly with InnoDB 2025-02-18 16:38:18 +01:00
alter.test MDEV-36038 ALTER TABLE…SEQUENCE does not work correctly with InnoDB 2025-02-18 16:38:18 +01:00
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-13005: Fixing bugs in SEQUENCE, part 3, 2/5 2022-03-30 15:12:43 +05:30
aria.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
auto_increment.result Sequences with negative numbers and auto_increment_increment crashes 2018-08-30 17:38:01 +03:00
auto_increment.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
binlog.result Merge 10.3 into 10.4 2022-03-11 09:26:42 +02:00
binlog.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
concurrent_create.result MDEV-24545 Sequence created by one connection remains invisible to another 2021-04-27 08:44:28 +03:00
concurrent_create.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
create.result Fixed that SHOW CREATE TABLE for sequences shows used table options 2024-10-16 17:24:46 +03:00
create.test Fixed that SHOW CREATE TABLE for sequences shows used table options 2024-10-16 17:24:46 +03: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 Merge 10.4 into 10.5 2022-10-25 11:26:37 +03:00
default.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
disabled.def
grant.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
grant.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
gtid-master.opt
gtid-slave.opt
gtid.result Merge branch '10.3' into 10.4 2022-10-01 23:07:26 +02:00
gtid.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07: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 MDEV-29968 Functions in default values in tables with some character sets break SHOW CREATE (and mysqldump) 2025-01-17 15:39:55 +04:00
mysqldump.test MDEV-21785: sequences used as default by other table not dumped in right order by mysqldump 2021-01-26 10:41:02 +01:00
next.result MDEV-13005: Fixing bugs in SEQUENCE, part 3, 1/5 2022-03-30 15:12:33 +05:30
next.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
other.result Merge branch '10.4' into 10.5 2023-11-08 12:59:00 +01:00
other.test Merge branch '10.4' into 10.5 2023-11-08 12:59:00 +01:00
partition.result
partition.test
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
replication-slave.opt
replication.result Merge branch '10.3' into 10.4 2022-10-01 23:07:26 +02:00
replication.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07: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-15732: Assertion `next_free_value % real_increment == offset && next_free_value >= reserved_until' failed in sequence_definition::adjust_values upon SETVAL for sequence with INCREMENT 0 2018-04-26 15:38:16 +02:00
setval.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
slave_nextval.result
slave_nextval.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
temporary.result Added test case for MDEV-13007 ALTER .. ENGINE on temporary sequence may go wrong 2018-05-07 16:39:53 +03:00
temporary.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07: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-11 13:26:28 +02:00