HexyinUESTC commented on issue #42553: URL: https://github.com/apache/doris/issues/42553#issuecomment-2447635548
"I understand your point as follows: 1. After setting set global `enable_prepared_stmt_audit_log = true;`, we should use `select * from tbl where id = XXX` to replace `EXECUTE xxxx USING XXX`. 2. When `set global enable_prepared_stmt_audit_log = false;`(default), the state of the audit log should be OK upon prepared success. (Here, I noticed that after a successful execution, the state is explicitly set to NOOP, and I’m unsure if this is intentional.) Is my understanding correct? Below is the version I implemented based on this understanding:" 1. before  after  2. before ``` State=NOOP|ErrorCode=0|ErrorMessage=|Time(ms)=0|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=638|QueryId=***IsQuery=false|isNereids=true|feIp=******|StmtType=SELECT|Stmt=select * from tbl_prepared_stmt_in_list WHERE `k10` IN (?, ?, ?, ?, ?) order by 1|CpuTimeMS=0| ``` after ``` State=OK|ErrorCode=0|ErrorMessage=|Time(ms)=0|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=319|QueryId=*****|IsQuery=false|isNereids=true|feIp=******|StmtType=SELECT|Stmt=select * from tbl_prepared_stmt_in_list WHERE `k10` IN (?, ?, ?, ?, ?) order by 1|CpuTimeMS=0| ``` Please let me know if I have misunderstood any part of this. Thank you. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
