Anway Durge
e782b38509
MDEV-40819: Do not crash on DuckDB TIME values beyond 24 hours
...
MariaDB TIME is a duration up to 838:59:59, but SELECT converted DuckDB
TIME through ToString(), which asserts clock-time validity in debug
builds. Convert microseconds to MYSQL_TIME directly instead.
SQL DML quoted TIME strings, so '25:00:00' failed conversion. Store
microseconds through mariadb_time() instead, matching the appender path.
2026-10-16 18:36:41 +05:30
Marko Mäkelä
0b24391c0b
Merge 12.3 to 13.1
2026-10-13 08:39:01 +03:00
Sergei Golubchik
b2bc6c2f70
Merge branch '11.8' into 12.3
2026-10-07 22:10:46 +02:00
Sergei Golubchik
f21444cd03
Merge branch '11.4' into 11.8
2026-10-07 10:57:35 +02:00
drrtuy
38bc5b954b
MDEV-40957 replication from InnoDB into DuckDB works using FULL mode only.
2026-10-06 13:47:28 +04:00
drrtuy
34e3dc8038
MDEV-40957 DuckDB engine now returns maximum cost for unimplemented index handler operations effectively disabling them.
2026-10-06 13:47:28 +04:00
drrtuy
8dddd70215
MDEV-40957 MTR tests to cover DML statements in a replicated setup.
2026-10-06 13:47:28 +04:00
drrtuy
189298bd2a
MDEV-40957 mixed-mode replication UPDATE/DELETE for DuckDB.
2026-10-06 13:47:28 +04:00
drrtuy
250ee9121f
MDEV-40957 read-free DML on the slave for DuckDB.
2026-10-06 13:47:28 +04:00
drrtuy
15174ecd8e
MDEV-40957 various fixes for mixed DML path that suffered from uninit bitmaps and wrong SQL statements that failed in DuckDB.
2026-10-06 13:47:28 +04:00
Oleksandr Byelkin
b140f801e6
Merge branch '13.0' into 13.1
2026-09-04 12:21:02 +02:00
Val Doroshchuk
b722cc53ed
Rename duckdb file name to allow to use duckdb as schema
...
If duckdb is used as schema, DuckDB requires to use it in queries explicitly since the name conflicts with the catalog.
This fixes
Ambiguous reference to catalog or schema "duckdb" - use a fully qualified path like '.duckdb'
2026-08-25 15:08:52 +01:00
drrtuy
5af13b65a3
fix: MDEV-40846 DuckDB handles functionality that is based on invisible columns, e.g. WITH SYSTEM VERSIONING.
2026-08-21 18:03:24 +01:00
Oleksandr Byelkin
3b8db45403
Merge branch '11.4' into 11.8
2026-08-19 11:28:01 +02:00
drrtuy
970492062d
chore: remove jemalloc extension from DuckDB CMake b/c since 1.5.4 is is a part of DuckDB core.
2026-08-12 12:17:48 +01:00
drrtuy
81bb68ba63
chore: add DuckDB version info function.
2026-08-12 12:17:48 +01:00
drrtuy
790a084aca
feat: update DuckDB submodule to 1.5.5.
2026-08-12 12:17:48 +01:00
drrtuy
f6418ff7b2
fix: MDEV-40651 ALTER TABLE and DDL in general is now executed in an atomic manner b/c previously MariaDB DDL triggered multiple autocommit DDL statements in DuckDB some of those can fail leaving table in unsable state.
2026-08-07 23:04:50 +01:00
aleksei.bukhalov
16ddaf82e2
docs: add public dataset tutorials for the DuckDB engine
...
Add two step-by-step tutorials:
- NYC Taxi Trips: load TLC Parquet via run_in_duckdb() + read_parquet(),
keep the zone lookup in InnoDB, then join the two engines in a plain
SELECT. Follows the structure of the ClickHouse taxi tutorial.
- OWID CO2 Emissions: load a commit-pinned CSV revision, run
aggregations and a LAG() window function.
Both tutorials point at security-model.md before telling the reader to
enable duckdb_allow_run_in_duckdb, and both note that ordinary
INSERT/UPDATE/DELETE also work on ENGINE=DuckDB tables so that
run_in_duckdb() does not look like the only write path.
Also documents TIMESTAMPDIFF in mariadb-duckdb-incompatibilities.md and
adds a tutorials section to the README.
Every SQL block and every expected output was extracted from the
markdown, executed, and compared cell by cell on MariaDB 11.4.13 built
from this branch; both data sets are pinned so results stay
reproducible.
2026-08-07 21:35:35 +01:00
drrtuy
d8bb2d50c1
fix: hardening against unknown SQL injection vectors running DuckDB.
2026-08-07 21:04:38 +01:00
drrtuy
9b4f6932ed
fix: resolve SQL injection imposed by lexer semantics difference b/w
...
MariaDB and DuckDB.
2026-08-07 21:04:38 +01:00
drrtuy
02a8d47e0e
fix: MDEV-40386 disable MTR tests for MSAN builds b/c MSAN build is unstable.
2026-08-06 00:15:58 +01:00
drrtuy
6fb7e41646
fix: MDEV-40610 fix for SQL injection in DEFAULT expression.
2026-08-06 00:15:58 +01:00
drrtuy
2295f22baf
feat: DuckDB supports AUTO INCREMENT stanza.
2026-08-04 23:26:28 +02:00
drrtuy
25636531e5
feat: implement SEQUENCE support in DEFAULT value clause for DuckDB tables.
2026-08-04 23:26:28 +02:00
drrtuy
81516d56da
chore: add more RYOW tests for DuckDB.
2026-08-04 23:26:28 +02:00
drrtuy
76ca478ca3
chore: use extended stack with up to 11 MB for ASAN/UBSAN builds.
2026-08-04 23:26:28 +02:00
forkfun
b8dbc264f0
Merge branch '13.0' into 'main'
2026-08-03 13:42:39 +02:00
forkfun
eaca80bf32
Merge branch '11.4' into '11.8'
2026-07-29 12:27:46 +02:00
Sergei Golubchik
eccf9ca5f1
move DuckDB to a separate package
2026-07-28 19:40:00 +02:00
drrtuy
452b1cd614
chore: renaming, extra docs and bump DuckDB to gamma.
2026-07-27 17:16:20 +03:00
drrtuy
51c65bd828
fix: MDEV-40452 ASAN builds complain about enourmous stack consumption b/c of the reference pointer used for stack usage calculations.
2026-07-27 17:16:20 +03:00
drrtuy
17c95946b9
chore: DuckDB build.sh exposes build with ASAN flag.
2026-07-27 17:16:20 +03:00
drrtuy
f72361a23f
fix: fix stack size warning.
2026-07-27 11:27:07 +03:00
drrtuy
bff41d98a5
fix: extra try-catch during plugin init.
2026-07-26 14:10:12 +03:00
drrtuy
4af16b4bcf
fix: clean DeltaAppender after at rollback or disconnect.
2026-07-26 14:10:12 +03:00
drrtuy
2cbce592c3
fix: add streaming into select/union handler to avoid results materialization.
2026-07-21 09:40:05 +03:00
Vladislav Vaintroub
934108aab5
MDEV-14443 DENY statement
...
Implements DENY/REVOKE DENY and associated tasks.
2026-07-20 13:23:00 +03:00
drrtuy
5420cccdb0
fix: MDEV-40379 temporary disable CREATE TEMPORARY TABLE engine=DuckDB b/c of naming temp table naming inconsitencies b/w MariaDB and DuckDB.
2026-07-17 21:55:20 +03:00
drrtuy
dd2fbd2dc4
chore: RYOW MTR test for DuckDB.
2026-07-17 21:55:20 +03:00
drrtuy
325048bac4
fix: DuckDB now optionally read same transactions writes applied to other engines tables.
2026-07-17 21:55:20 +03:00
Daniel Black
f950eec582
tests: pass test regardless of timezone
2026-07-15 23:55:15 +03:00
Daniel Black
e000e75e29
build: take server WITH_{UB,A}SAN settings
2026-07-15 23:55:15 +03:00
drrtuy
176589bf19
MDEV-40265 fix: UUID type support in DuckDB and mixed SELECT statements.
2026-07-05 17:25:06 +03:00
drrtuy
0c3ed7dad0
chore(build): suppress sfinae-incomplete warnings building DuckDB code to reduce noise for >=] GCC-16 compiler.
2026-07-05 17:25:06 +03:00
drrtuy
472898c75c
chore: default memory limits are now 80% * (physical RAM - innodb_buffer_pool_size_max)
2026-07-04 22:03:12 +03:00
drrtuy
ce566951c1
chore: enable run_in_duckdb by default()
2026-07-04 22:03:12 +03:00
drrtuy
2e25fa829f
chore: bump DuckDB version to 1.5.4.
2026-07-04 22:03:12 +03:00
drrtuy
7a8776a92e
chore(tests,docs): renew documentation and fixed a number of test inconsistences.
2026-07-04 19:44:27 +03:00
drrtuy
03cb6bc4f2
fix(func): time functions fixes and tests.
2026-07-04 19:44:27 +03:00