From: | "Paulo" <correio(dot)vip(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5068: LIKE |
Date: | 2009-09-20 01:00:03 |
Message-ID: | 200909200100.n8K1031b001958@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5068
Logged by: Paulo
Email address: correio(dot)vip(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-09-20 03:26:16 | Re: BUG #5066: plperl issues with perl_destruct() and END blocks |
Previous Message | Tom Lane | 2009-09-19 23:33:01 | Re: BUG #5067: vacuum problem |