firebird-automations

Modified by: @dyemanov Fix Version: 3\.0\.0 \[ 10048 \]

Modified by: @dyemanov Fix Version: 3\.0 RC2 \[ 10048 \] =\>

Modified by: @dyemanov summary: Performance degradation on nested loops when joining big table "A" and small "B" on indexed field 'X' which is STARTING part of compound index \{"X", "Y"\}...

Commented by: @dyemanov I'm not sure this is a bug, more or less "as designed"\. An implicit join replaces X \(unqualified\) with COALESCE\(A\.X, B\.X\) \-\- this is a handy trick...

Commented by: @asfernandes It's supposed to work only if the unicode characters are included in the system ANSI codepage\. There is another ticket opened about full support for Unicode\.

Commented by: @asfernandes Duplicates [CORE2172](https://github.com/FirebirdSQL/firebird/issues?q=CORE2172+in%3Atitle)\.

Modified by: @asfernandes status: Open \[ 1 \] =\> Resolved \[ 5 \] resolution: Duplicate \[ 3 \]

Modified by: @asfernandes Link: This issue duplicates [CORE2172](https://github.com/FirebirdSQL/firebird/issues?q=CORE2172+in%3Atitle) \[ [CORE2172](https://github.com/FirebirdSQL/firebird/issues?q=CORE2172+in%3Atitle) \]

Modified by: @pcisar status: Resolved \[ 5 \] =\> Closed \[ 6 \]

Commented by: @aafemt This ticket is not a duplicate because is caused not by lack of Unicode support in engine, but unnesessary recoding of UTF\-8 file names into ANSI code...