inE(), outE() and bothE() have different behaviors

[TheVamp]

ArcadeDB Version:

ArcadeDB Server v25.6.1 (build aa15bdf5ca7c78957f4e8163e213f05a97c4095f/1751901868702/main)

OS and JDK Version:

Running on Linux 6.15.7-3-cachyos - OpenJDK 64-Bit Server VM 21.0.7 (Temurin-21.0.7+6)

Description

inE(), outE() and bothE() have different behaviors.

Maybe similiar to #1590. I though it is not a duplicate, due to the Focus of the Studio Serializer.

Steps to reproduce

CREATE VERTEX TYPE News;
CREATE VERTEX TYPE Author;
CREATE EDGE TYPE Published;
INSERT INTO News CONTENT { "id": "1", "title": "News 1", "content": "Content 1" };
INSERT INTO News CONTENT { "id": "2", "title": "News 2", "content": "Content 2" };
INSERT INTO Author CONTENT { "id": "1", "name": "Author 1" };
CREATE EDGE Published FROM (SELECT FROM Author WHERE id = 1) TO (SELECT FROM News WHERE id = 1);

and

SELECT bothE("Published") as bothE, inE("Published") as inE, outE("Published") as outE FROM News;

Actual behavior - Studio serializer

bothE	inE	outE
1	[{}]	[]
[]	[]	[]

Expected behavior - Studio serializer

bothE	inE	outE
1	1	0
0	0	0

or

bothE	inE	outE
[{}]	[{}]	[]
[]	[]	[]

Actual behavior - Graph serializer via HTTP/API

[{"bothE("Published")":[{"@rid":"#7:0","@type":"Published","@cat":"e","@in":"#1:0","@out":"#4:0"}],"inE("Published")":[{}],"outE("Published")":[]},{"bothE("Published")":[],"inE("Published")":[],"outE("Published")":[]}]

Expected behavior - Graph serializer via HTTP/API

[{"bothE("Published")":[{}],"inE("Published")":[{}],"outE("Published")":[]},{"bothE("Published")":[],"inE("Published")":[],"outE("Published")":[]}]

or

[{"bothE("Published")":[{"@rid":"#7:0","@type":"Published","@cat":"e","@in":"#1:0","@out":"#4:0"}],"inE("Published")":[{"@rid":"#7:0","@type":"Published","@cat":"e","@in":"#1:0","@out":"#4:0"}],"outE("Published")":[]},{"bothE("Published")":[],"inE("Published")":[],"outE("Published")":[]}]

[gramian]

See also #1590

[lvca]

Reproduced