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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4.12
    • N/A
    • N/A
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.