Invalid string literals and casts behaviour in conjunction with GROUP BY clause
(FB 1.5x)
-----------------------------------------------------------------------------------------
Key: CORE-4048
URL: http://tracker.firebirdsql.org/browse/CORE-4048
Project: Firebird Core
Issue Type: Bug
Components: Engine
Environment: FireBird 1.5x, BDE (but it does not matter)
Reporter: Alexander Volok
Priority: Minor
table XXX(x integer not null primary key, y integer)
data (for example)
x y
1 2
2 3
3 4
SQLrequest SELECT X,SUM(Y),"1234"KLMN,CAST(""AS CHAR(1))ABCD FROM XXX GROUP
BY 1,3,4 (note the erroneus CAST missing near "1234")
returns garbage under 1.5x, and correct data under 2.1x
if change "" to NULL - works ok under 1.5x
if eliminate that "1234"KLMN - works ok under 1.5x
if eliminate CAST(""AS CHAR(1))ABCD - works ok under 1.5x
--
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
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
