Vladislav Vaintroub
c742cc94ba
MDEV-35611 ALTER IF EXISTS assertions in sql_errno with statement timeout
...
Check stmt_da::is_error before calling stmt_da::sql_errno(which is what
the assertion ensures)
The bug did not have any negative effects in optimized builds.
2025-06-28 01:13:10 +02:00
Oleksandr Byelkin
89c7e2b9c7
Merge branch '10.11' into 11.4
2025-06-17 09:50:22 +02:00
Daniel Black
676aea8cad
MDEV-36848: identify tests with various MSAN suitability
...
With MSAN the following test behavious where observed:
* funcs_1.myisam_views-big - normal big test for non-debug
* innodb_gis.rtree_purge - normal big test with MSAN
* main.alter_table_lock - very quick - unclear why disabled
* main.cte_recursive - slow on Debug only
* main.join_cache_notasan - special MSAN handing for returning OOM added
* main.sum_distinct-big - 90 seconds on non-debug - still big however
* maria.max_length - normal big test with MSAN
* perfschema.statement_digest_long_query - overflows stack on debug
Timingsi (on old memory constrained hardware):
non-debug:
funcs_1.myisam_views-big w2 [ pass ] 78564
innodb_gis.rtree_purge '16k' w2 [ pass ] 5784
innodb_gis.rtree_purge '32k' w2 [ pass ] 5242
innodb_gis.rtree_purge '4k' w1 [ pass ] 8303
innodb_gis.rtree_purge '64k' w1 [ pass ] 6348
innodb_gis.rtree_purge '8k' w2 [ pass ] 5870
main.alter_table_lock w1 [ pass ] 41
main.cte_recursive w1 [ pass ] 15485
main.join_cache_notasan w1 [ pass ] 39
main.sum_distinct-big w2 [ pass ] 96256
maria.max_length w1 [ pass ] 92990
perfschema.statement_digest_long_query w2 [ pass ] 8
debug:
funcs_1.myisam_views-big w1 [ skipped ] Can't be run WITH_MSAN and CMAKE_BUILD_TYPE=Debug
innodb_gis.rtree_purge '16k' w2 [ pass ] 109788
innodb_gis.rtree_purge '32k' w2 [ pass ] 62361
innodb_gis.rtree_purge '4k' w1 [ pass ] 89423
innodb_gis.rtree_purge '64k' w1 [ pass ] 72082
innodb_gis.rtree_purge '8k' w1 [ pass ] 98452
main.alter_table_lock w2 [ pass ] 38
main.cte_recursive w2 [ pass ] 180047
main.join_cache_notasan w1 [ pass ] 166
main.sum_distinct-big w1 [ skipped ] Can't be run WITH_MSAN and CMAKE_BUILD_TYPE=Debug
maria.max_length w1 [ skipped ] Can't be run WITH_MSAN and CMAKE_BUILD_TYPE=Debug
perfschema.statement_digest_long_query w1 [ skipped ] Can't be run WITH_MSAN and CMAKE_BUILD_TYPE=Debug
2025-05-28 16:33:49 +10:00
Nikita Malyavin
84ed2e7ce6
fix main.alter_table_{online,lock}
2023-08-15 10:16:13 +02:00
Sergei Golubchik
845c939601
MDEV-28943 Online alter fails under LOCK TABLE with ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
...
if ALTER TABLE ... LOCK=xxx is executed under LOCK TABLES,
ignore the LOCK clause, because ALTER should not downgrade
already taken EXCLUSIVE table lock to SHARED or NONE.
This commit preserves the existing behavior (LOCK was de facto ignored),
but makes it explicit.
2023-08-15 10:16:12 +02:00
Monty
f7dd8799e7
Fixed bug in alter_table_lock.result
...
Before this change the test could abort with ER_OPTION_PREVENTS_STATEMENT
2022-05-12 10:01:10 +03:00
Marko Mäkelä
13076bd314
Avoid some failures WITH_MSAN
2022-02-28 14:05:50 +02:00
