Problem With Dtxql - Aliases Handling In Joins
(Doc ID 3005843.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Retail Xstore Office Cloud Service - Version 23.2 and laterInformation in this document applies to any platform.
Symptoms
We've noticed a problem when joining a table with conditions on multiple existing tables.
This is the original sql:
STEPS
The issue can be reproduced at will with the following steps:
1. Generate query in DTXQL format
2. Run the query and see the resulting sql command
BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot use multiple joins with multiple alias references in dtxql.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |