Solution : https://service.sap.com/sap/support/notes/2241598 (SAP Service marketplace login required)
Summary :
SAP Note addresses the behavior changes in UPDATE FROM syntax in HANA. Initially, pre-HANA Revision82 treated update target table and its alias as different entities, allowing irregular results in specific SQL queries. Post-Revision82 to before HANA SPS11, a regression was noted where they were considered the same, creating erroneous outcomes. Since SPS11 and Revision 102.03, new requirements mandate explicit inclusion of the update target name in the FROM clause to avoid 'invalid table name' errors. Workaround involves reverting to old behavior via configuration settings if necessary. Adjustments to SQL scripts may be required to comply with current syntax expectations.
Key words :
customer component han-db sap hana database priority recommendations / additional info category consulting validity, sps10 2279078 sap hana sps 11 database revision 112 2275609 sap hana sps 10 database maintenance revision 102, 2265765 sap hana sps 11 database revision 111 2242726 sap hana sps 10 database maintenance revision 102, 03 2302188 sap hana sps 12 database revision 120 2300417 sap hana sps 11 database maintenance revision 112, 03 2233148 sap hana sps 11 database revision 110 2228298 sap foundation, rin 2311814 sap hana sps 11 database maintenance revision 112, 2257500 sap hana sps 10 database maintenance revision 102, 02 2296807 sap hana sps 11 database maintenance revision 112, 01 2290067 sap hana sps 10 database maintenance revision 102, dept t2 update empfrom dept t2-> update emp
Related Notes :
| 2257500 | |
| 2256179 | |
| 2249045 | |
| 2184212 | |
| 2279078 | |
| 2275609 | |
| 2272137 | |
| 2265765 | |
| 2242726 | |
| 2233148 | |
| 2228298 | |
| 2311814 | |
| 2302188 | SAP HANA SPS 12 Database Revision 120 |
| 2300417 | |
| 2296807 | |
| 2290067 |