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

BEGIN;DROP TABLE IF EXISTS no_nulls;
CREATE TABLE no_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 no_nulls VALUES (1, 50, 5000, 50000000, 50000000000, 490665600000, 99.0, '0', '000', X'00', X'00', 1);
INSERT INTO no_nulls VALUES (0, 49, 4900, 49000000, 49000000000, 490752000000, 49.5, '1', '001', X'0101', X'01', 0.5);
INSERT INTO no_nulls VALUES (1, 48, 4800, 48000000, 48000000000, 490838400000, 33.0, '2', '002', X'020202', X'02', 0.3333333333333333);
INSERT INTO no_nulls VALUES (0, 47, 4700, 47000000, 47000000000, 490924800000, 24.75, '3', '003', X'03030303', X'03', 0.25);
INSERT INTO no_nulls VALUES (1, 46, 4600, 46000000, 46000000000, 491011200000, 19.8, '4', '004', X'0404040404', X'04', 0.2);
INSERT INTO no_nulls VALUES (0, 45, 4500, 45000000, 45000000000, 491097600000, 16.5, '5', '005', X'05', X'05', 0.16666666666666666);
INSERT INTO no_nulls VALUES (1, 44, 4400, 44000000, 44000000000, 491184000000, 14.142857142857142, '6', '006', X'0606', X'06', 0.14285714285714285);
INSERT INTO no_nulls VALUES (0, 43, 4300, 43000000, 43000000000, 491270400000, 12.375, '7', '007', X'070707', X'07', 0.125);
INSERT INTO no_nulls VALUES (1, 42, 4200, 42000000, 42000000000, 491356800000, 11.0, '8', '008', X'08080808', X'08', 0.1111111111111111);
INSERT INTO no_nulls VALUES (0, 41, 4100, 41000000, 41000000000, 491443200000, 9.9, '9', '009', X'0909090909', X'09', 0.1);
INSERT INTO no_nulls VALUES (1, 40, 4000, 40000000, 40000000000, 491529600000, 9.0, '10', '010', X'0A', X'0A', 0.09090909090909091);
INSERT INTO no_nulls VALUES (0, 39, 3900, 39000000, 39000000000, 491616000000, 8.25, '11', '011', X'0B0B', X'0B', 0.08333333333333333);
INSERT INTO no_nulls VALUES (1, 38, 3800, 38000000, 38000000000, 491702400000, 7.615384615384615, '12', '012', X'0C0C0C', X'0C', 0.07692307692307693);
INSERT INTO no_nulls VALUES (0, 37, 3700, 37000000, 37000000000, 491788800000, 7.071428571428571, '13', '013', X'0D0D0D0D', X'0D', 0.07142857142857142);
INSERT INTO no_nulls VALUES (1, 36, 3600, 36000000, 36000000000, 491875200000, 6.6, '14', '014', X'0E0E0E0E0E', X'0E', 0.06666666666666667);
INSERT INTO no_nulls VALUES (0, 35, 3500, 35000000, 35000000000, 491961600000, 6.1875, '15', '015', X'0F', X'0F', 0.0625);
INSERT INTO no_nulls VALUES (1, 34, 3400, 34000000, 34000000000, 492048000000, 5.823529411764706, '16', '016', X'1010', X'10', 0.058823529411764705);
INSERT INTO no_nulls VALUES (0, 33, 3300, 33000000, 33000000000, 492134400000, 5.5, '17', '017', X'111111', X'11', 0.05555555555555555);
INSERT INTO no_nulls VALUES (1, 32, 3200, 32000000, 32000000000, 492220800000, 5.2105263157894735, '18', '018', X'12121212', X'12', 0.05263157894736842);
INSERT INTO no_nulls VALUES (0, 31, 3100, 31000000, 31000000000, 492307200000, 4.95, '19', '019', X'1313131313', X'13', 0.05);
INSERT INTO no_nulls VALUES (1, 30, 3000, 30000000, 30000000000, 492393600000, 4.714285714285714, '20', '020', X'14', X'14', 0.047619047619047616);
INSERT INTO no_nulls VALUES (0, 29, 2900, 29000000, 29000000000, 492480000000, 4.5, '21', '021', X'1515', X'15', 0.045454545454545456);
INSERT INTO no_nulls VALUES (1, 28, 2800, 28000000, 28000000000, 492566400000, 4.304347826086956, '22', '022', X'161616', X'16', 0.043478260869565216);
INSERT INTO no_nulls VALUES (0, 27, 2700, 27000000, 27000000000, 492652800000, 4.125, '23', '023', X'17171717', X'17', 0.041666666666666664);
INSERT INTO no_nulls VALUES (1, 26, 2600, 26000000, 26000000000, 492739200000, 3.96, '24', '024', X'1818181818', X'18', 0.04);
INSERT INTO no_nulls VALUES (0, 25, 2500, 25000000, 25000000000, 492825600000, 3.8076923076923075, '25', '025', X'19', X'19', 0.038461538461538464);
INSERT INTO no_nulls VALUES (1, 24, 2400, 24000000, 24000000000, 492912000000, 3.6666666666666665, '26', '026', X'1A1A', X'1A', 0.037037037037037035);
INSERT INTO no_nulls VALUES (0, 23, 2300, 23000000, 23000000000, 492998400000, 3.5357142857142856, '27', '027', X'1B1B1B', X'1B', 0.03571428571428571);
INSERT INTO no_nulls VALUES (1, 22, 2200, 22000000, 22000000000, 493084800000, 3.413793103448276, '28', '028', X'1C1C1C1C', X'1C', 0.034482758620689655);
INSERT INTO no_nulls VALUES (0, 21, 2100, 21000000, 21000000000, 493171200000, 3.3, '29', '029', X'1D1D1D1D1D', X'1D', 0.03333333333333333);
INSERT INTO no_nulls VALUES (1, 20, 2000, 20000000, 20000000000, 493257600000, 3.193548387096774, '30', '030', X'1E', X'1E', 0.03225806451612903);
INSERT INTO no_nulls VALUES (0, 19, 1900, 19000000, 19000000000, 493344000000, 3.09375, '31', '031', X'1F1F', X'1F', 0.03125);
INSERT INTO no_nulls VALUES (1, 18, 1800, 18000000, 18000000000, 493430400000, 3.0, '32', '032', X'202020', X'20', 0.030303030303030304);
INSERT INTO no_nulls VALUES (0, 17, 1700, 17000000, 17000000000, 493516800000, 2.911764705882353, '33', '033', X'21212121', X'21', 0.029411764705882353);
INSERT INTO no_nulls VALUES (1, 16, 1600, 16000000, 16000000000, 493603200000, 2.8285714285714287, '34', '034', X'2222222222', X'22', 0.02857142857142857);
INSERT INTO no_nulls VALUES (0, 15, 1500, 15000000, 15000000000, 493689600000, 2.75, '35', '035', X'23', X'23', 0.027777777777777776);
INSERT INTO no_nulls VALUES (1, 14, 1400, 14000000, 14000000000, 493776000000, 2.675675675675676, '36', '036', X'2424', X'24', 0.02702702702702703);
INSERT INTO no_nulls VALUES (0, 13, 1300, 13000000, 13000000000, 493862400000, 2.6052631578947367, '37', '037', X'252525', X'25', 0.02631578947368421);
INSERT INTO no_nulls VALUES (1, 12, 1200, 12000000, 12000000000, 493948800000, 2.5384615384615383, '38', '038', X'26262626', X'26', 0.02564102564102564);
INSERT INTO no_nulls VALUES (0, 11, 1100, 11000000, 11000000000, 494035200000, 2.475, '39', '039', X'2727272727', X'27', 0.025);
INSERT INTO no_nulls VALUES (1, 10, 1000, 10000000, 10000000000, 494121600000, 2.4146341463414633, '40', '040', X'28', X'28', 0.024390243902439025);
INSERT INTO no_nulls VALUES (0, 9, 900, 9000000, 9000000000, 494208000000, 2.357142857142857, '41', '041', X'2929', X'29', 0.023809523809523808);
INSERT INTO no_nulls VALUES (1, 8, 800, 8000000, 8000000000, 494294400000, 2.302325581395349, '42', '042', X'2A2A2A', X'2A', 0.023255813953488372);
INSERT INTO no_nulls VALUES (0, 7, 700, 7000000, 7000000000, 494380800000, 2.25, '43', '043', X'2B2B2B2B', X'2B', 0.022727272727272728);
INSERT INTO no_nulls VALUES (1, 6, 600, 6000000, 6000000000, 494467200000, 2.2, '44', '044', X'2C2C2C2C2C', X'2C', 0.022222222222222223);
INSERT INTO no_nulls VALUES (0, 5, 500, 5000000, 5000000000, 494553600000, 2.152173913043478, '45', '045', X'2D', X'2D', 0.021739130434782608);
INSERT INTO no_nulls VALUES (1, 4, 400, 4000000, 4000000000, 494640000000, 2.106382978723404, '46', '046', X'2E2E', X'2E', 0.02127659574468085);
INSERT INTO no_nulls VALUES (0, 3, 300, 3000000, 3000000000, 494726400000, 2.0625, '47', '047', X'2F2F2F', X'2F', 0.020833333333333332);
INSERT INTO no_nulls VALUES (1, 2, 200, 2000000, 2000000000, 494812800000, 2.020408163265306, '48', '048', X'30303030', X'30', 0.02040816326530612);
INSERT INTO no_nulls VALUES (0, 1, 100, 1000000, 1000000000, 494899200000, 1.98, '49', '049', X'3131313131', X'31', 0.02);
INSERT INTO no_nulls VALUES (1, 0, 0, 0, 0, 494985600000, 1.9411764705882353, '50', '050', X'32', X'32', 0.0196078431372549);
INSERT INTO no_nulls VALUES (0, -1, -100, -1000000, -1000000000, 495072000000, 1.9038461538461537, '51', '051', X'3333', X'33', 0.019230769230769232);
INSERT INTO no_nulls VALUES (1, -2, -200, -2000000, -2000000000, 495158400000, 1.8679245283018868, '52', '052', X'343434', X'34', 0.018867924528301886);
INSERT INTO no_nulls VALUES (0, -3, -300, -3000000, -3000000000, 495244800000, 1.8333333333333333, '53', '053', X'35353535', X'35', 0.018518518518518517);
INSERT INTO no_nulls VALUES (1, -4, -400, -4000000, -4000000000, 495331200000, 1.8, '54', '054', X'3636363636', X'36', 0.01818181818181818);
INSERT INTO no_nulls VALUES (0, -5, -500, -5000000, -5000000000, 495417600000, 1.7678571428571428, '55', '055', X'37', X'37', 0.017857142857142856);
INSERT INTO no_nulls VALUES (1, -6, -600, -6000000, -6000000000, 495504000000, 1.736842105263158, '56', '056', X'3838', X'38', 0.017543859649122806);
INSERT INTO no_nulls VALUES (0, -7, -700, -7000000, -7000000000, 495590400000, 1.706896551724138, '57', '057', X'393939', X'39', 0.017241379310344827);
INSERT INTO no_nulls VALUES (1, -8, -800, -8000000, -8000000000, 495676800000, 1.6779661016949152, '58', '058', X'3A3A3A3A', X'3A', 0.01694915254237288);
INSERT INTO no_nulls VALUES (0, -9, -900, -9000000, -9000000000, 495763200000, 1.65, '59', '059', X'3B3B3B3B3B', X'3B', 0.016666666666666666);
INSERT INTO no_nulls VALUES (1, -10, -1000, -10000000, -10000000000, 495849600000, 1.6229508196721312, '60', '060', X'3C', X'3C', 0.01639344262295082);
INSERT INTO no_nulls VALUES (0, -11, -1100, -11000000, -11000000000, 495936000000, 1.596774193548387, '61', '061', X'3D3D', X'3D', 0.016129032258064516);
INSERT INTO no_nulls VALUES (1, -12, -1200, -12000000, -12000000000, 496022400000, 1.5714285714285714, '62', '062', X'3E3E3E', X'3E', 0.015873015873015872);
INSERT INTO no_nulls VALUES (0, -13, -1300, -13000000, -13000000000, 496108800000, 1.546875, '63', '063', X'3F3F3F3F', X'3F', 0.015625);
INSERT INTO no_nulls VALUES (1, -14, -1400, -14000000, -14000000000, 496195200000, 1.523076923076923, '64', '064', X'4040404040', X'40', 0.015384615384615385);
INSERT INTO no_nulls VALUES (0, -15, -1500, -15000000, -15000000000, 496281600000, 1.5, '65', '065', X'41', X'41', 0.015151515151515152);
INSERT INTO no_nulls VALUES (1, -16, -1600, -16000000, -16000000000, 496368000000, 1.4776119402985075, '66', '066', X'4242', X'42', 0.014925373134328358);
INSERT INTO no_nulls VALUES (0, -17, -1700, -17000000, -17000000000, 496454400000, 1.4558823529411764, '67', '067', X'434343', X'43', 0.014705882352941176);
INSERT INTO no_nulls VALUES (1, -18, -1800, -18000000, -18000000000, 496540800000, 1.434782608695652, '68', '068', X'44444444', X'44', 0.014492753623188406);
INSERT INTO no_nulls VALUES (0, -19, -1900, -19000000, -19000000000, 496627200000, 1.4142857142857144, '69', '069', X'4545454545', X'45', 0.014285714285714285);
INSERT INTO no_nulls VALUES (1, -20, -2000, -20000000, -20000000000, 496713600000, 1.3943661971830985, '70', '070', X'46', X'46', 0.014084507042253521);
INSERT INTO no_nulls VALUES (0, -21, -2100, -21000000, -21000000000, 496800000000, 1.375, '71', '071', X'4747', X'47', 0.013888888888888888);
INSERT INTO no_nulls VALUES (1, -22, -2200, -22000000, -22000000000, 496886400000, 1.356164383561644, '72', '072', X'484848', X'48', 0.0136986301369863);
INSERT INTO no_nulls VALUES (0, -23, -2300, -23000000, -23000000000, 496972800000, 1.337837837837838, '73', '073', X'49494949', X'49', 0.013513513513513514);
INSERT INTO no_nulls VALUES (1, -24, -2400, -24000000, -24000000000, 497059200000, 1.32, '74', '074', X'4A4A4A4A4A', X'4A', 0.013333333333333334);
INSERT INTO no_nulls VALUES (0, -25, -2500, -25000000, -25000000000, 497145600000, 1.3026315789473684, '75', '075', X'4B', X'4B', 0.013157894736842105);
INSERT INTO no_nulls VALUES (1, -26, -2600, -26000000, -26000000000, 497232000000, 1.2857142857142858, '76', '076', X'4C4C', X'4C', 0.012987012987012988);
INSERT INTO no_nulls VALUES (0, -27, -2700, -27000000, -27000000000, 497318400000, 1.2692307692307692, '77', '077', X'4D4D4D', X'4D', 0.01282051282051282);
INSERT INTO no_nulls VALUES (1, -28, -2800, -28000000, -28000000000, 497404800000, 1.2531645569620253, '78', '078', X'4E4E4E4E', X'4E', 0.012658227848101266);
INSERT INTO no_nulls VALUES (0, -29, -2900, -29000000, -29000000000, 497491200000, 1.2375, '79', '079', X'4F4F4F4F4F', X'4F', 0.0125);
INSERT INTO no_nulls VALUES (1, -30, -3000, -30000000, -30000000000, 497577600000, 1.2222222222222223, '80', '080', X'50', X'50', 0.012345679012345678);
INSERT INTO no_nulls VALUES (0, -31, -3100, -31000000, -31000000000, 497664000000, 1.2073170731707317, '81', '081', X'5151', X'51', 0.012195121951219513);
INSERT INTO no_nulls VALUES (1, -32, -3200, -32000000, -32000000000, 497750400000, 1.1927710843373494, '82', '082', X'525252', X'52', 0.012048192771084338);
INSERT INTO no_nulls VALUES (0, -33, -3300, -33000000, -33000000000, 497836800000, 1.1785714285714286, '83', '083', X'53535353', X'53', 0.011904761904761904);
INSERT INTO no_nulls VALUES (1, -34, -3400, -34000000, -34000000000, 497923200000, 1.1647058823529413, '84', '084', X'5454545454', X'54', 0.011764705882352941);
INSERT INTO no_nulls VALUES (0, -35, -3500, -35000000, -35000000000, 498009600000, 1.1511627906976745, '85', '085', X'55', X'55', 0.011627906976744186);
INSERT INTO no_nulls VALUES (1, -36, -3600, -36000000, -36000000000, 498096000000, 1.1379310344827587, '86', '086', X'5656', X'56', 0.011494252873563218);
INSERT INTO no_nulls VALUES (0, -37, -3700, -37000000, -37000000000, 498182400000, 1.125, '87', '087', X'575757', X'57', 0.011363636363636364);
INSERT INTO no_nulls VALUES (1, -38, -3800, -38000000, -38000000000, 498268800000, 1.1123595505617978, '88', '088', X'58585858', X'58', 0.011235955056179775);
INSERT INTO no_nulls VALUES (0, -39, -3900, -39000000, -39000000000, 498355200000, 1.1, '89', '089', X'5959595959', X'59', 0.011111111111111112);
INSERT INTO no_nulls VALUES (1, -40, -4000, -40000000, -40000000000, 498441600000, 1.0879120879120878, '90', '090', X'5A', X'5A', 0.01098901098901099);
INSERT INTO no_nulls VALUES (0, -41, -4100, -41000000, -41000000000, 498528000000, 1.076086956521739, '91', '091', X'5B5B', X'5B', 0.010869565217391304);
INSERT INTO no_nulls VALUES (1, -42, -4200, -42000000, -42000000000, 498614400000, 1.064516129032258, '92', '092', X'5C5C5C', X'5C', 0.010752688172043012);
INSERT INTO no_nulls VALUES (0, -43, -4300, -43000000, -43000000000, 498700800000, 1.053191489361702, '93', '093', X'5D5D5D5D', X'5D', 0.010638297872340425);
INSERT INTO no_nulls VALUES (1, -44, -4400, -44000000, -44000000000, 498787200000, 1.0421052631578946, '94', '094', X'5E5E5E5E5E', X'5E', 0.010526315789473684);
INSERT INTO no_nulls VALUES (0, -45, -4500, -45000000, -45000000000, 498873600000, 1.03125, '95', '095', X'5F', X'5F', 0.010416666666666666);
INSERT INTO no_nulls VALUES (1, -46, -4600, -46000000, -46000000000, 498960000000, 1.0206185567010309, '96', '096', X'6060', X'60', 0.010309278350515464);
INSERT INTO no_nulls VALUES (0, -47, -4700, -47000000, -47000000000, 499046400000, 1.010204081632653, '97', '097', X'616161', X'61', 0.01020408163265306);
INSERT INTO no_nulls VALUES (1, -48, -4800, -48000000, -48000000000, 499132800000, 1, '98', '098', X'62626262', X'62', 0.010101010101010102);
COMMIT;