EVOLUTION-MANAGER

Edit File: index_multiple_column_unique_decimal.result

drop table if exists t1; create table t1 (c1 int primary key, c2 decimal(65,30), c3 decimal(65,30), unique key uk1(c2,c3)); insert into t1 values(1,123.456,0.000000000000000000000000000001); insert into t1 values(2,-123.456,123.456); insert into t1 values(3,98765432109876543210987654321098765.432109876543210987654321098765,-123.456); insert into t1 values(4,-98765432109876543210987654321098765.432109876543210987654321098765,98765432109876543210987654321098765.432109876543210987654321098765); insert into t1 values(5,0.000000000000000000000000000001,-98765432109876543210987654321098765.432109876543210987654321098765); select c1, c2, c3 from t1 force index(uk1) where c2 = -98765432109876543210987654321098765.432109876543210987654321098765 and c3 = 98765432109876543210987654321098765.432109876543210987654321098765; c1 c2 c3 4 -98765432109876543210987654321098765.432109876543210987654321098765 98765432109876543210987654321098765.432109876543210987654321098765 select c1, c2, c3 from t1 force index(uk1) order by c2, c3; c1 c2 c3 4 -98765432109876543210987654321098765.432109876543210987654321098765 98765432109876543210987654321098765.432109876543210987654321098765 2 -123.456000000000000000000000000000 123.456000000000000000000000000000 5 0.000000000000000000000000000001 -98765432109876543210987654321098765.432109876543210987654321098765 1 123.456000000000000000000000000000 0.000000000000000000000000000001 3 98765432109876543210987654321098765.432109876543210987654321098765 -123.456000000000000000000000000000 select c1, c2, c3 from t1 force index(uk1) order by c2 desc, c3 desc; c1 c2 c3 3 98765432109876543210987654321098765.432109876543210987654321098765 -123.456000000000000000000000000000 1 123.456000000000000000000000000000 0.000000000000000000000000000001 5 0.000000000000000000000000000001 -98765432109876543210987654321098765.432109876543210987654321098765 2 -123.456000000000000000000000000000 123.456000000000000000000000000000 4 -98765432109876543210987654321098765.432109876543210987654321098765 98765432109876543210987654321098765.432109876543210987654321098765 select c2, c3 from t1 force index(uk1) order by c2, c3; c2 c3 -98765432109876543210987654321098765.432109876543210987654321098765 98765432109876543210987654321098765.432109876543210987654321098765 -123.456000000000000000000000000000 123.456000000000000000000000000000 0.000000000000000000000000000001 -98765432109876543210987654321098765.432109876543210987654321098765 123.456000000000000000000000000000 0.000000000000000000000000000001 98765432109876543210987654321098765.432109876543210987654321098765 -123.456000000000000000000000000000 insert into t1 values(6,123.456,0.000000000000000000000000000001); ERROR 23000: Duplicate entry '123.456000000000000000000000000000-0.000000000000000000000000000' for key 'uk1' delete from t1 where c1 = 1; insert into t1 values(1,123.456,0.000000000000000000000000000001); drop table t1;