ArcadeDB Server v26.2.1 (build ced6531188602179fef91d7f831373e7ff47284c/1771258648678/UNKNOWN)

Running on Linux 6.17.0-14-generic - OpenJDK 64-Bit Server VM 21.0.10

The SQL methods include and exclude exhibit different and behavior (in particular with @this)

1. The * wildcard does not seem to work with @ properties like @rid, @type, etc.
2. Both methods return a JSON object when used on @this instead of a record.

Setup:

CREATE DOCUMENT TYPE doc;
INSERT INTO doc SET id = 1;

Test:

SELECT @this.include('@r*') FROM doc -- Returns {"@rid":"#1:0","@type":"doc","@cat":"d"}
SELECT @this.exclude('@*') FROM doc -- Returns {"@rid":"#1:0","@type":"doc","@cat":"d","id":1}

In both cases the wildcard filter is not applied, and a JSON object instead of a record is returned.