Issue Details (XML | Word | Printable)

Key: CORE-1347
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Unexpected "cannot transliterate" error

Created: 05/Jul/07 11:37 AM   Updated: 28/Feb/11 12:52 PM
Component/s: Charsets/Collation, Engine
Affects Version/s: 2.0.0, 2.0.1, 2.1 Alpha 1, 2.1 Beta 1
Fix Version/s: 2.0.2, 2.1 Beta 2

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
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.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 28/Feb/11 12:52 PM
Test added.