BUG #5068: LIKE
От | Paulo |
---|---|
Тема | BUG #5068: LIKE |
Дата | |
Msg-id | 200909200100.n8K1031b001958@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5068: LIKE
(Peter Eisentraut <peter_e@gmx.net>)
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5068 Logged by: Paulo Email address: correio.vip@gmail.com PostgreSQL version: 8.4 Operating system: win2003 Description: LIKE Details: like to select a field containing Numeric 4 and compared with a char(30) field. In oracle and postgresql to version 8.2 worked perfectly, now the new version no longer works, as we have many queries in this format. attached to select what worked and from 8.4 no longer works, which featured not work and select track ... ("A"."ACL_CdCurLet" LIKE btrim(:DB-LIKE)) OR ( (UPPER(translate(btrim("B"."ALE_Ano"), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) LIKE (UPPER(translate(btrim(:DB-LIKE), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) ) EXEC SQL DECLARE CSR-CURLET CURSOR FOR SELECT "A"."EMP_CdEmpresa" ,"A"."ACL_CdCurLet" ,"A"."ALE_CdLetivo" ,"A"."ACU_CdCurso" ,"A"."ACL_NrAulasDia" ,"A"."ACL_DuracaoAula" ,"A"."ACL_Nome" ,"B"."EMP_CdEmpresa" ,"B"."ALE_CdLetivo" ,"B"."ALE_Ano" ,"B"."ALE_Periodo" ,"B"."ALE_NmLetivo" ,"B"."ALE_DataInicio" ,"B"."ALE_DataFinal" ,"C"."ACU_CdCurso" ,"C"."ACU_NmCurso" ,"C"."ACU_AbrCurso" ,"C"."AEN_CdEnsino" ,"D"."AEN_CdEnsino" ,"D"."AEN_NmEnsino" ,"D"."AEN_AbrEnsino" FROM "aMatCurr" "A" ,"aLETIVO" "B" ,"aCURSO" "C" ,"aENSINO" "D" WHERE ( "A"."EMP_CdEmpresa" = "B"."EMP_CdEmpresa" ) AND ( "A"."ALE_CdLetivo" = "B"."ALE_CdLetivo" ) AND ( "A"."ACU_CdCurso" = "C"."ACU_CdCurso" ) AND ( "C"."AEN_CdEnsino" = "D"."AEN_CdEnsino" ) AND ( "B"."EMP_CdEmpresa" = :aLETIVO-EMP-CdEmpresa ) AND ( ("A"."ACL_CdCurLet" LIKE btrim(:DB-LIKE)) OR ( (UPPER(translate(btrim("B"."ALE_Ano"), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) LIKE (UPPER(translate(btrim(:DB-LIKE), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) ) OR ( (UPPER(translate(btrim("C"."ACU_NmCurso"), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) LIKE (UPPER(translate(btrim(:DB-LIKE), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) ) OR ( (UPPER(translate(btrim("C"."ACU_AbrCurso"), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) LIKE (UPPER(translate(btrim(:DB-LIKE), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) ) OR ( (UPPER(translate(btrim("D"."AEN_NmEnsino"), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) LIKE (UPPER(translate(btrim(:DB-LIKE), 'ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃKZYW', 'AAAAAEEEEIIIIOOOOOUUUUCCSIV'))) ) ) ORDER BY "B"."ALE_Ano" ,"C"."ACU_NmCurso" ,"A"."ACL_Nome" LIMIT :w-Limit END-EXEC
В списке pgsql-bugs по дате отправления:
Следующее
От: Robert HaasДата:
Сообщение: Re: BUG #5066: plperl issues with perl_destruct() and END blocks