shell del C:\MIX\firebird\QA\fbt-repo\tmp\c3131.fdb 2>nul;
set names utf8;
create database 'localhost/3333:C:\MIX\firebird\QA\fbt-repo\tmp\c3131.fdb';
commit;

set bail on;

recreate table test_lv_sort (
    text      varchar(30) character set win1257 collate win1257_lv,
    sort_idx  varchar(15)
);

insert into test_lv_sort values('Ab', '1');
insert into test_lv_sort values('Az', '2');
insert into test_lv_sort values('Āb', '3');
insert into test_lv_sort values('Āz', '4');
insert into test_lv_sort values('Cb', '5');
insert into test_lv_sort values('Cz', '6');
insert into test_lv_sort values('Čb', '7');
insert into test_lv_sort values('Čz', '8');
insert into test_lv_sort values('Eb', '9');
insert into test_lv_sort values('Ez', '10');
insert into test_lv_sort values('Ēb', '11');
insert into test_lv_sort values('Ēz', '12');
insert into test_lv_sort values('Gb', '13');
insert into test_lv_sort values('Gz', '14');
insert into test_lv_sort values('Ģb', '15');
insert into test_lv_sort values('Ģz', '16');
insert into test_lv_sort values('Ib', '17');
insert into test_lv_sort values('Iz', '18');
insert into test_lv_sort values('Īb', '19');
insert into test_lv_sort values('Īz', '20');
insert into test_lv_sort values('Kb', '21');
insert into test_lv_sort values('Kz', '22');
insert into test_lv_sort values('Ķb', '23');
insert into test_lv_sort values('Ķz', '24');
insert into test_lv_sort values('Lb', '25');
insert into test_lv_sort values('Lz', '26');
insert into test_lv_sort values('Ļb', '27');
insert into test_lv_sort values('Ļz', '28');
insert into test_lv_sort values('Nb', '29');
insert into test_lv_sort values('Nz', '30');
insert into test_lv_sort values('Ņb', '31');
insert into test_lv_sort values('Ņz', '32');
insert into test_lv_sort values('Sb', '33');
insert into test_lv_sort values('Sz', '34');
insert into test_lv_sort values('Šb', '35');
insert into test_lv_sort values('Šz', '36');
insert into test_lv_sort values('Ub', '37');
insert into test_lv_sort values('Uz', '38');
insert into test_lv_sort values('Ūb', '39');
insert into test_lv_sort values('Ūz', '40');
insert into test_lv_sort values('Zb', '41');
insert into test_lv_sort values('Zz', '42');
insert into test_lv_sort values('Žb', '43');
insert into test_lv_sort values('Žz', '44');
COMMIT;

create collation custom_w1257_ci_as
   for win1257 from win1257_lv
   no pad case insensitive accent sensitive;

create collation custom_utf8_ci_as
   for utf8 from unicode 
   no pad case insensitive accent sensitive;
commit;

set count on;
set echo on;

select s.*
from (
    select s.*, row_number()over() as sequential_idx
    from (
        select s.*
        from test_lv_sort s
        order by s.text collate custom_w1257_ci_as
    ) s
) s
where s.sort_idx<>s.sequential_idx
;


select s.*
from (
    select s.*, row_number()over() as sequential_idx
    from (
        select s.*
        from test_lv_sort s
        order by cast(s.text as varchar(30) character set utf8) collate custom_utf8_ci_as
    ) s
) s
where s.sort_idx<>s.sequential_idx
;

select s.*
from (
select s.*, row_number()over() as sequential_idx
from (
  select s.*
  from test_lv_sort s
  order by s.text collate custom_w1257_ci_as
) s
) s
where s.sort_idx<>s.sequential_idx
;
Records affected: 0


select s.*
from (
select s.*, row_number()over() as sequential_idx
from (
  select s.*
  from test_lv_sort s
  order by cast(s.text as varchar(30) character set utf8) collate custom_utf8_ci_as
) s
) s
where s.sort_idx<>s.sequential_idx
;

Āb                             3                                   2 
Az                             2                                   3 
Čb                             7                                   6 
Cz                             6                                   7 
Ēb                             11                                 10 
Ez                             10                                 11 
Ģb                             15                                 14 
Gz                             14                                 15 
Īb                             19                                 18 
Iz                             18                                 19 
Ķb                             23                                 22 
Kz                             22                                 23 
Ļb                             27                                 26 
Lz                             26                                 27 
Ņb                             31                                 30 
Nz                             30                                 31 
Šb                             35                                 34 
Sz                             34                                 35 
Ūb                             39                                 38 
Uz                             38                                 39 
Žb                             43                                 42 
Zz                             42                                 43 

Records affected: 22