Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.21
-
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 |