Submitted by: Maxim Kuzmin (cybermax)

Is related to QA494

Metadata:
CREATE TABLE TABLE2 (
ID INTEGER NOT NULL,
NAME VARCHAR(50)
);
ALTER TABLE TABLE2 ADD CONSTRAINT PK_TABLE2 PRIMARY KEY (ID);

CREATE TABLE TABLE1 (
ID INTEGER NOT NULL,
ID_NAME INTEGER,
NAME COMPUTED BY (COALESCE((SELECT NAME FROM TABLE2 WHERE ID = ID_NAME) || '.', '')),
OTHER_FIELD INTEGER
);
ALTER TABLE TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY (ID);

Data:
INSERT INTO TABLE2 (ID, NAME) VALUES (1, 'qqq');
INSERT INTO TABLE2 (ID, NAME) VALUES (2, 'www');
INSERT INTO TABLE2 (ID, NAME) VALUES (3, 'eee');

INSERT INTO TABLE1 (ID, ID_NAME, OTHER_FIELD) VALUES (1, 1, 100);
INSERT INTO TABLE1 (ID, ID_NAME, OTHER_FIELD) VALUES (2, 2, 101);
INSERT INTO TABLE1 (ID, ID_NAME, OTHER_FIELD) VALUES (3, 3, 102);

Query:
SELECT
http://T.NAME
FROM
TABLE1 T
GROUP BY
http://T.NAME,
T.OTHER_FIELD

Firebird returns:
Overflow occurred during data type conversion.
conversion error from string "qqq.".

Commits: b266e11 7fcc8b1 FirebirdSQL/fbt-repository@3f76801