同样的查询,有时候日志记录ROWCOUNT: 0(rows),有时候日志记录ROWCOUNT: 6(rows).
2022-09-20 15:28:52.161 (EP[0] sess:0xffff797e2220 thrd:70028 user:SYSDBA trxid:11698 stmt:0xffff79805218 appname:python3.9 ip:::ffff:127.0.0.1) [SEL] SELECT *
FROM test_users
WHERE test_users.“user_login” LIKE ?
LIMIT ? EXECTIME: 1(ms) ROWCOUNT: 0(rows).
2022-09-20 15:29:20.281 (EP[0] sess:0x3da97530 thrd:69256 user:SYSDBA trxid:11540 stmt:0x3daba528 appname:disql ip:::ffff:127.0.0.1) [SEL] SELECT *
FROM test_users
WHERE test_users.“user_login” LIKE ‘%t%’
LIMIT 1000000; EXECTIME: 2(ms) ROWCOUNT: 6(rows).
这两个语句明显是不同的,并且rowcount确实不一定准确,如果结果集较大,多次fetch的话,最后一次的rowcount才是准确的