DeleteDirectAsync problem

[PiaoYiQiang]

Is there an existing issue for this?

• I have searched the existing issues

Description

In mysql8,code first,
When using DeleteDirectAsync, I encountered the following error:
DELETE FROMMaintenance_ProcedureASmWHERE NOT (m.IsDeleted) AND (m.Id= '3a2040a8-6b10-b095-a3fe-66455c4ba817')
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASmWHERE NOT (m.IsDeleted) AND (m.Id= '3a2040a8-6b10-b095-a3fe-664' at line 1

Based on AI suggestions, the correct SQL should be:
DELETEmFROMMaintenance_ProcedureASmWHERE NOT (m.IsDeleted) AND (m.Id= '3a2040a8-6b10-b095-a3fe-66455c4ba817');

Reproduction Steps

No response

Expected behavior

No response

Actual behavior

No response

Regression?

No response

Known Workarounds

No response

Version

10.1.1

User Interface

Common (Default)

Database Provider

EF Core (Default)

Tiered or separate authentication server

Tiered

Operation System

Windows (Default)

Other information

No response

[maliming]

Hi

This is a known limitation of the Oracle MySql.EntityFrameworkCore provider. ABP's DeleteDirectAsync calls EF Core's ExecuteDeleteAsync, and the provider generates incorrect DELETE SQL syntax for MySQL. Same issue as #24451 and #25139.

As a workaround, you can use the standard DeleteAsync method instead of DeleteDirectAsync to avoid the problematic SQL generation.

Thanks