Console View

Categories: connectors experimental galera main

Legend:

Passed

Failed

Warnings

Failed Again

Running

Exception

Offline

No data

connectors

experimental

galera

main

f8cf1f387bab...

f8cf1f387babfcb02daa5dcc13674c766b87c5ab

Oleg Smirnov

olernov@gmail.com

Enable release builds

eef3f3a93508...

eef3f3a935087c9ae74522035bf728b565a7db44

drrtuy

drrtuy@gmail.com

chore: update DuckDB docs and info.

e5d72aad9c57...

e5d72aad9c5704ac9b89d2fcf06ec53635b08b53

Thirunarayanan Balathandayuthapani

thiru@mariadb.com

MDEV-28730 Remove internal parser usage from InnoDB FTS

InnoDB FTS performed all reads and DML on its auxiliary,
common and CONFIG tables through the InnoDB internal SQL
graph parser. Replace that path with direct B-tree access
via a new query-executor layer, and delete the parser-era
helpers.

row0query.h, row/row0query.cc - new QueryExecutor:
- General MVCC-aware record traversal and basic DML on the
clustered index. Sits on a btr_pcur and a transaction-owned
mtr; record processing goes through a RecordCallback that
bundles two std::functions:
compare_record() returns SKIP / PROCESS / STOP for a record
process_record() handles each PROCESS-ed (MVCC-visible) row

Public API:
read() scan a clustered index with a search key
read_all() full clustered scan (optional start tuple)
read_by_index() scan a secondary index, fetch the matching
clustered record, deliver it to the callback
insert_record() insert a tuple into the clustered index
delete_record() delete a row identified by tuple
delete_all() delete every row in the clustered index
select_for_update() position+X-lock the matching clustered row
update_record() update the row select_for_update() locked,
falling back to optimistic/pessimistic and
external storage paths as needed
replace_record() upsert: select_for_update()+update_record(),
else insert_record()
lock_table(), handle_wait(), commit_mtr()

fts0exec.h, fts/fts0exec.cc - new FTSQueryExecutor:
Thin wrapper over QueryExecutor specialised for FTS tables.
Opens and locks the required tables once and exposes typed
helpers keyed by table family.

Auxiliary INDEX_[1..6]:
open_all_aux_tables()
insert_aux_record(aux_index, fts_aux_data_t)
delete_aux_record(aux_index, fts_aux_data_t)
read_aux() range scan from a given word
read_from_range() paginated read that absorbs
DB_FTS_EXCEED_RESULT_CACHE_LIMIT internally
and resumes from the last word seen

Common deletion tables (DELETED, DELETED_CACHE, BEING_DELETED,
BEING_DELETED_CACHE):
open_all_deletion_tables()
insert_common_record(), delete_common_record(),
delete_all_common_records(), read_all_common()

CONFIG table (<key, value>):
open_config_table() / set_config_table()
insert_config_record(), update_config_record() (upsert),
delete_config_record(), read_config_with_lock()

fts_aux_data_t carries the auxiliary row payload.
RecordCallback specialisations live alongside the executor:

CommonTableReader collects doc_ids from common tables that
share the <doc_id> schema.

ConfigReader extracts <key, value> and provides
compare_config_key() for fast key matching.

AuxRecordReader scans auxiliary indexes with an
AuxCompareMode (GREATER_EQUAL / GREATER / LIKE / EQUAL) driving the
comparator; tracks the last word seen so a paginated scan can resume.

fts_query() walks index and common tables via
QueryExecutor::read_by_index() with RecordCallback;

fts_write_node() writes auxiliary rows through
FTSQueryExecutor::insert_aux_record() / delete_aux_record()
with fts_aux_data_t.

fts_optimize_write_word() now goes through the same
insert/delete path.

fts_select_index{,_by_range,_by_hash} return uint8_t (was
ulint) with a simpler control flow.

fts_optimize_table() binds a thd to its transaction whether
invoked from a user thread or the FTS optimize thread.

fts_optimize_t drops its fts_index_table and fts_common_table
fts_table_t fields; fts_query_t drops fts_common_table.

storage/innobase/fts/fts0sql.cc is deleted along with the
commented-out and unreferenced parser-era helpers it held.

dict_sys.latch is now acquired once per fts_sync_table(),
fts_optimize_table() and fts_query() call to open every
auxiliary and common table in one pass, instead of being
re-acquired per table.

