String truncation error when concatenating _UTF8 string onto extract(year result [CORE1255] #1679
Submitted by: Richard Wesley (hawkfish)
Is related to QA133
SELECT ((EXTRACT(YEAR FROM CURRENT_DATE) || _UTF8'')) col FROM rdb$database GROUP BY 1;
Produces the error
It should just return a column with a single value '2007'. Note that both the _UTF8 introducer and the GROUP BY are needed.
The text was updated successfully, but these errors were encountered: