SwapnilPatil07 commented on issue #27170:
URL:
https://github.com/apache/shardingsphere/issues/27170#issuecomment-1650893995
Added Case and Expected xml for below query.
```
UPDATE employees SET salary =
(SELECT salary FROM employees
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '2' MINUTE)
WHERE last_name = 'Chung')
WHERE last_name = 'Chung';
```
Other queries are throwing errors so I did not make changes for them. Please
let me know what oracle version I need to check these queries.
Also, I am not sure which SQL Doc are referred in below comment. Can you
please provide link ?
```
Compare SQL definitions in Oficial SQL Doc and ShardingSphere SQL Doc;
If there is any difference in ShardingSphere SQL Doc, please correct them by
referring to the Official SQL Doc;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
