search

IBM / db2forzosdeveloperextension-about

IBM Db2 for z/OS Developer Extension for VS Code
https://IBM.github.io/db2forzosdeveloperextension-about/
Other
12 stars 8 forks source link

Sorting on a column from SQL results not correct #166

Open dhiren-c opened 1 month ago

dhiren-c commented 1 month ago

Problem description

for a multi page SQL results output any column sorting only applies to that page only and not to the entire result set thus giving a false impression for the result set.

Detailed steps for reproducing the problem:

  1. First step

use any SQL which results in a multi page output e.g.

select creator, name, type, createdts from SYSIBM.systables where creator = 'XXXXX' with ur

Observed behavior

Assume you have 4 pages of output (default of 25 rows / page ) If you click the SORT option on type column then yo might see 4 aliases rows as the first 4 rows and the rest as type=T i.e. tables for the next page you may see 5 aliases and the rest rows for tables and so on on every page

Expected behavior

I would have expected when a SORT on any column is asked for then the results are for the entire result set - in the example above if there were 9 aliases then a sort should show all the 9 aliases on page 1 and not split between a page view

-

equalchenbj commented 1 month ago

@dhiren-c This is the current limitation of sort function. But We have opened an internal git issue to track for a future release.