Conversion error from string when using GROUP BY
------------------------------------------------
Key: CORE-3777
URL: http://tracker.firebirdsql.org/browse/CORE-3777
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.1, 2.5.0
Reporter: Maxim Kuzmin
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
T.NAME
FROM
TABLE1 T
GROUP BY
T.NAME,
T.OTHER_FIELD
Firebird returns:
Overflow occurred during data type conversion.
conversion error from string "qqq.".
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
