The Select Limit for Graph Database Queries in the User Interface Does Not Work (Doc ID 3062328.1)

Last updated on DECEMBER 27, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When running a "Select" database query using the LIMIT parameter a "Graph' database within the Database Query Tools User Interface, the LIMIT parameter is being ignored.

EXPECTED BEHAVIOR
-----------------------
The LIMIT value should be respected when used within a database query against the graph database.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Within the User Interface navigate to, Configuration -> Databases -> Query Tools.
2. Set the "Schema" to "Graph".
3. Set the SELECT 'Limit value' to '3'.
4. Copy and Paste the following command into the "Query" window: MATCH (d:Device) RETURN d.Name, d .CustomName.
5. Click on the'Execute' button.
6. Notice that the number of rows of data returned is greater than the SELECT 'Limit value' of 3.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.