Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.3.19
-
Component/s: qc_sqlite
-
Labels:None
Description
SELECT COUNT(IF(!c.ispackage, 1, NULL)) as cnt FROM test FOR UPDATE; |
This query should be QUERY_TYPE_WRITE, but it is QUERY_TYPE_READ now,
If change it to
SELECT COUNT(IF(not c.ispackage, 1, NULL)) as cnt FROM test FOR UPDATE |
, it will be ok