apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.74k stars 3.28k forks source link

[Bug] can't execuate truncate sql #41378

Open zhangtao106 opened 1 month ago

zhangtao106 commented 1 month ago

Search before asking

Version

doris 2.1.6

What's Wrong?

I use mybatis-plus in my project, and use "truncate table table_a " in mapper.xml file, when I tigger parent method to execuate this sql, it accour error, but in my single test methods, it can executed success. with my tigger with xxl-job,: @Autowried private dbService servide;

service.clean(); in service.clean(), autowried mapper,

detailMessage = Only support prepare SelectStmt or NativeInsertStmt|Time(ms)=1|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=3998558|QueryId=527c90c2b9ae4b15-a57834112407554b|IsQuery=false|isNereids=false|feIp=10.1.1.1|Stmt=truncate table tttt;

What You Expected?

clean all data in table

How to Reproduce?

test interface with truncate table case

Anything Else?

no

Are you willing to submit PR?

Code of Conduct

ihadoop commented 1 month ago

could you share more details about the usage in single test methods and mapper.xml

zhangtao106 commented 1 month ago

could you share more details about the usage in single test methods and mapper.xml

my service method: public void cleanAllData() { cityRegisterRateMapper.cleanAllData(); } my mapper interface : void cleanAllData();

my mapper xml file :

truncate table table_a