[MDEV-28643] view protocol fails due to different column name - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.3.38
Component/s: Views
Labels:
- view-protocol

Query:

SELECT CONVERT(DES_DECRYPT(0xFF0DC9FC9537CA75F4, CHAR('1' using ucs2)), UNSIGNED);

gives result:

SELECT CONVERT(DES_DECRYPT(0xFF0DC9FC9537CA75F4, CHAR('1' using ucs2)), UNSIGNED);

CONVERT(DES_DECRYPT(0xFF0DC9FC9537CA75F4, CHAR('1' using ucs2)), UNSIGNED)

Warnings:

Warning	1292	Truncated incorrect INTEGER value: 'test'

Query ('FF' is absent at the beginning of the value ):

SELECT CONVERT(DES_DECRYPT(0x0dc9fc9537ca75f4, CHAR('1' using ucs2)), UNSIGNED);

gives result:

SELECT CONVERT(DES_DECRYPT(0x0dc9fc9537ca75f4, CHAR('1' using ucs2)), UNSIGNED);

CONVERT(DES_DECRYPT(0x0dc9fc9537ca75f4, CHAR('1' using ucs2)), UNSIGNED)

Warnings:

Warning	1292	Truncated incorrect INTEGER value: '\x0D\xC9\xFC\x957\xCAu\xF4'

The view (like first 'select'):

CREATE VIEW v1 AS SELECT CONVERT(DES_DECRYPT(0xFF0DC9FC9537CA75F4, CHAR('1' using ucs2)), UNSIGNED);

SELECT * FROM v1;

DROP VIEW v1;

gives text in warning as second query not like first:

CREATE VIEW v1 AS SELECT CONVERT(DES_DECRYPT(0xFF0DC9FC9537CA75F4, CHAR('1' using ucs2)), UNSIGNED);

SELECT * FROM v1;

Name_exp_1

Warnings:

Warning	1292	Truncated incorrect INTEGER value: '\x0D\xC9\xFC\x957\xCAu\xF4'

is part of

MDEV-27691 make working view-protocol

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.