Describe the bug
I have run following update:
update tab1 set col=UPPER(col1)
the update caused the data in individual rows to be updated with values from other rows. This was also observed in the audit logs. Moreover, update finished but not all rows were updated.
To Reproduce
Query to reproduce the behavior:
update tab1 set col=UPPER(col1)
Expected behavior
update all rows with the row's upper value
Screenshots
If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
- SQL 4 CDS edition: [e.g. XrmToolBox
- Results of
SELECT @@VERSION: 9.2.0.0
Additional context
Add any other context about the problem here.
Sponsorship
If you find this tool useful, please consider sponsoring its development.
Describe the bug
I have run following update:
update tab1 set col=UPPER(col1)
the update caused the data in individual rows to be updated with values from other rows. This was also observed in the audit logs. Moreover, update finished but not all rows were updated.
To Reproduce
Query to reproduce the behavior:
update tab1 set col=UPPER(col1)
Expected behavior
update all rows with the row's upper value
Screenshots
If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
SELECT @@VERSION: 9.2.0.0Additional context
Add any other context about the problem here.
Sponsorship
If you find this tool useful, please consider sponsoring its development.