1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
create table t1 (a int primary key, b varchar(111), unique index b_idx (b(5)));
insert into t1 values (1, "foobar"),(2,"barbarbar");
insert into t1 values (3, "barbarpub");
Got one of the listed errors
select * from t1;
a b
1 foobar
2 barbarbar
drop table t1;
create table t2 (a int primary key, b varbinary(111), unique index b_idx (b(5)));
insert into t2 values (1, "foobar"),(2,"barbarbar");
insert into t2 values (3, "barbarpub");
Got one of the listed errors
select * from t2;
a b
1 foobar
2 barbarbar
drop table t2;
|