Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26515

query with condition on date type column on a view with order by on the date column return no row

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.4.12
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      None
    • Environment:
      Red Hat 8

      Description

      After upgrading from 10.2 to 10.4 we have a view not returning data when using condition on the date type colum but the same queyr on the same view return rows on 10.2. We have trim down the code of the view as much as possible to provide the information. We have found out that the order by at the end of the view definition makes a difference.

      The file view_order_by.txt contains the code of the view with query and analyze plan with the order by clause working on 10.2 but not 10.4.

      The file view_NO_order_by.txt contains the code of the view with query and analyze plan without the order by clause working on 10.4.

      The file tablesDDL.txt containt tables DDL used in the view.

      SQL_MODE used is ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

      Marc

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            marc.langevin@usherbrooke.ca Marc
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration