Error "Invalid expression in the select list" can be unexpectedly raised if a
string literal is used inside a GROUP BY clause in a multi-byte connection
--------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-3807
URL: http://tracker.firebirdsql.org/browse/CORE-3807
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1, 2.1.4, 2.5.0, 3.0 Initial, 2.1.3, 2.1.2, 2.1.1,
2.1.0
Reporter: Dmitry Yemanov
Simplified test case (to be executed with connection charset = UTF-8):
select
'Current time is ' || cast(a.t as varchar(10))
from
(select current_time t from rdb$database) a
group by
'Current time is ' || cast(a.t as varchar(10))
-- ERROR:
-- Invalid expression in the select list (not contained in either an aggregate
function or the GROUP BY clause)
--
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
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
