I am experiencing the following error while running YUNIQL against MariaDB version 10.11. Running the same migration against MariaDB version 10.9 works without problems.
"metaTableName": null,
"isContinueAfterFailure": false,
"transactionMode": "statement",
"isRequiredClearedDraft": false,
"isForced": false
}
INF 2023-12-09 14:12:24Z No explicit target version requested. We'll use latest available locally v0.0002 on E:\Work\Projects\sw20-rds\Db.
DBG 2023-12-09 14:12:24Z Replaced token YUNIQL_DB_NAME with mpiweb20
DBG 2023-12-09 14:12:24Z Replaced token YUNIQL_TABLE_NAME with __yuniql_schema_version
DBG 2023-12-09 14:12:24Z Executing statement 59D4E4:
SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'mpiweb20' AND TABLE_NAME = '__yuniql_schema_version' LIMIT 1;
ERR 2023-12-09 14:12:25Z Failed to execute run function. Object cannot be cast from DBNull to other types.
Diagnostics stack trace captured a System.InvalidCastException:
at System.DBNull.System.IConvertible.ToInt32(IFormatProvider )
at MySql.Data.MySqlClient.Driver.LoadCharacterSets(MySqlConnection connection)
at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Yuniql.Core.ConnectionExtensions.KeepOpen(IDbConnection connection)
at Yuniql.Core.ConnectionExtensions.QuerySingle(IDbConnection connection, String commandText, Nullable`1 commandTimeout, IDbTransaction transaction, ITraceService traceService)
at Yuniql.Core.ConnectionExtensions.QuerySingleBool(IDbConnection connection, String commandText, Nullable`1 commandTimeout, IDbTransaction transaction, ITraceService traceService)
at Yuniql.Core.MetadataService.IsDatabaseConfigured(String metaSchemaName, String metaTableName, Nullable`1 commandTimeout)
at Yuniql.Core.MigrationService.Run(String workspace, String targetVersion, Nullable`1 isAutoCreateDatabase, List`1 tokens, Nullable`1 isVerifyOnly, String bulkSeparator, String metaSchemaName, String metaTableName, Nullable`1 commandTimeout, Nullable`1 bulkBatchSize, String appliedByTool, String appliedByToolVersion, String environment, Nullable`1 isContinueAfterFailure, String transactionMode, Boolean isRequiredClearedDraft)
at Yuniql.Core.MigrationService.Run()
at Yuniql.CLI.CommandLineService.RunRunOption(RunOption opts)
If you think this is a bug, please report an issue here https://github.com/rdagumampan/yuniql/issues.
I am experiencing the following error while running YUNIQL against MariaDB version 10.11. Running the same migration against MariaDB version 10.9 works without problems.