Home - Waterfall Grid T-Grid Console Builders Recent Builds Buildslaves Changesources - JSON API - About

Console View


Categories: connectors experimental galera main
Legend:   Passed Failed Warnings Failed Again Running Exception Offline No data

connectors experimental galera main
fe39d73c8814...
fe39d73c8814f0fa20b334f67f762c1f9b8a6a58
Sergei Golubchik
Merge https://github.com/drrtuy/duckdb-engine into 11.4
fc007879fddf...
fc007879fddf600ff00984bd1204fb22af2bd0ae
drrtuy
chore(): avoid compilation error for the fiber test TU.
eff61139ea50...
eff61139ea5013777387fa4d01677d4b80f090fa
drrtuy
chore(test): fix flacky cross_join_where test.
e663297172af...
e663297172af58e9c61f3ba636ae73471c753482
drrtuy
fix(cej): escape column names, remove bin objects from the repo, add tests.
dcab9ba02c7c...
dcab9ba02c7ca4bc005957dcb63387f8cf0cf5f7
Rex Johnston
MDEV-39495 Parallel Query: Use temporary work tables to ship results: basic test

Built on top of MDEV-39492, the parallel worker manager creates N
temporary tables and gives them to each parallel worker to populate.
At the conclusion of all worker threads, each row from the above tables
is added to the join_tab->table representing the query result.  To use

MariaDB [test]> set session parallel_worker_threads=10;
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> select SQL_BUFFER_RESULT * from t1 join seq_1_to_5 on t1.a = seq;
+------+------+-----+
| a    | b    | seq |
+------+------+-----+
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
|    1 | one  |  1 |
|    2 | two  |  2 |
|    1 | un  |  1 |
+------+------+-----+
30 rows in set (0.010 sec)

Each worker has read the first table with a JT_ALL access method and
replicated the results back to the manager thread, which executes the
rest of the join.  In the above example there are 10 worker threads, so
10 copies of the join result.
d1973fbdae3a...
d1973fbdae3a05d9bb945b85bbe2a15f9226a94b
LaGrunge
feat(compat): add mid() UDF, CONVERT→CAST rewrite in pushdown

- mid(str, pos[, len]) via SQL macro delegating to DuckDB substr()
  (handles multibyte UTF-8 correctly)
- CONVERT(expr, TYPE) → CAST(expr AS TYPE) SQL rewrite in pushdown
  handler for MariaDB-specific syntax
- Remove mid SQL macros from duckdb_manager.cc

Tests progress:
- duckdb_string_func: past MID (line 212) to NOT REGEXP (line 226)
- duckdb_fix_sql: past CONVERT to DuckDB CAST type limitation
cdca05b1f673...
cdca05b1f673c866c0100bddc9abdf5045897e0e
LaGrunge
feat(compat): curdate/curtime macros, STRAIGHT_JOIN/index hints/LIMIT
rewrites, enable duckdb_sql_syntax test

- curdate()/curtime() macros → current_date/current_time
- STRAIGHT_JOIN → CROSS JOIN rewrite (before conditionless JOIN scan)
- Strip FORCE/USE/IGNORE INDEX(...) hints
- LIMIT offset,count → LIMIT count OFFSET offset
- Strip SQL_CALC_FOUND_ROWS and other SELECT hints
- addtime/subtime TIME overload: wrap around 24h for DuckDB range

Enable duckdb_sql_syntax test. Result diff: only ROLLUP grand total
row on empty table (+NULL,NULL,NULL — DuckDB SQL standard behavior)
and removed deprecation warnings.

Enabled: 23 -> 24.
cadef8bfce25...
cadef8bfce25c2f07f3284fbba0a831539c5a84d
LaGrunge
feat(compat): CURRENT_TIME(N)/CURRENT_DATE()/CURRENT_TIMESTAMP() rewrite,
curtime(fsp), datediff(d1,d2) macro

- Strip parens and args from CURRENT_TIME(N), CURRENT_DATE(),
  CURRENT_TIMESTAMP() — DuckDB uses keyword form without parens
