SHOW Commands: Pagination Support¶
This behavior change is in the 2023_05 bundle.
For the current status of the bundle, refer to Bundle History.
In the current release, the behavior of these commands changes as follows:
These commands do not support limiting the row output or pagination of the results.
These commands support pagination of the output using a LIMIT … FROM clause:
SHOW <domain_plural> [ LIMIT <rows> [ FROM '<name_string>' ] ]
The SHOW GRANTS command only supports the LIMIT clause. For example:
SHOW GRANTS [ LIMIT <rows> ]
Use one of the following plural forms of the object domain:
LIMIT rows [ FROM 'name_string' ]
Optionally limits the maximum number of rows returned, while also enabling “pagination” of the results. The actual number of rows returned night be less than the specified limit (e.g. the number of existing objects is less than the specified limit).
FROM 'name_string'subclause effectively serves as a “cursor” for the results. This enables fetching the specified number of rows following the first row whose object name matches the specified string:
The string must be enclosed in single quotes and is case-sensitive. In addition, the string does not have to include the full object name; partial names are supported.
Default: No value (no limit is applied to the output).
SHOW APPLICATION ROLES IN APPLICATION myapp LIMIT 10 FROM 'app_role2';
The statement returns up to ten application roles in the application named
myappafter the first application role named