Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.0.31
    • Fix Version/s: 5.5.57
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      Centos 7, cpanel

      Description

      I use a software called elevatedX. I recently ran a cpanel upgrade that upgraded MariaDB to 10.0.31. Since then the counting query in elevatedx runs but doesn't return any results. Prior to this everything was working find. ElevatedX has said its a bug in MariaDB. Here is what they told me. I apologize for lack of depth as I am not a dev.

      This query works:

      SELECT * FROM (totals) WHERE
      TotalDate IN (select MAX(TotalDate) from totals WHERE TotalDate <= '2017-05-26');
      

      This, however, does not:

      SELECT * FROM (totals) WHERE
      TotalDate IN (select MAX(TotalDate) from totals WHERE TotalDate <= '2017-05-26') OR TotalDate IS NULL;
      

      This is a bug in your version of MariaDB. Please consult your host.

      Any information on if this can be fixed or how I can downgrade would be appreciated.

        Attachments

          Activity

            People

            • Assignee:
              igor Igor Babaev
              Reporter:
              cptech Chris Peden
            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: