[MDEV-31538] Cursor protocol cuts result for procedure analyse() - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 11.1, 11.2
Component/s: None
Labels:
None

Description

If ENUM in procedure analyse() contains more than 58 characters, it is truncated:

Testcase:

create table t1 (v varchar(128));

insert into t1 values ('1111111111111111111111111111111111111111111111111111111112345');

select * from t1 procedure analyse();

drop table t1;

Expected result:

Field_name	Min_value	Max_value	Min_length	Max_length	Empties_or_zeros	Nulls	Avg_value_or_avg_length	Std	Optimal_fieldtype

test.t1.v	1111111111111111111111111111111111111111111111111111111112345	1111111111111111111111111111111111111111111111111111111112345	61	61	0	0	61.0000	NULL	ENUM('1111111111111111111111111111111111111111111111111111111112345') NOT NULL

Actual result:

Field_name	Min_value	Max_value	Min_length	Max_length	Empties_or_zeros	Nulls	Avg_value_or_avg_length	Std	Optimal_fieldtype

test.t1.v	1111111111111111111111111111111111111111111111111111111112345	1111111111111111111111111111111111111111111111111111111112345	61	61	0	0	61.0000	NULL	ENUM('1111111111111111111111111111111111111111111111111111111112

Attachments

Issue Links

relates to

MDEV-31005 Make working cursor-protocol

Stalled

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Lena Startseva

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2023-06-26 05:13

Updated:: 2024-05-03 14:41

Git Integration

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