Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Aliases can not exceed 31 characters that returns the error ISC error 336068767 [CORE5001] #5289

Closed
firebird-automations opened this issue Nov 9, 2015 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Workdev Tecnologia da Informação LTDA (workdev)

Is related to CORE2350
Is duplicated by CORE5960

SELECT
MO.cod,
CL.pd_crm_promocao,
CL.pd_crm_compra,
CL.co_empresa AS comercial_empresa,
COALESCE(CL.co_admissao, '') AS aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
FROM SM_CD_MO_MOVIMENTADOR MO
JOIN SM_CD_MO_MOVIMENTADOR_CL CL ON CL.cod = MO.cod
LEFT JOIN ST_CD_CIDADES CD_IC ON CL.co_cidade = CD_IC.codigo
LEFT JOIN ST_CD_UF UF_IC ON CD_IC.uf = UF_IC.uf
LEFT JOIN ST_CD_PAIS PA_IC ON UF_IC.pais = PA_IC.cod
LEFT JOIN ST_CD_CIDADES CD_N ON CL.ip_naturalidade = CD_N.codigo
LEFT JOIN ST_CD_UF UF_N ON CD_N.uf = UF_N.uf
LEFT JOIN ST_CD_PAIS PA_N ON UF_N.pais = PA_N.cod
LEFT JOIN SM_CD_MO_MOVIMENTADOR_CL_F FI ON 1 = FI.empresa AND MO.cod = FI.cod
WHERE MO.cod = 3

====== Test Details ======

See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

summary: The Nicknames can not exceed 31 characters that returns the error ISC error 336 068 767 .. => Aliases can not exceed 31 characters that returns the error ISC error 336068767

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

This was done intentionally, see CORE2350.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to CORE2350 [ CORE2350 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Covered by another test(s)

Test Details: See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).

@firebird-automations
Copy link
Collaborator Author

Modified by: @mrotteveel

Link: This issue is duplicated by CORE5960 [ CORE5960 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant