Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.21
    • Fix Version/s: 2.3.12, 2.4.3
    • 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

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            dapeng dapeng huang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: