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-issue-importer opened this issue Jul 5, 2007 · 9 comments
Closed

Unexpected "cannot transliterate" error [CORE1347] #1766

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

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Jul 5, 2007

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 5, 2007

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 6, 2007

Modified by: @asfernandes

Fix Version: 2.0.2 [ 10130 ]

Version: 2.0.2 [ 10130 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 29, 2007

Modified by: @pcisar

Link: This issue is related to QA170 [ QA170 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 29, 2007

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 28, 2011

Commented by: @pcisar

Test added.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 28, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

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