Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
MCOL Sprint 2 - Priority 2
Description
For bug3783, we have:
drop table if exists bug3783;
set max_length_for_sort_data = 4096;
create table bug3783 (id int, name varchar(1000))engine=infinidb;
insert into bug3783 values (1,'yionfsdayfeiwajg'),(2,'gretsuyhejkstj jkete');
select id, hex(name) from bug3783 order by 1,2;
The query fails for us but it didn't used to. However, the artificial setting of max_length_for_sort_data is triggering the problem. Nobody should do that.