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
34
35
36
37
38
39
40
41
42
43
44
45
|
DROP DATABASE IF EXISTS issue_96;
CREATE DATABASE issue_96;
USE issue_96;
DROP TABLE IF EXISTS t;
CREATE TABLE `t` (
`package_id` bigint(20) unsigned default NULL,
`location` varchar(4) default NULL,
`from_city` varchar(100) default NULL,
UNIQUE KEY `package_id` (`package_id`,`location`)
) ENGINE=InnoDB;
INSERT INTO t VALUES
(1,'ABC','lo'),
(NULL,'CHY','ch'),
(2,'BFN','na'),
(NULL,NULL,'gl'),
(12,'TTT','ty'),
(4,'CPR','ta'),
(8,'CSX','dz'),
(9,NULL,NULL),
(NULL,NULL,NULL),
(11,'PBR',NULL),
(NULL,'THR',NULL),
(6,NULL,'jr');
-- For TableSyncer.t
DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (
`package_id` bigint(20) unsigned default NULL,
`location` varchar(4) default NULL,
`from_city` varchar(100) default NULL,
UNIQUE KEY `package_id` (`package_id`,`location`)
) ENGINE=InnoDB;
INSERT INTO t2 VALUES
(1,'ABC','lo'),
(NULL,'CHY','ch'),
(2,'BFN','na'),
(NULL,NULL,'gl'),
(12,'TTT','ty'),
(4,'CPR','zz'), -- different than t
(8,'CSX','dz'),
(9,NULL,NULL),
(NULL,NULL,NULL),
(11,'PBR',NULL),
(NULL,'THR',NULL),
(6,NULL,'jr');
|
