gf/contrib/drivers/mariadb/testdata/table_with_prefix.sql

CREATE TABLE `instance`  (
    `f_id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NULL DEFAULT '',
    PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = InnoDB;

INSERT INTO `instance` VALUES (1, 'john');
test(contrib/drivers/mariadb): add softtime, with, scanlist, union and do tests (#4721) ## Summary - Port 48 soft-time tests: soft create/update/delete with timestamp/datetime/date types, SoftTime switches (SoftTimeTypeOff/Delete/Timestamp), Unscoped, ForceDelete, joined queries with soft-delete - Port 19 With/ScanList tests: With/WithAll for eager loading of hasOne/hasMany/belongsTo relations, ScanList for manual relation mapping, nested With - Port 12 union tests: Union/UnionAll with various parameter forms (string/Model/subquery), combined with OrderBy, Limit, Where conditions - Port 12 gdb.Do tests: DoSelect/DoInsert/DoUpdate/DoDelete raw operation hooks, batch insert, InsertIgnore/InsertGetId/Replace via DoInsert option Includes testdata SQL files for With relation table schemas (with_tpl). Soft-time tests create tables inline via SQL, no separate testdata files needed. All tests are structurally identical to the MySQL driver baseline. SQL syntax is standard and shared. Package and import references are adapted for MariaDB. ref #4689 2026-03-12 11:15:42 +08:00			CREATE TABLE `instance` (
			`f_id` int(11) NOT NULL AUTO_INCREMENT,
			`name` varchar(255) NULL DEFAULT '',
			PRIMARY KEY (`f_id`) USING BTREE
			`) ENGINE = InnoDB;`

			INSERT INTO `instance` VALUES (1, 'john');