GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

Sybase exception when combining random rows and binary primary keys

Open
#1,633 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.