Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.2.21
-
Component/s: qc_sqlite
-
Labels:None
Description
# | sql | current | should be |
---|---|---|---|
1 | select timediff(cast('2004-12-30 12:00:00' as time), '12:00:00') | QUERY_TYPE_READ|QUERY_TYPE_WRITE | QUERY_TYPE_READ |
2 | (select 1 as a from t1) union all (select 1 from dual) limit 1 | QUERY_TYPE_UNDEFINED | QUERY_TYPE_READ |
3 | SET @saved_cs_client= @@character_set_client; | QUERY_TYPE_UNKNOWN | QUERY_TYPE_SYSVAR_READ | QUERY_TYPE_USERVAR_WRITE |
4 | SELECT 1 AS c1 FROM t1 ORDER BY ( SELECT 1 AS c2 FROM t1 GROUP BY GREATEST(LAST_INSERT_ID(), t1.a) ORDER BY GREATEST(LAST_INSERT_ID(), t1.a) LIMIT 1); | QUERY_TYPE_READ | QUERY_TYPE_READ|QUERY_TYPE_MASTER_READ |