Hello list,
I definied a collation and used it in the order by - clauses of queries.
In one query, sqlite calls the collation function, and in the other
query, it does not (i checked by inserting a printf inside the collation
function).
The queries differ only in the order by - clause.
This query Works OK:
select d1._recno,
d1._source_id,
d1._source_position,
d1._source_len,
d1._source_lfd,
d1._list_id,
d1._list_lfd,
d1._country,
coalesce(d2._skip,d1._skip) _skip ,
coalesce(d1._skip,d2._skip) _state_num ,
d2.f_mail2Group f_mail2Group,
d2.f_mail2Code f_mail2Code,
d2.f_mail2Stat f_mail2Stat,
d1.f_FirstName f_FirstName,
d1.f_LastName f_LastName,
d1.f_StreetLine f_StreetLine,
d1.f_Zip f_Zip,
d1.f_CityName f_CityName,
d2.f_Bewertung f_Bewertung,
d2.f_Dublettengruppennummer f_Dublettengruppennummer,
d2.f_Dublettentyp f_Dublettentyp
from data1 d1 left outer join data2 d2 on d2._recno = d1._recno
order by 11 collate DQS_NUM_ASC, 13 collate DQS_NUM_ASC, 12 collate
DQS_NUM_ASC
If I change the oder by - clause to the following, the collation
function ist not called, and the result list is sorted in the standard
order.
order by 20 collate DQS_NUM_ASC, 21 collate DQS_NUM_ASC, 19 collate
DQS_NUM_ASC
All fields of the table "data2 d2" are defined as type "integer"
My version is 3.2.5.
Does anyone have an idea? Might it be a good idea to upgrade to the
newest version? I want do do this only if really necessary.
Thanks,
Martin
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
