1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
drop database if exists osc;
create database osc;
use osc;
create table t (
i int,
index (i)
);
insert into t values
(1),
(2),
(3),
(10),
(11),
(12),
-- 15 dupes
(13),(13),(13),(13),(13),(13),(13),(13),(13),(13),(13),(13),(13),(13),(13),
(24),
(101),
(102),
(103);
create table t2 (
c char,
index (c)
);
insert into t2 values
('a'), ('a'), ('a'), ('a'), ('a'), ('a'), ('a'), ('b'), ('b'), ('b'), ('c'),
('c'), ('d'), ('d'), ('d'), ('d'),
('e'), ('f'), ('g');
|
