GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator
Sybase exception when combining random rows and binary primary keys
Open
- Dominant language
- Python
- Stars
- 524
- Forks
- 171
- Avg merge
- 5d 15h
- Merged PRs (30d)
- 4
Description
To reproduce this issue search for "issue-1633" in `tests/system/data_sources/test_sybase.py`.
The problem is the order of getting the random rows and converting binary to string.
```
SELECT bintostr(t0.binary_id) AS binary_id
FROM (SELECT TOP 5 t1.binary_id AS binary_id
FROM (SELECT t2.binary_id AS binary_id
FROM pso_data_validator.dvt_binary AS t2) AS t1 ORDER BY NEWID() ASC) AS t0
Msg 154 (severity 15, state 53) from MYSYBASE Line 2:
"An ORDER BY clause is not allowed in a derived table.
"
```
I've decided this is not an urgent blocker preventing Sybase release.
Contributor guide
Assessment
This issue has not been assessed yet.