Memory sorting: Numbers are sorted like alphanumeric

[Chris_Bananas]

Hi Quest,

it looks like "memory sorting" in recent versions is sorting numeric columns in an alphanumeric mode.

For reproduction you can use this simple SELECT:

SELECT 1 AS "a number column" FROM dual
UNION
SELECT 5 FROM dual
UNION
SELECT 11 FROM dual;

After executing the query I activate "Memory Sorting" via right-click-menu.

Result of sorting "a number column" by clicking the column header:

In Toad for Oracle 2025 R2:

As expected.

But in Toad for Oracle 2026 R1:

Regards, Chris

[JohnDorlon]

Hi Chris,

Thanks. I can reproduce that and will investigate.

-John

[JohnDorlon]

It's not fixed yet for beta, but...

It will work correctly in 2026R1 if this option is checked: