Json results being duplicated from simple query

GSQL
1

I have a simple query that displays 4 vertices as expected, but when I look at the Json output the 4 vertices are represented twice. This is the query:

Start = {inputConcept};
Items = SELECT t FROM Start:s-(Concept_Has_ConceptItem>:e)-ConceptItem:t;
PRINT Items;

and this is the output:
image

and this is the Json:

[
{
“Items”: [
{
“v_id”: “11”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “OnePlus 8 Pro”,
“description”: “”,
“Id”: 11
}
},
{
“v_id”: “8”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “iPhone 11 Pro”,
“description”: “”,
“Id”: 8
}
},
{
“v_id”: “10”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “Google Pixel 4”,
“description”: “”,
“Id”: 10
}
},
{
“v_id”: “9”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “Samsung Galaxy S20”,
“description”: “”,
“Id”: 9
}
}
]
},
{
“Items”: [
{
“v_id”: “11”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “OnePlus 8 Pro”,
“description”: “”,
“Id”: 11
}
},
{
“v_id”: “10”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “Google Pixel 4”,
“description”: “”,
“Id”: 10
}
},
{
“v_id”: “8”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “iPhone 11 Pro”,
“description”: “”,
“Id”: 8
}
},
{
“v_id”: “9”,
“v_type”: “ConceptItem”,
“attributes”: {
“name”: “Samsung Galaxy S20”,
“description”: “”,
“Id”: 9
}
}
]
}
]

Can someone please explain why the Json is duplicated?

Thank you.

2

That looks odd.
Can you give us the schema too and I’ll try it out?

3

Thanks rik,

Having to replace all INT primary IDs with STRING (guid) data types forced me to drop and rebuild everything in the graph. Now when I execute the same query with the new vertices and edges it works as expected and there’s no way to determine what happened.

I guess this is a good problem.

4

Okay, good, I think :slight_smile: Hopefully it never returns. If it does. Please let us know.