AdminDatabaseFeature MySqlException Table doesn't exist

[LEIRONGHUA]

environment：

• MySQL Version：8.0.31
• ServiceStack.Server Version：6.8.0
• ServiceStack.OrmLite.MySql.Core Version：6.8.0
• AspNetCore Version：7.0

Example code/Steps to reproduce:

//Register your ServiceStack AppHost as a .NET Core module
app.UseServiceStack(new AppHost
{
    AppSettings = new NetCoreAppSettings(Configuration) // Use **appsettings.json** and config sources
});

ConfigureDb.cs:
services.AddSingleton<IDbConnectionFactory>(new OrmLiteConnectionFactory("Server=127.0.0.1;User ID=root;Password=123456;port=3306;Database=ServiceStackDb;CharSet=utf8;pooling=true;SslMode=None;OldGuids=true", MySqlDialect.Provider));

AppHost.cs:
Plugins.Add(new AdminDatabaseFeature());

Output:

Command:
SELECT * FROM `ServiceStackDb_ValidationRule` ORDER BY 1 LIMIT 1 OFFSET 0

Error:
Code	MySqlException
Message	Table 'ServiceStackDb.ServiceStackDb_ValidationRule' doesn't exist

StackTrace:
 at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at ServiceStack.OrmLite.OrmLiteCommand.ExecuteReader(CommandBehavior behavior) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/OrmLiteCommand.cs:line 56
   at ServiceStack.OrmLite.OrmLiteReadCommandExtensions.ExecReader(IDbCommand dbCmd, String sql, CommandBehavior commandBehavior) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/OrmLiteReadCommandExtensions.cs:line 54
   at ServiceStack.OrmLite.ReadExpressionCommandExtensions.GetSchemaTable(IDbCommand dbCmd, String sql) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/Expressions/ReadExpressionCommandExtensions.cs:line 248
   at ServiceStack.OrmLite.ReadExpressionCommandExtensions.GetTableColumns(IDbCommand dbCmd, String sql) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/Expressions/ReadExpressionCommandExtensions.cs:line 256
   at ServiceStack.OrmLite.OrmLiteReadExpressionsApi.<>c__DisplayClass70_0.<GetTableColumns>b__0(IDbCommand dbCmd) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/OrmLiteReadExpressionsApi.cs:line 465
   at ServiceStack.OrmLite.OrmLiteExecFilter.Exec[T](IDbConnection dbConn, Func`2 filter) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/OrmLiteExecFilter.cs:line 66
   at ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Exec[T](IDbConnection dbConn, Func`2 filter) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/OrmLiteReadExpressionsApi.cs:line 18
   at ServiceStack.OrmLite.OrmLiteReadExpressionsApi.GetTableColumns(IDbConnection dbConn, String sql) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack.OrmLite/src/ServiceStack.OrmLite/OrmLiteReadExpressionsApi.cs:line 465
   at ServiceStack.AdminDatabaseService.<>c__DisplayClass7_0.<GetColumns>b__0(String k) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack/src/ServiceStack.Server/AdminDatabaseFeature.cs:line 310
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at ServiceStack.AdminDatabaseService.GetColumns(IDbConnection db, String dbName, String table) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack/src/ServiceStack.Server/AdminDatabaseFeature.cs:line 307
   at ServiceStack.AdminDatabaseService.Any(AdminDatabase request) in /home/runner/work/ServiceStack/ServiceStack/ServiceStack/src/ServiceStack.Server/AdminDatabaseFeature.cs:line 167

Bug Analysis:

Table 'ServiceStackDb.ServiceStackDb_ValidationRule' doesn't exist，The real table name is：'ServiceStackDb.ValidationRule'，Table names do not have the 'ServiceStackDb_' prefix

Please fix this bug, thanks!
In SQL Server there is no such bug

[mythz]

This should now be resolved from the latest v6.8.1+ that's now available on MyGet

[LEIRONGHUA]

Thanks, I just tested it, this bug has been fixed in v6.8.1+