mirror of
https://gitee.com/johng/gf
synced 2026-06-06 16:21:40 +08:00
1878202625
## 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>
32 lines
1.2 KiB
SQL
32 lines
1.2 KiB
SQL
-- ----------------------------
|
|
-- Table structure for parcel_items
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `parcel_items`;
|
|
CREATE TABLE `parcel_items` (
|
|
`id` int(11) NOT NULL,
|
|
`parcel_id` int(11) NULL DEFAULT NULL,
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of parcel_items
|
|
-- ----------------------------
|
|
INSERT INTO `parcel_items` VALUES (1, 1, '新品');
|
|
INSERT INTO `parcel_items` VALUES (2, 3, '新品2');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for parcels
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `parcels`;
|
|
CREATE TABLE `parcels` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of parcels
|
|
-- ----------------------------
|
|
INSERT INTO `parcels` VALUES (1);
|
|
INSERT INTO `parcels` VALUES (2);
|
|
INSERT INTO `parcels` VALUES (3); |