gf/2643.sql at fix/gconv_array - gf - Gitea: Git with a cup of tea

bingyi/gf

mirror of https://gitee.com/johng/gf synced 2026-06-06 16:21:40 +08:00

Files

Jack Ling 1878202625 test(contrib/drivers/mariadb): add layer 3 features and issue regression tests (#4724 )

## Summary

- Port 5 feature tests: duplicate-key handling
(OnDuplicate/OnDuplicateEx/Save), JSON field operations, row-level
locking (Lock/LockUpdate/LockShared with transactions), master-slave
configuration, table metadata inspection
- Port 1 partition test: RANGE partitioning with Partition() clause
(adapted from MySQL baseline)
- Port 30 issue regression tests from MySQL baseline
- Includes 14 testdata SQL files for issue-specific table schemas

Layer 3 tests cover MariaDB-specific adaptations where needed (e.g.,
SKIP LOCKED requires MariaDB 10.6+ — commented out for compatibility,
LOCK IN SHARE MODE instead of FOR SHARE for older versions).

All tests are structurally aligned with the MySQL driver baseline.
Package and import references are adapted for MariaDB.

ref #4689

Co-authored-by: John Guo <claymore1986@gmail.com>

2026-04-10 09:38:43 +08:00

7 lines

200 B

SQL

Raw Permalink Blame History

 CREATE TABLE `issue2643` (
     `id` INT(10) NULL DEFAULT NULL,
     `name` VARCHAR(50) NULL DEFAULT NULL,
     `value` INT(10) NULL DEFAULT NULL,
     `dept` VARCHAR(50) NULL DEFAULT NULL
 )
 ENGINE=InnoDB