Hello Dan, yes, you are right, Thank you. Is there a reason for this?
martin Dan schrieb: > On Jan 9, 2009, at 9:43 PM, Martin.Engelschalk wrote: > > >> 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. >> > > The collation function is only called for sorting (or comparing) text > values. Is it possible that the second set of columns are entirely > populated with numbers, blobs and nulls? > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