Every FTS trx_create() site now takes the THD from a real
caller (user trx, fts_opt_thd, DDL ctx->trx, ha_thd())
instead of either leaving it NULL or pulling current_thd.

fts_commit(): Each fts_commit_table() used to create transaction
and commit, producing N undo segments, N read views and N group-commit
batches for N FTS tables touched by the user statement.
fts_commit() now creates one internal trx, runs every
fts_commit_table() under it, and commits once.

fts_optimize_word() could fail when source nodes have equal
boundary doc_ids. Loosen the merge predicate from '>' to
'>=' so legitimate overlapping ranges that occur when nodes
fill to FTS_ILIST_MAX_SIZE at doc_id boundaries are handled
correctly.

INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE (i_s.cc) wires the
shared words_heap via set_words_heap() and empties it per batch
with mem_heap_empty(); the per-fetch cleanup frees only the
per-node ilist (ut_alloc'd) and skips fts_word_free().

e0ca6d1d3efe...

e0ca6d1d3efe7429cef3b4d6ef598918a2c32d6d

Sergei Petrunia

sergey@mariadb.com

Move auto-partitioning sql_partition_auto_interval.cc

e073724f183d...

e073724f183d798ffb75fb7a4d5f15b28268e8c0

Oleg Smirnov

olernov@gmail.com

Enable InnoDB pre-fetcher for parallel scans

ddc7ace36307...

ddc7ace36307fcdc6f9361adc4752885382fa8bd

Rex Johnston

rex.johnston@mariadb.com

MDEV-39859 Remove per worker tmp tables, ship raw records to manager

d9c364ec4dc9...

d9c364ec4dc967ffa7a02a030c5b2c1fa8faf8a7

Jan Lindström

jan.lindstrom@mariadb.com

MDEV-38870 : Galera test failure on galera.MDEV-38201

Test changes only. Moved wait condition where node should
disconnect from cluster because it has become inconsistent.
After that next FLUSH HOST based on timing could return
not supported or timeout.

d3911381d7cb...

d3911381d7cb70ac95c9a0dcbacc26f6ae743286

Dave Gosselin

dave.gosselin@mariadb.com

MDEV-39952: Skip tests that need mariabackup

Skips tests that require mariabackup if mariabackup was not
built (WITH_MARIABACKUP=OFF).

Backport of the same MTR change from 12.3 but applied to
additional tests.

d2bb2fe32c87...

d2bb2fe32c87496889cb4d2194fac5c4c436ac35

Pekka Lampio

pekka.lampio@galeracluster.com

MDEV-38386 Fix incomplete cleanup in Galera MTR tests failing under --repeat

A number of Galera MTR tests pass on the first run but fail on a second
--repeat iteration, because server, cluster or filesystem state leaks
across runs and the test does not restore a clean starting state.

Fix the cleanup (or force a fresh cluster) in the affected tests. Each
fix was verified with --repeat=2 --force.

1. Stale async-slave GTID position (11 tests)

RESET SLAVE [ALL] does not clear gtid_slave_pos. As the master does
RESET MASTER in cleanup, on the next run the slave considers the
events already applied and skips them, so the replicated tables never
appear. Clear the position with SET GLOBAL gtid_slave_pos = "".

2. Leftover binlog GTID state from trailing cleanup (1 test)

Trailing DROP TABLE / mtr.add_suppression statements ran after the
.inc's reset master and re-populated node_2's binlog. gtid_binlog_state
keeps the latest seqno per (domain, server_id) pair, so a stray
0-2-<n> survived into the next run and broke the state comparison.
Reorder the cleanup and reset node_2's binlog last.

3. Cluster-global, one-time or time-window state (11 tests)

The wsrep GTID domain seqno is cluster-global and is not reset by
reset master (nor by a mid-test SST rejoin); error-log contents,
warning-flood suppression timers and one-time bootstrap behaviour are
likewise not restored by in-test cleanup. Force a fresh cluster with
include/force_restart.inc.

4. Leftover filesystem artifacts (1 test)

mariabackup refuses to back up into a non-empty target directory, so
the leftover target dirs from the previous run made the backup fail
silently and the expected log messages never appeared. Remove the
target directories in cleanup.

c3ec2dc368a8...

c3ec2dc368a8c7165cdbea58208eb828e76ebc57

Varun Deep Saini

varun.23bcs10048@ms.sst.scaler.com

MDEV-25727 Add FORMAT JSON support to JSON_TABLE

Allow explicit FORMAT JSON columns in JSON_TABLE for supported
string, blob, and JSON targets.

Preserve the explicit clause in view printing and add regression
coverage for formatted extraction, unsupported targets, and SHOW
CREATE VIEW.

Signed-off-by: Varun Deep Saini <[email protected]>
Signed-off-by: Varun Deep Saini <[email protected]>

c307d91be19b...

c307d91be19b96bdad2a572958627a328a3f1a8d

Dave Gosselin

dave.gosselin@mariadb.com

MDEV-38210: Unary negation of LONGTEXT, wrong result under GROUP BY

Unary negation of a LONGTEXT or LONGBLOB value returned the wrong
result under GROUP BY. The length of the result was set to the
argument length plus one for the sign, but for these two types the
argument length is already the largest value the length field can
hold, so adding one wrapped it back to zero. A zero length result
loses its value when it is stored in the temporary table that GROUP BY
builds, so the query returned an empty value instead of the expected
number. The argument length is now limited before the sign character
is added, so it can no longer wrap to zero.

b9e3bdfbc5d0...

b9e3bdfbc5d0750a186a30122b6cb5aeab382c01

Sergei Petrunia

sergey@mariadb.com

Move auto-partitioning sql_partition_auto_interval.cc

b88fe40601a2...

b88fe40601a252c29fde7432e04d9ed7e9897c40

Dave Gosselin

dave.gosselin@mariadb.com

MDEV-39952: Skip binlog_in_engine tests that need mariabackup

Several tests in the binlog_in_engine suite run the mariabackup
binary but did not check that it was built. When the server is
built with WITH_MARIABACKUP=OFF, the test runner leaves the
mariabackup command empty and these tests fail instead of being
skipped.

Add include/have_mariabackup_binary.inc, which skips the test when
the binary is not available, and source it from the affected tests.
Unlike have_mariabackup.inc, it does not also require socat or nc,
because these tests copy the backup to a local directory rather than
streaming it.

ae136494fb2a...

ae136494fb2a447d74c0e6cc747461f96e2ec17f

Fariha Shaikh

farihais@amazon.com

MDEV-39928 Fix GitLab CI centos9 job failure

The centos9 job uses yum-builddep -y mariadb-server to install build
dependencies, but the mariadb-server source package has been removed
from CentOS Stream 9 repositories. Replace with explicit installation of
the required build dependencies.

All new code of the whole pull request, including one or several files
that are either new files or modified ones, are contributed under the
BSD-new license. I am contributing on behalf of my employer Amazon Web
Services, Inc.

ad5c9d6c359c...

ad5c9d6c359cf7bc4ffd684e5866145b6c298c3e

Raghunandan Bhat

raghunandan.bhat96@gmail.com

MDEV-39559: Assertion `b` failed in `my_strnncoll_xxxx_nopad_ci`

Problem:
When verifying a `UNIQUE` constraint over an empty BLOB/TEXT column,
`Field_blob::cmp(a_ptr, b_ptr)` extracts a NULL data pointer (with
length 0) from the record slot and forwards it to the charset-level
comparison, which asserts non-NULL pointers (added in MDEV-35717).

A zero-length blob is allowed to have a NULL data pointer in its
record slot; `Field_blob::val_decimal()` already treats (NULL, 0) as
an empty value. The comparison paths missed that substitution.

Fix:
- In `Field_blob::cmp(a_ptr, b_ptr)`, `Field_blob::cmp_prefix()` and
`Field_blob::key_cmp(key_ptr, max_key_length)`, substitute "" for a
NULL data pointer before delegating to the comparison.
- Add a debug assert in each of the above functions to document the
invariant that a NULL pointer is only valid alongside zero length
and (NULL, length>0) is invalid.

aa4fa33ba15e...

aa4fa33ba15e59ccde7e4eae8b99b4e395494f0c

Yuchen Pei

ycp@mariadb.com

MDEV-32796 [demo] federatedx suffers the same problem as spider

a7a2bfda2a15...

a7a2bfda2a15b8b42693f3d99d8b27edb023fe31

Dave Gosselin

dave.gosselin@mariadb.com

a6d76cb48952...

a6d76cb4895266bb65b5291abaa8082c3db5bb27

Oleg Smirnov

olernov@gmail.com

Enable re-split of marked chunks

9bf71b3eb7b9...

9bf71b3eb7b987c746015c280b2fe486a071be69

Yuchen Pei

ycp@mariadb.com

MDEV-15621 Auto add RANGE COLUMNS partitions by interval

Allow auto partitioning by interval in PARTITION BY RANGE COLUMNS

PARTITION BY RANGE COLUMNS (col_name)
INTERVAL interval [AUTO]
(
PARTITION partition_name VALUES LESS THAN (value)
[, PARTITION partition_name VALUES LESS THAN (value) ... ]
)

where

- col_name is the name of one column of type DATE or DATETIME or
TIMESTAMP

- at least one partition is supplied, and the highest partition cannot
have MAXVALUE range

- INTERVAL interval is a positive time interval. it can be mariadb
format or oracle NUMTODSINTERVAL/NUMTOYMINTERVAL format. Like
versioning, the smallest unit is second, i.e. no subsecond like
microsecond.

- DATE column cannot have interval with values less than a day

- Subpartitions are allowed, but restricted to existing subpartition
types, i.e. [LINEAR] (KEY|HASH)

When performing one of the following DML statements on such a table,
it will first add partitions by the specified interval until the
partition covers the current time:

- INSERT
- INSERT ... SELECT
- LOAD
- UPDATE
- REPLACE
- REPLACE ... SELECT

Partition addition will not cause an implicit commit like DDL normally
does.

The partitions are named pN.

Otherwise the table behaves exactly the same as a normal RANGE COLUMNS
partitioned table.

Note that TIMESTAMP is not allowed as a type for PARTITION BY RANGE
COLUMNS otherwise.

96ca4d3d5aa4...

96ca4d3d5aa416eb26c4de8bf3e681bb5185ae5e

Dave Gosselin

dave.gosselin@mariadb.com

MDEV-38158: Incorrect query result

When setup_copy_fields() needs to copy a non-aggregate function value,
it doesn't construct an Item_copy directly. Instead, it calls
Type_handler::create_item_copy, which is a kind of factory. The base
Type_handler::create_item_copy returns Item_copy_string. Some type
handlers override it, like timestamp and fixed binary. However, the
numeric type handlers (e.g., float, double, int, decimal) did not, so
they fell through to that base and got Item_copy_string.

A SELECT that aggregates will copy each non aggregate function value
into a temporary table through an Item_copy object, whose concrete
type is chosen by the create_item_copy method on the value's type
handler. For numeric types that method returned Item_copy_string,
which stores the value as text. A FLOAT keeps only FLT_DIG
significant digits as text, too few to reproduce its 24 bit mantissa,
so the copied value differed from the original. With one row per
group, CAST(c1 AS FLOAT) - MIN(CAST(c1 AS FLOAT)) returned a large
number instead of zero.

Add Item_copy_real with Item_copy_float and Item_copy_double variants
that keep the value as a double, the same way Item_cache_real does, and
let the float and double type handlers create them. This mirrors the
existing copy items for timestamp and fixed binary types.

91da209f23a4...

91da209f23a48c7b8d41ea819349c742c2d33d3f

Alexander Barkov

bar@mariadb.com

MDEV-39518 Allow prepared statements in stored functions in assignment right hand

In progress

8f120e6cbb44...

8f120e6cbb448585965c888edb99055c8b37c67b

Alexander Barkov

bar@mariadb.com

MDEV-39518 Allow prepared statements in stored functions in assignment right hand

In progress

8d605f8e9458...

8d605f8e94587b8e165dbd35f1fff20dc1e7fc89

Rucha Deodhar

rucha.deodhar@mariadb.com

MDEV-34723: NEW and OLD in a trigger as row variables

Implementation:
NEW and OLD represent the entire table row. So it can be thought of as
list of Item_trigger_field. When we are in a trigger and NEW or OLD is
encountered, create Item_trigger_row object with same constructor as
Item_trigger_field, it will also be used later while creating
Item_trigger_field objects. Populate the m_fields list while
fixing fields. Create a corresponding instruction sp_instr_set_trigger_row
which will be used to set the values

8bde48034bb9...

8bde48034bb9413820f65a44851e71177ab10a99

Vladislav Vaintroub

vvaintroub@gmail.com

MDEV-38369 improve heap allocation performance on Windows with segmentHeap

Use modern segmentHeap heap manager on Windows.

The problem it is solving is severily reduced scalability on concurrent
OLTP benchmarks, due to inherent scalability problems in default NT Heap
implementation.

The benchmarks (see the corresponding ticket) show improvements across
the board, with about 5-10% on low concurrency up to several orders of
magnitude on high concurrency.

8bd0360b2167...

8bd0360b2167588c001350903bbe344c6c0f1c5a

Vladislav Vaintroub

vvaintroub@gmail.com

MDEV-40002 REVOKE DENY on table debug asserts with existing GRANT, without existing DENY

Fix handling of update_denies_in_user_table() inside replace_table_table()

replace_table_table is "special", and should return -1 if grant was
revoked, 1 if error, 0 if success. Whenever it is used, caller explicitly
checks for return code greater 0

It did however return -1 on all errors with denies. The debug assertion
that catches cases where my_error() is followed by my_ok() fired then.

This is now fixed. Added test cases for "REVOKE DENY on non-existing DENY
and existing GRANT" scenarios.

8077134777e3...

8077134777e3d3fda875413b45f440873c46e358

Marko Mäkelä

marko.makela@mariadb.com

Multi-threaded backup and stub of streaming backup

79a9baea9ce6...

79a9baea9ce671774072026258b7d899fbdd1a12

PranavKTiwari

pranav.tiwari@mariadb.com

Assertion 'marked_for_read()' failed in Field_varstring::val_str on CHECKSUM TABLE

76f30d51b99d...

76f30d51b99d13a47da8f96aca34b946e1d380ab

Thirunarayanan Balathandayuthapani

thiru@mariadb.com

- Addressed the failures

6b3f97894d93...

6b3f97894d933bc7d56e0a2a0f1aec3bad5e88dc

Dave Gosselin

dave.gosselin@mariadb.com

66430af54fe2...

66430af54fe2da9cce56d81f891971f4f9cbbbb1

drrtuy

drrtuy@gmail.com

chore: TPC-H automation and packaging section update in README.

63108fd76738...

63108fd76738baeca2c5d58099c871481fa8d978

Vladislav Vaintroub

vvaintroub@gmail.com

6287ee0a3c9c...

6287ee0a3c9cc272b9826aca37ffa30718a4aef3

Sergei Petrunia

sergey@mariadb.com

Review input: add more comments, function renames.

5cf8e34edaa5...

5cf8e34edaa5e5c06d0a0419e7c78c73adfacedc

bsrikanth-mariadb

srikanth.bondalapati@mariadb.com

store index_name instead of index number everywhere in the context

Multi_range_read_const_call_record, and dump_mrr_info_calls()
already store index names. However, cost_index_read_call_record,
dump_index_read_calls() were using index numbers.

To be consistent, this PR changes index methods, and classes
to use index name instead of index number.

4bbd63de45e1...

4bbd63de45e1d342855a45bc39c4a51a85b9f244

Rex Johnston

rex.johnston@mariadb.com

MDEV-39495 Parallel Query:comments and code cleanup

484364661bc8...

484364661bc87a20c248c2834806f16cd153d17c

Vladislav Vaintroub

vvaintroub@gmail.com

Potential fix for pull request finding

Co-authored-by: Copilot Autofix powered by AI <[email protected]>

30fdf6ff2ec8...

30fdf6ff2ec8b285ecbee561f93c14a3e7160701

Dave Gosselin

dave.gosselin@mariadb.com

17ce1be1ed9a...

17ce1be1ed9adf7f61a74a0ffceefe45ef64756e

Marko Mäkelä

marko.makela@mariadb.com

fixup! 8077134777e3d3fda875413b45f440873c46e358

0964c82e16f9...

0964c82e16f99c5ef2f583ea6e63a74307a7a9f5

Rucha Deodhar

rucha.deodhar@mariadb.com

MDEV-39878: JSON_ARRAY_INTERSECT: nested call JSON_ARRAY_INTERSECT(
JSON_ARRAY_INTERSECT(a,b), b) returns NULL instead of intersect result

Analysis:
Evaluating args[0] inside fix_length_and_dec() forces the argument to run
during the query preparation phase. If args[0] is a nested function,
its runtime memory structures are not yet initialized. This causes a
early failure that makes inner function as NULL before the query
starts executing.

Fix:
Wrap the evaluation in a const_item() check so it only runs during setup
if the argument is a constant. Otherwise, do it in runtime.

08faed6601fd...

08faed6601fdc59dca4b4b3959fbf1a931a32bc9

Yuchen Pei

ycp@mariadb.com

07e42ead548a...

07e42ead548a547c4510d0cdfbab62b734862043

Vladislav Vaintroub

vvaintroub@gmail.com