Mirrors/MariaDB-server
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-12-28 00:01:00 +00:00
Code Issues Actions 5 Packages Projects Releases Wiki Activity
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.
203,194 Commits 3,337 Branches 370 Tags 1.7 GiB
MariaDB\ 71.9%
C++ 16.2%
C 10.5%
Shell 0.5%
Perl 0.4%
Other 0.3%
bb-11.4-MDEV-38426
Go to file
Sergei Petrunia 50ee5d1b3f MDEV-38426: Clustered PK not used for Loose Index Scan optimization 
Loose Index Scan optimization can only be used when the index it is
uses covers all columns used by the query. So, it would not be
attempted for indexes that are not present in table->covering_keys.

Before commit ed0a723566 (pushed to 11.0), Clustered PK would be
present in table->covering_keys if primary key columns are covering.

However, that commit gave Clustered PKs special treatment: they are
no longer present in table->covering_keys. This caused Loose Scan not
to be considered for Clustered PKs.

Fixed this by making the check in get_best_group_min_max() to allow
Loose Scan if all fields used by the query are parts of the Clustered PK.

Also made changes:
- The logic in JOIN_TAB::save_explain_data() assumed that Loose Scan
  could only be used for index-only scans. This is not the case for
  clustered PKs.
- One query in group_min_max_innodb started to use Loose Scan. It did so
  in 10.11, too.
2025-12-27 16:41:08 +02:00
.github
BUILD
client cleanup: CREATE_TYPELIB_FOR() helper 2025-10-25 00:19:11 +07:00
cmake Merge branch '10.11' into 11.4 2025-11-04 13:44:16 +01:00
dbug
debian Merge branch '10.11' into 11.4 2025-11-04 13:44:16 +01:00
Docs
extra Merge 10.11 into 11.4 2025-11-28 12:56:27 +02:00
include Merge 10.11 into 11.4 2025-11-28 12:56:27 +02:00
libmariadb@46880b0036
libmysqld
libservices
man
mysql-test MDEV-38426: Clustered PK not used for Loose Index Scan optimization 2025-12-27 16:41:08 +02:00
mysys Merge 10.11 into 11.4 2025-11-28 12:56:27 +02:00
mysys_ssl
plugin Merge 10.11 into 11.4 2025-11-11 10:34:33 +02:00
randgen/conf
scripts Merge branch '10.11' into 11.4 2025-11-04 13:44:16 +01:00
sql MDEV-38426: Clustered PK not used for Loose Index Scan optimization 2025-12-27 16:41:08 +02:00
sql-bench
sql-common cleanup: CREATE_TYPELIB_FOR() helper 2025-10-25 00:19:11 +07:00
storage MDEV-38164: Fix the estimates reported by TABLE::key_storage_length() 2025-12-02 10:54:31 +02:00
strings
support-files Merge branch '10.11' into 11.4 2025-11-04 13:44:16 +01:00
tests
tpool
unittest MDEV-38029 my_tzinfo-t fails for certain TZ values on musl 2025-11-20 11:52:54 +11:00
vio
win
wsrep-lib@14ce8cab76
zlib
.clang-format
.gitattributes
.gitignore Add mariadb-plugin-columnstore.install.generated to .gitignore 2025-11-19 14:05:29 +02:00
.gitlab-ci.yml
.gitmodules
appveyor.yml
BUILD-CMAKE
CMakeLists.txt
CODING_STANDARDS.md
config.h.cmake
configure.cmake
CONTRIBUTING.md
COPYING
CREDITS
INSTALL-SOURCE
INSTALL-WIN-SOURCE
KNOWN_BUGS.txt
README.md
SECURITY.md
THIRDPARTY
VERSION bump the VERSION 2025-11-06 12:30:28 -05:00

README.md

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 our security-policy.

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