From: SourceForge.net <no...@so...> - 2005-04-17 13:48:33
|
Bugs item #1183979, was opened at 2005-04-15 16:58 Message generated for change (Comment added) made by danielrail You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1183979&group_id=9028 Category: ISQL Group: Feature v1.5 Status: Open Resolution: None Priority: 5 Submitted By: Neto (fco_ernesto) Assigned to: Nobody/Anonymous (nobody) Summary: Incorrect SELECT..ORDER BY field Initial Comment: I think that is a bug: I tried to do a simple select ordered by field 'FUNCIONARIO.NOME', but the value 'EDNA MARIA' appear after 'EDNALVA DOS SANTOS SOARES' and is incorrect ( space after 'L' ?). This error apear on Interbase 6 too. Can you help me?! Im sending the database backup generated with gbak too. This is the SELECT SQL: -------------------------------------------------- SELECT FUNCIONARIO.MATRICULA, FUNCIONARIO.NOME, FUNCIONARIO.CPF, FUNCIONARIO.COD_FUNCAO, FUNCIONARIO.COD_CARGO, FUNCIONARIO.COD_SECRETARIA, FUNCIONARIO.COD_LOTACAO, FUNCIONARIO.COD_UNDTRABALHO, FUNCIONARIO.DT_ADMISSAO, FOLHA.COD_FOLHA, FOLHA.SALARIOBASE, FOLHA.BASEPREVIDENCIA, FOLHA.BASEFGTS, FOLHA.VALORFGTS, FOLHA.BASEIRRF, FOLHA.TOTALVENCIMENTOS, FOLHA.TOTALDESCONTOS, FOLHA.VALORLIQUIDO, FOLHA.CAPTION_CARGO_FUNCAO, FOLHA.DESC_CARGO_FUNCAO, FOLHA.COMPETENCIA, FOLHA.DT_PAGAMENTO FROM FUNCIONARIO INNER JOIN FOLHA ON (FUNCIONARIO.MATRICULA = FOLHA.MATRICULA) WHERE (FUNCIONARIO.COD_SECRETARIA = '7') AND (FOLHA.COMPETENCIA = '03200500') ORDER BY FUNCIONARIO.COD_SECRETARIA, FUNCIONARIO.NOME ---------------------------------------------------------------------- Comment By: Daniel Rail (danielrail) Date: 2005-04-17 10:48 Message: Logged In: YES user_id=238419 What are the character set and the collation that you are using? It's possible that the collation that you are using uses the dictionary sort, which in most collations ignores the space and punctuation characters when sorting. This is probably what you are seeing and that would not be a bug. Daniel Rail ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1183979&group_id=9028 |