MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.
Find a file
Aleksey Midenkov 0b1ce1ca87 MDEV-26048 Table 'test._test_new' doesn't exist when add trigger (use pt-osc)
There is inconsistency happens between two INSERTs. First INSERT
happens after only tr1 was created. It enters
DML_prelocking_strategy::handle_table() and sets need_prelocking as
there is table->triggers. But there is no relevant triggers: tr1 is
TRG_EVENT_DELETE, so nothing was added for prelocking. Nonetheless,
extend_table_list() calls mark_as_requiring_prelocking() based on
need_prelocking. It sets lex->query_tables_own_last to
save_query_tables_last which is double pointer to NULL. Then
reset_lex_and_exec_core() based on that value (double pointer is
non-NULL itself) propagates that to SP's m_lex.

After tr2 created, next execution of INSERT thinks it has prelocking
list. extend_table_list() receives has_prelocking_list:true and
skips handle_table() (and therefore any prelocking list updates).

As a result when process_triggers() is trying to open t2 it does not
see it in the list of open (and prelocked) tables and fails with
ER_NO_SUCH_TABLE (which is misleading error code as t2 exists).

The fix avoids setting need_prelocking for the cases when no triggers
executed (i.e. no matching event type).

Note that we can not disable prelocking for triggers without any
tables like that:

  *need_prelocking|= trigger->add_used_tables_to_table_list(thd,
	     &prelocking_ctx->query_tables_last,
	     table_list->belong_to_view);

because trigger must be executed under LTM_PRELOCKED, otherwise it
will close not own tables (this can be further improved, see TODO in
the patch).

Thanks to Chǔ Huáxīng <15381158111@163.com> for the patch idea.
2025-07-08 15:57:22 +03:00
.github Merge 10.5 into 10.6 2023-05-19 14:24:09 +03:00
BUILD Check and remove high stack usage 2024-04-23 14:12:31 +03:00
client mysqltest: result_format fix 2025-05-21 11:10:09 +03:00
cmake MDEV-34388: Stack overflow on Alpine Linux (postfix) - sanitizers 2025-06-02 11:40:39 +02:00
dbug Merge branch '10.6.12' into 10.6 2023-02-06 20:18:44 +01:00
debian Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
Docs Merge 10.4 into 10.5 2022-09-26 13:34:38 +03:00
extra MDEV-36316/MDEV-36327/MDEV-36328 Debug msan 2025-05-28 16:28:34 +10:00
include Get debug version to compile with gcc 7.5.0 2025-06-02 14:02:53 +03:00
libmariadb@55abb32038 new CC 2025-04-20 20:48:21 +02:00
libmysqld Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
libservices MDEV-33277 In-place upgrade causes invalid AUTO_INCREMENT values 2024-02-08 10:35:45 +02:00
man Merge branch '10.5' into 10.6 2024-07-16 15:54:22 +08:00
mysql-test MDEV-26048 Table 'test._test_new' doesn't exist when add trigger (use pt-osc) 2025-07-08 15:57:22 +03:00
mysys MDEV-37170 Enable AVX10.1 CRC-32 on GCC 16 2025-07-07 09:30:34 +03:00
mysys_ssl MDEV-35838 libressl support differences in CRYPTO_set_mem_functions 2025-01-14 12:13:22 +11:00
plugin MDEV-36337 auth_ed25519 correct UDF pointers for is_null/error 2025-05-21 09:47:55 +02:00
randgen/conf Group commit for maria engine. 2010-02-12 15:12:28 +02:00
scripts print_ddl_recovery_log.pl ; Print content of the ddl_recovery.log 2025-04-27 15:12:21 +03:00
sql MDEV-26048 Table 'test._test_new' doesn't exist when add trigger (use pt-osc) 2025-07-08 15:57:22 +03:00
sql-bench MDEV-24854: Change innodb_flush_method=O_DIRECT by default 2021-02-20 11:58:58 +02:00
sql-common Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
storage MDEV-37121 Change buffer freed pages are not removed during slow shutdown 2025-07-04 10:51:17 +05:30
strings MDEV-37048 revert MSAN my_vsnprintf_ex for double workaround 2025-07-03 10:43:40 +03:00
support-files Merge branch '10.5' into 10.6 2025-04-26 10:41:52 +02:00
tests Merge branch '10.5' into 10.6 2025-04-26 10:41:52 +02:00
tpool MDEV-36482: Make libaio work WITH_MSAN=ON 2025-06-26 10:05:36 +03:00
unittest Merge 10.5 into 10.6 2024-12-11 14:46:43 +02:00
vio Compiling - fix warnings with MSVC 17.14 2025-05-26 16:58:21 +02:00
win Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
wsrep-lib@e55f01ce1e MDEV-36422 Build fails with cmake 4.0.0 due to wsrep 2025-04-10 13:05:19 +02:00
zlib Merge branch 'merge-zlib' (1.3.1) into 10.4 2024-04-26 13:50:03 +02:00
.clang-format Remove duplicate key "Language" from .clang-format 2024-04-17 16:52:37 +02:00
.gitattributes Merge branch '10.5' into 10.6 2022-02-03 17:01:31 +01:00
.gitignore print_ddl_recovery_log.pl ; Print content of the ddl_recovery.log 2025-04-27 15:12:21 +03:00
.gitlab-ci.yml Merge branch '10.5' into 10.6 2024-07-18 16:25:33 +02:00
.gitmodules Merge remote-tracking branch '10.4' into 10.5 2023-03-31 21:32:41 +02:00
appveyor.yml Merge 10.5 into 10.6 2024-06-07 10:03:51 +03:00
BUILD-CMAKE Minor spelling fixes in code comments, docs and output 2018-01-12 16:49:02 +02:00
CMakeLists.txt Merge branch '10.5' into '10.6' 2025-04-15 01:49:48 +02:00
config.h.cmake Merge branch '10.5' into 10.6 2024-10-29 14:20:03 +01:00
configure.cmake Merge branch '10.5' into 10.6 2024-10-29 14:20:03 +01:00
CONTRIBUTING.md Remove mention of Freenode 2021-09-22 07:15:08 +02:00
COPYING Update FSF Address 2019-05-11 21:29:06 +03:00
CREDITS Update sponsors 2024-08-12 09:32:30 +01:00
INSTALL-SOURCE Update AskMonty and Atlassian references to MariaDB 2016-03-08 15:24:01 +02:00
INSTALL-WIN-SOURCE Update AskMonty and Atlassian references to MariaDB 2016-03-08 15:24:01 +02:00
KNOWN_BUGS.txt Changed some MySQL names in messages to MariaDB 2018-12-09 20:49:05 +02:00
README.md Update README for branch choice 2024-05-29 13:49:32 +01:00
THIRDPARTY Added socketpair.c as a replacement for 'pipe()' call for Windows. 2024-01-23 13:03:11 +02:00
VERSION bump the VERSION 2025-02-04 10:11:58 -05:00

