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

Unexpected "cannot transliterate" error [CORE1347] #1766

Closed
firebird-automations opened this issue Jul 5, 2007 · 9 comments
Closed

Unexpected "cannot transliterate" error [CORE1347] #1766

firebird-automations opened this issue Jul 5, 2007 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @asfernandes

Is related to QA170

Reported by Dmitry:

I see a very weird situation. A database and connection charsets are win1251, database is empty and it's in ODS11.1:

CREATE PROCEDURE P (
P_TABLENAME VARCHAR(30) ,
P_IDNAME VARCHAR(30) ,
P_SEQNAME VARCHAR(30) ,
P_ISUSEFUNC SMALLINT
)
RETURNS (
COLUMN_VALUE BIGINT
)
AS
declare variable l_MaxId bigint;
begin
/*
-- Находим разрыв в значениях ПК таблицы
-- если разрыв отсутствует то дергаем секвенс
-- p_IsUseFunc=1 - дергать секвенс ч/з ф-цию GetSeqValue
*/
end

The text is in cp1251 too.

Now, if I query:

SELECT PR.rdb$procedure_name
FROM RDB$PROCEDURES PR
WHERE PR.RDB$PROCEDURE_SOURCE containing '1'
and PR.rdb$procedure_name='P'

I get the error "cannot transliterate". If I remove at least one of the hyphens, the query succeeds. But a removal of any other character doesn't help.

It looks like a bug, but with very unusual symptoms.

Commits: e60160a e68d7a2

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Fix Version: 2.0.2 [ 10130 ]

Version: 2.0.2 [ 10130 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA170 [ QA170 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

description: Reported by Dmitry:

I see a very weird situation. A database and connection charsets are win1251, database is empty and it's in ODS11.1:

CREATE PROCEDURE P (
P_TABLENAME VARCHAR(30) ,
P_IDNAME VARCHAR(30) ,
P_SEQNAME VARCHAR(30) ,
P_ISUSEFUNC SMALLINT
)
RETURNS (
COLUMN_VALUE BIGINT
)
AS
declare variable l_MaxId bigint;
begin
/*
-- ??????? ?????? ? ????????? ?? ???????
-- ???? ?????? ??????????? ?? ??????? ???????
-- p_IsUseFunc=1 - ??????? ??????? ?/? ?-??? GetSeqValue
*/
end

The text is in cp1251 too.

Now, if I query:

SELECT PR.rdb$procedure_name
FROM RDB$PROCEDURES PR
WHERE PR.RDB$PROCEDURE_SOURCE containing '1'
and PR.rdb$procedure_name='P'

I get the error "cannot transliterate". If I remove at least one of the hyphens, the query succeeds. But a removal of any other character doesn't help.

It looks like a bug, but with very unusual symptoms.

=>

Reported by Dmitry:

I see a very weird situation. A database and connection charsets are win1251, database is empty and it's in ODS11.1:

CREATE PROCEDURE P (
P_TABLENAME VARCHAR(30) ,
P_IDNAME VARCHAR(30) ,
P_SEQNAME VARCHAR(30) ,
P_ISUSEFUNC SMALLINT
)
RETURNS (
COLUMN_VALUE BIGINT
)
AS
declare variable l_MaxId bigint;
begin
/*
-- Находим разрыв в значениях ПК таблицы
-- если разрыв отсутствует то дергаем секвенс
-- p_IsUseFunc=1 - дергать секвенс ч/з ф-цию GetSeqValue
*/
end

The text is in cp1251 too.

Now, if I query:

SELECT PR.rdb$procedure_name
FROM RDB$PROCEDURES PR
WHERE PR.RDB$PROCEDURE_SOURCE containing '1'
and PR.rdb$procedure_name='P'

I get the error "cannot transliterate". If I remove at least one of the hyphens, the query succeeds. But a removal of any other character doesn't help.

It looks like a bug, but with very unusual symptoms.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 12512 ] => Firebird [ 15046 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

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