Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.4, 2.5, 6.4, 22.08
-
Component/s: qc_sqlite
-
Labels:None
Description
select CONVERT(substring(receive_code,8), UNSIGNED INTEGER) as sort, `id`, `receive_code` from `hz_lab_sample_receive` where `created_at` >= '2022-09-16 00:00:00' and `laboratory_code` = LY0023A order by `sort` desc limit 1 lock in share mode; |
in `CONVERT(substring(receive_code,8), UNSIGNED INTEGER)`, UNSIGNED INTEGER is not recognized.
The SQL is parsed as QUERY_TYPE_READ.
`lock in share mode` has no chance of parsing.