Code status:

  • Appveyor CI status ci.appveyor.com

MariaDB: The innovative open source database

MariaDB was designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.

MariaDB is brought to you by the MariaDB Foundation and the MariaDB Corporation. Please read the CREDITS file for details about the MariaDB Foundation, and who is developing MariaDB.

MariaDB is developed by many of the original developers of MySQL who now work for the MariaDB Corporation, the MariaDB Foundation and by many people in the community.

MySQL, which is the base of MariaDB, is a product and trademark of Oracle Corporation, Inc. For a list of developers and other contributors, see the Credits appendix. You can also run 'SHOW authors' to get a list of active contributors.

A description of the MariaDB project and a manual can be found at:

https://mariadb.org

https://mariadb.com/kb/en/

https://mariadb.com/kb/en/mariadb-vs-mysql-features/

https://mariadb.com/kb/en/mariadb-versus-mysql-compatibility/

https://mariadb.com/kb/en/new-and-old-releases/

Getting the code, building it and testing it

Refer to the following guide: https://mariadb.org/get-involved/getting-started-for-developers/get-code-build-test/ which outlines how to build the source code correctly and run the MariaDB testing framework, as well as which branch to target for your contributions.

Help

More help is available from the Maria Discuss mailing list https://lists.mariadb.org/postorius/lists/discuss.lists.mariadb.org/ and MariaDB's Zulip instance, https://mariadb.zulipchat.com/

Licensing


MariaDB is specifically available only under version 2 of the GNU General Public License (GPLv2). (I.e. Without the "any later version" clause.) This is inherited from MySQL. Please see the README file in the MySQL distribution for more information.

License information can be found in the COPYING file. Third party license information can be found in the THIRDPARTY file.


Bug Reports

Bug and/or error reports regarding MariaDB should be submitted at: https://jira.mariadb.org

For reporting security vulnerabilities see: https://mariadb.org/about/security-policy/

The code for MariaDB, including all revision history, can be found at: https://github.com/MariaDB/server