sqlite-parquet-vtable/parquet-generator/nulls.sql

BEGIN;DROP TABLE IF EXISTS nulls;
CREATE TABLE nulls (bool_0 BOOLEAN, int8_1 TINYINT, int16_2 SMALLINT, int32_3 INT, int64_4 BIGINT, ts_5 BIGINT, double_6 DOUBLE, string_7 TEXT, string_8 TEXT, binary_9 BLOB, binary_10 BLOB, float_11 DOUBLE);
INSERT INTO nulls VALUES (1, 50, 5000, 50000000, 50000000000, 490665600000, 99.0, '0', '000', X'00', X'00', 1);
INSERT INTO nulls VALUES (0, 49, 4900, 49000000, 49000000000, 490752000000, 49.5, '1', '001', X'0101', X'01', 0.5);
INSERT INTO nulls VALUES (1, 48, 4800, 48000000, 48000000000, 490838400000, 33.0, '2', '002', X'020202', X'02', 0.3333333333333333);
INSERT INTO nulls VALUES (0, 47, 4700, 47000000, 47000000000, 490924800000, 24.75, '3', '003', X'03030303', X'03', 0.25);
INSERT INTO nulls VALUES (1, 46, 4600, 46000000, 46000000000, 491011200000, 19.8, '4', '004', X'0404040404', X'04', 0.2);
INSERT INTO nulls VALUES (0, 45, 4500, 45000000, 45000000000, 491097600000, 16.5, '5', '005', X'05', X'05', 0.16666666666666666);
INSERT INTO nulls VALUES (1, 44, 4400, 44000000, 44000000000, 491184000000, 14.142857142857142, '6', '006', X'0606', X'06', 0.14285714285714285);
INSERT INTO nulls VALUES (0, 43, 4300, 43000000, 43000000000, 491270400000, 12.375, '7', '007', X'070707', X'07', 0.125);
INSERT INTO nulls VALUES (1, 42, 4200, 42000000, 42000000000, 491356800000, 11.0, '8', '008', X'08080808', X'08', 0.1111111111111111);
INSERT INTO nulls VALUES (0, 41, 4100, 41000000, 41000000000, 491443200000, 9.9, '9', '009', X'0909090909', X'09', 0.1);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO nulls VALUES (NULL, 30, NULL, 30000000, NULL, 492393600000, NULL, '20', NULL, X'14', NULL, 0.047619047619047616);
INSERT INTO nulls VALUES (0, NULL, 2900, NULL, 29000000000, NULL, 4.5, NULL, '021', NULL, X'15', NULL);
INSERT INTO nulls VALUES (NULL, 28, NULL, 28000000, NULL, 492566400000, NULL, '22', NULL, X'161616', NULL, 0.043478260869565216);
INSERT INTO nulls VALUES (0, NULL, 2700, NULL, 27000000000, NULL, 4.125, NULL, '023', NULL, X'17', NULL);
INSERT INTO nulls VALUES (NULL, 26, NULL, 26000000, NULL, 492739200000, NULL, '24', NULL, X'1818181818', NULL, 0.04);
INSERT INTO nulls VALUES (0, NULL, 2500, NULL, 25000000000, NULL, 3.8076923076923075, NULL, '025', NULL, X'19', NULL);
INSERT INTO nulls VALUES (NULL, 24, NULL, 24000000, NULL, 492912000000, NULL, '26', NULL, X'1A1A', NULL, 0.037037037037037035);
INSERT INTO nulls VALUES (0, NULL, 2300, NULL, 23000000000, NULL, 3.5357142857142856, NULL, '027', NULL, X'1B', NULL);
INSERT INTO nulls VALUES (NULL, 22, NULL, 22000000, NULL, 493084800000, NULL, '28', NULL, X'1C1C1C1C', NULL, 0.034482758620689655);
INSERT INTO nulls VALUES (0, NULL, 2100, NULL, 21000000000, NULL, 3.3, NULL, '029', NULL, X'1D', NULL);
INSERT INTO nulls VALUES (NULL, 20, NULL, 20000000, NULL, 493257600000, NULL, '30', NULL, X'1E', NULL, 0.03225806451612903);
INSERT INTO nulls VALUES (0, NULL, 1900, NULL, 19000000000, NULL, 3.09375, NULL, '031', NULL, X'1F', NULL);
INSERT INTO nulls VALUES (NULL, 18, NULL, 18000000, NULL, 493430400000, NULL, '32', NULL, X'202020', NULL, 0.030303030303030304);
INSERT INTO nulls VALUES (0, NULL, 1700, NULL, 17000000000, NULL, 2.911764705882353, NULL, '033', NULL, X'21', NULL);
INSERT INTO nulls VALUES (NULL, 16, NULL, 16000000, NULL, 493603200000, NULL, '34', NULL, X'2222222222', NULL, 0.02857142857142857);
INSERT INTO nulls VALUES (0, NULL, 1500, NULL, 15000000000, NULL, 2.75, NULL, '035', NULL, X'23', NULL);
INSERT INTO nulls VALUES (NULL, 14, NULL, 14000000, NULL, 493776000000, NULL, '36', NULL, X'2424', NULL, 0.02702702702702703);
INSERT INTO nulls VALUES (0, NULL, 1300, NULL, 13000000000, NULL, 2.6052631578947367, NULL, '037', NULL, X'25', NULL);
INSERT INTO nulls VALUES (NULL, 12, NULL, 12000000, NULL, 493948800000, NULL, '38', NULL, X'26262626', NULL, 0.02564102564102564);
INSERT INTO nulls VALUES (0, NULL, 1100, NULL, 11000000000, NULL, 2.475, NULL, '039', NULL, X'27', NULL);
INSERT INTO nulls VALUES (NULL, 10, NULL, 10000000, NULL, 494121600000, NULL, '40', NULL, X'28', NULL, 0.024390243902439025);
INSERT INTO nulls VALUES (0, NULL, 900, NULL, 9000000000, NULL, 2.357142857142857, NULL, '041', NULL, X'29', NULL);
INSERT INTO nulls VALUES (NULL, 8, NULL, 8000000, NULL, 494294400000, NULL, '42', NULL, X'2A2A2A', NULL, 0.023255813953488372);
INSERT INTO nulls VALUES (0, NULL, 700, NULL, 7000000000, NULL, 2.25, NULL, '043', NULL, X'2B', NULL);
INSERT INTO nulls VALUES (NULL, 6, NULL, 6000000, NULL, 494467200000, NULL, '44', NULL, X'2C2C2C2C2C', NULL, 0.022222222222222223);
INSERT INTO nulls VALUES (0, NULL, 500, NULL, 5000000000, NULL, 2.152173913043478, NULL, '045', NULL, X'2D', NULL);
INSERT INTO nulls VALUES (NULL, 4, NULL, 4000000, NULL, 494640000000, NULL, '46', NULL, X'2E2E', NULL, 0.02127659574468085);
INSERT INTO nulls VALUES (0, NULL, 300, NULL, 3000000000, NULL, 2.0625, NULL, '047', NULL, X'2F', NULL);
INSERT INTO nulls VALUES (NULL, 2, NULL, 2000000, NULL, 494812800000, NULL, '48', NULL, X'30303030', NULL, 0.02040816326530612);
INSERT INTO nulls VALUES (0, NULL, 100, NULL, 1000000000, NULL, 1.98, NULL, '049', NULL, X'31', NULL);
INSERT INTO nulls VALUES (NULL, 0, NULL, 0, NULL, 494985600000, NULL, '50', NULL, X'32', NULL, 0.0196078431372549);
INSERT INTO nulls VALUES (0, NULL, -100, NULL, -1000000000, NULL, 1.9038461538461537, NULL, '051', NULL, X'33', NULL);
INSERT INTO nulls VALUES (NULL, -2, NULL, -2000000, NULL, 495158400000, NULL, '52', NULL, X'343434', NULL, 0.018867924528301886);
INSERT INTO nulls VALUES (0, NULL, -300, NULL, -3000000000, NULL, 1.8333333333333333, NULL, '053', NULL, X'35', NULL);
INSERT INTO nulls VALUES (NULL, -4, NULL, -4000000, NULL, 495331200000, NULL, '54', NULL, X'3636363636', NULL, 0.01818181818181818);
INSERT INTO nulls VALUES (0, NULL, -500, NULL, -5000000000, NULL, 1.7678571428571428, NULL, '055', NULL, X'37', NULL);
INSERT INTO nulls VALUES (NULL, -6, NULL, -6000000, NULL, 495504000000, NULL, '56', NULL, X'3838', NULL, 0.017543859649122806);
INSERT INTO nulls VALUES (0, NULL, -700, NULL, -7000000000, NULL, 1.706896551724138, NULL, '057', NULL, X'39', NULL);
INSERT INTO nulls VALUES (NULL, -8, NULL, -8000000, NULL, 495676800000, NULL, '58', NULL, X'3A3A3A3A', NULL, 0.01694915254237288);
INSERT INTO nulls VALUES (0, NULL, -900, NULL, -9000000000, NULL, 1.65, NULL, '059', NULL, X'3B', NULL);
INSERT INTO nulls VALUES (NULL, -10, NULL, -10000000, NULL, 495849600000, NULL, '60', NULL, X'3C', NULL, 0.01639344262295082);
INSERT INTO nulls VALUES (0, NULL, -1100, NULL, -11000000000, NULL, 1.596774193548387, NULL, '061', NULL, X'3D', NULL);
INSERT INTO nulls VALUES (NULL, -12, NULL, -12000000, NULL, 496022400000, NULL, '62', NULL, X'3E3E3E', NULL, 0.015873015873015872);
INSERT INTO nulls VALUES (0, NULL, -1300, NULL, -13000000000, NULL, 1.546875, NULL, '063', NULL, X'3F', NULL);
INSERT INTO nulls VALUES (NULL, -14, NULL, -14000000, NULL, 496195200000, NULL, '64', NULL, X'4040404040', NULL, 0.015384615384615385);
INSERT INTO nulls VALUES (0, NULL, -1500, NULL, -15000000000, NULL, 1.5, NULL, '065', NULL, X'41', NULL);
INSERT INTO nulls VALUES (NULL, -16, NULL, -16000000, NULL, 496368000000, NULL, '66', NULL, X'4242', NULL, 0.014925373134328358);
INSERT INTO nulls VALUES (0, NULL, -1700, NULL, -17000000000, NULL, 1.4558823529411764, NULL, '067', NULL, X'43', NULL);
INSERT INTO nulls VALUES (NULL, -18, NULL, -18000000, NULL, 496540800000, NULL, '68', NULL, X'44444444', NULL, 0.014492753623188406);
INSERT INTO nulls VALUES (0, NULL, -1900, NULL, -19000000000, NULL, 1.4142857142857144, NULL, '069', NULL, X'45', NULL);
INSERT INTO nulls VALUES (NULL, -20, NULL, -20000000, NULL, 496713600000, NULL, '70', NULL, X'46', NULL, 0.014084507042253521);
INSERT INTO nulls VALUES (0, NULL, -2100, NULL, -21000000000, NULL, 1.375, NULL, '071', NULL, X'47', NULL);
INSERT INTO nulls VALUES (NULL, -22, NULL, -22000000, NULL, 496886400000, NULL, '72', NULL, X'484848', NULL, 0.0136986301369863);
INSERT INTO nulls VALUES (0, NULL, -2300, NULL, -23000000000, NULL, 1.337837837837838, NULL, '073', NULL, X'49', NULL);
INSERT INTO nulls VALUES (NULL, -24, NULL, -24000000, NULL, 497059200000, NULL, '74', NULL, X'4A4A4A4A4A', NULL, 0.013333333333333334);
INSERT INTO nulls VALUES (0, NULL, -2500, NULL, -25000000000, NULL, 1.3026315789473684, NULL, '075', NULL, X'4B', NULL);
INSERT INTO nulls VALUES (NULL, -26, NULL, -26000000, NULL, 497232000000, NULL, '76', NULL, X'4C4C', NULL, 0.012987012987012988);
INSERT INTO nulls VALUES (0, NULL, -2700, NULL, -27000000000, NULL, 1.2692307692307692, NULL, '077', NULL, X'4D', NULL);
INSERT INTO nulls VALUES (NULL, -28, NULL, -28000000, NULL, 497404800000, NULL, '78', NULL, X'4E4E4E4E', NULL, 0.012658227848101266);
INSERT INTO nulls VALUES (0, NULL, -2900, NULL, -29000000000, NULL, 1.2375, NULL, '079', NULL, X'4F', NULL);
INSERT INTO nulls VALUES (NULL, -30, NULL, -30000000, NULL, 497577600000, NULL, '80', NULL, X'50', NULL, 0.012345679012345678);
INSERT INTO nulls VALUES (0, NULL, -3100, NULL, -31000000000, NULL, 1.2073170731707317, NULL, '081', NULL, X'51', NULL);
INSERT INTO nulls VALUES (NULL, -32, NULL, -32000000, NULL, 497750400000, NULL, '82', NULL, X'525252', NULL, 0.012048192771084338);
INSERT INTO nulls VALUES (0, NULL, -3300, NULL, -33000000000, NULL, 1.1785714285714286, NULL, '083', NULL, X'53', NULL);
INSERT INTO nulls VALUES (NULL, -34, NULL, -34000000, NULL, 497923200000, NULL, '84', NULL, X'5454545454', NULL, 0.011764705882352941);
INSERT INTO nulls VALUES (0, NULL, -3500, NULL, -35000000000, NULL, 1.1511627906976745, NULL, '085', NULL, X'55', NULL);
INSERT INTO nulls VALUES (NULL, -36, NULL, -36000000, NULL, 498096000000, NULL, '86', NULL, X'5656', NULL, 0.011494252873563218);
INSERT INTO nulls VALUES (0, NULL, -3700, NULL, -37000000000, NULL, 1.125, NULL, '087', NULL, X'57', NULL);
INSERT INTO nulls VALUES (NULL, -38, NULL, -38000000, NULL, 498268800000, NULL, '88', NULL, X'58585858', NULL, 0.011235955056179775);
INSERT INTO nulls VALUES (0, NULL, -3900, NULL, -39000000000, NULL, 1.1, NULL, '089', NULL, X'59', NULL);
INSERT INTO nulls VALUES (NULL, -40, NULL, -40000000, NULL, 498441600000, NULL, '90', NULL, X'5A', NULL, 0.01098901098901099);
INSERT INTO nulls VALUES (0, NULL, -4100, NULL, -41000000000, NULL, 1.076086956521739, NULL, '091', NULL, X'5B', NULL);
INSERT INTO nulls VALUES (NULL, -42, NULL, -42000000, NULL, 498614400000, NULL, '92', NULL, X'5C5C5C', NULL, 0.010752688172043012);
INSERT INTO nulls VALUES (0, NULL, -4300, NULL, -43000000000, NULL, 1.053191489361702, NULL, '093', NULL, X'5D', NULL);
INSERT INTO nulls VALUES (NULL, -44, NULL, -44000000, NULL, 498787200000, NULL, '94', NULL, X'5E5E5E5E5E', NULL, 0.010526315789473684);
INSERT INTO nulls VALUES (0, NULL, -4500, NULL, -45000000000, NULL, 1.03125, NULL, '095', NULL, X'5F', NULL);
INSERT INTO nulls VALUES (NULL, -46, NULL, -46000000, NULL, 498960000000, NULL, '96', NULL, X'6060', NULL, 0.010309278350515464);
INSERT INTO nulls VALUES (0, NULL, -4700, NULL, -47000000000, NULL, 1.010204081632653, NULL, '097', NULL, X'61', NULL);
INSERT INTO nulls VALUES (NULL, -48, NULL, -48000000, NULL, 499132800000, NULL, '98', NULL, X'62626262', NULL, 0.010101010101010102);
COMMIT;