Skip to content

Sybase exception when combining random rows and binary primary keys #1633

@nj1973

Description

@nj1973

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions