Netezza - ORDER BY [position] - Causes Toad Datapoint to Crash

Toad Data Point
1

The following code causes Toad Datapoint to crash:

image

The same code works fine in Aginity Workbench:

image
image287×553 27.9 KB

If I change the ORDER BY to use a column name, the code runs without the crash:

image

I am running Toad Datapoint 5.7 against a Netezza database.

2

Hi - I am reporting this into our defect backlog.

3

Thank you Julie.