[Firebird-devel] [ firebird-Bugs-1183979 ] Incorrect SELECT..ORDER BY field

[SourceForge.net <no...@so...>]

Bugs item #1183979, was opened at 2005-04-15 16:58
Message generated for change (Tracker Item Submitted) made by Item Submitter
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

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1183979&group_id=9028