1
0
mirror of https://github.com/MariaDB/server.git synced 2026-10-23 18:49:29 +03:00

75 Commits

Author SHA1 Message Date
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