Index on field defined with "collate unicode_ci" is not used in GROUP BY on
that field
--------------------------------------------------------------------------------------
Key: CORE-4787
URL: http://tracker.firebirdsql.org/browse/CORE-4787
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.5.4, 3.0 Beta 1, 3.0 Beta 2
Reporter: Pavel Zotov
SQL> recreate table t2(a varchar(10) character set utf8 collate unicode_ci);
commit;
SQL> insert into t2 select left(uuid_to_char(gen_uuid()),10) from
rdb$types,rdb$types; commit;
SQL> create index t2_a on t2(a); commit;
SQL> set planonly;
SQL> select a from t2 group by a;
PLAN SORT ((T2 NATURAL))
Reproduced on WI-V2.5.5.26865, WI-T3.0.0.31828.
PS. Sorry if this ticket duplicates something old: I can`t get rid of sense
that this question already was discussed but could not find corresp. ticket.
--
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
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