- curtime(fsp) macro: accept optional fractional seconds precision arg
- datediff(d1, d2) macro: d1::DATE - d2::DATE (MariaDB 2-arg form)

duckdb_time_func progresses: line 45 → 155 (of 847).
Next blocker: DATEDIFF(TIMESTAMP, TIME) — DuckDB can't cast TIME→DATE.
ca6a30e626e3...
ca6a30e626e36735fc60a50ea8eeeff98958dddf
drrtuy
feat(runtime): fiber runtime based on ASM borrowed from libmariadb + custom select_result_interceptor for DuckDB.
bf703f9540f3...
bf703f9540f33d44def7b1a5ff2eb4c6611d668f
drrtuy
chore(build) preparation for code refactoring.
baaf6fd98439...
baaf6fd98439118a62a7149677e8ae84ab8e9114
Sergei Golubchik
rpm
ac9ae6adf41e...
ac9ae6adf41e89f4dfb65c9faeb0c3212ab00fd5
Sergei Golubchik
Merge https://github.com/mariadb/duckdb-engine into 11.4
a69957599be6...
a69957599be63179e7908645df1a5977d4be8b18
Sergei Golubchik
add submodule, most-merge fixes
a6649b1e619c...
a6649b1e619c0f42898de495068dab1bc0296848
LaGrunge
feat(compat): override length(VARCHAR) and ascii(VARCHAR) for MariaDB
byte semantics, enable duckdb_string_func test

Add C++ UDF overloads via ALTER_ON_CONFLICT:
- length(VARCHAR) → byte count (was: DuckDB char count)
- ascii(VARCHAR) → first byte value (was: DuckDB Unicode codepoint)

This matches MariaDB LENGTH()/ASCII() semantics for pushdown queries.

Result diff reviewed:
- Warnings removed (DuckDB doesn't emit truncation warnings)
- REGEXP_LIKE/multi-arg REGEXP_* sections removed (MySQL 8.0 only)
- ORD() for multibyte: 15111600→25968 (MariaDB multibyte ORD vs
  DuckDB Unicode codepoint — minor, TODO)

Enabled: 22 -> 23.
a541453fd5ac...
a541453fd5ac553b3081b774700afa27179972d6
drrtuy
chore(build): refactor code breaking it into separate modules.
a1749287decd...
a1749287decd7262ca6c26c3c32c8d693796791a
drrtuy
chore(): docs updates based on the recent changes.
8f761317659d...
8f761317659d697b78d2b95a6e5bcc881e1abb08
Sergei Petrunia
--disable_replay testfile in  main.invisible_field_debug test
872b6d90bac9...
872b6d90bac9247eac5f703a4f277a52dc734c61
LaGrunge
feat(pushdown): add CROSS JOIN, REGEXP, NOT REGEXP rewrites + mid UDF

SQL rewrites in pushdown handler:
- Conditionless JOIN → CROSS JOIN (scan for ON/USING before boundary)
- expr REGEXP pattern → expr ~ pattern (DuckDB regex operator)
- expr NOT REGEXP pattern → expr !~ pattern

mid(str, pos[, len]) implemented as SQL macro delegating to DuckDB
substr() for proper UTF-8 multibyte handling.

Tests progress:
- duckdb_sql_syntax: past JOIN to HIGH_PRIORITY (line 34)
- duckdb_string_func: past REGEXP to REGEXP_INSTR (line 302)
83078fa25014...
83078fa250147899e40b3e629cc04f73ced7ba49
Rex Johnston
MDEV-39492 Parallel Query: Study how to create worker threads

Introduces parallel_worker_threads variable to control the number
of worker threads created by a parallel execution query.

2 new files, sql_parallel_workers.h sql_parallel_workers.cc which
contain structures for the creation, management and deletion of
parallel worker threads (pwt_ in the name).  Main management
class created in the stack in JOIN::exec, implemented for the
top level select.

Current parallel_worker_thread_func sleeps for 10 seconds, generates
a warning, signals the main thread, sleeps 10 seconds, signals the
main thread again, sets it's finished flag and cleans it's THD.

The main thread loops through worker threads, looking for finished
thread and cleans them up if they have finished.
It then waits for a signal, then processes it's message queue.

Threads are registed in server_threads, so are visible in
information_schema.processlist and the show processlist command.

We check that a kill query on a parallel worker is passed onto it's
manager and the query is properly aborted, and that a kill connection
is handled properly in parallel_worker.test.

Review input 1: cleanup earlier

Do cleanup before we've finished sending the result to the client.
This way, one can see the errors (and eventually warnings) marshalled
back to the main thread and returned to the user:

MariaDB [test]> set parallel_worker_threads=10;
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> select seq from seq_1_to_10;
ERROR 4103 (HY000): Argument to the worker_busted_function() function does not belong to the range [0,1]

Assisted by Sergei Petrunia and Claude Code.
81bb4c550726...
81bb4c5507264da4afdd8e9db041512236d739e9
Sergei Golubchik
improve ExternalProject

* don't bother merging libraries
* gitignore the build dir
* prefix dir = build dir
* produce the progress log while building
75b0224a8121...
75b0224a81210ff80f88634fcc079693d3b25952
Oleg Smirnov
Fix failing tests
68ceb9f6f679...
68ceb9f6f6798706a760e046f4285b8fb272bdf6
Sergei Petrunia
Fix --replay-server for main.derived_view
612480e439c2...
612480e439c2869aa4cd860d15bd4f60ce090467
drrtuy
chore(): update documentation.
55a6ac2cf13f...
55a6ac2cf13facfaef1da988b0c8c39b6f09d108
drrtuy
chore(build): install build dependencies in build.sh.
529c8908dd48...
529c8908dd48f699d087f4076d7c624b70f4ac8c
LaGrunge
feat(compat): implement regexp_instr, regexp_replace, regexp_substr,
json_unquote using RE2 directly

Instead of calling MariaDB Item_func_* classes (which require
current_thd unavailable in DuckDB worker threads), implement
regex functions using DuckDB's bundled RE2 library directly:
- regexp_instr(str, pattern) → position of first match
- regexp_replace(str, pattern, repl) → RE2::GlobalReplace
- regexp_substr(str, pattern) → first matching substring
- json_unquote(str) → strip JSON quotes and unescape

Add DuckDB third_party/re2 to include path in cmake.

duckdb_string_func progresses past REGEXP_INSTR to test issue
(MariaDB 11.4 doesn't support 3-arg REGEXP_INSTR).
4928b46c5b2d...
4928b46c5b2dbff6e53f881297c0a2ae78181316
drrtuy
fix(pushdown): skip-list of all escaped strings to avoid SQL expressions lookup in those.
47402e37565e...
47402e37565e8e10eea48da4fd7ddfb92b1860e5
drrtuy
Expose static symbols leveraged in DuckDB to stringify WHERE conditions for other MariaDB engines.
47252343a5c9...
47252343a5c9c2664e7b2c26f76688df1d7818c6
LaGrunge
feat(compat): addtime/subtime C++ UDFs, convert_tz macro, LIMIT and
SELECT hints rewrite

- addtime/subtime: C++ UDFs parsing MariaDB interval format
  'D H:M:S.us', with TIMESTAMP and TIME overloads (TIME wraps 24h)
- convert_tz(ts, from, to): macro via DuckDB timezone()
- Remove MariaDB SELECT hints: HIGH_PRIORITY, SQL_NO_CACHE,
  SQL_SMALL_RESULT, SQL_BIG_RESULT, SQL_CALC_FOUND_ROWS, STRAIGHT_JOIN
- Rewrite LIMIT offset,count → LIMIT count OFFSET offset

Tests progress:
- duckdb_time_func: past addtime to CONVERT_TZ (line 60)
- duckdb_sql_syntax: past hints to LIMIT syntax (line 47)
460e132ee812...
460e132ee812a9a034637f02f3d0202df88a34be
Sergei Golubchik
don't modify server's error messages
433ae8999e52...
433ae8999e52a945589151bd751479697c7a9565
drrtuy
fix(build): now DuckDB core extensions are statically linked instead auto-loaded.
4078135d73e5...
4078135d73e52fab9c154b32d77e7c0ca62ff18a
LaGrunge
fix(rebase issues): Some tests are broken now, a big thanx
33cff772e2d4...
33cff772e2d42c861e077e882178f0a0490ca857
LaGrunge
feat(compat): port full hex/oct/bin from AliSQL, add locate C++ UDF

Port production-quality hex/oct/bin scalar functions from AliSQL DuckDB
fork. Supports all numeric types including HUGEINT (no precision loss
for large decimals), VARCHAR (parse as double), DOUBLE/FLOAT (round
first), BLOB (hex encoding). Replaces previous SQL macros.

Add locate(needle, haystack) and locate(needle, haystack, pos) as
native C++ scalar functions with proper 2-arg and 3-arg overloads.

Remove oct/bin/locate SQL macros from duckdb_manager.cc — now handled
by C++ UDFs in duckdb_mysql_compat.cc.

Tests progress: duckdb_string_func past LOCATE/BIN/HEX to MID (line
212), duckdb_fix_sql past hex(decimal) to CONVERT (line 53).
33a7c1cc5a7c...
33a7c1cc5a7c5c4d30df2ef50561f51ed3ff47e1
Oleg Smirnov
WIP: Integrate chunked InnoDB scan with parallel workers framework
2b59dea02002...
2b59dea02002d032fdfba5c41ff6081727adbd47
drrtuy
fix(cej): WHERE predicate now does not contain alias or table name in column idents.
26bbf6041820...
26bbf604182061cae98cc77ed756627316a34367
drrtuy
fix(mtr): trim couple tests to pass on U24.04.
19b7c8b5471d...
19b7c8b5471df492fdafc1ff0a30663f1025a42b
drrtuy
fix(pushdown): fix for STRAIGHT_JOIN, various JOIN re-write cases and also recursive cases WITH ROLLUP and LIMIT clauses.
17fe2d65e564...
17fe2d65e564b0d7063aeea2a919cdeaed2bea7b
Sergei Petrunia
Fix replay for non-default @@sql_mode settings.

sql_mode=ORACLE and similar settings may prevent the table and/or
column options from being printed correctly.

Remove them when calling show_create_table_ex().

Since the output of show_create_table_ex() is added into the
SQL script, also add a "SET sql_mode=..." before the CREATE TABLE
and another one to restore the value after it.

This fixes main.intersect_all
1639aebe79fd...
1639aebe79fdd471fc8848c3757a6b0427471534
drrtuy
fix(build):thread local maps with default TLS model got broken with MSAN build.
15fd9e2214f0...
15fd9e2214f0d6f5cb2ea947359521318fe240cb
LaGrunge
feat(compat): add strcmp, substring_index, to_base64 macros, RLIKE
rewrite, adapt test for MariaDB 11.4

New SQL macros: strcmp(a,b), substring_index(s,d,c), to_base64(x).
Add RLIKE/NOT RLIKE → ~/!~ rewrite alongside REGEXP.

Adapt duckdb_string_func test:
- Comment out REGEXP_LIKE section (MySQL 8.0 only)
- Comment out multi-arg REGEXP_INSTR/REPLACE/SUBSTR (MySQL 8.0 only)

Test runs to completion but has semantic differences:
- LENGTH() returns chars in DuckDB vs bytes in MariaDB
- ASCII() returns codepoint in DuckDB vs first byte in MariaDB
Needs LENGTH/ASCII UDF overloads for byte semantics.
15fd76b35d18...
15fd76b35d18743ba2e624a225f25402cdf70fef
drrtuy
feat(cej): MDB tables scan now uses mysql_execute_command to to leverage optimizer and various access paths for a scan.
BuildBot (0.8.9) working for the MariaDB project.
Page built: Sun 07 Jun 2026 20:13:39 (UTC)