CREATE TABLE RDB$DOCSETTINGS (
    ID                    INTEGER NOT NULL,
    PARENT_ID             INTEGER,
    NAME                  DMN_STRING_500,
    HAS_CHILDREN          INTEGER DEFAULT 0,
    IS_NODE               DMN_BOOL_2 DEFAULT 0,
    NOTE                  DMN_BLOBTXT,
    TYPE_STRING           DMN_STRING_500,
    TYPE_INTEGER          INTEGER,
    TYPE_BOOLEAN          DMN_BOOL_3,
    TYPE_DATETIME         DMN_DATETIME,
    TYPE_TXTBLOB          DMN_BLOBTXT,
    TYPE_BINBLOB          DMN_BLOBIMG,
    KIND_ACTION           DMN_KIND_ACTION,
    INS_UPD_DEL_USER      DMN_STRING_100 NOT NULL,
    INS_UPD_DEL_ROLE      DMN_STRING_100 NOT NULL,
    INS_UPD_DEL_DATETIME  DMN_DATETIME,
    DELETED_REC           DMN_BOOL_2,
    UUID                  DMN_UUID
);

ALTER TABLE RDB$DOCSETTINGS ADD CONSTRAINT PK_RDB$DOCSETTINGS PRIMARY KEY (ID);
ALTER TABLE RDB$DOCSETTINGS ADD CONSTRAINT FK_RDB$DOCSETTINGS FOREIGN KEY (PARENT_ID) REFERENCES RDB$DOCSETTINGS (ID) ON DELETE CASCADE ON UPDATE CASCADE;

WITH RECURSIVE TREE (ID,
       PARENT_ID,
       NAME,
       HAS_CHILDREN,
       IS_NODE,
       NOTE,
       TYPE_STRING,
       TYPE_INTEGER,
       TYPE_BOOLEAN,
       TYPE_DATETIME,
       TYPE_TXTBLOB,
       TYPE_BINBLOB)
AS (SELECT ID,
       PARENT_ID,
       NAME,
       HAS_CHILDREN,
       IS_NODE,
       NOTE,
       TYPE_STRING,
       TYPE_INTEGER,
       TYPE_BOOLEAN,
       TYPE_DATETIME,
       TYPE_TXTBLOB,
       TYPE_BINBLOB
    FROM RDB$DOCSETTINGS
    WHERE (UPPER(NAME) = UPPER(:prmName))
    UNION ALL
    SELECT D.ID,
       D.PARENT_ID,
       D.NAME,
       D.HAS_CHILDREN,
       D.IS_NODE,
       D.NOTE,
       D.TYPE_STRING,
       D.TYPE_INTEGER,
       D.TYPE_BOOLEAN,
       D.TYPE_DATETIME,
       D.TYPE_TXTBLOB,
       D.TYPE_BINBLOB
    FROM RDB$DOCSETTINGS D
    INNER JOIN TREE T ON T.ID = D.PARENT_ID
    WHERE (D.PARENT_ID IS NOT NULL))
SELECT *
FROM TREE

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).