| # |
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 |
Bug
Major