866 lines
20 KiB
Plaintext
866 lines
20 KiB
Plaintext
set @@tidb_partition_prune_mode='dynamic';
|
|
drop table if exists t1;
|
|
CREATE TABLE t1 ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, num float(9,8) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin PARTITION BY HASH (id) PARTITIONS 128;
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(6404,0.44816685),
|
|
(6532,0.7986926),
|
|
(6660,0.00085072),
|
|
(6788,0.00002967),
|
|
(6916,0.0),
|
|
(7044,0.03088332),
|
|
(7172,0.00046703),
|
|
(7300,0.00568179),
|
|
(7428,0.33018935),
|
|
(7556,0.00455456);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(7684,0.36683157),
|
|
(7812,0.6140698),
|
|
(7940,0.10177323),
|
|
(8068,0.00434905),
|
|
(8196,0.07348831),
|
|
(8324,0.00006405),
|
|
(8452,0.02007892),
|
|
(8580,0.01050341),
|
|
(8708,0.00030031),
|
|
(8836,0.02070964);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(8964,0.02303072),
|
|
(9092,0.44560316),
|
|
(9220,0.00069178),
|
|
(9348,0.06521516),
|
|
(9476,NULL),
|
|
(9604,0.01747504),
|
|
(9732,0.6579575),
|
|
(9860,0.0025045),
|
|
(9988,0.03484399),
|
|
(10116,0.00193867);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(10244,0.0),
|
|
(10372,0.0007868),
|
|
(10500,0.00031922),
|
|
(10628,0.09769934),
|
|
(10756,0.00715676),
|
|
(10884,NULL),
|
|
(11012,0.30375117),
|
|
(11140,0.7572566),
|
|
(11268,0.00018916),
|
|
(11396,0.00969914);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(11524,0.05069033),
|
|
(11652,0.25621885),
|
|
(11780,0.00468599),
|
|
(11908,NULL),
|
|
(12036,0.00011619),
|
|
(12164,0.05855278),
|
|
(12292,0.00367099),
|
|
(12420,0.9929275),
|
|
(12548,0.15242451),
|
|
(12676,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(12804,0.0246472),
|
|
(12932,0.00472382),
|
|
(13060,NULL),
|
|
(13188,0.93716323),
|
|
(13316,NULL),
|
|
(13444,0.01234986),
|
|
(13572,0.00076421),
|
|
(13700,0.0),
|
|
(13828,NULL),
|
|
(13956,0.12757756);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(14084,0.00484138),
|
|
(14212,0.02226818),
|
|
(14340,0.00265866),
|
|
(14468,0.0016064),
|
|
(14596,0.8862497),
|
|
(14724,0.00004634),
|
|
(14852,0.00835311),
|
|
(14980,0.55768555),
|
|
(15108,0.04359115),
|
|
(15236,0.00277844);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(15364,NULL),
|
|
(15492,NULL),
|
|
(15620,0.01908805),
|
|
(15748,0.12949005),
|
|
(15876,0.00305156),
|
|
(16004,0.00148819),
|
|
(16132,0.5249692),
|
|
(16260,0.14020711),
|
|
(16388,0.16946065),
|
|
(16516,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(16644,0.00692773),
|
|
(16772,0.00527069),
|
|
(16900,NULL),
|
|
(17028,0.00114955),
|
|
(17156,0.00134839),
|
|
(17284,0.02818464),
|
|
(17412,NULL),
|
|
(17540,0.0),
|
|
(17668,0.00351416),
|
|
(17796,0.00437542);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(17924,0.0012496),
|
|
(18052,0.00040084),
|
|
(18180,0.35637453),
|
|
(18308,0.0220884),
|
|
(18436,0.0020587),
|
|
(18564,0.00297463),
|
|
(18692,0.00487483),
|
|
(18820,0.00246549),
|
|
(18948,NULL),
|
|
(19076,0.9188499);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(19204,0.0168393),
|
|
(19332,0.00016338),
|
|
(19460,0.0),
|
|
(19588,0.28465533),
|
|
(19716,0.00008774),
|
|
(19844,0.0),
|
|
(19972,0.46484554),
|
|
(20100,0.00113875),
|
|
(20228,0.02503506),
|
|
(20356,0.01585903);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(20484,0.84865177),
|
|
(20612,0.00004633),
|
|
(20740,0.00002771),
|
|
(20868,0.17606646),
|
|
(20996,NULL),
|
|
(21124,NULL),
|
|
(21252,0.06745174),
|
|
(21380,NULL),
|
|
(21508,0.06476934),
|
|
(21636,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(21764,0.05436462),
|
|
(21892,0.0),
|
|
(22020,0.01013111),
|
|
(22148,0.72076213),
|
|
(22276,0.00758889),
|
|
(22404,NULL),
|
|
(22532,0.01502812),
|
|
(22660,0.03836808),
|
|
(22788,0.01743244),
|
|
(22916,0.90398115);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(23044,0.39467624),
|
|
(23172,0.9271143),
|
|
(23300,0.0),
|
|
(23428,NULL),
|
|
(23556,0.01379231),
|
|
(23684,0.0557244),
|
|
(23812,NULL),
|
|
(23940,0.00256223),
|
|
(24068,0.05586718),
|
|
(24196,0.00675368);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(24324,0.00235754),
|
|
(24452,0.00048123),
|
|
(24580,0.00684315),
|
|
(24708,0.00022108),
|
|
(24836,0.8159851),
|
|
(24964,0.00049652),
|
|
(25092,0.11392157),
|
|
(25220,0.21413554),
|
|
(25348,0.00061148),
|
|
(25476,0.00622709);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(25604,0.00213495),
|
|
(25732,NULL),
|
|
(25860,NULL),
|
|
(25988,0.0),
|
|
(26116,0.02214408),
|
|
(26244,0.03450824),
|
|
(26372,0.85039985),
|
|
(26500,0.00969678),
|
|
(26628,0.01092109),
|
|
(26756,0.07614598);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(26884,0.02030184),
|
|
(27012,0.0),
|
|
(27140,0.7304159),
|
|
(27268,0.05062966),
|
|
(27396,0.07090286),
|
|
(27524,0.00589924),
|
|
(27652,0.00982369),
|
|
(27780,0.01139362),
|
|
(27908,0.12942761),
|
|
(28036,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(28164,0.973725),
|
|
(28292,0.0),
|
|
(28420,0.9658361),
|
|
(28548,0.7608606),
|
|
(28676,0.00033382),
|
|
(28804,0.0006193),
|
|
(28932,0.01344005),
|
|
(29060,0.00213988),
|
|
(29188,0.20606396),
|
|
(29316,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(29444,0.00029995),
|
|
(29572,0.11128831),
|
|
(29700,0.00022049),
|
|
(29828,0.09755096),
|
|
(29956,0.0),
|
|
(30084,0.15368505),
|
|
(30212,0.00385346),
|
|
(30340,NULL),
|
|
(30468,0.03264421),
|
|
(30596,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(30724,0.02093143),
|
|
(30852,0.00251696),
|
|
(30980,NULL),
|
|
(31108,0.5892975),
|
|
(31236,0.15591888),
|
|
(31364,NULL),
|
|
(31492,0.13643512),
|
|
(31620,0.0),
|
|
(31748,0.0124521),
|
|
(31876,0.10001199);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(32004,0.9572708),
|
|
(32132,0.2702167),
|
|
(32260,0.0),
|
|
(32388,NULL),
|
|
(32516,0.00197053),
|
|
(32644,NULL),
|
|
(32772,0.00294003),
|
|
(32900,0.0001796),
|
|
(33028,0.00109745),
|
|
(33156,0.00084148);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(33284,0.02335174),
|
|
(33412,NULL),
|
|
(33540,NULL),
|
|
(33668,0.00069347),
|
|
(33796,0.00317112),
|
|
(33924,0.00514138),
|
|
(34052,0.0),
|
|
(34180,0.20418067),
|
|
(34308,0.21699235),
|
|
(34436,0.00151851);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(34564,0.00260781),
|
|
(34692,0.00042542),
|
|
(34820,NULL),
|
|
(34948,0.0001932),
|
|
(35076,0.0),
|
|
(35204,0.00023503),
|
|
(35332,0.27567366),
|
|
(35460,0.00029132),
|
|
(35588,0.0038553),
|
|
(35716,0.00028413);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(35844,0.0001824),
|
|
(35972,0.8047172),
|
|
(36100,0.9117202),
|
|
(36228,0.00090282),
|
|
(36356,0.00003453),
|
|
(36484,0.00177934),
|
|
(36612,0.02046586),
|
|
(36740,0.00146691),
|
|
(36868,0.00613281),
|
|
(36996,0.02881232);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(37124,0.0),
|
|
(37252,0.5468523),
|
|
(37380,0.0),
|
|
(37508,NULL),
|
|
(37636,NULL),
|
|
(37764,0.08866176),
|
|
(37892,0.01583531),
|
|
(38020,0.00258847),
|
|
(38148,0.0),
|
|
(38276,0.0013263);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(38404,0.00610365),
|
|
(38532,0.0022153),
|
|
(38660,0.00080778),
|
|
(38788,0.19915293),
|
|
(38916,NULL),
|
|
(39044,0.0266057),
|
|
(39172,0.02324441),
|
|
(39300,0.00193156),
|
|
(39428,0.00059531),
|
|
(39556,0.10964896);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(39684,0.02697241),
|
|
(39812,0.00929319),
|
|
(39940,0.00053213),
|
|
(40068,0.0),
|
|
(40196,0.00294272),
|
|
(40324,NULL),
|
|
(40452,NULL),
|
|
(40580,NULL),
|
|
(40708,0.08479243),
|
|
(40836,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(40964,NULL),
|
|
(41092,0.2487916),
|
|
(41220,NULL),
|
|
(41348,0.00043917),
|
|
(41476,0.0),
|
|
(41604,0.00049506),
|
|
(41732,0.00250602),
|
|
(41860,0.00011041),
|
|
(41988,0.01406988),
|
|
(42116,0.00199188);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(42244,0.2924709),
|
|
(42372,NULL),
|
|
(42500,0.01702607),
|
|
(42628,NULL),
|
|
(42756,0.15324448),
|
|
(42884,0.13135524),
|
|
(43012,0.01943198),
|
|
(43140,0.00188494),
|
|
(43268,0.00071816),
|
|
(43396,0.00012918);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(43524,0.00498049),
|
|
(43652,0.13445085),
|
|
(43780,0.14880875),
|
|
(43908,0.00077732),
|
|
(44036,0.54969823),
|
|
(44164,0.02765146),
|
|
(44292,0.00238847),
|
|
(44420,0.93815935),
|
|
(44548,0.00112602),
|
|
(44676,0.00970578);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(44804,0.00539565),
|
|
(44932,0.00198959),
|
|
(45060,NULL),
|
|
(45188,0.0004845),
|
|
(45316,0.11085703),
|
|
(45444,0.00036987),
|
|
(45572,0.00451057),
|
|
(45700,0.00005143),
|
|
(45828,NULL),
|
|
(45956,0.02388487);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(46084,0.00037795),
|
|
(46212,NULL),
|
|
(46340,0.05443271),
|
|
(46468,0.02153216),
|
|
(46596,NULL),
|
|
(46724,0.0),
|
|
(46852,0.38851526),
|
|
(46980,0.7427731),
|
|
(47108,0.03969904),
|
|
(47236,0.00078965);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(47364,0.03562958),
|
|
(47492,0.00100583),
|
|
(47620,0.03697728),
|
|
(47748,0.08408318),
|
|
(47876,0.00057393),
|
|
(48004,0.00710408),
|
|
(48132,0.01589785),
|
|
(48260,NULL),
|
|
(48388,0.0029398),
|
|
(48516,0.0168582);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(48644,0.15535928),
|
|
(48772,0.04729551),
|
|
(48900,0.00045675),
|
|
(49028,0.111338),
|
|
(49156,0.05104741),
|
|
(49284,0.00957311),
|
|
(49412,0.00032368),
|
|
(49540,0.0011836),
|
|
(49668,0.59423715),
|
|
(49796,0.07930596);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(49924,0.00970574),
|
|
(50052,0.1389579),
|
|
(50180,0.01344621),
|
|
(50308,0.02605027),
|
|
(50436,0.81112456),
|
|
(50564,0.08266076),
|
|
(50692,0.00064055),
|
|
(50820,0.00506184),
|
|
(50948,0.07310118),
|
|
(51076,0.08932291);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(51204,0.00027035),
|
|
(51332,0.00340637),
|
|
(51460,0.03478277),
|
|
(51588,0.00016421),
|
|
(51716,0.01174176),
|
|
(51844,0.28394622),
|
|
(51972,0.09893544),
|
|
(52100,0.9233999),
|
|
(52228,0.00086335),
|
|
(52356,0.0101455);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(52484,0.0),
|
|
(52612,0.04069425),
|
|
(52740,0.00043829),
|
|
(52868,0.00023583),
|
|
(52996,0.00259821),
|
|
(53124,NULL),
|
|
(53252,0.13227282),
|
|
(53380,NULL),
|
|
(53508,0.00010061),
|
|
(53636,0.00038794);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(53764,0.34211513),
|
|
(53892,0.02905787),
|
|
(54020,0.06862675),
|
|
(54148,NULL),
|
|
(54276,0.0),
|
|
(54404,0.0),
|
|
(54532,0.00019574),
|
|
(54660,0.03211332),
|
|
(54788,0.61193645),
|
|
(54916,0.00076543);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(55044,0.0),
|
|
(55172,0.00331305),
|
|
(55300,0.28308892),
|
|
(55428,0.34937865),
|
|
(55556,0.0749846),
|
|
(55684,0.00009996),
|
|
(55812,0.0188099),
|
|
(55940,0.0161851),
|
|
(56068,NULL),
|
|
(56196,0.4822152);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(56324,0.00293867),
|
|
(56452,0.00180932),
|
|
(56580,0.00598398),
|
|
(56708,0.9666414),
|
|
(56836,0.01628674),
|
|
(56964,0.97586924),
|
|
(57092,0.000337),
|
|
(57220,0.01060274),
|
|
(57348,0.0002598),
|
|
(57476,0.00377207);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(57604,0.00066885),
|
|
(57732,0.12196585),
|
|
(57860,0.00030946),
|
|
(57988,0.20773576),
|
|
(58116,0.00061379),
|
|
(58244,0.01043255),
|
|
(58372,0.00191419),
|
|
(58500,0.001862),
|
|
(58628,NULL),
|
|
(58756,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(58884,NULL),
|
|
(59012,0.0),
|
|
(59140,0.00029226),
|
|
(59268,0.0),
|
|
(59396,0.00449778),
|
|
(59524,0.02558722),
|
|
(59652,NULL),
|
|
(59780,0.01153614),
|
|
(59908,0.0),
|
|
(60036,0.2763834);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(60164,NULL),
|
|
(60292,NULL),
|
|
(60420,0.00149),
|
|
(60548,0.9590044),
|
|
(60676,0.0),
|
|
(60804,0.02398982),
|
|
(60932,0.05412427),
|
|
(61060,0.00005242),
|
|
(61188,0.01232633),
|
|
(61316,0.0005189);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(61444,0.0),
|
|
(61572,0.00196546),
|
|
(61700,0.00716419),
|
|
(61828,0.0),
|
|
(61956,0.0),
|
|
(62084,0.00122224),
|
|
(62212,0.00988189),
|
|
(62340,NULL),
|
|
(62468,0.00006262),
|
|
(62596,0.00334187);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(62724,NULL),
|
|
(62852,0.11244337),
|
|
(62980,NULL),
|
|
(63108,0.4137224),
|
|
(63236,0.00094869),
|
|
(63364,0.00037691),
|
|
(63492,0.09065232),
|
|
(63620,0.70078176),
|
|
(63748,0.2610763),
|
|
(63876,0.58452475);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(64004,0.00037725),
|
|
(64132,0.01363691),
|
|
(64260,0.03295722),
|
|
(64388,0.00775894),
|
|
(64516,0.00597924),
|
|
(64644,0.00098757),
|
|
(64772,0.0),
|
|
(64900,0.02986313),
|
|
(65028,0.00005731),
|
|
(65156,0.259131);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(65284,0.00433746),
|
|
(65412,0.03780772),
|
|
(65540,0.00255001),
|
|
(65668,0.33036566),
|
|
(65796,0.00004995),
|
|
(65924,0.00010118),
|
|
(66052,0.0),
|
|
(66180,0.00053285),
|
|
(66308,NULL),
|
|
(66436,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(66564,0.00215946),
|
|
(66692,0.00012339),
|
|
(66820,0.20895952),
|
|
(66948,0.01364484),
|
|
(67076,0.00161306),
|
|
(67204,0.01784489),
|
|
(67332,0.51345026),
|
|
(67460,0.00022264),
|
|
(67588,0.5755771),
|
|
(67716,0.07973811);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(67844,0.00075325),
|
|
(67972,0.02588654),
|
|
(68100,0.0066424),
|
|
(68228,0.0),
|
|
(68356,NULL),
|
|
(68484,0.00452684),
|
|
(68612,0.0),
|
|
(68740,NULL),
|
|
(68868,0.00148165),
|
|
(68996,0.00069906);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(69124,0.36696395),
|
|
(69252,0.00176318),
|
|
(69380,0.0),
|
|
(69508,0.00322113),
|
|
(69636,0.66234267),
|
|
(69764,NULL),
|
|
(69892,0.17466402),
|
|
(70020,NULL),
|
|
(70148,0.3849655),
|
|
(70276,0.00634581);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(70404,0.00898295),
|
|
(70532,0.10214821),
|
|
(70660,0.03422715),
|
|
(70788,0.01116229),
|
|
(70916,0.40757605),
|
|
(71044,0.76234627),
|
|
(71172,0.00059572),
|
|
(71300,0.00323015),
|
|
(71428,0.00015896),
|
|
(71556,0.04674813);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(71684,0.00002449),
|
|
(71812,0.5066135),
|
|
(71940,0.94456),
|
|
(72068,0.00022794),
|
|
(72196,0.00155764),
|
|
(72324,0.00060991),
|
|
(72452,NULL),
|
|
(72580,0.0),
|
|
(72708,0.23283394),
|
|
(72836,0.04149162);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(72964,0.00059429),
|
|
(73092,0.0),
|
|
(73220,0.0),
|
|
(73348,0.19649409),
|
|
(73476,0.0017861),
|
|
(73604,0.0),
|
|
(73732,NULL),
|
|
(73860,0.02864335),
|
|
(73988,0.9),
|
|
(74116,0.01258155);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(74244,0.00925873),
|
|
(74372,0.00323526),
|
|
(74500,0.00258794),
|
|
(74628,0.09800948),
|
|
(74756,0.00680334),
|
|
(74884,NULL),
|
|
(75012,0.02857617),
|
|
(75140,0.06355022),
|
|
(75268,0.0),
|
|
(75396,0.01389665);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(75524,0.49072826),
|
|
(75652,0.00250901),
|
|
(75780,0.00081248),
|
|
(75908,0.02927421),
|
|
(76036,NULL),
|
|
(76164,0.01670666),
|
|
(76292,0.01635653),
|
|
(76420,NULL),
|
|
(76548,0.1040872),
|
|
(76676,0.10566042);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(76804,NULL),
|
|
(76932,0.00663577),
|
|
(77060,0.21661888),
|
|
(77188,0.45707023),
|
|
(77316,0.00272538),
|
|
(77444,0.00419203),
|
|
(77572,NULL),
|
|
(77700,0.00237827),
|
|
(77828,0.00146376),
|
|
(77956,0.03254667);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(78084,0.00237725),
|
|
(78212,NULL),
|
|
(78340,0.02337047),
|
|
(78468,0.6066429),
|
|
(78596,NULL),
|
|
(78724,0.99989676),
|
|
(78852,0.02890464),
|
|
(78980,0.07082515),
|
|
(79108,NULL),
|
|
(79236,0.0019473);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(79364,0.00358919),
|
|
(79492,NULL),
|
|
(79620,0.28481358),
|
|
(79748,0.00222982),
|
|
(79876,NULL),
|
|
(80004,0.00547454),
|
|
(80132,NULL),
|
|
(80260,0.0002941),
|
|
(80388,0.00061776),
|
|
(80516,0.00002488);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(80644,0.09067673),
|
|
(80772,0.97947466),
|
|
(80900,NULL),
|
|
(81028,0.00611359),
|
|
(81156,0.0001545),
|
|
(81284,NULL),
|
|
(81412,0.02183841),
|
|
(81540,0.01013091),
|
|
(81668,0.00044435),
|
|
(81796,0.00101722);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(81924,0.0),
|
|
(82052,0.01291962),
|
|
(82180,0.00089332),
|
|
(82308,NULL),
|
|
(82436,0.38697731),
|
|
(82564,0.0),
|
|
(82692,0.06748839),
|
|
(82820,0.00505329),
|
|
(82948,0.00197535),
|
|
(83076,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(83204,NULL),
|
|
(83332,0.02577116),
|
|
(83460,0.00040706),
|
|
(83588,0.00387944),
|
|
(83716,0.00060442),
|
|
(83844,0.00140539),
|
|
(83972,0.02212065),
|
|
(84100,0.0009958),
|
|
(84228,0.21305683),
|
|
(84356,0.01075263);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(84484,NULL),
|
|
(84612,0.04209423),
|
|
(84740,0.00016298),
|
|
(84868,0.00030807),
|
|
(84996,0.0033516),
|
|
(85124,0.01264506),
|
|
(85252,NULL),
|
|
(85380,0.00797018),
|
|
(85508,0.03014666),
|
|
(85636,0.0);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(85764,0.0198979),
|
|
(85892,NULL),
|
|
(86020,NULL),
|
|
(86148,0.00323176),
|
|
(86276,0.56539536),
|
|
(86404,0.04482054),
|
|
(86532,0.07097953),
|
|
(86660,0.00034572),
|
|
(86788,0.0),
|
|
(86916,0.00194455);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(87044,0.0),
|
|
(87172,0.0),
|
|
(87300,0.00335881),
|
|
(87428,0.6016782),
|
|
(87556,0.02347282),
|
|
(87684,0.0),
|
|
(87812,0.00998413),
|
|
(87940,0.10825046),
|
|
(88068,0.11218246),
|
|
(88196,NULL);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(88324,0.16741024),
|
|
(88452,0.00222767),
|
|
(88580,0.00215809),
|
|
(3,0.05589541),
|
|
(131,0.0),
|
|
(259,0.00747037),
|
|
(387,0.00063459),
|
|
(515,0.28516522),
|
|
(643,0.07687332),
|
|
(771,0.00015758);
|
|
INSERT INTO t1 (id,num) VALUES
|
|
(6019,0.36197448),
|
|
(6147,0.00694031),
|
|
(6275,NULL),
|
|
(6403,0.05160758),
|
|
(6531,0.98084956),
|
|
(6659,0.0),
|
|
(6787,0.00084533),
|
|
(6915,0.05876909),
|
|
(7043,NULL),
|
|
(7171,NULL);
|
|
analyze table t1;
|
|
set @@tidb_partition_prune_mode=default;
|
|
set tidb_partition_prune_mode=dynamic;
|
|
drop table if exists t;
|
|
CREATE TABLE `t` ( `id` int(11) DEFAULT NULL, `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL ) PARTITION BY RANGE (`id`) (PARTITION `p0` VALUES LESS THAN (3), PARTITION `p1` VALUES LESS THAN (7), PARTITION `p2` VALUES LESS THAN (11));
|
|
insert into t values (1,1,1,1),(2,2,2,2),(4,4,4,4),(5,5,5,5),(6,6,6,6),(8,8,8,8),(9,9,9,9);
|
|
create index idxa on t (a);
|
|
create index idxb on t (b);
|
|
create index idxc on t (c);
|
|
analyze table t partition p0 index idxa;
|
|
analyze table t partition p1 index idxb;
|
|
analyze table t partition p2 index idxc;
|
|
SHOW WARNINGS WHERE Level IN ('Warning', 'Error');
|
|
Level Code Message
|
|
Warning 1105 The version 2 would collect all statistics not only the selected indexes
|
|
analyze table t partition p0;
|
|
SHOW WARNINGS WHERE Level IN ('Warning', 'Error');
|
|
Level Code Message
|
|
set tidb_partition_prune_mode=default;
|
|
set @@session.tidb_enable_fast_analyze=1;
|
|
show warnings;
|
|
Level Code Message
|
|
Warning 1105 the fast analyze feature has already been removed in TiDB v7.5.0, so this will have no effect
|
|
set @@session.tidb_enable_fast_analyze=default;
|
|
drop table if exists t;
|
|
create table t(a int, b int, primary key(a), index idx(b));
|
|
analyze incremental table t index;
|
|
Error 1105 (HY000): the incremental analyze feature has already been removed in TiDB v7.5.0, so this will have no effect
|
|
drop table if exists t;
|
|
create table t(a int, b int, primary key(a), index idx(b)) partition by range(a) (partition p0 values less than (10), partition p1 values less than (20));
|
|
analyze incremental table t partition p0 index idx;
|
|
Error 1105 (HY000): the incremental analyze feature has already been removed in TiDB v7.5.0, so this will have no effect
|
|
drop table if exists t;
|
|
set tidb_enable_clustered_index=on;
|
|
create table t (a int, b int, c int, primary key(a, b));
|
|
insert into t values (0, 0, 0);
|
|
insert into t values (1, 1, 1);
|
|
insert into t values (2, 2, 2);
|
|
insert into t values (3, 3, 3);
|
|
insert into t values (4, 4, 4);
|
|
insert into t values (5, 5, 5);
|
|
insert into t values (6, 6, 6);
|
|
insert into t values (7, 7, 7);
|
|
insert into t values (8, 8, 8);
|
|
insert into t values (9, 9, 9);
|
|
analyze table t;
|
|
drop table t;
|
|
create table t (a varchar(255), b int, c float, primary key(c, a));
|
|
insert into t values (0, 0, 0);
|
|
insert into t values (1, 1, 1);
|
|
insert into t values (2, 2, 2);
|
|
insert into t values (3, 3, 3);
|
|
insert into t values (4, 4, 4);
|
|
insert into t values (5, 5, 5);
|
|
insert into t values (6, 6, 6);
|
|
insert into t values (7, 7, 7);
|
|
insert into t values (8, 8, 8);
|
|
insert into t values (9, 9, 9);
|
|
analyze table t;
|
|
drop table t;
|
|
create table t (a char(10), b decimal(5, 3), c int, primary key(a, c, b));
|
|
insert into t values (0, 0, 0);
|
|
insert into t values (1, 1, 1);
|
|
insert into t values (2, 2, 2);
|
|
insert into t values (3, 3, 3);
|
|
insert into t values (4, 4, 4);
|
|
insert into t values (5, 5, 5);
|
|
insert into t values (6, 6, 6);
|
|
insert into t values (7, 7, 7);
|
|
insert into t values (8, 8, 8);
|
|
insert into t values (9, 9, 9);
|
|
analyze table t;
|
|
drop table t;
|
|
set tidb_enable_clustered_index=default;
|
|
set @@tidb_analyze_version = 1;
|
|
drop table if exists t0;
|
|
CREATE TABLE t0(c0 INT PRIMARY KEY);
|
|
ANALYZE TABLE t0 INDEX PRIMARY;
|
|
drop table if exists t0;
|
|
CREATE TABLE t0(c0 INT, c1 INT, PRIMARY KEY(c0, c1));
|
|
INSERT INTO t0 VALUES (0, 0);
|
|
ANALYZE TABLE t0;
|
|
drop table if exists t0;
|
|
CREATE TABLE t0(c0 INT);
|
|
INSERT INTO t0 VALUES (0);
|
|
CREATE INDEX i0 ON t0(c0);
|
|
ANALYZE TABLE t0 INDEX i0;
|
|
set @@tidb_analyze_version = default;
|
|
drop table if exists t;
|
|
create table t(a int, b int, c json, d text, e mediumtext, f blob, g mediumblob, index idx(d(10)));
|
|
set @@session.tidb_analyze_skip_column_types = 'json,blob,mediumblob,text,mediumtext';
|
|
delete from mysql.analyze_jobs;
|
|
analyze table t;
|
|
select job_info from mysql.analyze_jobs where job_info like '%analyze table%';
|
|
job_info
|
|
analyze table all indexes, columns a, b, d with 256 buckets, 100 topn, 1 samplerate
|
|
delete from mysql.analyze_jobs;
|
|
analyze table t columns a, e;
|
|
select job_info from mysql.analyze_jobs where job_info like '%analyze table%';
|
|
job_info
|
|
analyze table all indexes, columns a, d with 256 buckets, 100 topn, 1 samplerate
|
|
set @@session.tidb_analyze_skip_column_types = default;
|
|
DROP TABLE IF EXISTS Issue34228;
|
|
CREATE TABLE Issue34228 (id bigint NOT NULL, dt datetime NOT NULL) PARTITION BY RANGE COLUMNS(dt) (PARTITION p202201 VALUES LESS THAN ("2022-02-01"), PARTITION p202202 VALUES LESS THAN ("2022-03-01"));
|
|
INSERT INTO Issue34228 VALUES (1, '2022-02-01 00:00:02'), (2, '2022-02-01 00:00:02');
|
|
SET @@global.tidb_analyze_version = 1;
|
|
SET @@session.tidb_partition_prune_mode = 'static';
|
|
ANALYZE TABLE Issue34228;
|
|
SET @@session.tidb_partition_prune_mode = 'dynamic';
|
|
ANALYZE TABLE Issue34228;
|
|
SELECT * FROM Issue34228;
|
|
id dt
|
|
1 2022-02-01 00:00:02
|
|
2 2022-02-01 00:00:02
|
|
DROP TABLE IF EXISTS Issue34228;
|
|
CREATE TABLE Issue34228 (id bigint NOT NULL, dt datetime NOT NULL) PARTITION BY RANGE COLUMNS(dt) (PARTITION p202201 VALUES LESS THAN ("2022-02-01"), PARTITION p202202 VALUES LESS THAN ("2022-03-01"));
|
|
INSERT INTO Issue34228 VALUES (1, '2022-02-01 00:00:02'), (2, '2022-02-01 00:00:02');
|
|
SET @@global.tidb_analyze_version = 1;
|
|
SET @@session.tidb_partition_prune_mode = 'static';
|
|
ANALYZE TABLE Issue34228;
|
|
SET @@session.tidb_partition_prune_mode = 'dynamic';
|
|
ANALYZE TABLE Issue34228;
|
|
SELECT * FROM Issue34228;
|
|
id dt
|
|
1 2022-02-01 00:00:02
|
|
2 2022-02-01 00:00:02
|
|
create table analyze_virtual_col(a int generated always as (1) virtual, b int);
|
|
insert into analyze_virtual_col(b) values(2);
|
|
analyze table analyze_virtual_col all columns;
|
|
select * from analyze_virtual_col where a > 1 and b > 1;
|
|
a b
|
|
show stats_topn where table_name = 'analyze_virtual_col';
|
|
Db_name Table_name Partition_name Column_name Is_index Value Count
|
|
executor__analyze analyze_virtual_col b 0 2 1
|
|
SET @@global.tidb_analyze_version = default;
|
|
SET @@session.tidb_partition_prune_mode = default;
|