Wrong result for RIGHT(UTF8 varchar) [CORE3277]

[firebird-automations]

Submitted by: 1g0r (1g0r)

example of the issue:

{{SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);}}

||VAL||LEFT||RIGHT||
|АБВГД|АБ| |

RIGHT() returns an empty string

Commits: cdd8620 1a1e892

[firebird-automations]

Modified by: 1g0r (1g0r)

description: example of the issue:

SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);

VAL LEFT RIGHT
========== ========== ==========
АБВГД АБ

RIGHT() returns an empty string

=>

example of the issue:

SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);

VAL LEFT RIGHT <BR>
========== ========== ==========
АБВГД АБ

RIGHT() returns an empty string

[firebird-automations]

Modified by: 1g0r (1g0r)

description: example of the issue:

SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);

VAL LEFT RIGHT <BR>
========== ========== ==========
АБВГД АБ

RIGHT() returns an empty string

=>

example of the issue:

SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);

VAL LEFT RIGHT
========== ========== ==========
АБВГД АБ

RIGHT() returns an empty string

[firebird-automations]

Modified by: 1g0r (1g0r)

security: Developers [ 10012 ] =>

[firebird-automations]

Commented by: @dyemanov

Confirmed for both 2.5.0 and 2.5.1.

[firebird-automations]

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: 1g0r (1g0r)

description: example of the issue:

SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);

VAL LEFT RIGHT
========== ========== ==========
АБВГД АБ

RIGHT() returns an empty string

=>

example of the issue:

{{SELECT VAL,
LEFT(VAL, 2),
RIGHT(VAL, 2)
FROM (SELECT CAST('АБВГД' AS VARCHAR(10) CHARACTER SET UTF8) VAL
FROM RDB$DATABASE);}}

||VAL||LEFT||RIGHT||
|АБВГД|АБ| |

RIGHT() returns an empty string

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: Done successfully