Table I/O in RDA: Order By clause is missing in SQL
- Application Release: 9.1
- Tools Release: 9.1.3.3
- MS SQL Server 2012 on Windows Server 2008 Enterprise
---------------------------------------------------------------------------------------------------------
When a partial key is used in a "Fetch Single" operation, and the keys are consecutive starting with the first key, then the "Order By" clause is missing in the resulting SQL statement. Has anyone else experienced this issue? I'm not looking for a workaround using the Fetch.Select, I just want the "Fetch Single" to work correctly. Any way to resolve this would be much appreciated.
This happens when:
- Partial Key is used in the where clause.
- Consecutive keys are used starting with the first column.
Example #1:
2