Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4.12
-
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