Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

bug: MemTable error: Inconsistent operation with empty Delete Key #12140

Closed
kwannoel opened this issue Sep 7, 2023 · 13 comments · Fixed by #13015
Closed

bug: MemTable error: Inconsistent operation with empty Delete Key #12140

kwannoel opened this issue Sep 7, 2023 · 13 comments · Fixed by #13015
Assignees
@KeXiangWang
Labels
found-by-sqlsmith help wanted Issues that need help from contributors type/bug Something isn't working
Milestone
release-1.4

Comments

@kwannoel
Copy link
Contributor

kwannoel commented Sep 7, 2023 •
edited

Describe the bug

Mem Table inconsistent error. Sometimes this will cause the cluster to hang, and it will still undergo recovery. Other times the cluster will crash. Likely caused by executor itself OR some upstream executor.

Workload is only INSERTs (you can see the sql further down).

Error message/log

2023-09-07T10:26:41.483523+08:00  WARN risingwave_meta::barrier: Failed to complete epoch 5034368603389952: Rpc error: gRPC error (Internal error): Actor 152 exit unexpectedly: Executor error: Storage error: MemTable error: Inconsistent operation 
key: b"\0\xc8\x01\x01\x01\x01\x01\x01\x01\x01\0\x80\0\0\0\0\0\x01\xa0\0\x80\x0bE\xcc\x01\0\x01\0\x80\0\0\x01\0\x80\0\t\x02\x7f\0\x80\0\0\xb2\0\x07\0\x01\0\x01PpMuYH\tOx\teV\0\0\0\t\0\0\0\x02\0\x01tv\ts29Z8V\tS\t6\0\0\0\0\0\0\x02\t\0\x01ONghj5\tjN\tbw\0\0\0\t\0\0\0\x02\0\x017k\tTisez3\tC\tl\0\0\0\0\0\0\x02\x08\x01\0\x84x\xae\xc9\xdcI@\0\0\x80\0\0\0d\xf2a\xd1\0\0\0\0\x01", 
prev: Delete(b""), 
new: Delete(b"\0\x01\xa0\x01\0\0\0\0\0\0\0\x01\0@I\xdc\xc9\xaex\x04\x01\xd1a\xf2d\0\0\0\0\0\0\0\0\0")

To Reproduce

git checkout kwannoel/sqlsmith-debug
./test.sh

SQL (already provided in the branch above):

SET RW_IMPLICIT_FLUSH TO TRUE;
SET QUERY_MODE TO DISTRIBUTED;
CREATE TABLE supplier (s_suppkey INT, s_name CHARACTER VARYING, s_address CHARACTER VARYING, s_nationkey INT, s_phone CHARACTER VARYING, s_acctbal NUMERIC, s_comment CHARACTER VARYING, PRIMARY KEY (s_suppkey));
CREATE TABLE part (p_partkey INT, p_name CHARACTER VARYING, p_mfgr CHARACTER VARYING, p_brand CHARACTER VARYING, p_type CHARACTER VARYING, p_size INT, p_container CHARACTER VARYING, p_retailprice NUMERIC, p_comment CHARACTER VARYING, PRIMARY KEY (p_partkey));
CREATE TABLE partsupp (ps_partkey INT, ps_suppkey INT, ps_availqty INT, ps_supplycost NUMERIC, ps_comment CHARACTER VARYING, PRIMARY KEY (ps_partkey, ps_suppkey));
CREATE TABLE customer (c_custkey INT, c_name CHARACTER VARYING, c_address CHARACTER VARYING, c_nationkey INT, c_phone CHARACTER VARYING, c_acctbal NUMERIC, c_mktsegment CHARACTER VARYING, c_comment CHARACTER VARYING, PRIMARY KEY (c_custkey));
CREATE TABLE orders (o_orderkey BIGINT, o_custkey INT, o_orderstatus CHARACTER VARYING, o_totalprice NUMERIC, o_orderdate DATE, o_orderpriority CHARACTER VARYING, o_clerk CHARACTER VARYING, o_shippriority INT, o_comment CHARACTER VARYING, PRIMARY KEY (o_orderkey));
CREATE TABLE lineitem (l_orderkey BIGINT, l_partkey INT, l_suppkey INT, l_linenumber INT, l_quantity NUMERIC, l_extendedprice NUMERIC, l_discount NUMERIC, l_tax NUMERIC, l_returnflag CHARACTER VARYING, l_linestatus CHARACTER VARYING, l_shipdate DATE, l_commitdate DATE, l_receiptdate DATE, l_shipinstruct CHARACTER VARYING, l_shipmode CHARACTER VARYING, l_comment CHARACTER VARYING, PRIMARY KEY (l_orderkey, l_linenumber));
CREATE TABLE nation (n_nationkey INT, n_name CHARACTER VARYING, n_regionkey INT, n_comment CHARACTER VARYING, PRIMARY KEY (n_nationkey));
CREATE TABLE region (r_regionkey INT, r_name CHARACTER VARYING, r_comment CHARACTER VARYING, PRIMARY KEY (r_regionkey));
CREATE TABLE person (id BIGINT, name CHARACTER VARYING, email_address CHARACTER VARYING, credit_card CHARACTER VARYING, city CHARACTER VARYING, state CHARACTER VARYING, date_time TIMESTAMP, extra CHARACTER VARYING, PRIMARY KEY (id));
CREATE TABLE auction (id BIGINT, item_name CHARACTER VARYING, description CHARACTER VARYING, initial_bid BIGINT, reserve BIGINT, date_time TIMESTAMP, expires TIMESTAMP, seller BIGINT, category BIGINT, extra CHARACTER VARYING, PRIMARY KEY (id));
CREATE TABLE bid (auction BIGINT, bidder BIGINT, price BIGINT, channel CHARACTER VARYING, url CHARACTER VARYING, date_time TIMESTAMP, extra CHARACTER VARYING);
CREATE TABLE alltypes1 (c1 BOOLEAN, c2 SMALLINT, c3 INT, c4 BIGINT, c5 REAL, c6 DOUBLE, c7 NUMERIC, c8 DATE, c9 CHARACTER VARYING, c10 TIME, c11 TIMESTAMP, c13 INTERVAL, c14 STRUCT<a INT>, c15 INT[], c16 CHARACTER VARYING[]);
CREATE TABLE alltypes2 (c1 BOOLEAN, c2 SMALLINT, c3 INT, c4 BIGINT, c5 REAL, c6 DOUBLE, c7 NUMERIC, c8 DATE, c9 CHARACTER VARYING, c10 TIME, c11 TIMESTAMP, c13 INTERVAL, c14 STRUCT<a INT>, c15 INT[], c16 CHARACTER VARYING[]);
INSERT INTO supplier VALUES ((INT '890'), '2CnOMn6u9U', 'kTauMER3gZ', (INT '746'), '0uWCKEovfx', (0), 'pfttZYJSZ3'), ((INT '994'), 'SVvWSeZ3qA', 'yejahbgzEW', (INT '-2147483648'), 'BHBNNpX8Pi', (1), 'OoUwhDTweu'), ((INT '815'), 'gzEu8v9Le8', 'Bm9uU6TB4r', (INT '780'), '1H9pLkyUH6', (891), 'B1R5cPEbfB'), ((INT '793'), 'oBuyJtQB6a', '8o56HRWOKL', (INT '889'), 'S80g77fhXr', (998), 'TxVOfAzy65'), ((INT '2147483647'), 'wZbif6841z', 'g3aHqIqCkD', (INT '467'), 'ylDWifx3V2', (274), '8utuPD8TbM'), ((INT '0'), '5p1vKZTFIf', 'YsIKxA8qyI', (INT '190'), 'qT0nDwcO0q', (758), '5JpoOhEy8m'), ((INT '0'), 'GIoNwmYNvQ', '3NKJGP1gO5', (INT '808'), 'opIOxC1hLf', (808), 'tcYwOqfg2A'), ((INT '-1424108631'), '7hVxZHiSoY', 'X67Y1aqoAo', (INT '471'), 'hK5gSLA5Tm', (513), 'tJFHLiJrzv'), ((INT '978'), 'KmOydQzxtR', 'Nam5S3VzHa', (INT '707'), 'QHYr2uiOIa', (313), 'G0eLbM1Tw0'), ((INT '-1524256179'), 'tYdUVoNL2W', 'b73PWGWfer', (INT '820'), 'WibWP2dtYf', (-2147483648), 'mWcaHB9HxK'), ((INT '318'), '6ful83srEf', 'kN0QdKyXwm', (INT '219'), 'HjjmxJhULN', (2147483647), 'JajUTudt3p'), ((INT '0'), '74YNgwGrRv', 'OJrjFp0Ebc', (INT '516'), 'zqRUzbSyAH', (807), 'WBPYlakpdR'), ((INT '0'), 'w1y1pyMKon', '9ATUd018Xr', (INT '742'), 'kwOCbiI3qk', (208), 'otO0e6DoMe'), ((INT '258'), 'XlQRG3C5Kk', 'I6XitVfMvo', (INT '999'), 'RZgBjZrLuB', (58), 'ZmNgM1JDg5'), ((INT '142'), 'Nndaa1Zxcp', 'TqQ16UpblI', (INT '146'), '5eirn3r7z3', (272), '9SPCU5ViIl'), ((INT '102'), '8tiVRD17GL', 'RlhUxht4UX', (INT '719'), 'mW4agciyfX', (1), 'y8SbufGzzX'), ((INT '466'), 's6kyHQGkM5', 'GlGf90LQID', (INT '562'), 'y8yYeMeRZo', (-280447100), 'cvInjt0Sbm'), ((INT '-1925673506'), 'k3r4wtACl9', 'HzPScYUzkw', (INT '363'), 'Sl6BhFpOnN', (662), 'OIJ54Ig1UO'), ((INT '354'), 'maXUwHhRLN', 'xA8hpE8Jsr', (INT '432'), '4YJotHZJnt', (911), 'x7L4ukqZc1'), ((INT '-2147483648'), 'd6COwRTez0', 'Yhrkq4dgz2', (INT '264'), 'WHpKLoM9HW', (648), '0nwtqIlFhR'), ((INT '0'), 'qRdo7Rpi8N', 'y5nSCDVXvb', (INT '19'), 'mWUDkdt6Fw', (0), 'hRvu5vW7LM'), ((INT '93'), 'bMYea0lfvP', 'ByMQnLaibx', (INT '1'), 'iOKY7Lu5u9', (1572621327), 'Pdpwvya2K9'), ((INT '0'), '4mKS8a77OV', 'dUplQE1I7U', (INT '358'), 'snfJO4dLmY', (443), 'llp3YlSy6J'), ((INT '0'), 'xX3vlW1Po1', 'X5QKQAt5ey', (INT '1'), 'sHFtPIKeQ6', (802), 'tsjCr4NkS4'), ((INT '432'), 'rLvbGG2zTI', 'h0ZJuk8hgj', (INT '331'), '19geSbQ9tb', (0), '343g5GUeAT'), ((INT '2147483647'), 'R1x3B77pbE', 'DxDWoJMPWh', (INT '-2147483648'), 'm2HYGeLvqb', (1), 'pZfap9679p'), ((INT '599'), 'qRbOdmXLXw', 'xhfPvpIv7L', (INT '157'), 'xjtLxl4L05', (168), 'tTohaypGhv'), ((INT '1'), 'HxOo4SKgef', '4tsQOaX2vA', (INT '1567445198'), 'csn09Lkogw', (0), 'SO2IEwDuwX'), ((INT '586'), 'JfVneQypJO', 'QIAVYPkGtb', (INT '853'), 'wdbuY6aMt1', (224), '7FnmkyM4h5'), ((INT '2147483647'), 'OM65VMgnUS', 'HXp3X6cAgA', (INT '713'), 'G07QOFlLtF', (243), 'bu0wxYcbeq'), ((INT '970'), '7tNgoA8arB', 'rnUXw6OiWZ', (INT '384'), 'ORenMR63oe', (391), 'w7syK04JRk'), ((INT '383'), '4nN2iMd1YK', 'P5GOycezeU', (INT '408793093'), 'GfZG3m3egW', (709), 'u0yz5IeDLs'), ((INT '436'), 'XOzGPVovgg', 'lBD4BFIy9R', (INT '1'), '0HxNmsf2j1', (-1206633088), 'jdVo3uD59Z'), ((INT '60'), 'yAhbx6W71L', '0dufeRTlyq', (INT '22'), 'KV0UdVYpCm', (596), 'VWNN5cnSfE'), ((INT '425'), '1qlaU1aMuQ', 'Qdz8bf9LhU', (INT '1905184884'), '1ioiVfgTqk', (452), 'SxQYUQHzta'), ((INT '954'), 'OdRRQiLuiR', 'oO3JfsCIPQ', (INT '730'), '15mOMGzP4h', (647), 'zKR4EFwkMd'), ((INT '-1190211839'), 'YuiojXQo9J', '2PcXyBVENk', (INT '1'), 'YaT7V602Wv', (2147483647), '7AU6C3C1YX'), ((INT '310'), 'WFkHqC7frg', 'GSuc8FBZgu', (INT '180953381'), 'CdXgUyfCRM', (809), 'p6cYDjOGxM'), ((INT '804'), 'S5t9fYLSEQ', 'HpIi8sQh6S', (INT '728'), '3FUxlCL3Au', (820), 'Q4WbmVgAwV'), ((INT '490'), '1TtRmaziL9', 'DA4DW0AhHx', (INT '2147483647'), '9zsB7T34GB', (431), 'Y9gLmxuprC'), ((INT '190'), '6nKKNsBTgo', 'PuNVxICg3O', (INT '363'), 'B6lz2Jq23k', (251), 'GVF0ODkdba'), ((INT '1'), 'besXvaNt0P', 'G0hEuyDJl5', (INT '2147483647'), 'DIR8Dkmcvu', (941), 'nhUxlpIrv0'), ((INT '796'), '0jbFbzqP7u', '721HZb30AI', (INT '20'), 'jMv7fIQOOo', (657), 'ROzDuEXHh8'), ((INT '687'), '0OYntCdxO2', 'A0rq3uRT2W', (INT '532'), 'nTeEy24fCq', (563), 'BCh0ycbrmz'), ((INT '1'), 'Cenut0Whz1', 'xxKcXaYe9t', (INT '0'), 'hh3nomBUl8', (1408676820), 'I4TmUE8LJh'), ((INT '-2147483648'), 'yTxDL4LUhj', 'Zlx1r2vVZi', (INT '135'), '3u7Hu1sC4Y', (163), 'zez9392Q3B'), ((INT '591'), 'DPXfCluWB3', 'W5CjmiAMMX', (INT '657'), 'nkzIV1mMGb', (209), 'JUriab2ZM9'), ((INT '1045295358'), 'kd5ZqXIoT4', 'ck28tq0rw2', (INT '636'), 'wZzYrYQ7q8', (279), 'yUeFZj1OUS'), ((INT '1'), 'Boast7rAdx', 'rJRKrHTkcP', (INT '594'), '5ixOQJroBs', (945), '8fafuQBs1J'), ((INT '304'), 'QIjCTaNHt2', 'XcZuaBryvO', (INT '572'), 'tHmd95doD3', (282), 'y7IsV03vQW');
INSERT INTO part VALUES ((INT '0'), 'hAid0fwqWU', 'HiWEmBcvaQ', 'BTDPs0MDbD', 'VH7j54mtcB', (INT '850'), 'laCdXUdQZV', (722), 'f5wrPryrG8'), ((INT '916'), 'wh9orkQvcN', '82pNVcCLOj', 'f1EUKZ6YwL', 'GtDvZhQpdD', (INT '2147483647'), 'oAgAaB0Qm5', (232), 'fwfnvZjdjr'), ((INT '-2147483648'), 'WXsOs7ROvu', 'FgC4dEY9u1', '8IJttGA2ks', 'uKiAkcEIFW', (INT '128'), 'TaT3wFrddX', (232), 'EH5IYyZhEM'), ((INT '657'), 'OaNy8w0ltm', 'yPTcAMwMB0', '6MJtEGofa3', 'uey7AyZ8Hg', (INT '139'), 'ZYgoQG1HHu', (729), 'ovOBbUeDHd'), ((INT '640'), 'XjZCnpVloi', 'UuNBWZGHNh', 'N8hbKbWzvI', 'ZJmcsPgOgr', (INT '0'), 'rfzRtCwVDw', (81), '9Sxi7ujyFG'), ((INT '-2147483648'), 'hBSfCYhxtQ', 'hjMRQVZURC', 'Kpyi0IAMDc', 'YQBcHIM18O', (INT '275'), 'l75eNq8igY', (222), 'UuoSYrjY0r'), ((INT '868'), 'nS7ZMfFjTE', '6aKdwyZFip', '6NGIXoYn1o', 'JFc52QRQQJ', (INT '881'), '1gzfbvCWzK', (258), 'GNlEht5DED'), ((INT '282'), 'QbJiMp0A3Y', 'eedkXh4VQQ', 'csYiDgBxZK', '5o0DWlyQfO', (INT '1'), '9fvDiNIWyg', (141), '1WN4F5p3Ya'), ((INT '383'), 'HZJkDPwIbS', 'fKVOurTNAI', '1EoSeGIRPq', 'arVlDM1c2D', (INT '979'), 'zVTW1ohqdO', (871), 'hWYWLxxoUP'), ((INT '198'), 'B2l9qZKZX2', 'V6ZHmi6kxI', 'aNJOZAmPF7', 'AUXnvWaHAx', (INT '105'), '0uMZ1RFnhC', (939), 'qKiNXqbsl6'), ((INT '-2147483648'), 'ct8a9Z8BMw', 'ql6MxJN78C', 'T3XVOHYa2S', 'R9Bl7RgcV6', (INT '67'), 'T0nYc8UvLB', (-1313324947), 'oorepzIrd5'), ((INT '402'), 'BIpvpzFNWR', '16yUWE5Kxx', '89S9qsg7Nv', '1xvqYmaBrD', (INT '797'), 'zEUoxD3cXs', (250), 'xu4q97zwZd'), ((INT '616'), 'E7Ofo3soOG', 'n26dzdEwrV', '4LB3rk7ooI', 'Uc1CEnk5L1', (INT '-2147483648'), 'UtxfckuhOV', (712), 'bAhIRCa06k'), ((INT '716'), 'ZJ0z4klYwo', 'uI8XP4g634', 'vdFFVuVFZk', 'n0QHpv756y', (INT '123'), '1MUuZ19SnG', (620), '2q9JboydTk'), ((INT '515'), 'gYF5DVt1DU', 'Nn5CFBcKPM', '7a1yIna2hX', 'oRAugtJsbk', (INT '938'), 'KDktVZYthx', (1361043068), 'MYXBIHrpPR'), ((INT '425'), 'lsEKrbpTPl', '9xEuZRTae9', 'GtKmjEwyxk', '7BlMA3PlJa', (INT '351'), 'dlBTJw8oFq', (18), 'honxOLgbK5'), ((INT '592'), 'VoFszMkA39', 'z02zu2gCyx', 'stxSfIpSMJ', '6xWosaBqxv', (INT '681'), '7tuTJ5BHe4', (21), 'JEFxwfY5QG'), ((INT '805'), 'eO36DIibZT', 'ELWsGcgF4w', 'YasqurgxLw', 'HbgVPW46vE', (INT '683'), 'DIqWq61AEH', (366), 'vrBQKO5CRv'), ((INT '49'), 'xk9AJY6AdY', 'PkKssS8W1V', '5yM33t0skQ', 'xaxzVE99S8', (INT '854005308'), 'y2g2evkYWs', (943), 'tjMR3sZJrP'), ((INT '681'), 'r3XYll6TFw', 'oCHch5ZflE', 'zdqvvEu3OO', 'jRY8vy6LUV', (INT '641'), '297P3B4JNn', (161), '3TsxdynPNN'), ((INT '0'), 'kFmrlnO7E8', 'YqzY0Q8Bq1', 'lH3cKh46aK', 'IcJGYmwpqQ', (INT '-2134984922'), 'GUyukWScLZ', (726), 'E9BXyVC1qr'), ((INT '1'), 'HZ94OhQ5aC', 'iozF1kJTQ3', 'KnD9925v8i', 'yQQmJ6n5xs', (INT '1'), '2d3W4QedsM', (73), 'XnPcK5j9yE'), ((INT '600'), 'ehujIxtudO', 'GcJksFPn4F', 'C6UDoqWqPe', 'd02HYmcNep', (INT '600'), 'peArqyWmgZ', (39), '77Wqcnb87x'), ((INT '1783562266'), 'b6p3kLIGmn', '0ruDglaR4C', 'elmXQFYWgj', 'rD0e72hSQi', (INT '-1152112467'), 'nRLOXO65VF', (303), 'fdfDOzwkgC'), ((INT '202'), 'othyz3vv4A', 'y9VKsewtZX', 'ELEEzw8k9w', 'g7M1At3K0m', (INT '841'), 'XHT9mskxPk', (818), 'g0HUxy4e3w'), ((INT '658'), 'hRka8q7f9M', '9J57oohaMe', 'OJbmKJ9XVF', 'K65QbZm0ph', (INT '1'), 'PTNejfekNw', (539), 'QStMywSJiL'), ((INT '120'), 'BZj3Ofq4DE', 'Z8VcdDPuG1', 'IfIFaK7Xvo', 'Mjz09zh9eH', (INT '465'), 'qBJJFYfwRv', (1), 'bmL5txxWE8'), ((INT '143398058'), 'XHY9sxgVO4', 'UsPcBkOhU9', '0p0xVHCXmT', 'jjjs0xGEFx', (INT '55'), 'NYT7U1B52g', (1127664330), '833NA2MRxM'), ((INT '886'), 'okBVP2IFTP', 'DsS0ibvcIL', 'NrMVspcCC5', 'Sdd61WdS6C', (INT '92'), 'NRIdWvz4h0', (351), '7RraEZm7fE'), ((INT '399'), 'OokUd0oTnE', '9pciEVI83b', 'ehrCdKoOQn', 'mbIVjyojjY', (INT '934'), 'S66MQjcKQY', (354), 'EQt2dT9A3t'), ((INT '375'), 'sXRq6G8hb3', 'ee6FKIe7yK', 'fEx7ZFsHzz', 'mtaPliyLtM', (INT '952'), 'M24X3XUAHt', (668), 'KJbHVmHUot'), ((INT '752'), 'WWoZybMb53', 'FS1mayOOVb', 'OSkyh3v5KY', 'bhYXyqNKB0', (INT '1'), '3oRHB1alK4', (1899670187), 'PRQ64hcNoX'), ((INT '449'), 'gQTJeoTiWm', 'sE1vgF88tv', '6YYwjLde9N', 'PzmS0w4aYt', (INT '189'), '8aqksBIJB3', (985), 'pN2ycEYcbp'), ((INT '347'), 'tTouNLEtvs', 'LoxoWBa3xV', '6J6BP98upI', 'jktaKwOPqP', (INT '681'), 'ZPM6ZXY8Cr', (190), 'AbjHyobMJm'), ((INT '373'), '4BQF7g7X4W', 'ZhCPOYAULb', '1r6jLn6TAL', 'gkTdvFoCvm', (INT '977'), 'd94NY10dqb', (854), 'g1xM8uKiWP'), ((INT '958'), 'KHTL1wBJpx', 'cEnzQTu5su', 'UEjOUnkVIP', 'KD73Enlrfc', (INT '1603375569'), 'rz9vzBoWzI', (930), 'FOsUY2tcVj'), ((INT '2147483647'), 'hXuV46qrBP', 'Qu5pFkQAWY', 'ljSWarhnyv', 'kq7HCKAQpu', (INT '981'), 'k5qU5tLEaS', (731), '9a2xPUiBoO'), ((INT '340'), 'mOv2m90pkV', 'EUomuENMjg', 'VumfYVKdqj', 'okVamoI2ZD', (INT '324'), 'G69omauDWr', (382), 'ftrh2fUKup'), ((INT '73'), 'xdUq2RKcjg', 'iszIjSi2jz', 'u31A7HkzhG', 'lBMGIHFycY', (INT '2147483647'), 'UEyr7rLO8P', (142), '73a8YlWF3Z'), ((INT '-1289120294'), 'qVY0kTtXK2', 'QVfWeXUMJU', 'kU4XSlFS1b', '8jlfGek6K6', (INT '-2147483648'), 'iRN1QeiluK', (283), 'IEMCbHvCbs'), ((INT '332'), 'pdfeZMsVFt', 'oF3488BWeo', '0xuIc4y02z', 'LzZi0uPhDC', (INT '1830468412'), 'HmKvgk3Rms', (2147483647), '1Yyczh8ZFd'), ((INT '2147483647'), 'xMLfmxokYy', 'zOP9HMRU1E', 'Nz9LPydSEp', 'nhMqGpOj87', (INT '343'), 'tX5H8X8May', (2147483647), 'yjalcz9Ylt'), ((INT '716'), 'iYwVRLNAit', 'LI8MraPDcp', 'V3lnJyfqKu', '7YVjXOAwGO', (INT '393'), 'JPNaE7q0dN', (124), 'lo3eG4QqK9'), ((INT '251'), 'BhjSUBxDMn', 'PlwARwmSX4', 'is8RjWsUJp', 'uoqL3K8gPq', (INT '111440974'), '6rJMJftfch', (958), 'YcrLyECTjS'), ((INT '620'), 'NZQEzuQKYW', 'KfL4tH7cw7', 'CAIOlltdAY', 'TE0P8nBJ0e', (INT '922'), 'Qmc9PNZlEs', (438), 'cZXgds6oVm'), ((INT '0'), '5FiEnvx8cl', 'WxWvySokRe', 'o4NLLquPUx', 'LsgVEZgs0V', (INT '-1718337477'), 'JsWcNmNBw7', (577), '5kY3Yz3DpB'), ((INT '782'), 'eWQmVHZoYv', '8xd9I5kS8D', 'TpxxZDLp1P', 'D0fYm44uRu', (INT '2147483647'), 'HFYhVWz5MK', (2147483647), 'o5roO2kf0c'), ((INT '137'), 'txTgjTHA0o', 'QBnmDhTtGR', '44dMdRyKUF', 'w5pdTheLL1', (INT '834'), 'HsHRPEgoCE', (287), 'xLypll4ZAB'), ((INT '-1546431307'), 'EjBxgoDvDd', 'CNBpbTqSLR', 'uuDhmwrSdp', 'qCDd44wgjl', (INT '940'), 'OZsELqf9xE', (849), 'RxNvMk7OV7'), ((INT '4'), 'Pr9yeKpnz6', 'UsfvDBvjLl', 'wgCmh7D4R9', 'THKq6sMyZt', (INT '235'), 'BZ39cGRaqG', (217), 'mdy93EoKZs');
INSERT INTO partsupp VALUES ((INT '20'), (INT '64'), (INT '-2147483648'), (-2147483648), 'ZuT4aIQVhA'), ((INT '1'), (INT '769'), (INT '262'), (884), 'zT5IIoj67d'), ((INT '809'), (INT '0'), (INT '882'), (585), 'mvmVNzd8Fy'), ((INT '600'), (INT '-2147483648'), (INT '0'), (588), 'mV1LQM5q3x'), ((INT '-1837245125'), (INT '684'), (INT '622'), (4), 'ivVn3ls3Bq'), ((INT '169'), (INT '760'), (INT '844'), (436), 'U7bJg7SBOh'), ((INT '281'), (INT '986'), (INT '2147483647'), (773), '0CxL1EZXml'), ((INT '579'), (INT '-1630364959'), (INT '199'), (712), '4e5wQsv7Y2'), ((INT '458'), (INT '-1543659340'), (INT '375'), (46), 'm829tPXJNE'), ((INT '823'), (INT '659'), (INT '844'), (236), 'q7N6LnlLNs'), ((INT '1'), (INT '1176273159'), (INT '-1964166703'), (525), 'TNjOFWsj1p'), ((INT '786'), (INT '314'), (INT '577'), (250), '2FNPjgNEBf'), ((INT '153'), (INT '272'), (INT '0'), (1), 'f18EY4zEmD'), ((INT '955'), (INT '175'), (INT '2147483647'), (487), 'fkjspm9Kc7'), ((INT '504'), (INT '1'), (INT '815'), (379), 'AVE8LN9Ann'), ((INT '958'), (INT '249'), (INT '0'), (182), 'Rikl3YCljM'), ((INT '-978852315'), (INT '28'), (INT '493'), (-597332640), 'la3RGUjJ3o'), ((INT '0'), (INT '290'), (INT '43'), (242), 'VWboNiCIAq'), ((INT '913'), (INT '755'), (INT '276'), (10), 'DwSqrAmqhV'), ((INT '-1632812089'), (INT '1843266085'), (INT '14'), (1), 'OAVCII46cY'), ((INT '855'), (INT '3'), (INT '300'), (118), 'oEsjc7cPCq'), ((INT '0'), (INT '939'), (INT '944'), (727), 'Iu8KnhGQS6'), ((INT '432'), (INT '790'), (INT '237'), (125), 'YxAo3eUxVp'), ((INT '249'), (INT '922'), (INT '1'), (-2147483648), 'Qp9CqOd281'), ((INT '662'), (INT '-254003305'), (INT '938'), (600), 'DjD2RP7YNR'), ((INT '55'), (INT '-2147483648'), (INT '8'), (0), 'XcOoNjoWqM'), ((INT '239'), (INT '989'), (INT '910'), (913), 'aPwnLO38j4'), ((INT '158'), (INT '429'), (INT '2147483647'), (0), 'UKV4wUdm5C'), ((INT '684'), (INT '781'), (INT '614'), (115), 'wMB55ll7ql'), ((INT '61'), (INT '815'), (INT '655'), (-1179263335), 'tXm9HJPuur'), ((INT '0'), (INT '343'), (INT '2147483647'), (526), 'tN8KEEehSM'), ((INT '0'), (INT '713'), (INT '0'), (90), 'YtT0w1fMHT'), ((INT '586'), (INT '790'), (INT '344'), (452), '2rSebF5yr0'), ((INT '-2107917908'), (INT '151'), (INT '739'), (602), 'oYpzFTixKc'), ((INT '-2147483648'), (INT '3'), (INT '-2147483648'), (403), 'gqOOKhoRoZ'), ((INT '2147483647'), (INT '1'), (INT '632'), (0), 'iZscNRNUk8'), ((INT '2134100685'), (INT '830'), (INT '312'), (343), 'LuigRb1B08'), ((INT '2147483647'), (INT '491'), (INT '-2147483648'), (357), 'OFdvGSQto8'), ((INT '325'), (INT '671'), (INT '319'), (978), 'IRLWytI9L9'), ((INT '738'), (INT '-1488234063'), (INT '645'), (818), 'smxrIxPwv6'), ((INT '588'), (INT '653'), (INT '0'), (2147483647), 'NQTwGpIg7h'), ((INT '272'), (INT '790'), (INT '427'), (670630956), 'Lx1hHFXAnq'), ((INT '176'), (INT '106'), (INT '680'), (446), 'rf8KHdTZSu'), ((INT '411'), (INT '707'), (INT '462'), (156), 'EyEKOaFaCj'), ((INT '444'), (INT '109'), (INT '539'), (87), 'zPSkVCjd7H'), ((INT '790'), (INT '567'), (INT '0'), (703), '4HpjbBdCJ3'), ((INT '455'), (INT '0'), (INT '561'), (90), 'iHKbQgGSYK'), ((INT '1'), (INT '469'), (INT '183'), (341), 'OIwYDTCGQc'), ((INT '504'), (INT '256'), (INT '96'), (2147483647), '4FORTdJ6os'), ((INT '204'), (INT '0'), (INT '497'), (2147483647), 'AFfyPOyhTW');
INSERT INTO customer VALUES ((INT '54'), 'Q0gcRxIE1v', '2Tjpry9Of8', (INT '-2147483648'), 't5wpjKRFWI', (82), '9eYtJ479eY', 'nw1l1IiAuO'), ((INT '36'), '1gfyxoMyz4', 'eC1bk4a33t', (INT '664'), 'ZvVOIQGmZh', (272), 'yw30RwZ4jG', 'zfrOaKlW9r'), ((INT '63'), 'xJPZfE5TMx', 'N76ZnRHmBX', (INT '593'), 'FndUdLGPxN', (567), 'Rz5qhbTQRt', 'CVyZrW5qz9'), ((INT '864'), 'G4J8My6nsU', 'uqnaBf8vIx', (INT '622'), 'TVD86sJr9g', (1), 'IUktoE8KQE', 'ENyF1a3yuI'), ((INT '806'), 'M7oir54NLV', 'vLxPEMLvtA', (INT '77'), '9n8ILIaZgB', (1), 'xhFU0poPrc', '315Z15l6IC'), ((INT '155'), '4Rffgs98zl', 'oWvhYsh2Lb', (INT '598'), 'dpZfN3yTXn', (677), 'bDcJMMQJ3z', 'bJDYglpbxN'), ((INT '823'), 'k1ubxQlbzZ', 'ntautm7t3D', (INT '396'), 'MCCzmN9IjH', (643), 'IVn5fLrLbh', 'P9icPNcXue'), ((INT '918'), 'OyxDdcoIV1', 'jV0iXu2Izn', (INT '792'), 'AfRAHQcyfi', (62), 'razuAUt7Ut', 'r1dxcH70pg'), ((INT '723'), 'Ey0HJMO8zo', 'XEuGZDDzrl', (INT '387'), 'UeoQltzxhY', (810), 'eGdpGSs5OR', 'ol68YHATNZ'), ((INT '554'), 'zM3jXyLo1a', 'XA69L3kBjW', (INT '145'), 'IBDbxg5iWY', (840), 'Ks2q3598C2', 'gvFBC1kFbq'), ((INT '968'), 'HdKWYhsCB4', 'wqbbo79Nfc', (INT '1'), 'LFEUmzSH1i', (150), '7XS3px3S31', 'iUOAFfl7gU'), ((INT '38'), 'bB4pJKKO2t', 'H2z9yKGCau', (INT '335'), 'Jp4GxIfDGs', (669), 'wbKTCSm2sd', 'mBi9M8HaYd'), ((INT '449'), 'yr3RHQmfH8', '2cOVI7pmxm', (INT '335'), 'uGHl7nOrm1', (382), '2VMmycMOgS', 'iJ3XaB0Tzp'), ((INT '477'), '8jWfQTeJpj', 'd1zbdCggtx', (INT '186'), 'bB7q5ZT1Iu', (567), '19PWYyEpoi', 'AXBc3BoAUv'), ((INT '-2147483648'), 'iwLvrxU4TP', 'ZNRGr8savC', (INT '2147483647'), 'VNY0XFEoEJ', (29), 'YQqCfmKT3R', 'YGEop34SSp'), ((INT '1'), '2cH9GjdcX8', 'fCOy4HkILM', (INT '227'), '9ONd1pAZ74', (303), '2Utxycz9Uf', '2iMI73G5Bw'), ((INT '2147483647'), 'e0rgtbPcIg', '2iN5FLsqLx', (INT '191'), '63VyIkhGwE', (727), 'GBPZAdWMPh', 'SJXEn4lCJP'), ((INT '1'), '6PcefX6jgW', '0VaY61Z3gb', (INT '-2147483648'), 'gb903JO2lI', (0), 'fREv60akJ5', 'E71RDEsMgE'), ((INT '507'), 'ln87YtanI8', 'fclj9Kz063', (INT '166'), 'WZLylIuU7R', (177), 'spxgF016Ol', 'vKbnsVqXCF'), ((INT '333'), 'D86p0uWV8o', 'CTGsA4HtnE', (INT '249'), 'cFJEpKa0KB', (-2147483648), 'Ze5YY6tN0t', '4ugP655Ji9'), ((INT '123'), 'fAHOD8DbDP', 'mvOMPyT92X', (INT '2147483647'), 'F5V7vLzhMt', (0), 'OV24lsH0Ry', 'Q7zE3fM9Vh'), ((INT '401'), 'PcoIlsOAHc', 'um2aiUgtNL', (INT '1985660180'), 'QRjHnCfIQ6', (727), '7XWnx4Neu1', 'yRXRTTGV4C'), ((INT '597'), 'iR5IlOimq5', '68ipr7kkXt', (INT '201'), 'o6crPAH23y', (459), 'IwEmy6sGor', 'gbBCWneAWg'), ((INT '990'), 'eUsH7DfPzc', 'PWKkFUMmZq', (INT '544493310'), 'aaQLtyFquG', (486), 'w8YbhXsQc4', 'agYI1yDHmN'), ((INT '623'), 'DGaEzQplQH', 'U9CFJglHZ9', (INT '165'), '9fVmErnqU8', (-2147483648), 'dKdSIAGCKR', 'ZshL0uQ21t'), ((INT '0'), 'JuyBYjy7Gq', 'll3DotwwIf', (INT '-595512541'), 'ETFasAdOXJ', (878), 'lBbdVyHGJC', 'bVFtOhPiev'), ((INT '611'), 'LLfrtVB2nA', 'qbIx9lK5im', (INT '20'), 'F4tGKRk5jx', (0), 'CvyhrhbZjO', 'ajDwkqc0WZ'), ((INT '796'), 'vvT8LlvsEj', 'wJSwtty7S6', (INT '239'), 'eWLGq9BTyM', (2147483647), 'sMY9DRpNBW', 'LTXrsFybWu'), ((INT '922'), 'Ysi83AvvBm', 'B6X77Z1ttY', (INT '903'), 'OtsS8jXgFR', (84), 'DmPW0QRZRF', 'ptqKr4TcJG'), ((INT '28'), 'b2bYdiYLNd', 'RvKHHCxUVU', (INT '-1608841530'), 'da0zMBpYbw', (465), 'bcu5gPparL', 'Pj6wmo2bSi'), ((INT '558'), 'VmWIOq2AG0', 'VzHFgA4HAm', (INT '384'), 'weOWqBxQJC', (390), 'NrTr9v6ERv', 'iRGPFVua09'), ((INT '-229573692'), '5YwEJ3FrP3', '9ksw21g9j8', (INT '470'), 'YcPHtk9G8R', (477615460), 'OUV7jwL1jA', 'xUENf1oSNX'), ((INT '515'), 'EFVgmPwALd', 'Wm4aATaRsD', (INT '372'), 'MPh6aVQTcR', (735), '4WwFdxdZ1b', 'MJ8X3eqFEU'), ((INT '310'), 'yCmOmurrBV', 'Xa0yJq2oeE', (INT '0'), 'Kt1Z7H0Uji', (397), 'iLBEGgbycd', 'aHAF9z2QBM'), ((INT '191'), 'BqPYY5jJqH', 'yqT0cxZ4IC', (INT '2147483647'), 'BBPP9SNmmU', (713), 'WgyoU5gGED', 'Zh0o3khy6Z'), ((INT '-919309489'), 'FMK3N6xj8N', 'FTLsujM51C', (INT '0'), '308y4wfO3v', (650), 'BaSLs1izCc', 'MDCbovPpVr'), ((INT '610'), 'dFWS5Idmlx', 'Lou5E7Ej75', (INT '945'), '1ZmHxAQzVk', (0), 'rAlfs6DTV4', 'B4nAJ4F62v'), ((INT '2147483647'), 'enG3EqqusO', 'NDI0ell73j', (INT '788'), 'uhPsiFYB0e', (-1292162814), 'p2Tah5n4tu', 'CzWopSuCIa'), ((INT '825'), 'QDdnZYzfWE', '6iP1TUzOfO', (INT '959'), 'cIDy3WLbUs', (45), 'ge1gPSjIZ1', 'qD6sTCFSPC'), ((INT '319'), 'fY2cYTrQvC', 'd31od40WMV', (INT '432'), 'PCWxMXs3yN', (806), 'w2YlBOTlES', '52pCEuHY8e'), ((INT '-2058111476'), 'VdA4PUWb4I', 'MmRKEVLd6i', (INT '1'), 'b9PMoT6BMo', (74), 'zOeJhVe8xa', 'oyUFg30eAz'), ((INT '709'), '3eNELkmrjp', '9KghQiWSfM', (INT '254'), 'vWYRmk55Sn', (917), 'SacrMEIPaM', 'GOl5qpwxCJ'), ((INT '205'), 'GWl16OPlgu', '3BJh60XTWt', (INT '767'), 'N8S0OTyBYb', (2147483647), 'RDsFrnjYbH', 'lwNVOJuON5'), ((INT '778'), '7GXhEd4GkJ', '2aHP0VQsTF', (INT '786'), 'yM5P1Grbq0', (1), 'M2t36y84vT', 'HKiGSpN9Zb'), ((INT '126'), 'XciqMNZulG', 'hw7tzNbGoS', (INT '57'), 'nEWAeNi4pO', (-2147483648), 'N6cANvYILP', 'iOQicIEXkN'), ((INT '459'), 'd8uImQjZYS', 'tYJ74pKiOr', (INT '1'), 'ENDjxTNIj0', (416), '2nXBCZVREq', 'bff6JGZfRb'), ((INT '78'), '2O0HrYlcXz', 'yXuEfByvSn', (INT '317'), 'pb8t6pSuP8', (501), 'o33d6bzm5w', 'reoIKzocK8'), ((INT '456'), 'A21kj4HBrh', '1mVRcyg4ks', (INT '27154865'), '1ZqNx2WtZx', (857), 'hGwHBRHKt8', 'wgMxT1vXAP'), ((INT '0'), 'IsfGpVdWSp', 'QBu5VAJJES', (INT '231'), '589rQFQMMt', (572), 'XmMvWBgTGu', 'GfULWgvkyN'), ((INT '337'), 'amYvThPA1M', 'KPQWufUxE9', (INT '387'), 'RcySah3IDe', (2147483647), 'vHEao9Wg1K', 'pIqp7oN82k');
INSERT INTO orders VALUES ((BIGINT '1'), (INT '671'), 'Q5MeE8OSZl', (346), DATE '2023-09-01', 'eF1h6fGvnJ', 'hZGCb8Vg79', (INT '440'), '16HVFC5S54'), ((BIGINT '595'), (INT '526'), 'SInajQwphl', (843), DATE '2023-09-01', 'vulrqOL23A', '1RhY2xAIOx', (INT '518096001'), 'jK0SLzjrT5'), ((BIGINT '545'), (INT '246'), 'rUzYzJzyUU', (350868241), DATE '2023-09-01', 'OSvARaxQuy', 'gxawny6WJg', (INT '-822154520'), 'aD554chBuT'), ((BIGINT '101'), (INT '464'), 'mTWVHOskin', (954970996), DATE '2023-09-01', 'ihEbZJ6xMH', 'EwYwwfn7I6', (INT '904'), 'auPrwQBwzb'), ((BIGINT '48'), (INT '737'), 'IoJkGvdcFH', (578), DATE '2023-09-01', 'WwPwB17OB9', 'SdTeeaxKAA', (INT '838'), 'PVFeiITcjq'), ((BIGINT '3864694792261203251'), (INT '775'), '6gI9rODhBe', (2096891395), DATE '2023-09-01', 'uypZWmMV4R', 'JPtdMo5lHK', (INT '25'), 'YAOhC2VIAX'), ((BIGINT '693'), (INT '1'), 'MWd3IJBb0j', (699), DATE '2023-09-01', 'eqRvcyhXh5', 'kNS48xAClP', (INT '929174588'), 'BhPWS40XNR'), ((BIGINT '147'), (INT '1'), 'Y2rZLgGsI5', (0), DATE '2023-09-01', 'JCf96er7yM', 'VEZvY7hcng', (INT '2111374660'), 'v577JXIjwk'), ((BIGINT '0'), (INT '217'), 'lvqvJw80Ub', (-1326438389), DATE '2023-09-01', '1aTIrHgWlT', 'aE6DbqU6qd', (INT '733'), 'fBjWBYzPbq'), ((BIGINT '742'), (INT '2147483647'), 'xUMcWIgy5Q', (0), DATE '2023-09-01', 'yY9nNQUu8U', 'WbE6sjfd3t', (INT '104'), 'jNnZRs5gcz'), ((BIGINT '9223372036854775807'), (INT '215'), 'cFio1ZVhQB', (-2147483648), DATE '2023-09-01', 'nQJxO3G9gb', 'SqYfq8JyqT', (INT '-534030677'), 'APPKeq8U5Q'), ((BIGINT '1'), (INT '-2147483648'), 'hCbHLmVvuy', (69), DATE '2023-08-31', 'AalyNkyjIv', '256gJdPDxw', (INT '1670319528'), 'qjka7iPjQC'), ((BIGINT '337'), (INT '923'), '6s3A0McG1W', (0), DATE '2023-08-25', 'XoIkMZP4Sc', 'UM2rprIyRt', (INT '488'), 'gvnG34ZTH3'), ((BIGINT '317'), (INT '-2147483648'), 'RTow7uqsWo', (141), DATE '2023-09-01', 'EFCFmWX8tT', 'dGAqNmFtcJ', (INT '915'), 'gLn3TJO4uH'), ((BIGINT '514'), (INT '1879062048'), 'S6WKMbBAwi', (1), DATE '2023-09-01', 'yP3ZNwnXTi', 'M287VxuHlU', (INT '688'), 'EmUgWX4Far'), ((BIGINT '287'), (INT '0'), '9vU8wxM8py', (168), DATE '2023-09-01', 'cOTBgAGuwZ', 'GM5Xvld4MR', (INT '631'), 'KZPr80dNhP'), ((BIGINT '416'), (INT '-146048288'), 'slKpr2RYlc', (117), DATE '2023-09-01', 'TWLs2MzqyO', 'BQYzFYra0T', (INT '113'), 'b1acp1hdjj'), ((BIGINT '388'), (INT '774'), '7BTDIrEky2', (374), DATE '2023-09-01', '0o9P9S7Fsb', 'jpSjYWp4QY', (INT '-2147483648'), 'Yt4wISoKH6'), ((BIGINT '118'), (INT '798'), 'rNuBvENKwY', (123), DATE '2023-09-01', 'eJOTSeQLKs', 'PhFuwvRk5O', (INT '-460211194'), 'dqsT95HC3G'), ((BIGINT '1'), (INT '-2147483648'), 'KJyfENShul', (792), DATE '2023-09-01', 'Udw68sxZkO', 'WgDUSdiidB', (INT '0'), 'jQbxahSrew'), ((BIGINT '0'), (INT '642'), 'GgXoL7Liva', (-1217817109), DATE '2023-09-01', 'd7XbUNK18x', 'agbvTYwH6o', (INT '553'), 'FO347OhUwr'), ((BIGINT '372'), (INT '496'), 'I9yKn5fcCq', (-2147483648), DATE '2023-08-25', 'JV6MkQbi4N', 'A9A3TIuXsC', (INT '-2147483648'), 'm4SpnFAgSC'), ((BIGINT '394'), (INT '1'), 'AXCxgfrNwY', (1), DATE '2023-09-01', 'u2Xmix9PJz', 'u8hhGNEBoD', (INT '-2147483648'), 'kGWXE28jGM'), ((BIGINT '780'), (INT '368'), 'CrBrxCx5CT', (321), DATE '2023-09-01', 'VcvWw62hlA', 'Hl4wM7vIh0', (INT '999'), 'K8CICchjoQ'), ((BIGINT '139'), (INT '510'), '8GbR5FmtxX', (51), DATE '2023-09-01', 'fSC9aTdbQz', 'ZjgpCwIPNR', (INT '743'), 'tUSS0k1eVk'), ((BIGINT '79'), (INT '98'), 'NLGuvsWBQc', (745), DATE '2023-09-01', 'e3bU0CjM2k', '6AvnzugDef', (INT '853'), 'WVZPVVw3jS'), ((BIGINT '194'), (INT '124'), 'ivgzWGiBR6', (726), DATE '2023-09-01', 'hxMtVMYqAX', 'Ai1FZhy2r9', (INT '786'), 'XdyUnU1LZi'), ((BIGINT '662'), (INT '2147483647'), 'bxTDOP0r9l', (690), DATE '2023-09-01', 'q6u03seKEI', 'T1XnE50g7T', (INT '864'), 'kuWV4QrHxh'), ((BIGINT '59'), (INT '-211687592'), 't456B69eDE', (44), DATE '2023-08-31', '6fGx22HKPY', 'wmIVS21hnU', (INT '2'), 'WcAEsCJnI4'), ((BIGINT '160'), (INT '203'), 'ofHnRKGHdB', (1), DATE '2023-09-01', 'oODkpgtVfY', 'neVAxA1wZj', (INT '259'), 'pP2ambFsvu'), ((BIGINT '5059974784014634619'), (INT '304'), 'MNlZFvJUzA', (411), DATE '2023-09-01', 'RVPWRLNHxP', 'qxW6iLLBkm', (INT '0'), '75RECr3R2S'), ((BIGINT '301'), (INT '-439178822'), 'KNIA6vCCFD', (625), DATE '2023-09-01', 'vtooX2ux6X', 'qIULsnoMYY', (INT '847'), 'jYZlIqqqNL'), ((BIGINT '532'), (INT '104'), 'k2Jh4AjbpZ', (529), DATE '2023-08-25', 'XyjZ4ryaFX', 'xfAbSE8Wyu', (INT '533'), 'mgnKsFpYjc'), ((BIGINT '9223372036854775807'), (INT '826'), 'SpHUVl8rXZ', (2147483647), DATE '2023-09-01', 'LPefLovCqU', 'IBqdj7OSio', (INT '60'), 'yBpDgvgyjL'), ((BIGINT '843'), (INT '-1717136769'), 'yu0wd2Ij48', (961242917), DATE '2023-09-01', 'jWmgHQNQNM', 'zxO2jrWYod', (INT '940'), 'WclaR94Y1g'), ((BIGINT '51'), (INT '1'), 'HXZNBdpl8M', (2147483647), DATE '2023-08-31', 'oPd33xzO0w', 'tuA94UUEy2', (INT '294'), '57McRmZjnv'), ((BIGINT '812'), (INT '907'), 'CSRMlWI7oa', (978), DATE '2023-09-01', '6mtpxvBj9E', 'EupEahx6zl', (INT '180'), 'tGjRgzLFeg'), ((BIGINT '801'), (INT '-2147483648'), 'FUDSmnPEEx', (1), DATE '2023-09-01', 'tx9YvjAEEY', '6tSTP9UN7j', (INT '198'), 'WDDvq0Stqt'), ((BIGINT '917'), (INT '483'), 'VSqrEjBdAd', (295), DATE '2023-09-01', 'DftaVVXkfz', 'OftOXoB7Uv', (INT '495'), 'WupwR6a68Q'), ((BIGINT '267'), (INT '200'), 'emJAxMNLY1', (1696162878), DATE '2023-09-01', '5Ebkp5VhNz', 'ZjGsovGR3c', (INT '313'), 'KTYgN5VQ16'), ((BIGINT '-9223372036854775808'), (INT '6'), 'suzceVZB1d', (61), DATE '2023-09-01', '1V4HoiTSod', 'YxwwEhnC2s', (INT '485'), 'OM1i9LF165'), ((BIGINT '0'), (INT '370'), '7v7HkkyGpH', (645), DATE '2023-09-01', 'jeKb8ayGgo', 'YTU1KqagpP', (INT '794'), '0zpNW4isVM'), ((BIGINT '0'), (INT '-1981209318'), '3ut2O21uCX', (297), DATE '2023-09-01', 'YHAKpbWA3x', 'vMhmJwugWe', (INT '262'), '6Dc7yFCZZC'), ((BIGINT '796'), (INT '585'), 'fK1QDu0iiC', (664), DATE '2023-09-01', 'muHeYXr1FH', 'eF4JFV7oKD', (INT '714'), 'immElCLnHv'), ((BIGINT '258'), (INT '555'), 'hoNwSjVG5h', (263), DATE '2023-08-31', 'JVkLfeMEbG', 'lHozdtN2X9', (INT '861'), 'UJRc3047n4'), ((BIGINT '495'), (INT '68'), 'Q00yfsKiU6', (124), DATE '2023-09-01', 'No5AyuWEOK', 'DeNOkHLhO5', (INT '673'), 'snG7qy6BMP'), ((BIGINT '840'), (INT '350'), 'uvCviQsF7E', (509), DATE '2023-09-01', 'sppRpBYTQS', '9qApf9gsx9', (INT '64'), 'HLx0swsm8l'), ((BIGINT '369'), (INT '514'), '7rWrCQ1XqJ', (646), DATE '2023-09-01', 'kr26xZI8gE', 'jWY2tjjqga', (INT '-1450982873'), 'IVo9wmu6C1'), ((BIGINT '915'), (INT '420'), '6imNCK6fdm', (829), DATE '2023-09-01', 'zDOTCw1z1Q', 'bOjQQZxQEd', (INT '533'), 'SpZAEqGITY'), ((BIGINT '308'), (INT '659'), 'xEyZq9Tr9K', (0), DATE '2023-09-01', 'HbMEwvss5b', 'gR6FJ5oiyl', (INT '626'), 'z40ScHKy9V');
INSERT INTO lineitem VALUES ((BIGINT '303'), (INT '2147483647'), (INT '529'), (INT '1568085131'), (150), (314), (0), (110), 'XCtaVSPr6D', 'JMQUV77KYK', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'asSyHwfRYX', 'y7UkYFFGZD', 'OC8TkBYLdy'), ((BIGINT '9223372036854775807'), (INT '1270555601'), (INT '2147483647'), (INT '965'), (-2147483648), (598), (89), (2147483647), '3lU1XOecS1', '5tZsREHPtu', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'cjvShLlZvS', 'PFGFatZU5K', 'Zwu3w7ACSO'), ((BIGINT '1'), (INT '486'), (INT '627'), (INT '359'), (-1757297476), (874), (478), (43), 'b4IVLcNzEf', '6vo0bumtgB', DATE '2023-08-31', DATE '2023-08-31', DATE '2023-09-01', 'zBP4ukBmmG', 'pCtxFEHdeE', 'wsTZJlynE9'), ((BIGINT '560'), (INT '679'), (INT '143'), (INT '2147483647'), (1), (263), (343), (856), 'V9d3EXxLsn', 'K2URfuwgjT', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'sLKCrl5qlZ', 'IN4lAB9pZf', 'sXcQGSb0jv'), ((BIGINT '973'), (INT '710594655'), (INT '327'), (INT '-2147483648'), (787), (1718865690), (726), (81), 'MCsFGdOSFu', 'wyChxlmRWe', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'AzTlPGl3fL', 'N8D33RLMJo', 'UEuwbWE5ro'), ((BIGINT '0'), (INT '0'), (INT '761'), (INT '-145699627'), (-2147483648), (705), (828), (331), 'U5wfEFkvUM', 'W9CVwXU7RT', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'XEslksw9cP', '01zZoSN23v', 'KDCZWRoexu'), ((BIGINT '-6497470430983398384'), (INT '836'), (INT '0'), (INT '923'), (613), (702), (-1774903555), (498), 'GzXb6w3PTT', 'JblN2qmd9z', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', '9icx3PvAB4', 'tiWDXuR25J', 'RTofzaYtOq'), ((BIGINT '474'), (INT '956'), (INT '2147483647'), (INT '521'), (574), (2147483647), (230), (153), '4MVFOghnF0', 'TFHBsm44J5', DATE '2023-08-31', DATE '2023-09-01', DATE '2023-09-01', 'sxD1KXBWWn', 'lpPlRNuYzn', 'XsLCSfYprz'), ((BIGINT '809'), (INT '2147483647'), (INT '1'), (INT '153'), (-67804001), (-1344386091), (962), (686), 'GV45lEf7j1', 'xSqzYZoLC5', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'mFRf7P6E12', '3ylRygGFyY', 'meTaudWUnR'), ((BIGINT '813'), (INT '786'), (INT '921'), (INT '883'), (542), (576), (-1888777258), (134), 'O4X4jOmvYB', 'txgpUjBElo', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'Zeab2qlRoL', 'hflIL63sA1', 'DsbOkMnNUF'), ((BIGINT '373'), (INT '387'), (INT '2082346587'), (INT '2147483647'), (120), (371), (991), (668), 'Bvol954Guw', 'FJIbSKQUSB', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'HnLlbljtff', 'tZVF1txOf3', '5EIY9BkIKf'), ((BIGINT '535'), (INT '0'), (INT '236'), (INT '46'), (1), (649), (657), (-2147483648), 'ycwEaaNPmC', 'o6QRFTwsAM', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'jG5NhPdXBP', '1usuMnBJJ3', 'S0V8Te3pb1'), ((BIGINT '516'), (INT '80'), (INT '1'), (INT '707'), (1), (359), (298), (398), 'Mac4KSfpVD', 'ybXgrv5tgG', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'fTSemZw6mj', 'BtvlwgzpLz', 'TTlutAddNb'), ((BIGINT '813'), (INT '729'), (INT '412'), (INT '803'), (405), (-637352509), (986), (427), '3BTICTEsUC', 'E2GDxEpkjl', DATE '2023-09-01', DATE '2023-08-25', DATE '2023-09-01', '0AvrdDYzyr', 'U27JsrbO52', 'nPGCUu9Gqp'), ((BIGINT '0'), (INT '164'), (INT '1'), (INT '2147483647'), (290), (1), (306), (710), 'r44fw9upgf', '1oHa95e6Le', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'OPJ2JzXTE6', 'Edo88gIpdM', 'OvEaV2iBf9'), ((BIGINT '707'), (INT '9'), (INT '407'), (INT '0'), (1538524202), (1), (1), (371), 'uWnoCib2ns', 'EbbfwMrvaO', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'LWm5a7NuQd', 'bbqfRAQVYB', 'zFGDcAf14V'), ((BIGINT '1'), (INT '0'), (INT '208'), (INT '443'), (984), (594), (0), (2147483647), 'BX0WhOjLud', 'nCalsSyGim', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', '1aHgxnQT64', 'Ryiqftlffu', 'WxnuWbFLtn'), ((BIGINT '901'), (INT '404'), (INT '913'), (INT '70'), (593), (687), (2147483647), (731), 'bXLaDQU6fg', 'GUjTafkJBP', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'Hj8ZqvuFQm', 'cxhXcI6S9m', '7JIpGG79M6'), ((BIGINT '971'), (INT '173'), (INT '-2147483648'), (INT '967'), (369), (145), (3), (587), '1QRLT6TdpI', '3iRqQTnDBG', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'QsjMHOROY9', 'C3i4Czlbe3', 'eqfaxzopi7'), ((BIGINT '372'), (INT '110'), (INT '-2147483648'), (INT '2147483647'), (617), (458), (672), (0), 'IEMZcAYYMD', 'ab8VX7T9hM', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'e3TKxbdr74', 'ufEiOp5FlZ', 'YQVvvblwfQ'), ((BIGINT '133'), (INT '221'), (INT '-1483887061'), (INT '862'), (980), (679), (749), (457), 'UqrxjEMCRm', '1eXCOT14Xg', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'AfDII3D3lU', 'KLU6ZNCZ1B', 'OeA9Synpnb'), ((BIGINT '0'), (INT '215'), (INT '791'), (INT '1'), (1), (181), (478), (655), 'uYd9JySu8I', 'pvv1A3aqpa', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'uziJGMiYJY', 'D9pRrcmgeh', 'wKQOU6auHr'), ((BIGINT '0'), (INT '306'), (INT '247'), (INT '717'), (485), (619), (869), (11), 'yC1hbv9bVZ', 'h69Dh3YwPm', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-08-25', 'hy4hp8Z0ke', 'tJR5PV12Tc', 'Pd8lznbWOt'), ((BIGINT '580'), (INT '147'), (INT '163'), (INT '956'), (-2147483648), (588), (44), (523), 'SBjGLGjOZr', 'DNya6rodEs', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'N6x84PttgP', 'TJzkaIi1os', 'lrBH52cgHC'), ((BIGINT '-7025070967709202766'), (INT '651'), (INT '745'), (INT '374'), (-872626061), (888), (951), (450), 'EXglYZgBqp', 'mjwIFW2jmQ', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'KOYjnJsxbY', 'bJEQH5k3gI', 'cTjoQwGvnI'), ((BIGINT '-9223372036854775808'), (INT '706'), (INT '2147483647'), (INT '244'), (494), (966), (372), (2147483647), 'i0WnFmOnaB', 'pe46Cp23Sx', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'WdHWwyetKC', '73IqvGWTsd', 'nDQbB69SbQ'), ((BIGINT '-9223372036854775808'), (INT '0'), (INT '0'), (INT '70'), (431), (660), (42), (5), 'Gbu5KsJSvp', 'xZPw2ML6se', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'WhfP2qcY78', 'r8ZuWLFwA2', 'Ik2LbZMCLE'), ((BIGINT '489'), (INT '508'), (INT '177'), (INT '947319203'), (2147483647), (11), (748), (2147483647), 'C9MFbd6TRW', 'g1EsBdUWBv', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'LhOMUXHke5', 'vsKJpahHLm', 'NO5fzAKODK'), ((BIGINT '462'), (INT '0'), (INT '812'), (INT '0'), (720), (166), (843), (86), '8HBcrbi7bh', 'rbSdkIMkIo', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'R9W7pFD230', '5G2cJKTOKT', 'Mb5jLXQzca'), ((BIGINT '9223372036854775807'), (INT '-2147483648'), (INT '309'), (INT '416'), (84), (375), (47), (210), '4ATkehHx4r', 'BT6vZhhD8K', DATE '2023-09-01', DATE '2023-08-31', DATE '2023-09-01', 'YjTJDgPVvz', 'ithe9hSeOu', 'ZBm2VmMmwx'), ((BIGINT '931'), (INT '1'), (INT '802'), (INT '988'), (848), (820), (35), (376), '5VNZpuZnUl', 'hHOpVayPBW', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'z9nYvViODC', 'ZVpzHjXktW', '3A2tT3PsYH'), ((BIGINT '875'), (INT '787'), (INT '0'), (INT '34'), (757), (-2147483648), (507), (749), 'D2VkndwMnE', 'CCJ4alWapK', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'EiZVp2edA1', 'biakffhNfc', 'PilluptiUC'), ((BIGINT '423'), (INT '410'), (INT '590'), (INT '157'), (-1690592183), (-1641786691), (285), (289), '6TC9LjKWLK', 'T7kshhqD64', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'iSr1mq6PU4', 'OqchQgRNXQ', 'fq6Urmuvqs'), ((BIGINT '210'), (INT '818'), (INT '570'), (INT '1'), (147), (492), (731), (0), '8URSbneEKb', 'aC1my2pC8S', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'S6UByNy3Rq', '1gTU5H7na8', 'gVmCOlLGJs'), ((BIGINT '683'), (INT '798'), (INT '733'), (INT '27'), (470), (709), (721), (518), 'dZQjkMSjhZ', '4afn3GF6TF', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'Fxbadwbdla', 'DcxhSv15DK', 'R2bi2lsRjA'), ((BIGINT '87'), (INT '915'), (INT '902'), (INT '8'), (533), (613), (0), (305), '0kEE3hfxBi', 'ggxwp83ldk', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-08-25', 'LtnmRswv3e', '2cvDGuZjQw', 'NpqBOm7f6S'), ((BIGINT '450'), (INT '329'), (INT '567'), (INT '75'), (399), (874), (219), (441), 'Is5qY3FSq7', 'QluM5YIsHA', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'YHyvIK2u9Q', 'G5JzbSngDT', '5aEELQUNVt'), ((BIGINT '993'), (INT '1'), (INT '510'), (INT '-906262257'), (0), (788958922), (658), (626), '5vBeUUjxDu', 'N3cvQQvIhs', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'lphOJbBbbk', 'mKh6amvoOb', 'a0GwOOiLwR'), ((BIGINT '1'), (INT '2147483647'), (INT '323'), (INT '175'), (737), (942), (140), (44), 'dhK3uDGbek', 'IdISTgYzn3', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'poyEL8pFYu', 'kLm4eIV1Kn', 'BZ4hYFuBXy'), ((BIGINT '214'), (INT '0'), (INT '2147483647'), (INT '890'), (-2147483648), (184), (716), (910), '71As7uM2Tv', 'depnYzmUOb', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', '4ba1dGw4zQ', 'cYqdxIF0xC', '9SKNWxvRrD'), ((BIGINT '630'), (INT '-236296021'), (INT '918'), (INT '-2147483648'), (-2147483648), (507), (69), (896), 'fex7yw0bBu', 'HVbstkQMCK', DATE '2023-08-25', DATE '2023-09-01', DATE '2023-09-01', '5ovOWdTkCs', 'g41gHsEcBp', 'XwAY355ea3'), ((BIGINT '499'), (INT '855'), (INT '526'), (INT '593'), (774796311), (-528660839), (50), (918), 'YHxaZa32QH', 'ZmIiKaAlol', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'xDQtyaS1QR', 'jXR6yDbwDT', 'QAmL8ejXbe'), ((BIGINT '9223372036854775807'), (INT '1868204708'), (INT '971'), (INT '-2147483648'), (-2147483648), (177), (73), (950), 'bjj8q0Sq6Z', 'gubGskIyYf', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'pU5W0P4YQj', 'Tr537eOYHM', 'QzNLyM2Lz0'), ((BIGINT '0'), (INT '867'), (INT '766'), (INT '222'), (854), (508), (1770382842), (-605121609), 'Bl2plBRdsT', 'KKreXtk7q8', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'Pd95rbcpfd', 'iAOyFkgIth', 'CdWrqAwfvF'), ((BIGINT '993'), (INT '240'), (INT '935'), (INT '447'), (933), (591), (-2147483648), (-2147483648), 'oqXnR02YBE', 'UALGaiqP5s', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'CCUhwrRY9d', 'aek7zprfzr', 'SokkN6A9By'), ((BIGINT '683'), (INT '2147483647'), (INT '-175056004'), (INT '542'), (-797747779), (416), (247), (522), 'jKcJhyOZju', 'pevKaQ1Fx8', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'CIge1HZmXp', 'u5IL7Xcn1b', 'pRmRS4LKTn'), ((BIGINT '778'), (INT '747'), (INT '265'), (INT '680127887'), (233), (2147483647), (2147483647), (921), 'D16eP4fjxh', 'fTOi3FwEtU', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'eI2rgFSyGO', 'wcjPvTbEdc', 'ZtdCUm00zV'), ((BIGINT '0'), (INT '1'), (INT '63'), (INT '563'), (666), (623), (0), (327), '14L0V1Jf0P', 'SQU5m3VwJn', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-08-31', 'koAnlJVXWK', 'ZvU1nvUXgP', 'eBpnQnsGNC'), ((BIGINT '777'), (INT '770'), (INT '1491897578'), (INT '823'), (964), (538), (652), (29), 'afunKRpeOV', '5Tz5442nHB', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-09-01', 'ixGuO4hSnB', 'xdGkuUdIhK', 'oq463UTOf6'), ((BIGINT '111'), (INT '251'), (INT '26'), (INT '244'), (-2147483648), (0), (448), (611), 'IubPYIysxN', 'SWjakgI85S', DATE '2023-09-01', DATE '2023-09-01', DATE '2023-08-25', 'Pkuqs1xQIG', 'MErDGsNPdP', 'gSOPvVV6eF');
INSERT INTO nation VALUES ((INT '786'), 'XvJfoNzDoN', (INT '835'), '9uDeXZGqPs'), ((INT '237'), 'hTDkVlUJO8', (INT '608'), '8EQFwcOJHK'), ((INT '2147483647'), 'y12iqKaBBh', (INT '415'), 'YLcIMgMbBG'), ((INT '444'), '7WEq6BnJFP', (INT '843'), 'EpwQ5PJCVr'), ((INT '1281200382'), '6yxHUYG6LO', (INT '644'), 'dvkNTfadfK'), ((INT '919'), 'Qui0kzGNgE', (INT '933'), 'Mkz45zPSF2'), ((INT '221'), '2f5T71HJvx', (INT '-723938381'), 'XYmA29GmN3'), ((INT '347'), 'F9tCkpUbx8', (INT '-967290226'), 'q1siNInTwt'), ((INT '0'), 'K8D1MUxucM', (INT '-1922275927'), 'Cp8XNxNoVt'), ((INT '978'), 'pEpOdZNIqJ', (INT '776'), 'e3RTa9QkBG'), ((INT '-2048679693'), 'YXvbQhvITV', (INT '486'), '8zWuTkYst9'), ((INT '34'), '8nOwu0v0qS', (INT '236'), 'SQDrF7Ntcb'), ((INT '1337734344'), 'eZdjApnyBS', (INT '0'), 'dsoxjWW0Zd'), ((INT '89'), 'mO6Rkyj4wV', (INT '2147483647'), 'kKm2V8r1D9'), ((INT '1406352285'), 'qR8jbSpSVb', (INT '98'), 'IKkP528syk'), ((INT '0'), 'kLja5SCCBJ', (INT '318'), 'iHiAbXGvnH'), ((INT '417'), 'auSEyjN0DA', (INT '369'), 'oRfRHVKcSm'), ((INT '545'), 'MtB96KvVOk', (INT '1'), 'Bl4oqKpRnq'), ((INT '2147483647'), 'OH4yrI4IUi', (INT '0'), 'D4f5KHpmcL'), ((INT '776836118'), 'JFmtR52WDV', (INT '-2147483648'), 'o2kzHb2cLV'), ((INT '442'), 'GFqGxl5EOK', (INT '1'), 'gamEMNMfuP'), ((INT '1371669838'), 'v7ObqynNxp', (INT '0'), 'mudTRBuQff'), ((INT '1'), 'yGgsDa3paT', (INT '967'), 'MvIt7Tbm0k'), ((INT '2147483647'), 'fwh5sjXDXZ', (INT '173'), 'H65LBoiLsW'), ((INT '2147483647'), 'K1eT3iUi6S', (INT '414'), 'COps0Z2zED'), ((INT '433'), '03WRUFLpMx', (INT '2147483647'), 'cq4BaQ8v0u'), ((INT '607'), 'MyILSLoBtL', (INT '145'), 'dDpaWbvRjP'), ((INT '131'), '2KC7DQZ9Q1', (INT '0'), 'SwgnhBi8xG'), ((INT '826'), 'Om3KCgqfzK', (INT '2147483647'), 'CaQG2XROM9'), ((INT '565790215'), 'VhaKyMQpPm', (INT '87'), 'sgpExTczcz'), ((INT '80'), 'LBwzu84bkA', (INT '-2147483648'), 'KS0tGrZu7z'), ((INT '549'), '64vsz3xVej', (INT '0'), 'QYEzQQcUNR'), ((INT '-479744459'), 'X84FMErk8r', (INT '352'), 'DgoIH8tzDu'), ((INT '515'), 'Dk0iWowrJJ', (INT '760'), 'THGoqGBl2A'), ((INT '649'), 'VDvQynkWpT', (INT '35'), 'JMlT2X265U'), ((INT '869'), 'SzlGu4HuVH', (INT '982'), '8HElwFCnCj'), ((INT '1'), 'Q9VtbnGAb0', (INT '35'), 'nPXsCeqT1E'), ((INT '394'), 'SunqRcv2Yk', (INT '908'), 'VYzg9UlUc4'), ((INT '1'), 'MJc2IGHe4k', (INT '183'), 'mgK1IBgDdt'), ((INT '2147483647'), '7sPUw0vRiA', (INT '427'), 'fKlyW0PYVi'), ((INT '856'), 'GXOQ5gXdRZ', (INT '804'), 'lON49Izgms'), ((INT '2147483647'), '9ho7aqVFM5', (INT '166'), 'aOMrU6Ccvf'), ((INT '2147483647'), 'BGq47KzZwA', (INT '912'), 'XpNQfb5AeY'), ((INT '723'), '3aR4K1uNA5', (INT '-2147483648'), 'bYO7RbwX5p'), ((INT '204'), 'SZjzbbCT05', (INT '6'), 'kpe1YVoHQh'), ((INT '136'), 'qQ0U7ngU04', (INT '358'), 'x0PFL2HXTp'), ((INT '747'), 'jyZiEUiQxD', (INT '72'), 'y6xwhndIrO'), ((INT '1'), 'upplBdmaap', (INT '2147483647'), 'FIvHJFsWta'), ((INT '137'), 'jWrade3eEg', (INT '1'), '4ehTp2I9qd'), ((INT '602'), 'SRUYDmsU6q', (INT '568413565'), 'uJBPkxD4un');
INSERT INTO region VALUES ((INT '856'), '09vg44HgPf', 'V09kwTlHa3'), ((INT '385'), 'UIj8rV2mU9', 'MqgMId1M5x'), ((INT '874'), '9gR3F5T20l', 'GocLohWSrt'), ((INT '712'), 'ZmI584jPUh', 'SRhrtqJgar'), ((INT '43'), 'KN31Fs6Uby', '8ayZ1sGCNS'), ((INT '0'), 'aB2muTvWLL', '7Y50jtNSCh'), ((INT '70'), 'qOJPJsWgTy', 'HBaov14zgJ'), ((INT '453'), 'bcPtumzVwu', 'zCL6HaV1LO'), ((INT '481'), 'DGl5NgF8y3', 'v3CRF7zYEH'), ((INT '-2147483648'), 'ZPuG6Ko9gR', 'K4P4qtKqfY'), ((INT '158'), 'VzSRUqfInt', 'HITv9P3g2J'), ((INT '0'), 'FM5zCRrv3K', '9qMC0onoGf'), ((INT '768'), 'VcM3VN85h5', 'u2gPFKv9BU'), ((INT '135'), 'T2OIRe4JI1', 'b9O9meeSmP'), ((INT '258'), 'ZMZnJGVRsC', 'cGyPgf6nIc'), ((INT '37'), 'Dajz13LC2p', 'FUWfp6W61T'), ((INT '834152569'), 'OWfkbevhrx', '4uMTtRW1Ya'), ((INT '809'), 'vLkEEGVwIl', '42HyzBlG0M'), ((INT '2147483647'), 'xMGAFmgTdW', 'bEi4iEFjmc'), ((INT '455'), 'eH99Odtl4H', 'phqgLGNXk8'), ((INT '987356818'), 'CswavWPzVc', 'd3yDwDlnGC'), ((INT '91'), 'xLN7h3SZUf', 'yycxrWnwdI'), ((INT '180'), 'aGXr6Yiakq', 'c7GouneUn9'), ((INT '804'), 'cO2rU4729J', '8V0M5Bprd9'), ((INT '496'), 'sWdi836Kua', 'LZVTLJpTTH'), ((INT '3'), '4gGwglc8hi', 'JfGQ3VkPnf'), ((INT '-17085137'), '7KBIAyfj3V', 'R3Hi3le646'), ((INT '973'), 'vs282thCEf', '4TPbOl2Qre'), ((INT '70'), 'fZcGnKaWvq', 'iF1VbdPo6O'), ((INT '902'), 'xYCWCOieNI', 'Q38fNhG2zN'), ((INT '951'), 'PT2GiwGgxz', 'NQNgvBD1sW'), ((INT '-1072139723'), '0y3HFcGM0m', 'nl9Q7pRQgf'), ((INT '273'), 'd4OMk1lplC', 'WTT11N1KAU'), ((INT '940'), 'rTLUVnj2cM', '59dBQCNemm'), ((INT '0'), 'MVjpkuatMf', 'ZdsBFcMEwE'), ((INT '170'), 'jmM24fWG5S', 'dA6wbe7TEs'), ((INT '2147483647'), '6rmUqoczyh', 'Uu0RRDq6t1'), ((INT '2147483647'), 'XI64kbxZPs', 'mJE9fq62uF'), ((INT '70'), 'MCSUfVSar2', 'OizvWM0CNJ'), ((INT '47'), 'V4hPKeEloG', 'mOIFFHdTFf'), ((INT '951'), 'Kq496Z1DwG', 'uc4jQcEcmN'), ((INT '1'), 'UZbIdJVOX8', '7HIunX4nfh'), ((INT '-2147483648'), 'FoOwGmi9hb', 'SiBESR00N6'), ((INT '542'), '5VqLm8sVcY', '15yuWLbepy'), ((INT '315'), 'F0FrdIb2Vk', 'czy6OHynNc'), ((INT '41'), 'mY0P4QgxBD', 'mAkHrOFMWP'), ((INT '110'), 'MhVdUveowY', '4iNQZaJoqq'), ((INT '255'), 'NZJZRkJwJo', 'MVUWG9MwKi'), ((INT '712'), 'HOlER1BBjI', '3JfTYlggat'), ((INT '573'), 'ajpO03bl8H', '5fV3olK8PO');
INSERT INTO person VALUES ((BIGINT '409'), 'rwl8yr06y3', 'vWglJKBEGO', 'I6lIPijdFB', 'FWBSoUznQR', 'VCo1BrYMex', TIMESTAMP '2023-09-01 22:12:10', 'UUeCdtK4r4'), ((BIGINT '743'), 'rHyEHlOlQo', 'dn8m1mDgGz', 'XbkerkOmWA', 'ZRzKwP34pc', 'R98v2fM6Ak', TIMESTAMP '2023-08-25 22:12:54', 'QdrAzOBBnj'), ((BIGINT '821'), 'yhGLxRKJP3', 'uFXnLTqype', 'Zm40k8ngzu', 'EzGHi9Lnw3', 'g2fs6elTwo', TIMESTAMP '2023-09-01 22:12:39', 'YZfyLHvtzv'), ((BIGINT '-2076285715252729117'), 'TDNL3dRVWL', 'FI3EP7Y412', 'oFotjGdm5Z', '89lTh6JoAl', 'fJyaGD5ZQV', TIMESTAMP '2023-09-01 22:11:25', 'fmeOVQOhLR'), ((BIGINT '498'), 'EjsMpOsr54', '5G1gbfCcyi', 'ovliUX3DZw', 'tOFAnmTnRQ', 'bxZzHcgNTW', TIMESTAMP '2023-09-01 22:12:06', 'n1H0lz1Ykz'), ((BIGINT '-5217841534937710612'), 'EY53GI9NFz', 'AOMz9HTWcH', 'ChhXMqocxR', 'eGG0PIpwGK', 'z5ABoQbBPE', TIMESTAMP '2023-09-01 22:11:57', 'eFcVoWxewH'), ((BIGINT '71'), '3yWaR2nFFf', 'VTTSWjnjLB', 'zoWboYeqXM', 'b8VKpK2yEp', 'SxpLV1yPwe', TIMESTAMP '2023-09-01 22:12:09', 'hSF2qIlOsd'), ((BIGINT '0'), '8wyT4H1ZGs', 'NCyJqFFzYt', 'UcAFFUWx8p', '0wi8qvlGAI', 'UQSL53IiHz', TIMESTAMP '2023-09-01 21:12:54', '1LzcNrpgdP'), ((BIGINT '103'), 'SlpkVynKPQ', 'fB2L6CNJP0', 'bN9YHNfNno', 'N3zWphIqjt', 'hy0qQAKHgJ', TIMESTAMP '2023-09-01 22:12:27', 'dY1rBR8UGn'), ((BIGINT '949'), 'CLkQAxka8E', 'dsmh9mq0ek', 'D2NMiNkO8M', 'CdV73C7ajb', '6awDFgpQHz', TIMESTAMP '2023-09-01 22:11:32', 'kWsyTnF3Iv'), ((BIGINT '47'), 'fIMSgA8UxV', 'mXF54KJ3O4', 'tkV1hUIQGB', '5OSPiGfXGQ', '0Y2AUHUtyP', TIMESTAMP '2023-09-01 22:12:45', '1N64y9ANrb'), ((BIGINT '202'), 'ipHQszdY6L', 'GDXTpOuM5t', 'cKmd74LTgB', 'M3GhCAMKmQ', '1mv5ruXRvT', TIMESTAMP '2023-09-01 22:12:46', 'ocRzzOmKyv'), ((BIGINT '-1890844870309572113'), '9qAXNilOkx', 'PC4okX0A4M', 'e7BglqGqiT', 'NmhBI7TUuS', '6mtR9UIkf9', TIMESTAMP '2023-09-01 22:11:57', 'taWXhQkiQt'), ((BIGINT '8587471595144510756'), 'IggYV7aCLc', 'sdhfVAxUSr', 'mDO37a9SHi', 'AAQQH59hcz', 'KEHU04RHqr', TIMESTAMP '2023-09-01 22:12:26', 'HDruH08Dv7'), ((BIGINT '723'), 'cYBnEsAQNw', 'GNYLGYgTxl', 'dMPnirDBB9', 'xivUZwbR9w', 'o7GA6mhU9Y', TIMESTAMP '2023-09-01 22:12:53', 'uhOedBdFO3'), ((BIGINT '9223372036854775807'), 'UkV0M3P7Of', '3SkgOBigsh', 'uOvTNl3ELL', 'fgeWYwq7JG', '4YNiS7dy0U', TIMESTAMP '2023-09-01 22:11:54', 'Eab86Kga42'), ((BIGINT '0'), 'mBtFfMjoST', 'h856Pt0t21', 'cZ0MSnIT2y', 'wuUXULwlYb', '7xqm11lFs9', TIMESTAMP '2023-09-01 22:12:11', '4t2hs1vvSO'), ((BIGINT '516'), '0QAoIczrap', 'ibFiuCfX9R', 'YzkzroknG4', 'EPD9RqThMD', 'HUCylk1sTC', TIMESTAMP '2023-09-01 21:12:54', 'lDtCI8TBAq'), ((BIGINT '677'), 'kG9dX4f8DH', '1kmrloz1WW', 'OV0CV8teoj', 'pgi8cNYjzm', 'T7mqBoGDla', TIMESTAMP '2023-09-01 22:12:34', '51J44jZnl7'), ((BIGINT '491'), 'BWipryJYwX', 'DmjDcYFvC2', 'QTXFiCSHKA', 'Z6KNVT2Qlr', 'PBF1bct4RG', TIMESTAMP '2023-09-01 22:12:34', 'zjiwUxg5Cj'), ((BIGINT '776'), '37RvWIKTjN', 'eWXkzzcbqF', 'KZtO4UHCDb', 'd6eFAu1cKB', 'KOXtEdnKuU', TIMESTAMP '2023-09-01 22:11:53', 'VxFqrZ3zI9'), ((BIGINT '282'), 'e0p4GmakaZ', 'IsOtPd5r6E', '2YUVQQMefc', 'W8bmJcCtWU', 'EvLv1AX7Po', TIMESTAMP '2023-09-01 22:11:36', 'hFIZ6q62pw'), ((BIGINT '786'), 'E5fRfrSUIn', 'C0xHEFAQPt', '07sWqcuKOA', 'WvZJAt5K6E', 'X5lDxS2Zjh', TIMESTAMP '2023-09-01 21:12:54', 'gW1qPj2zrz'), ((BIGINT '696'), 'U5c4vzHMyy', 'hXbi53JhcS', 'pxgACx2rGV', 'ccmJ4bzuhh', 'YPLx90LO4I', TIMESTAMP '2023-09-01 22:12:51', '7kNsfDJ00w'), ((BIGINT '282'), 'CxMbJcvaQ1', 'ljoBhlDPQn', 'rMAt1ePGRQ', 'wQSfkqDYUs', '9OExtI0eaH', TIMESTAMP '2023-08-31 22:12:54', 'vwuuS5SXrY'), ((BIGINT '3649124395143627878'), '5mBrtxYfuW', '1kbmc0lvB9', 'WyZDTgRB2q', 'pnmANJJfuZ', 'Hi3TPP2r52', TIMESTAMP '2023-08-25 22:12:54', 'WH0tjWdgVP'), ((BIGINT '785'), 'WiT2cDSmIp', 'mTiHAJ7NGc', '4NuMHw1tBC', '5dqFZpDLGx', 'Cs46EAmn6Q', TIMESTAMP '2023-08-25 22:12:54', 'LeCVLg7Spd'), ((BIGINT '2439341702997770217'), 'dtynArGftU', 'RXCNHtZ4gt', 'QaJmF7qNUQ', '0u3KLJNJyZ', 'KC5EUZqh1v', TIMESTAMP '2023-09-01 22:11:49', 'GFcSWaWGIv'), ((BIGINT '689'), 'NblxHrQ8kX', 'J7HRpZwobw', '0MJ6OHB5Be', '5RRDoAmH2b', 'NeEcPb3L3M', TIMESTAMP '2023-09-01 22:12:54', '9QoKkqRfkM'), ((BIGINT '471'), 'D6rY2UcNGP', 'G7pTbwtlU2', 'I3dI0hoNza', 'NSnuk2rHVR', 'HMo3B3CRRF', TIMESTAMP '2023-09-01 22:12:51', 'scT60HU1vp'), ((BIGINT '1'), 'L9HZjd9zsD', 'XOG0sLUxBc', 'YXrfEnV9Ff', 'LmIqmSejq1', 'IxAx9m9H1f', TIMESTAMP '2023-09-01 22:11:53', 'nv2CfSpqtz'), ((BIGINT '803'), 'BIp8UtKykN', 'kc6PVb62SX', 'PDnPY0QDw1', 'HZawd1VAMK', '2GLr4XPcXi', TIMESTAMP '2023-09-01 21:12:54', 'B2RviL3bDF'), ((BIGINT '0'), 'ii8YDA2BAK', 'pvqXr7drXI', 'JVmcYLYL59', 'pUSl4C5PdE', 'WKAVDbMjM1', TIMESTAMP '2023-09-01 22:12:52', 'ZjgP7Jy1Vj'), ((BIGINT '591'), '3YEW1z4C0s', 'eRsGU6a1oQ', '1lrtUHBrV2', 'uu4rBh6bgO', 'NhR0pVPfkP', TIMESTAMP '2023-09-01 22:12:11', 'FzvEkLWt8i'), ((BIGINT '888'), '8j3R5ZxTVL', '6bHh6DL2pC', 'F3RMNBKqbM', 'TMK7zZae0d', 'HVKayLAwPf', TIMESTAMP '2023-09-01 22:12:36', 'j8F2QofQmR'), ((BIGINT '1'), 'CulaS0aXV7', 'WfK3fQICcX', 'EbXWdsidrY', 'zoArrXJmUF', 'aRb35h3bWu', TIMESTAMP '2023-09-01 22:12:51', 'PrTv9QUjnt'), ((BIGINT '0'), 'tlTIXKw6mE', 'DjWyJImD7X', 'JeGIat1Jl0', '3HATUIrSTn', 'AQ77dVYi0N', TIMESTAMP '2023-09-01 22:11:46', 'UfNawIGt1S'), ((BIGINT '4927856344504987385'), 'xur2lU0y8W', 'cKIj9HdZRu', 'Cw0bMxgWvu', '1OzaxNIPdc', 'EwWPebMcHM', TIMESTAMP '2023-09-01 22:11:54', '3JURm3AfaD'), ((BIGINT '855'), 'tGPUZpwB9R', 'ekXWavFY8r', 'nSkJgoZXVK', 'eaY5SCcGcI', 'fl2QNIKeqt', TIMESTAMP '2023-09-01 22:12:08', '215QVuZ2Sx'), ((BIGINT '663'), '0vg4QOmYOb', 'V435zDooYt', 'nYxFtPlHAT', 'Ef1RKCY7t5', 'l4CMuxpVWA', TIMESTAMP '2023-09-01 22:11:22', 'aEeh5bzZva'), ((BIGINT '902'), 'vCsmEnMF13', '8FUkEMjCIF', 'SO1R0RciqM', 'ADM2Y9nFaf', 'A2shkVSTfg', TIMESTAMP '2023-09-01 22:11:20', '8b8alwjWHZ'), ((BIGINT '186'), 'AIGjxagEGc', '5j0Zc0FT6d', '6MG93kNb84', 'Y0PjRbwFag', '6LJzOHQyHK', TIMESTAMP '2023-09-01 22:11:42', 'HJmcpvuiTh'), ((BIGINT '408'), '4A0LTs79ZU', '0IJb9c03Lm', 'Y7Y8b0HJif', '2jjlmGS0zI', 'es0KnPe9Ey', TIMESTAMP '2023-09-01 22:12:14', 'KuuJdv7Zj8'), ((BIGINT '145'), 'N6SJPnCle9', 'OVPwhrXtu2', '9u5GAyJZHE', '3T4NrwAZrA', 's1agU6JjqT', TIMESTAMP '2023-09-01 21:12:54', 'Y53FeHPng9'), ((BIGINT '4271310189722715545'), 'azopKt6R77', 'vKmNhXodFS', 'Ejn6yXf3R6', 'bU586RuEic', 'jlzrr2vgGD', TIMESTAMP '2023-09-01 22:12:09', 'fDJGzltp35'), ((BIGINT '729'), 'xMPIE2Tk2T', 'knzkeDdiZ6', 'AwLCia0TYi', 'ab1TcnWXcT', '80GLCLjlFl', TIMESTAMP '2023-09-01 22:12:47', 'M3XsP81iIG'), ((BIGINT '0'), '8XvR8UrFO6', '5j0wiSgkTR', 'Wrz051brsu', 'JfgstMBTjq', 'zlnOazsVok', TIMESTAMP '2023-09-01 22:11:54', 'eMDA0EDuOk'), ((BIGINT '10'), 'fuy74njzTs', 'kwAZrLoXn4', '21vGnXUiOR', 'ZwIAvZNTic', 'KYKd7C3P9U', TIMESTAMP '2023-09-01 22:12:08', '9jlLJrSY5o'), ((BIGINT '519'), 'sUx2ETccFL', 'MD4mixqOCo', 'fGzaX6zpxL', '56nmN8db7F', 'yor6E2zQMt', TIMESTAMP '2023-09-01 22:11:26', 'tNLavCjITi'), ((BIGINT '31'), 'WAa49dzA9v', 'PCLNE1FUex', 'bykIMKw42Q', 'NXWxTpWeTQ', 'PljqxXfBQH', TIMESTAMP '2023-09-01 22:12:04', 'gSLEAZHBM8');
INSERT INTO auction VALUES ((BIGINT '696'), 'Lmhr2OavoH', 'eMyilnzavt', (BIGINT '6203922189741830250'), (BIGINT '221'), TIMESTAMP '2023-09-01 22:12:31', TIMESTAMP '2023-08-31 22:12:54', (BIGINT '457'), (BIGINT '569'), '5DK5rJ2HMR'), ((BIGINT '525'), 'DnkSJ7W3vB', 'CblKc0CrHT', (BIGINT '1'), (BIGINT '261'), TIMESTAMP '2023-09-01 22:12:36', TIMESTAMP '2023-09-01 22:12:00', (BIGINT '682'), (BIGINT '1'), '5V461IA2WX'), ((BIGINT '802'), 'sgTLtaib9t', 'W7BG9e54g9', (BIGINT '597'), (BIGINT '888'), TIMESTAMP '2023-09-01 22:11:54', TIMESTAMP '2023-09-01 21:12:54', (BIGINT '4'), (BIGINT '2'), '7nxvRdC5dY'), ((BIGINT '932'), 'qr93gsWu1n', '1e6UgxCMZI', (BIGINT '-9223372036854775808'), (BIGINT '-9223372036854775808'), TIMESTAMP '2023-09-01 22:11:47', TIMESTAMP '2023-09-01 22:11:54', (BIGINT '370'), (BIGINT '169'), 'pQNiFhnB38'), ((BIGINT '234'), 'mSK22rv267', 'sBWqqg28z6', (BIGINT '62'), (BIGINT '1'), TIMESTAMP '2023-09-01 22:11:40', TIMESTAMP '2023-09-01 22:12:53', (BIGINT '965'), (BIGINT '141'), 'f1m1Zsj3t5'), ((BIGINT '640'), 'ZBVBdjQuUz', 'VvG5i48jSr', (BIGINT '12'), (BIGINT '631'), TIMESTAMP '2023-09-01 22:12:53', TIMESTAMP '2023-09-01 22:12:44', (BIGINT '585'), (BIGINT '512'), '3ddCbSQDal'), ((BIGINT '-4431103386993705790'), 'whaGNNQTiD', '5JOVlItY5p', (BIGINT '718'), (BIGINT '464'), TIMESTAMP '2023-09-01 22:12:53', TIMESTAMP '2023-09-01 22:11:54', (BIGINT '145'), (BIGINT '993'), 'nbg6XCBR7i'), ((BIGINT '612'), 'PhLYcxuCRP', 'LZ97kJE6Gy', (BIGINT '183'), (BIGINT '405'), TIMESTAMP '2023-09-01 21:12:54', TIMESTAMP '2023-09-01 22:12:32', (BIGINT '843'), (BIGINT '50'), 'iY4Q7g6jrf'), ((BIGINT '811'), 'VFUyhnf4yF', 'gp5yYhF2n0', (BIGINT '7820766108066221291'), (BIGINT '158'), TIMESTAMP '2023-09-01 22:12:11', TIMESTAMP '2023-09-01 22:12:20', (BIGINT '834'), (BIGINT '562'), 'M2PSpXBQNU'), ((BIGINT '322'), '8qJN5U5chy', 'QXSniuibKh', (BIGINT '164'), (BIGINT '1'), TIMESTAMP '2023-09-01 22:11:54', TIMESTAMP '2023-09-01 22:12:27', (BIGINT '3043443322599001009'), (BIGINT '843'), 'gNsGsMHnUl'), ((BIGINT '753'), 'IOcdiGvw4P', 'cjZw4gqx5T', (BIGINT '763'), (BIGINT '941'), TIMESTAMP '2023-09-01 21:12:54', TIMESTAMP '2023-09-01 22:12:54', (BIGINT '860'), (BIGINT '1'), 'VDLMLzi2cC'), ((BIGINT '586'), 'eKNVcUc3B3', 'lvaO2Dk4Uz', (BIGINT '273'), (BIGINT '0'), TIMESTAMP '2023-09-01 22:12:10', TIMESTAMP '2023-09-01 22:11:17', (BIGINT '-4087684664450056318'), (BIGINT '-9223372036854775808'), 'rkyXPk2MFv'), ((BIGINT '948'), 'dW6NQBo9aR', 'u7QEqtTtm8', (BIGINT '950'), (BIGINT '910'), TIMESTAMP '2023-09-01 22:11:17', TIMESTAMP '2023-09-01 22:12:36', (BIGINT '284'), (BIGINT '529'), 'TwVwtFSEZO'), ((BIGINT '438'), 'ldqjdOU7Sh', 'tqkEWSwtCQ', (BIGINT '4658702039235255556'), (BIGINT '899'), TIMESTAMP '2023-09-01 22:12:22', TIMESTAMP '2023-09-01 22:12:19', (BIGINT '656'), (BIGINT '699'), 'ncIvE4ncd4'), ((BIGINT '-3459676477290542156'), 'nQgNs9EXjk', 'n011nDyF8M', (BIGINT '9223372036854775807'), (BIGINT '456'), TIMESTAMP '2023-09-01 22:12:18', TIMESTAMP '2023-09-01 22:12:01', (BIGINT '0'), (BIGINT '634'), '2eYNWv5q9V'), ((BIGINT '646'), 'JdPwQUdPKN', 'BWCMCSNr9K', (BIGINT '726'), (BIGINT '0'), TIMESTAMP '2023-09-01 22:12:15', TIMESTAMP '2023-09-01 22:12:54', (BIGINT '-7931432934434878889'), (BIGINT '478'), 'xcUou1fUSQ'), ((BIGINT '1'), 'j2OqcA8Hz3', 'zVWgrrStzV', (BIGINT '614'), (BIGINT '8455532957775164087'), TIMESTAMP '2023-09-01 22:12:54', TIMESTAMP '2023-09-01 22:11:15', (BIGINT '541'), (BIGINT '-8122948809553264735'), 'dWhP1ndTS9'), ((BIGINT '580'), 'tJ3ysD2EEy', 'pcQEQBrSrT', (BIGINT '141'), (BIGINT '68'), TIMESTAMP '2023-09-01 22:12:34', TIMESTAMP '2023-08-25 22:12:54', (BIGINT '42'), (BIGINT '0'), '48cHPRWHl5'), ((BIGINT '954'), 'SRCaQGG5mA', 'VbWXFR282F', (BIGINT '561'), (BIGINT '780'), TIMESTAMP '2023-09-01 22:12:32', TIMESTAMP '2023-09-01 22:12:09', (BIGINT '647'), (BIGINT '172'), 'j64Rm8xwWd'), ((BIGINT '-9223372036854775808'), 'yv4NticcwK', 'BAPOFa3Q6u', (BIGINT '58'), (BIGINT '670'), TIMESTAMP '2023-09-01 21:12:54', TIMESTAMP '2023-09-01 22:11:52', (BIGINT '151'), (BIGINT '454'), 'rSbmXYsZbY'), ((BIGINT '167'), 'UjWSWjQpNL', 'ZOhnXa3NBh', (BIGINT '-7417095031144740644'), (BIGINT '63'), TIMESTAMP '2023-09-01 22:11:52', TIMESTAMP '2023-08-31 22:12:54', (BIGINT '249'), (BIGINT '318'), 'a1R6EfjoAa'), ((BIGINT '275'), 'dPLfOhygVF', 'udUSsBNclH', (BIGINT '950'), (BIGINT '396'), TIMESTAMP '2023-09-01 22:11:50', TIMESTAMP '2023-09-01 22:11:57', (BIGINT '962'), (BIGINT '933'), 'VMP20pWN5r'), ((BIGINT '108'), 'H8iJG1QXnP', 'CUDk67ziZH', (BIGINT '781'), (BIGINT '518'), TIMESTAMP '2023-09-01 21:12:54', TIMESTAMP '2023-09-01 22:11:54', (BIGINT '548'), (BIGINT '368'), 'ht8o5B0kjy'), ((BIGINT '449'), 'EgZ9tb3rdD', 'ekkexZ781W', (BIGINT '755'), (BIGINT '889'), TIMESTAMP '2023-09-01 22:12:53', TIMESTAMP '2023-09-01 22:12:04', (BIGINT '901'), (BIGINT '523'), 'gc2ooxbb8w'), ((BIGINT '266'), 'NQBX8RAZMy', 't2qwYypFeF', (BIGINT '455'), (BIGINT '210'), TIMESTAMP '2023-09-01 22:11:38', TIMESTAMP '2023-09-01 22:12:31', (BIGINT '604'), (BIGINT '24'), 'G9kTcvpQyf'), ((BIGINT '183'), 'rFLEINIt0A', 'KqNlvrlIou', (BIGINT '5755346923182086012'), (BIGINT '898'), TIMESTAMP '2023-09-01 22:11:48', TIMESTAMP '2023-09-01 22:11:31', (BIGINT '509'), (BIGINT '9223372036854775807'), 'AUMFXwm1oM'), ((BIGINT '470'), 'YzN03caouN', 'cnVdl8NfCX', (BIGINT '8880308344854748580'), (BIGINT '645'), TIMESTAMP '2023-09-01 22:12:21', TIMESTAMP '2023-08-31 22:12:54', (BIGINT '977'), (BIGINT '2707065357911783155'), 'aKCiy1DYMn'), ((BIGINT '327'), 'JuQibNyLNa', 'uFcXLqRwIv', (BIGINT '464'), (BIGINT '9223372036854775807'), TIMESTAMP '2023-09-01 22:12:53', TIMESTAMP '2023-09-01 22:12:53', (BIGINT '81'), (BIGINT '941'), 'PVsWNINM1V'), ((BIGINT '223'), 'zpWo8zo0N7', 'Xvjta7NaSf', (BIGINT '476'), (BIGINT '724'), TIMESTAMP '2023-08-31 22:12:54', TIMESTAMP '2023-09-01 22:12:26', (BIGINT '923'), (BIGINT '919'), 'SiRzvSWZwB'), ((BIGINT '444'), 'Af1IDSxQ1S', 'bB7KMX3ELa', (BIGINT '-9223372036854775808'), (BIGINT '489'), TIMESTAMP '2023-09-01 22:11:21', TIMESTAMP '2023-09-01 22:12:33', (BIGINT '537'), (BIGINT '1254811721084813544'), 'Fgy7n0q4Vg'), ((BIGINT '2915685815871741526'), 'vPAv3ES4TP', 'pElgA5DE6z', (BIGINT '896'), (BIGINT '204'), TIMESTAMP '2023-09-01 22:11:37', TIMESTAMP '2023-09-01 22:11:54', (BIGINT '-9223372036854775808'), (BIGINT '989'), '6IZsqMsPlP'), ((BIGINT '-2976447147673732739'), 'ZxaG38OIlz', 'KLwckY6q5U', (BIGINT '28'), (BIGINT '530'), TIMESTAMP '2023-09-01 22:12:27', TIMESTAMP '2023-09-01 22:11:23', (BIGINT '728'), (BIGINT '211'), 'nTP0P4yCxF'), ((BIGINT '608'), 'EUHKJthPzW', 'JrtSfvmw0h', (BIGINT '0'), (BIGINT '297'), TIMESTAMP '2023-09-01 22:11:54', TIMESTAMP '2023-09-01 22:11:39', (BIGINT '1'), (BIGINT '656'), 'wYuzkQ9R1q'), ((BIGINT '967'), 'xoo8Ysw1yu', 'WHGBnaOPvr', (BIGINT '486'), (BIGINT '159'), TIMESTAMP '2023-09-01 22:11:57', TIMESTAMP '2023-09-01 22:12:54', (BIGINT '0'), (BIGINT '643'), 'HixAotP6Fm'), ((BIGINT '770'), 's5lDN9Tb1Z', 'HEnFhEdyOh', (BIGINT '0'), (BIGINT '532'), TIMESTAMP '2023-09-01 22:11:19', TIMESTAMP '2023-08-25 22:12:54', (BIGINT '495'), (BIGINT '590'), 'EfOpKj09AM'), ((BIGINT '1'), 'PnUU879ss5', 'Hp5vgx4KZt', (BIGINT '1'), (BIGINT '293'), TIMESTAMP '2023-09-01 22:11:38', TIMESTAMP '2023-08-25 22:12:54', (BIGINT '412'), (BIGINT '0'), 'zn67nboEtf'), ((BIGINT '250'), 'gBHsGyFmF5', 'uwdRkQeMqT', (BIGINT '630'), (BIGINT '761'), TIMESTAMP '2023-09-01 22:11:54', TIMESTAMP '2023-09-01 22:11:45', (BIGINT '508'), (BIGINT '446'), 'GXMyTPAupt'), ((BIGINT '743'), 'xjK5YDLzy8', 'W83TXZAcoI', (BIGINT '316'), (BIGINT '145'), TIMESTAMP '2023-09-01 22:11:46', TIMESTAMP '2023-09-01 22:11:28', (BIGINT '156'), (BIGINT '70'), 'mU2RndOVnv'), ((BIGINT '-4016880394742629303'), 'w6l35epa2k', 'FtUdO9hGxg', (BIGINT '758'), (BIGINT '723'), TIMESTAMP '2023-09-01 22:12:33', TIMESTAMP '2023-09-01 22:12:21', (BIGINT '949'), (BIGINT '676'), 'DmK4x6dIbP'), ((BIGINT '437'), 'k8xAWx6Vde', 'D4cZ0dfD8l', (BIGINT '1'), (BIGINT '913'), TIMESTAMP '2023-09-01 22:11:29', TIMESTAMP '2023-09-01 22:11:21', (BIGINT '538'), (BIGINT '827'), 'SFFbPHfXcJ'), ((BIGINT '-1028690284359344435'), 'fsGfc1soHQ', '4rIOULfaan', (BIGINT '726'), (BIGINT '414'), TIMESTAMP '2023-08-31 22:12:54', TIMESTAMP '2023-09-01 22:11:54', (BIGINT '225'), (BIGINT '7341144504753441146'), '6Gm0NjVZzb'), ((BIGINT '1'), 'P6UFWIJCTT', 'TA1QdRF1Bj', (BIGINT '801'), (BIGINT '324'), TIMESTAMP '2023-09-01 21:12:54', TIMESTAMP '2023-09-01 22:12:04', (BIGINT '526'), (BIGINT '62'), 'oM9nqY4ecF'), ((BIGINT '345'), 'e2GA2nzQ1A', 'ZyZNAu5y25', (BIGINT '565'), (BIGINT '9223372036854775807'), TIMESTAMP '2023-09-01 22:12:37', TIMESTAMP '2023-09-01 21:12:54', (BIGINT '882'), (BIGINT '90'), 'f0NblNqINl'), ((BIGINT '9223372036854775807'), '18vyBEK0oD', 'kITWui7YMg', (BIGINT '1'), (BIGINT '140'), TIMESTAMP '2023-09-01 22:11:53', TIMESTAMP '2023-09-01 22:12:54', (BIGINT '779'), (BIGINT '349'), 'yjsL8LbWn1'), ((BIGINT '186'), 'l3staXmKpy', 'qU89Fy47HT', (BIGINT '102'), (BIGINT '-9223372036854775808'), TIMESTAMP '2023-09-01 22:11:59', TIMESTAMP '2023-09-01 22:12:05', (BIGINT '922'), (BIGINT '788'), 'LVnN9OvXQP'), ((BIGINT '9223372036854775807'), 'RYZq16DVja', '189SjklDbJ', (BIGINT '26'), (BIGINT '508'), TIMESTAMP '2023-09-01 22:12:17', TIMESTAMP '2023-09-01 22:12:54', (BIGINT '9223372036854775807'), (BIGINT '9223372036854775807'), 'W9knEVd0Yh'), ((BIGINT '1'), 'GqRzxNk003', '7jdGNetuGU', (BIGINT '922'), (BIGINT '754'), TIMESTAMP '2023-09-01 22:11:54', TIMESTAMP '2023-09-01 22:11:52', (BIGINT '268'), (BIGINT '5059041236478666607'), 'ANvRacSYBz'), ((BIGINT '9223372036854775807'), '3l5RvQpEaG', 'Fx6lXe1wSE', (BIGINT '599'), (BIGINT '-9223372036854775808'), TIMESTAMP '2023-09-01 22:11:31', TIMESTAMP '2023-09-01 22:12:22', (BIGINT '386'), (BIGINT '102'), '1f00WJdzjL'), ((BIGINT '-3934798421906180339'), 'MzmNEuEvAu', 'UWrNrt133K', (BIGINT '868'), (BIGINT '409'), TIMESTAMP '2023-08-31 22:12:54', TIMESTAMP '2023-09-01 22:11:24', (BIGINT '658'), (BIGINT '4'), 'xNwiFtxcup'), ((BIGINT '614'), 'hxZTnZoIt2', 'Rk5YtmnLfW', (BIGINT '144'), (BIGINT '0'), TIMESTAMP '2023-09-01 22:11:45', TIMESTAMP '2023-08-31 22:12:54', (BIGINT '9223372036854775807'), (BIGINT '481'), 'zF6xc0E9ZR');
INSERT INTO bid VALUES ((BIGINT '790'), (BIGINT '0'), (BIGINT '1'), '3JgBl8glpV', 'YbW02aV8IJ', TIMESTAMP '2023-09-01 22:12:01', '8Vj08yOCG6'), ((BIGINT '9223372036854775807'), (BIGINT '-9223372036854775808'), (BIGINT '0'), 'E3PBpqGfyz', 'F8ZRaU0KrM', TIMESTAMP '2023-09-01 22:12:54', '2cZTgKc4xZ'), ((BIGINT '0'), (BIGINT '388'), (BIGINT '621'), 'WyJ17zxxQP', 'qbNIpZ2VSV', TIMESTAMP '2023-09-01 22:12:06', 'jvpO6Evlo9'), ((BIGINT '9223372036854775807'), (BIGINT '292'), (BIGINT '-965737290972050171'), 'dIiOEVV1f9', 'GPaLiPFq6h', TIMESTAMP '2023-09-01 22:11:44', 'KvW4iG87AL'), ((BIGINT '1186200897509294296'), (BIGINT '747'), (BIGINT '-9223372036854775808'), 'HbExvZyhrF', 'UNXOikha0O', TIMESTAMP '2023-09-01 22:12:23', '7PsuNxopxO'), ((BIGINT '0'), (BIGINT '656'), (BIGINT '668'), 'VDM2GRbFic', 'HTDIfhoSCP', TIMESTAMP '2023-09-01 22:12:30', 'THloRFbLaU'), ((BIGINT '732'), (BIGINT '603'), (BIGINT '790'), 'fvDuPP5c5d', 'UPiDVCt3rf', TIMESTAMP '2023-09-01 22:12:13', '0SODofg5Df'), ((BIGINT '44'), (BIGINT '342'), (BIGINT '-5684643899113787204'), '66Ocqx8zLS', 'Ny2tj9SYV0', TIMESTAMP '2023-09-01 22:11:54', 'WP2DQ53kqi'), ((BIGINT '110'), (BIGINT '726'), (BIGINT '379'), 'iM2WdYdmdw', 'ztYmyMgl6c', TIMESTAMP '2023-09-01 22:11:40', 'XDqwwJ712U'), ((BIGINT '784'), (BIGINT '9223372036854775807'), (BIGINT '299'), 'lbD5t7hLvK', 'l9FsUlORkk', TIMESTAMP '2023-09-01 22:11:32', 'atvcr0yoOJ'), ((BIGINT '-9223372036854775808'), (BIGINT '679'), (BIGINT '162'), '5KdZ9Q1FFx', 'hoDpV4VEG8', TIMESTAMP '2023-08-25 22:12:54', 'HSTrSPjp9Q'), ((BIGINT '969'), (BIGINT '418'), (BIGINT '89'), 'fI52xvqSOE', '3YMIcoUryg', TIMESTAMP '2023-09-01 22:12:13', 'gvN4AtlB1o'), ((BIGINT '0'), (BIGINT '0'), (BIGINT '779'), 'MVwGYZ24TG', 'Ylv3CoOBQq', TIMESTAMP '2023-09-01 22:11:54', '0fbOyasXIQ'), ((BIGINT '143'), (BIGINT '486'), (BIGINT '290'), 'JRQN7d29Lk', 'xTh0NjIvtc', TIMESTAMP '2023-09-01 22:11:59', 'oimpAo38mX'), ((BIGINT '761'), (BIGINT '175'), (BIGINT '1'), 'ZEr9v6pTu8', '2hLCfmPfr6', TIMESTAMP '2023-09-01 22:11:54', 'ZA98fLEeND'), ((BIGINT '0'), (BIGINT '-9223372036854775808'), (BIGINT '-5229342155682836349'), '8KDJjzvPWm', 'MjLq2c5fUu', TIMESTAMP '2023-09-01 22:12:13', '9Y4C4cLmHF'), ((BIGINT '511'), (BIGINT '6399785451901175693'), (BIGINT '647'), 'xwtmz2ra1l', 'nzeArKwH0j', TIMESTAMP '2023-09-01 22:11:27', '4DptKMmFtK'), ((BIGINT '733'), (BIGINT '316'), (BIGINT '9223372036854775807'), 'R9C4XJmOkr', '2FRI3FXqhe', TIMESTAMP '2023-09-01 22:12:53', 'T0Oo30YOjI'), ((BIGINT '44'), (BIGINT '672'), (BIGINT '430'), 'INJAX9PDYo', 'twd5guwk2k', TIMESTAMP '2023-09-01 22:12:35', '1Uc5V8qPUV'), ((BIGINT '976'), (BIGINT '354'), (BIGINT '801'), 'AKnfQYt7jU', 'y8o8tdGeUt', TIMESTAMP '2023-09-01 22:11:23', 'e5KthCPgHc'), ((BIGINT '0'), (BIGINT '307'), (BIGINT '782'), 'tCmcE5TMiN', 'sk5YalSlnj', TIMESTAMP '2023-09-01 22:12:13', 'Yyyykj0aVO'), ((BIGINT '520'), (BIGINT '802'), (BIGINT '484'), 'xg7bhlgeTy', 'dLn2nUbqMQ', TIMESTAMP '2023-08-31 22:12:54', 'qBxEC38FhT'), ((BIGINT '471'), (BIGINT '310'), (BIGINT '307'), 'DSbi0H1wWi', 'GwHdrmhQHX', TIMESTAMP '2023-09-01 22:11:45', 'Qyk0CNbfSX'), ((BIGINT '164'), (BIGINT '1'), (BIGINT '774'), '2qS9JikQ48', 'rgZUflCMt1', TIMESTAMP '2023-09-01 22:12:13', 'XkdCzYe56p'), ((BIGINT '58'), (BIGINT '362'), (BIGINT '6019211949975990000'), 'm5WttTEM1o', 'xIUvPMWLL6', TIMESTAMP '2023-09-01 21:12:54', 'Ry3aDZQYpd'), ((BIGINT '632'), (BIGINT '494'), (BIGINT '1'), 'osCeHeQ7qi', 'QMLuyKr9Nr', TIMESTAMP '2023-08-25 22:12:54', 'wxzljdg0kG'), ((BIGINT '-9223372036854775808'), (BIGINT '-4172344811292728272'), (BIGINT '787'), 'Ynd6wasAYi', '9g0txJSUol', TIMESTAMP '2023-09-01 22:11:24', 'ECkHvyWqHU'), ((BIGINT '-1117145163569285971'), (BIGINT '16'), (BIGINT '246'), 'Bq6k3PXBzt', 'gujPpVsXZb', TIMESTAMP '2023-08-31 22:12:54', 'nWU227uIdS'), ((BIGINT '511'), (BIGINT '9223372036854775807'), (BIGINT '142'), 'Z9dkdHoWKL', 'd8Ny7aYlEF', TIMESTAMP '2023-09-01 22:12:17', 'DNDOa5Psso'), ((BIGINT '9223372036854775807'), (BIGINT '-9223372036854775808'), (BIGINT '707'), 'pHgJGUwtqd', 'XjEVi37xBR', TIMESTAMP '2023-09-01 22:12:26', 'I8fJ3onjX8'), ((BIGINT '4506864894389342037'), (BIGINT '0'), (BIGINT '527'), 'GgJsxAfOv9', 'Fl41nsUg6Y', TIMESTAMP '2023-09-01 22:11:36', '9tMQVHFnCZ'), ((BIGINT '922'), (BIGINT '720'), (BIGINT '170'), '69q5vaJDOR', 'fuJhueklNQ', TIMESTAMP '2023-09-01 22:11:19', 'PeNNfM8hxz'), ((BIGINT '736'), (BIGINT '950'), (BIGINT '5683197852745103143'), 'LEaneKK2KC', '3nv2TtknC0', TIMESTAMP '2023-09-01 22:12:14', 'aJZeGn9BCz'), ((BIGINT '-9223372036854775808'), (BIGINT '9223372036854775807'), (BIGINT '697'), '6iMSTYwvmF', 'nLHZqJ4IHY', TIMESTAMP '2023-08-31 22:12:54', 'EghZLS2QLE'), ((BIGINT '1'), (BIGINT '834'), (BIGINT '481'), 'zFNSNMrgEg', 'Zv47xy9HEs', TIMESTAMP '2023-09-01 22:12:37', 'DdLbmDkpPA'), ((BIGINT '-1430551466157568050'), (BIGINT '382'), (BIGINT '864'), 'i5qQx6YyFX', 'VreVSS9aHC', TIMESTAMP '2023-08-25 22:12:54', 'Wa3aunT7I9'), ((BIGINT '-6496328424366527544'), (BIGINT '0'), (BIGINT '496'), 'eQx8whPtLI', 'nHbFNl04FL', TIMESTAMP '2023-09-01 22:11:48', 'hoVs8Rbiay'), ((BIGINT '497'), (BIGINT '544'), (BIGINT '-9223372036854775808'), 'hLG1euUFlU', 'bJ30Odv7Vf', TIMESTAMP '2023-09-01 22:12:02', 'wzYqBTqNc1'), ((BIGINT '719'), (BIGINT '-9223372036854775808'), (BIGINT '281'), 'wa2XMVmbql', 'yyv0EOyBIl', TIMESTAMP '2023-09-01 22:12:53', 'rmK0ZH4vSb'), ((BIGINT '316'), (BIGINT '161'), (BIGINT '256'), 'Lloa6R4yAa', 'EGSFS0xWBt', TIMESTAMP '2023-09-01 21:12:54', 'hiykc6fFTe'), ((BIGINT '717'), (BIGINT '129'), (BIGINT '6502061001678260849'), 'KmouQNTgmx', 'SUjA1kKWLE', TIMESTAMP '2023-09-01 22:12:53', '5ZZxwE8Bkb'), ((BIGINT '965'), (BIGINT '8767795821396149461'), (BIGINT '749'), 'QgLt9KnAkg', '9qw1SHVhdQ', TIMESTAMP '2023-09-01 22:12:37', 'siwYwKVvSA'), ((BIGINT '-6487901115265867581'), (BIGINT '452'), (BIGINT '693'), 'eU34YkLaKw', 'KyKuIPpEfw', TIMESTAMP '2023-09-01 22:12:14', 'Lszg3RKFQT'), ((BIGINT '588'), (BIGINT '939'), (BIGINT '8800950640029056723'), 'CossFkg43F', 'AN8l0hUdqL', TIMESTAMP '2023-08-25 22:12:54', 'KaOU610cko'), ((BIGINT '300'), (BIGINT '579'), (BIGINT '456'), 'JKtnbHPAUc', 'jYxSjqNmsW', TIMESTAMP '2023-09-01 22:11:53', 'cVEFZSGEy4'), ((BIGINT '404'), (BIGINT '728'), (BIGINT '205'), 'd7wyfGPii6', 'Bg6Bww3zUL', TIMESTAMP '2023-08-31 22:12:54', 'SqvEwTfz24'), ((BIGINT '581'), (BIGINT '6358673601144319090'), (BIGINT '678'), 'lVfFBcb6Ww', 'LdILrnj3rL', TIMESTAMP '2023-09-01 22:11:51', '3c2hliAywi'), ((BIGINT '793'), (BIGINT '52'), (BIGINT '672'), 'UgYs3OruOV', '6g2KIhQReG', TIMESTAMP '2023-09-01 22:12:20', '42SAZUomQF'), ((BIGINT '0'), (BIGINT '162'), (BIGINT '308'), 'v00I1pRybY', 'nbLGD1HKZM', TIMESTAMP '2023-09-01 22:12:34', 'nlz3Q0EaiA'), ((BIGINT '596'), (BIGINT '713'), (BIGINT '477'), 'THuddVnAwm', '6TWFJpWWgN', TIMESTAMP '2023-09-01 22:11:22', 'GSLJpZNWT5');
INSERT INTO alltypes1 VALUES (true, (SMALLINT '786'), (INT '1409922817'), (BIGINT '925'), (REAL '536'), (FLOAT '782'), (487), DATE '2023-09-01', 'IwfwuseZmg', TIME '22:12:54', TIMESTAMP '2023-09-01 22:12:42', (INTERVAL '-78'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '354'), (INT '627')], ARRAY['yRMgX7pFXW', 'r7PAN6KB2b', 'NQJbRQoVib']), (true, (SMALLINT '82'), (INT '216'), (BIGINT '732'), (REAL '337'), (FLOAT '772'), (378), DATE '2023-09-01', '6nNf6LL2C1', TIME '22:12:25', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '0')], ARRAY['3NE5ewEx4T']), (false, (SMALLINT '761'), (INT '966'), (BIGINT '153'), (REAL '1023789467'), (FLOAT '752'), (630), DATE '2023-09-01', 'ySrgeBXDuc', TIME '22:11:17', TIMESTAMP '2023-09-01 22:11:50', (INTERVAL '-91'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '77'), (INT '718'), (INT '401'), (INT '874')], ARRAY['k6N5rUX8p1', 'sFRQ1u2ihF']), (false, (SMALLINT '255'), (INT '1'), (BIGINT '9223372036854775807'), (REAL '0'), (FLOAT '775'), (-2147483648), DATE '2023-09-01', '2498VN2txc', TIME '22:11:54', TIMESTAMP '2023-09-01 22:12:54', (INTERVAL '-84'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '246'), (INT '120'), (INT '154')], ARRAY['Rau1Iezv50', 'uWtqX1jIP0', 'N356wachUq', 'tDVFlmtDNk']), (true, (SMALLINT '933'), (INT '915'), (BIGINT '433'), (REAL '734'), (FLOAT '438'), (998512901), DATE '2023-09-01', 'Qgfzps4qkX', TIME '22:12:54', TIMESTAMP '2023-09-01 22:12:02', (INTERVAL '3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '329'), (INT '577'), (INT '255'), (INT '70')], ARRAY['1HQloIk7oW', 'ixxNgP8vaq', '9CSOsftyRA', 'jiqocRdrUC']), (true, (SMALLINT '7096'), (INT '-1627323193'), (BIGINT '191'), (REAL '483'), (FLOAT '85'), (-2147483648), DATE '2023-09-01', 'sLgs9Am1iP', TIME '22:12:40', TIMESTAMP '2023-09-01 22:11:27', (INTERVAL '-60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '252'), (INT '137'), (INT '110'), (INT '574')], ARRAY['t5073iSwvs']), (false, (SMALLINT '972'), (INT '-235825836'), (BIGINT '842'), (REAL '27'), (FLOAT '675'), (0), DATE '2023-08-25', 'uwAFEeex9Y', TIME '22:12:37', TIMESTAMP '2023-09-01 22:11:40', (INTERVAL '28'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '355')], ARRAY['xan6o2VHID', 'MTSy3lzImo', 'UZqnEMW60w']), (true, (SMALLINT '-5675'), (INT '351'), (BIGINT '2126970337502976901'), (REAL '279'), (FLOAT '1'), (1), DATE '2023-09-01', 'kVzsUBBtgm', TIME '22:11:24', TIMESTAMP '2023-09-01 22:11:53', (INTERVAL '0'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '29'), (INT '0'), (INT '42')], ARRAY['qP0T9MIUuT', 'NHWrN8G4K4']), (true, (SMALLINT '32767'), (INT '-1086555024'), (BIGINT '240'), (REAL '504'), (FLOAT '750'), (-1305391488), DATE '2023-09-01', 'DVs87hPqq1', TIME '22:11:52', TIMESTAMP '2023-09-01 22:12:39', (INTERVAL '29'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '219'), (INT '897'), (INT '1440766178'), (INT '456')], ARRAY['bdIPBn6krj']), (false, (SMALLINT '0'), (INT '334'), (BIGINT '1'), (REAL '726'), (FLOAT '893675912'), (318), DATE '2023-09-01', 'kSCEOOrd7G', TIME '22:12:53', TIMESTAMP '2023-09-01 22:12:26', (INTERVAL '47'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '476'), (INT '673'), (INT '690')], ARRAY['5iGpDRnOrH', 'J1sKmk7KUA', 'HfSSJzIZmf', 'XznmtXpyDN']), (true, (SMALLINT '678'), (INT '2147483647'), (BIGINT '445'), (REAL '2147483647'), (FLOAT '-2147483648'), (133), DATE '2023-09-01', '5C2zHZ2rsj', TIME '22:11:55', TIMESTAMP '2023-08-25 22:12:54', (INTERVAL '-16'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '852'), (INT '2147483647')], ARRAY['jMHREGCjta', 'gPIU9JZFKw']), (true, (SMALLINT '389'), (INT '144'), (BIGINT '391'), (REAL '535'), (FLOAT '151'), (511), DATE '2023-09-01', '51fq6lAnvY', TIME '22:12:41', TIMESTAMP '2023-09-01 22:12:34', (INTERVAL '89'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '574'), (INT '769'), (INT '448'), (INT '147')], ARRAY['MBY4vydmiP']), (false, (SMALLINT '896'), (INT '437'), (BIGINT '970'), (REAL '649'), (FLOAT '110'), (2114259465), DATE '2023-09-01', '8d1r33ciZg', TIME '22:11:15', TIMESTAMP '2023-09-01 22:11:44', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2115567970'), (INT '831'), (INT '1'), (INT '255')], ARRAY['hTMWjO1ZU3', '2FpBbybZgL', 'KgCuBbqpCi']), (true, (SMALLINT '-22796'), (INT '2147483647'), (BIGINT '402'), (REAL '714'), (FLOAT '57'), (529), DATE '2023-09-01', 't0yBTBlGUK', TIME '22:12:17', TIMESTAMP '2023-09-01 22:12:45', (INTERVAL '59'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '97'), (INT '91'), (INT '11')], ARRAY['npi6VOKLD0', 'ZxydLW5uBo', 'VDHhVfouI0', '8KNtnY2VK0']), (true, (SMALLINT '946'), (INT '0'), (BIGINT '579'), (REAL '1'), (FLOAT '291'), (371), DATE '2023-09-01', 'Wtz9d99le4', TIME '22:11:55', TIMESTAMP '2023-09-01 22:11:45', (INTERVAL '-40'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '806')], ARRAY['XxR4qJiu6K', '1Xu1JSnash', 'ScE6xix9lj']), (true, (SMALLINT '42'), (INT '728'), (BIGINT '18'), (REAL '89'), (FLOAT '860'), (877), DATE '2023-09-01', 'oKwHBUh54Y', TIME '22:12:40', TIMESTAMP '2023-09-01 22:11:45', (INTERVAL '-52'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '201'), (INT '363'), (INT '376')], ARRAY['1FnrxA78t9', 'vx5JGtGmLg']), (true, (SMALLINT '348'), (INT '803'), (BIGINT '510'), (REAL '960'), (FLOAT '725837969'), (-2147483648), DATE '2023-09-01', 'yZDBdmQpQV', TIME '22:12:54', TIMESTAMP '2023-09-01 22:12:42', (INTERVAL '-81'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '306'), (INT '958')], ARRAY['EEVDU2QtqY', '4FNWYctYlh', 'Q6zXDMSKDh']), (true, (SMALLINT '32767'), (INT '311'), (BIGINT '-9223372036854775808'), (REAL '-2147483648'), (FLOAT '0'), (0), DATE '2023-09-01', 'vxEIKnAMZT', TIME '22:12:38', TIMESTAMP '2023-08-25 22:12:54', (INTERVAL '-62'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '645'), (INT '2147483647'), (INT '786')], ARRAY['yCe22lEjCR']), (true, (SMALLINT '976'), (INT '1556183328'), (BIGINT '542'), (REAL '675'), (FLOAT '265'), (333), DATE '2023-09-01', '5D1eIb0BHO', TIME '22:12:00', TIMESTAMP '2023-09-01 22:12:39', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '508'), (INT '777')], ARRAY['nGpn9DL18y', '1R0LYxErPh', 'z5qmXAUjLJ', 'Pssmftrash']), (false, (SMALLINT '-28853'), (INT '-2147483648'), (BIGINT '631'), (REAL '895'), (FLOAT '104'), (396), DATE '2023-08-31', 'axbR42nSkH', TIME '22:11:45', TIMESTAMP '2023-09-01 22:12:20', (INTERVAL '18'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '-2147483648'), (INT '0'), (INT '1')], ARRAY['Ya67nqBGvp', '6rgRM28mKj', 'ilCa7fCSGq']), (true, (SMALLINT '909'), (INT '1616759219'), (BIGINT '416'), (REAL '657'), (FLOAT '528'), (1), DATE '2023-09-01', 'V8va2DGlvL', TIME '22:12:54', TIMESTAMP '2023-09-01 22:12:41', (INTERVAL '-29'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '639'), (INT '178')], ARRAY['PpMuYHOxeV', 'tvs29Z8VS6', 'ONghj5jNbw', '7kTisez3Cl']), (true, (SMALLINT '3489'), (INT '779'), (BIGINT '0'), (REAL '2147483647'), (FLOAT '505'), (459), DATE '2023-09-01', 'Np7ox7p98E', TIME '22:12:05', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '45'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '421'), (INT '887')], ARRAY['nUDc5kXF51', '8sgMlJHnQj', 'qNSEfU2AE4']), (false, (SMALLINT '671'), (INT '79'), (BIGINT '417'), (REAL '44'), (FLOAT '332'), (2147483647), DATE '2023-09-01', 'L3sRRxCdk1', TIME '22:12:53', TIMESTAMP '2023-09-01 22:12:47', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '956'), (INT '250'), (INT '739'), (INT '566')], ARRAY['Pk4GaeKhOa', '5ttXe7ot2p']), (false, (SMALLINT '654'), (INT '300'), (BIGINT '480'), (REAL '382'), (FLOAT '2147483647'), (2147483647), DATE '2023-09-01', 'ep4BTqtZeV', TIME '22:12:37', TIMESTAMP '2023-09-01 22:11:31', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '639'), (INT '332')], ARRAY['XOy9DxECQA', 'ePGIcrQwQl']), (true, (SMALLINT '221'), (INT '649'), (BIGINT '4698713049929743010'), (REAL '264'), (FLOAT '-502856329'), (110), DATE '2023-09-01', 'aOUGgl431T', TIME '22:11:17', TIMESTAMP '2023-09-01 22:11:16', (INTERVAL '-60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '543')], ARRAY['wXYYtQR6Zb', 'gjgxun54fF', 'UI2WiHI4gx', 'jm2T6c9WlI']), (true, (SMALLINT '2880'), (INT '481'), (BIGINT '970'), (REAL '890'), (FLOAT '637'), (-175164678), DATE '2023-09-01', 'BUkwpn6X2F', TIME '22:11:20', TIMESTAMP '2023-09-01 22:12:48', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '349'), (INT '581')], ARRAY['MqCARgjDCf']), (true, (SMALLINT '0'), (INT '59'), (BIGINT '-9223372036854775808'), (REAL '815'), (FLOAT '149'), (503), DATE '2023-09-01', 'lDurIDe7FV', TIME '22:11:54', TIMESTAMP '2023-09-01 22:12:14', (INTERVAL '-19'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '0'), (INT '686'), (INT '900')], ARRAY['hFNX2VUWu3', 'VXwa8ez8gK']), (false, (SMALLINT '240'), (INT '476'), (BIGINT '367'), (REAL '98'), (FLOAT '469'), (0), DATE '2023-09-01', 'QHRIbLarzG', TIME '22:12:22', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '179'), (INT '46')], ARRAY['1QDYmzWZfU', 'VVEiyuhezZ', 'gLavfgOPWC']), (true, (SMALLINT '456'), (INT '1'), (BIGINT '-6225175240960357013'), (REAL '-15277401'), (FLOAT '337'), (767), DATE '2023-09-01', 'Kq8kG9N39T', TIME '22:12:53', TIMESTAMP '2023-09-01 22:11:54', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '708')], ARRAY['SpJK3zTP6X', 'HClUb7fnRZ']), (true, (SMALLINT '402'), (INT '731'), (BIGINT '9223372036854775807'), (REAL '536'), (FLOAT '733'), (506), DATE '2023-09-01', 'HDOhyj3mqw', TIME '22:11:20', TIMESTAMP '2023-09-01 22:11:17', (INTERVAL '93'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '733'), (INT '2147483647')], ARRAY['Fhsca0pTLq']), (true, (SMALLINT '971'), (INT '780'), (BIGINT '264'), (REAL '146'), (FLOAT '2147483647'), (330), DATE '2023-09-01', 'JrhRuYVrVg', TIME '22:12:34', TIMESTAMP '2023-09-01 22:12:50', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '375'), (INT '0'), (INT '96')], ARRAY['mudynYVN1L', 'gDB6fChCto']), (false, (SMALLINT '797'), (INT '729'), (BIGINT '115'), (REAL '321'), (FLOAT '1'), (285), DATE '2023-08-31', 'CkGs0CPHyU', TIME '22:12:17', TIMESTAMP '2023-09-01 22:11:25', (INTERVAL '-604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '780'), (INT '176'), (INT '860'), (INT '45')], ARRAY['4X4p0GXJS8', 'qOft3N9lpG', '3cXyuIRlHJ']), (true, (SMALLINT '-1845'), (INT '956'), (BIGINT '727'), (REAL '673'), (FLOAT '1'), (2147483647), DATE '2023-09-01', 'd4FCASAUh8', TIME '22:11:52', TIMESTAMP '2023-09-01 22:12:40', (INTERVAL '-604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-728541368'), (INT '656')], ARRAY['RA4vnoRdEh', 'CIjW03RzF6']), (true, (SMALLINT '245'), (INT '252'), (BIGINT '81'), (REAL '1'), (FLOAT '266'), (1), DATE '2023-09-01', 'myBmwP5vJy', TIME '22:11:24', TIMESTAMP '2023-09-01 22:11:35', (INTERVAL '17'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '582'), (INT '59'), (INT '0'), (INT '62')], ARRAY['YPnvZN9ou8', 'eBXP0vPeeo', '5ONLMU7WK2']), (true, (SMALLINT '566'), (INT '325'), (BIGINT '966'), (REAL '0'), (FLOAT '799'), (-298947858), DATE '2023-09-01', 'MdyI6j5yFx', TIME '22:12:53', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '557125444')], ARRAY['U6rz2NArVn']), (true, (SMALLINT '569'), (INT '-352482923'), (BIGINT '6718236687896284757'), (REAL '67'), (FLOAT '200'), (179), DATE '2023-09-01', 'wV142MUg1p', TIME '22:12:44', TIMESTAMP '2023-09-01 22:12:26', (INTERVAL '-12'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '534'), (INT '0'), (INT '730')], ARRAY['JV8CiJ0x4E']), (false, (SMALLINT '348'), (INT '685'), (BIGINT '9223372036854775807'), (REAL '1'), (FLOAT '0'), (536), DATE '2023-09-01', 'T6gCtZEHUT', TIME '22:12:28', TIMESTAMP '2023-09-01 22:12:20', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '97'), (INT '5'), (INT '835'), (INT '679')], ARRAY['y3aAPbv2fD']), (false, (SMALLINT '857'), (INT '296'), (BIGINT '6045899193458644586'), (REAL '1'), (FLOAT '832'), (268), DATE '2023-09-01', 'yGjdVqmemD', TIME '22:11:29', TIMESTAMP '2023-09-01 22:12:15', (INTERVAL '-38'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '53')], ARRAY['HEjE3ZyopY', 'frs50qYdMj', 'VHVLznfcjq', 'uR5HP3KbR7']), (false, (SMALLINT '285'), (INT '6'), (BIGINT '368'), (REAL '0'), (FLOAT '12'), (397), DATE '2023-09-01', 'r6ejByJCym', TIME '22:12:49', TIMESTAMP '2023-08-25 22:12:54', (INTERVAL '-86'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '711'), (INT '-240239873'), (INT '1'), (INT '1911327746')], ARRAY['OlfYXkHQQs', '7r8yACMFsX', 'Lx7Vs2fw7P', 'ZqZA2BYvl9']), (true, (SMALLINT '287'), (INT '149'), (BIGINT '-9223372036854775808'), (REAL '886761245'), (FLOAT '615'), (424), DATE '2023-09-01', 'rIDWh9gPv3', TIME '22:11:30', TIMESTAMP '2023-09-01 22:11:26', (INTERVAL '72'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1271800813')], ARRAY['gxlPtYjFc9', '8eDSto3L7e', 'Lpe34kPIc7']), (false, (SMALLINT '788'), (INT '949'), (BIGINT '880'), (REAL '2147483647'), (FLOAT '979'), (632), DATE '2023-09-01', '4luWV716ZC', TIME '22:11:46', TIMESTAMP '2023-09-01 22:12:38', (INTERVAL '71'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '196'), (INT '890'), (INT '58'), (INT '-1692003695')], ARRAY['aO9DTES4SN', 'AcdfKiXhIB', 'teW8VdJ0Lc']), (true, (SMALLINT '204'), (INT '551'), (BIGINT '787'), (REAL '2147483647'), (FLOAT '2147483647'), (96), DATE '2023-09-01', 'Ftuh9HZVf1', TIME '22:12:29', TIMESTAMP '2023-09-01 22:12:46', (INTERVAL '3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '979734564')], ARRAY['vsm8vvvxi9', 'ElGMu3KTSf']), (false, (SMALLINT '-29812'), (INT '314'), (BIGINT '-9223372036854775808'), (REAL '-503002463'), (FLOAT '2147483647'), (163), DATE '2023-09-01', 'AMUOzRjt4N', TIME '22:11:54', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '0'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647'), (INT '-2147483648')], ARRAY['T2iURbzdzs', 'VC1eLGMdgm', 'GEue55ULDX', 'na71Ti6X0C']), (false, (SMALLINT '876'), (INT '0'), (BIGINT '649'), (REAL '-1762623065'), (FLOAT '2147483647'), (-2147483648), DATE '2023-09-01', 'hmSrc8Q9dx', TIME '22:11:33', TIMESTAMP '2023-09-01 22:11:24', (INTERVAL '84'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '731'), (INT '82'), (INT '481')], ARRAY['jBG0xd9wqt', '4zyLJwsEzF', 'UtE5iVMHIa']), (false, (SMALLINT '1'), (INT '585'), (BIGINT '887'), (REAL '574'), (FLOAT '728'), (-1860545994), DATE '2023-08-31', 'CEceM8UU2B', TIME '22:12:24', TIMESTAMP '2023-09-01 22:11:36', (INTERVAL '11'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '802'), (INT '68'), (INT '194')], ARRAY['eIofNjWnUS', 'km9tbGGwfh', 'mnoEuzblTX', 'xS2cifGeHi']), (true, (SMALLINT '128'), (INT '646'), (BIGINT '651'), (REAL '-2147483648'), (FLOAT '284'), (92), DATE '2023-09-01', 'twGIxRHbwf', TIME '22:11:54', TIMESTAMP '2023-09-01 22:11:54', (INTERVAL '-59'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '794')], ARRAY['rFqcRW9Xej']), (false, (SMALLINT '727'), (INT '117'), (BIGINT '143'), (REAL '534'), (FLOAT '-1135652653'), (163), DATE '2023-08-31', 'Gew78kinak', TIME '22:12:54', TIMESTAMP '2023-09-01 22:12:04', (INTERVAL '-82'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '306'), (INT '629'), (INT '379'), (INT '623')], ARRAY['XQeF5Mr5aV', 'QnO9sFo0Op', 'WzygxWfWCZ']), (true, (SMALLINT '531'), (INT '82'), (BIGINT '225'), (REAL '1914162555'), (FLOAT '-2147483648'), (1), DATE '2023-09-01', 'R1MlwkBROf', TIME '22:12:09', TIMESTAMP '2023-09-01 22:11:22', (INTERVAL '23'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '132'), (INT '209'), (INT '538'), (INT '960')], ARRAY['1XBHrKhXy1']), (true, (SMALLINT '1'), (INT '2147483647'), (BIGINT '225'), (REAL '858'), (FLOAT '2147483647'), (996), DATE '2023-09-01', 'iUQy198eZl', TIME '22:12:09', TIMESTAMP '2023-09-01 22:12:43', (INTERVAL '-68'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '237'), (INT '703'), (INT '134')], ARRAY['DClKXHCP4c', 'W0h0kgpoUp']), (true, (SMALLINT '719'), (INT '834'), (BIGINT '885'), (REAL '930'), (FLOAT '123'), (885), DATE '2023-08-31', 'BHvwvPtLIo', TIME '22:12:54', TIMESTAMP '2023-09-01 22:11:22', (INTERVAL '-65'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '557')], ARRAY['uVe5ZbqY4A', 'tVccAv7pBQ']);
INSERT INTO alltypes2 VALUES (true, (SMALLINT '-32768'), (INT '8'), (BIGINT '849'), (REAL '156'), (FLOAT '722360238'), (765), DATE '2023-09-01', 'r9BxwWjAVr', TIME '22:11:17', TIMESTAMP '2023-09-01 22:11:56', (INTERVAL '66'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '898177119'), (INT '2147483647'), (INT '2147483647'), (INT '619')], ARRAY['ZRtisVPzlb', 'gRZsu9Rh3Y']), (false, (SMALLINT '-1763'), (INT '843'), (BIGINT '277'), (REAL '845'), (FLOAT '1'), (846), DATE '2023-09-01', 'VFa78fRZyl', TIME '22:11:19', TIMESTAMP '2023-09-01 22:12:26', (INTERVAL '4'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647'), (INT '152'), (INT '-1589134816'), (INT '426')], ARRAY['q5fBe01tFl']), (false, (SMALLINT '0'), (INT '611'), (BIGINT '60'), (REAL '1512257720'), (FLOAT '541'), (0), DATE '2023-09-01', 'JDffEda5TN', TIME '22:12:35', TIMESTAMP '2023-09-01 22:11:32', (INTERVAL '3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '712')], ARRAY['C4GAnFJCSy', 'AdtRVmDVZ7', 'MCfgg1CjGH']), (true, (SMALLINT '102'), (INT '909'), (BIGINT '325'), (REAL '468'), (FLOAT '1'), (-449714044), DATE '2023-09-01', 'IXEbXZu1pF', TIME '22:11:59', TIMESTAMP '2023-09-01 22:11:19', (INTERVAL '-83'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648'), (INT '-1533865769'), (INT '35'), (INT '-456241420')], ARRAY['lwy2Abvzg2', 'w1qPrYFy1O']), (false, (SMALLINT '20'), (INT '203'), (BIGINT '825'), (REAL '2147483647'), (FLOAT '941'), (171), DATE '2023-08-25', '8OXWjlLk7l', TIME '22:11:38', TIMESTAMP '2023-09-01 22:11:19', (INTERVAL '-42'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '236'), (INT '491'), (INT '810')], ARRAY['z3hxEqoISU']), (true, (SMALLINT '420'), (INT '609'), (BIGINT '154'), (REAL '554'), (FLOAT '711'), (2147483647), DATE '2023-09-01', 'L0hJPxGMrU', TIME '22:11:36', TIMESTAMP '2023-08-25 22:12:54', (INTERVAL '-64'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '531'), (INT '512'), (INT '288'), (INT '1082453324')], ARRAY['dGFjc9mWK2', '5ex0PcVCcz']), (true, (SMALLINT '173'), (INT '868'), (BIGINT '686'), (REAL '330'), (FLOAT '503'), (442), DATE '2023-09-01', 'KDQVqmgGr6', TIME '21:12:54', TIMESTAMP '2023-09-01 22:11:53', (INTERVAL '-56'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '855'), (INT '896')], ARRAY['up920ZUUAY', 'eg6vDQhILf', '7ajX4TR7MB', 'hHdx4FX0Yl']), (false, (SMALLINT '999'), (INT '410'), (BIGINT '9223372036854775807'), (REAL '823'), (FLOAT '639'), (-2147483648), DATE '2023-09-01', '3UkBWAZaXa', TIME '22:11:22', TIMESTAMP '2023-09-01 22:11:42', (INTERVAL '58'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '760'), (INT '434'), (INT '470'), (INT '667847850')], ARRAY['EWhFhmtaTU', '57fFUrsrln', 'oKowa3JtXT', '715UaBuEjO']), (true, (SMALLINT '-32768'), (INT '2147483647'), (BIGINT '837'), (REAL '0'), (FLOAT '873'), (1), DATE '2023-09-01', '7lS86EGeVL', TIME '22:11:19', TIMESTAMP '2023-09-01 22:12:37', (INTERVAL '-41'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '632'), (INT '581')], ARRAY['9FFiQdo1Rb', 'vA5SUTszzo']), (false, (SMALLINT '232'), (INT '1'), (BIGINT '989'), (REAL '472'), (FLOAT '1'), (420), DATE '2023-08-31', 'aQHYneSJ4m', TIME '22:11:34', TIMESTAMP '2023-09-01 22:12:54', (INTERVAL '-83'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '0'), (INT '748')], ARRAY['AVyjmlPxqP', 'mLvo4PXGap']), (true, (SMALLINT '794'), (INT '-2147483648'), (BIGINT '664'), (REAL '130'), (FLOAT '238'), (183), DATE '2023-09-01', 'lomdThsE7A', TIME '22:11:27', TIMESTAMP '2023-09-01 22:12:51', (INTERVAL '-89'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2022577029')], ARRAY['XSYd35AUhP', '5QySBJlz6D']), (false, (SMALLINT '-32768'), (INT '-2147483648'), (BIGINT '923'), (REAL '526'), (FLOAT '-201930251'), (2147483647), DATE '2023-08-25', 'Ny73BbWDVl', TIME '22:12:51', TIMESTAMP '2023-09-01 22:11:33', (INTERVAL '-58'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '179'), (INT '66')], ARRAY['6ZpdizeUKY']), (true, (SMALLINT '0'), (INT '715'), (BIGINT '-1843028075296298898'), (REAL '109'), (FLOAT '987'), (1), DATE '2023-08-31', '3GQDrotqeL', TIME '22:11:39', TIMESTAMP '2023-08-31 22:12:54', (INTERVAL '-52'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '409'), (INT '54'), (INT '70'), (INT '945')], ARRAY['Kf82rC2ebz']), (true, (SMALLINT '453'), (INT '-2147483648'), (BIGINT '376'), (REAL '231'), (FLOAT '2147483647'), (2147483647), DATE '2023-08-31', 'MgS6x3aEqs', TIME '22:12:40', TIMESTAMP '2023-09-01 22:11:36', (INTERVAL '98'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '399'), (INT '140'), (INT '624'), (INT '600')], ARRAY['VbGfxOaQj9', 'WDurmixu88', 'DhXmfNhiwS']), (true, (SMALLINT '32767'), (INT '690'), (BIGINT '239'), (REAL '271'), (FLOAT '918'), (984), DATE '2023-09-01', '52xgvRVkEH', TIME '22:11:51', TIMESTAMP '2023-09-01 22:11:32', (INTERVAL '60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '660'), (INT '828'), (INT '848'), (INT '-1382151524')], ARRAY['HrYWY15AkV', 'Gv2qEQSDv3']), (false, (SMALLINT '607'), (INT '951'), (BIGINT '26'), (REAL '162'), (FLOAT '83'), (1), DATE '2023-09-01', '5dDJVFA4LN', TIME '21:12:54', TIMESTAMP '2023-09-01 22:12:42', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '128'), (INT '754'), (INT '196')], ARRAY['uzYphDDQkT']), (true, (SMALLINT '760'), (INT '186'), (BIGINT '664'), (REAL '82'), (FLOAT '901'), (607), DATE '2023-09-01', 'frj78XP5iW', TIME '22:11:55', TIMESTAMP '2023-09-01 22:11:46', (INTERVAL '-60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '621'), (INT '1'), (INT '495')], ARRAY['1RcDp8tpAH', 'MIJrS9oZJz', '9GTpLqByoP']), (false, (SMALLINT '957'), (INT '483'), (BIGINT '852'), (REAL '24525432'), (FLOAT '69'), (657), DATE '2023-09-01', 'Rt6ExHc2Gu', TIME '22:12:35', TIMESTAMP '2023-09-01 22:11:29', (INTERVAL '18'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '868')], ARRAY['xDvBWrFLsU']), (true, (SMALLINT '347'), (INT '64'), (BIGINT '79'), (REAL '344'), (FLOAT '85'), (543), DATE '2023-09-01', 'zROdUy0hax', TIME '22:11:54', TIMESTAMP '2023-09-01 22:12:39', (INTERVAL '-38'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '925'), (INT '595')], ARRAY['QseDSjYFr2']), (true, (SMALLINT '305'), (INT '439'), (BIGINT '693'), (REAL '466'), (FLOAT '226'), (760), DATE '2023-09-01', 'KvapGAvcDz', TIME '22:11:54', TIMESTAMP '2023-09-01 22:11:30', (INTERVAL '-14'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647')], ARRAY['OWoPX34LH5', 'y4UtQCXm1F', 'UmYbNbhESG']), (true, (SMALLINT '740'), (INT '708'), (BIGINT '848'), (REAL '1'), (FLOAT '133'), (0), DATE '2023-09-01', 'JpoiZBsnjz', TIME '21:12:54', TIMESTAMP '2023-09-01 22:11:54', (INTERVAL '-60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '96')], ARRAY['ptzyD4AI1I', 'hRbGJRrC20']), (false, (SMALLINT '734'), (INT '731'), (BIGINT '7038054458581489210'), (REAL '0'), (FLOAT '283'), (906), DATE '2023-09-01', 'HMtayCtoI9', TIME '22:12:43', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '97'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '223')], ARRAY['odPWFadgPj']), (false, (SMALLINT '607'), (INT '2147483647'), (BIGINT '684'), (REAL '640'), (FLOAT '-2147483648'), (1787842950), DATE '2023-09-01', 'lLKeIldHfH', TIME '22:12:33', TIMESTAMP '2023-09-01 22:12:00', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '959'), (INT '462'), (INT '61'), (INT '-2147483648')], ARRAY['2KvBUdMoeP']), (true, (SMALLINT '649'), (INT '2147483647'), (BIGINT '499'), (REAL '548'), (FLOAT '550'), (2147483647), DATE '2023-09-01', 'jFMU7MZOXd', TIME '22:12:32', TIMESTAMP '2023-09-01 22:12:13', (INTERVAL '33'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '387'), (INT '1325529502'), (INT '723'), (INT '468')], ARRAY['wDG5MCaxxi', 'GGX1KFO1Pd', 'lpY3CT1lZl']), (false, (SMALLINT '452'), (INT '1'), (BIGINT '789'), (REAL '952'), (FLOAT '88'), (708), DATE '2023-08-25', 'Xd4QLExVv8', TIME '22:12:52', TIMESTAMP '2023-09-01 22:11:54', (INTERVAL '-86'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '182'), (INT '625')], ARRAY['cqXzGSWcUS', 'RoLuBM2DsS', 'CZkjWml8b6']), (false, (SMALLINT '1'), (INT '21'), (BIGINT '607'), (REAL '806'), (FLOAT '2147483647'), (745), DATE '2023-08-25', 'iFV5PtuNqa', TIME '22:12:54', TIMESTAMP '2023-09-01 22:11:57', (INTERVAL '78'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '591')], ARRAY['ZL20oxXNg6', 'RbyNmACFDM', 'JjHJbUZ7iG', 'mRhmKS6Guv']), (true, (SMALLINT '669'), (INT '132'), (BIGINT '9223372036854775807'), (REAL '660'), (FLOAT '2022576510'), (770), DATE '2023-09-01', 'CY70uohj7D', TIME '22:12:01', TIMESTAMP '2023-09-01 21:12:54', (INTERVAL '97'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '455'), (INT '2147483647')], ARRAY['HIJW4nXxNE', 'z5FAWCxGpU', 'iQrS8XFczw']), (false, (SMALLINT '56'), (INT '659'), (BIGINT '135'), (REAL '411'), (FLOAT '173'), (728), DATE '2023-09-01', 'bE5qH7st2T', TIME '22:12:14', TIMESTAMP '2023-09-01 22:11:22', (INTERVAL '-86'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '853')], ARRAY['b9BqsWuHuy', 'sUCT3UXF6j', 'zDZLDMYThf']), (true, (SMALLINT '1'), (INT '527'), (BIGINT '980'), (REAL '960'), (FLOAT '417'), (1), DATE '2023-09-01', '9JuOBME0qr', TIME '22:12:07', TIMESTAMP '2023-09-01 22:11:25', (INTERVAL '13'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '609'), (INT '2147483647'), (INT '672339946'), (INT '-1988673907')], ARRAY['UxEb1F36j9', 'lKZVQXbQzR']), (false, (SMALLINT '820'), (INT '644'), (BIGINT '1'), (REAL '177'), (FLOAT '184'), (769), DATE '2023-09-01', 'VNOMSg5M29', TIME '22:12:16', TIMESTAMP '2023-09-01 22:11:37', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '842557255')], ARRAY['5VbZQEExS1', '5iIXJ0xiW0']), (false, (SMALLINT '0'), (INT '386'), (BIGINT '406'), (REAL '939'), (FLOAT '0'), (90), DATE '2023-09-01', 'mpWpAfXR34', TIME '22:11:17', TIMESTAMP '2023-08-25 22:12:54', (INTERVAL '0'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '479'), (INT '402')], ARRAY['SAJp5fV7f8']), (true, (SMALLINT '977'), (INT '1'), (BIGINT '488'), (REAL '636'), (FLOAT '988'), (0), DATE '2023-09-01', 'dga52IIou7', TIME '22:11:54', TIMESTAMP '2023-09-01 22:12:47', (INTERVAL '76'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '583')], ARRAY['gBHYqaY2U4']), (false, (SMALLINT '805'), (INT '807'), (BIGINT '980'), (REAL '0'), (FLOAT '74'), (418), DATE '2023-09-01', 'MipDa1fFdr', TIME '22:11:57', TIMESTAMP '2023-09-01 22:11:43', (INTERVAL '-66'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '800'), (INT '584')], ARRAY['IZgl8bZnLv', 'q98X1dK2Ov', 'svYnAEhAlJ']), (true, (SMALLINT '654'), (INT '887'), (BIGINT '901'), (REAL '1574358811'), (FLOAT '0'), (250), DATE '2023-09-01', 'rOmvw89Hkf', TIME '22:12:11', TIMESTAMP '2023-09-01 22:12:14', (INTERVAL '33'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '292'), (INT '665'), (INT '792'), (INT '950')], ARRAY['v72XEy7aeF', 'bfXJ912igP', 'wYnRgN8Mq5', 'nxQnaSyznJ']), (true, (SMALLINT '950'), (INT '202'), (BIGINT '811'), (REAL '720'), (FLOAT '900'), (703), DATE '2023-09-01', 'cldpGesmCJ', TIME '22:12:54', TIMESTAMP '2023-09-01 22:12:47', (INTERVAL '-55'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '524')], ARRAY['bPhW7PnPeF']), (false, (SMALLINT '696'), (INT '923'), (BIGINT '450'), (REAL '52'), (FLOAT '1627091905'), (-454402015), DATE '2023-08-31', 'lRFJHWlrbZ', TIME '22:11:31', TIMESTAMP '2023-09-01 22:12:08', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '324'), (INT '-933717148')], ARRAY['T4DnVIw8ql', 'Rsmw7K39EH', 'ICwPIs7Zzu']), (true, (SMALLINT '32767'), (INT '644'), (BIGINT '0'), (REAL '0'), (FLOAT '2147483647'), (257), DATE '2023-09-01', 'SJ5WYJoOHg', TIME '22:12:14', TIMESTAMP '2023-09-01 22:11:39', (INTERVAL '76'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '786'), (INT '0'), (INT '489'), (INT '-2147483648')], ARRAY['AVyImtAAy0']), (false, (SMALLINT '823'), (INT '1'), (BIGINT '39'), (REAL '174'), (FLOAT '475'), (406852545), DATE '2023-09-01', 'CDPxeU0ZTl', TIME '22:12:03', TIMESTAMP '2023-08-25 22:12:54', (INTERVAL '-86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '380')], ARRAY['03FqJWzRbL']), (true, (SMALLINT '57'), (INT '1'), (BIGINT '215'), (REAL '-1139563125'), (FLOAT '714'), (286), DATE '2023-09-01', 'QJjiGCd7pa', TIME '22:12:53', TIMESTAMP '2023-09-01 22:11:43', (INTERVAL '4'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '780'), (INT '-2147483648')], ARRAY['4YEA28ukTd']), (true, (SMALLINT '32767'), (INT '984'), (BIGINT '495'), (REAL '0'), (FLOAT '681'), (306), DATE '2023-08-25', '6GAqDMg8mE', TIME '22:11:28', TIMESTAMP '2023-09-01 22:12:11', (INTERVAL '28'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '759'), (INT '935'), (INT '269'), (INT '1461238107')], ARRAY['HnsHENxZHT', 'muxY57pNB7', 'nRpNF30bpq']), (true, (SMALLINT '257'), (INT '2147483647'), (BIGINT '314'), (REAL '126'), (FLOAT '169'), (-2147483648), DATE '2023-09-01', 'HiCDAUEmSm', TIME '22:11:33', TIMESTAMP '2023-08-31 22:12:54', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '760'), (INT '449'), (INT '0'), (INT '364')], ARRAY['QTEikwiJCB', 'ef7evBgH2i', 'RCh2lcwCc9', '03LLspP5NN']), (true, (SMALLINT '94'), (INT '1'), (BIGINT '96'), (REAL '561'), (FLOAT '940'), (44), DATE '2023-09-01', 'HIwcUxZ5HW', TIME '22:12:45', TIMESTAMP '2023-09-01 22:11:37', (INTERVAL '30'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '692'), (INT '416')], ARRAY['YB2T9Cs6N5']), (false, (SMALLINT '210'), (INT '412'), (BIGINT '-5583022454790831206'), (REAL '918'), (FLOAT '431'), (0), DATE '2023-09-01', 'dab7dykZA8', TIME '22:11:27', TIMESTAMP '2023-09-01 22:12:54', (INTERVAL '-4'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '169'), (INT '-2147483648'), (INT '665'), (INT '654')], ARRAY['75zIaBYOvp']), (false, (SMALLINT '767'), (INT '-566475541'), (BIGINT '496'), (REAL '908'), (FLOAT '1'), (993), DATE '2023-09-01', 'LL7BuLb1VB', TIME '22:12:13', TIMESTAMP '2023-09-01 22:12:03', (INTERVAL '31'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '555')], ARRAY['KHU2e8Emmq', '6GrbC7vuhq']), (false, (SMALLINT '865'), (INT '2147483647'), (BIGINT '872'), (REAL '-1198564944'), (FLOAT '410'), (85), DATE '2023-09-01', 'LqTaXCotEL', TIME '22:12:24', TIMESTAMP '2023-09-01 22:11:30', (INTERVAL '60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '380')], ARRAY['jTx3CQc8s7', '4WFTfEULaN']), (false, (SMALLINT '785'), (INT '449'), (BIGINT '47'), (REAL '2147483647'), (FLOAT '552'), (885), DATE '2023-09-01', 'tX8TEKU2uy', TIME '22:12:03', TIMESTAMP '2023-09-01 22:12:26', (INTERVAL '-3'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '788'), (INT '376'), (INT '378'), (INT '805929238')], ARRAY['QNQ9XenDva', 'hmpX4MCtS0', 'KhlcUbB8Xi']), (false, (SMALLINT '8259'), (INT '2082425212'), (BIGINT '1'), (REAL '960'), (FLOAT '0'), (177), DATE '2023-09-01', 'vMFRSMkeU3', TIME '22:12:28', TIMESTAMP '2023-09-01 22:12:53', (INTERVAL '-60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '448')], ARRAY['UGO7E4O0j5', 'azkpyi7KGG', 'IHjA1m9Wsp', 'MfKKF6XDYM']), (false, (SMALLINT '726'), (INT '2147483647'), (BIGINT '0'), (REAL '687'), (FLOAT '513'), (1), DATE '2023-09-01', 'Jd4Kfa47V3', TIME '22:11:47', TIMESTAMP '2023-09-01 22:12:53', (INTERVAL '-604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '206'), (INT '905')], ARRAY['5ZJZpemHnq', 'fj9keL67nh', 'ubpMrn4dh3', 'xfbdNa2yJa']), (true, (SMALLINT '32767'), (INT '-2147483648'), (BIGINT '315'), (REAL '771'), (FLOAT '2147483647'), (68), DATE '2023-09-01', 'L67i3tSjFq', TIME '22:11:54', TIMESTAMP '2023-09-01 22:11:50', (INTERVAL '-36'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '196'), (INT '312'), (INT '225')], ARRAY['jZfgHo41rC', 'Zx6yMejnSm', 'BmddsKRhSW', 'UOyKIPvrVz']), (true, (SMALLINT '-32768'), (INT '480'), (BIGINT '578'), (REAL '651'), (FLOAT '37'), (2147483647), DATE '2023-09-01', 'v4ASS6a0yb', TIME '22:11:31', TIMESTAMP '2023-09-01 22:12:32', (INTERVAL '42'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '170')], ARRAY['q8yePXYzDo']);
CREATE MATERIALIZED VIEW m0 AS SELECT t_0.ps_availqty AS col_0, t_0.ps_suppkey AS col_1, t_0.ps_supplycost AS col_2, min(t_0.ps_suppkey) FILTER(WHERE true) AS col_3 FROM partsupp AS t_0 GROUP BY t_0.ps_supplycost, t_0.ps_availqty, t_0.ps_suppkey;
CREATE MATERIALIZED VIEW m1 AS WITH with_0 AS (WITH with_1 AS (WITH with_2 AS (SELECT t_4.r_comment AS col_0, t_4.r_comment AS col_1, t_3.r_name AS col_2, (coalesce(NULL, NULL, NULL, NULL, NULL, NULL, TIME '22:12:55', NULL, NULL, NULL)) AS col_3 FROM region AS t_3 LEFT JOIN region AS t_4 ON t_3.r_regionkey = t_4.r_regionkey AND true WHERE false GROUP BY t_4.r_comment, t_3.r_name) SELECT TIMESTAMP '2023-09-01 22:11:27' AS col_0, TIME '22:11:56' AS col_1, (FLOAT '597') AS col_2 FROM with_2 WHERE ((REAL '292') = (FLOAT '750'))) SELECT TIME '22:11:48' AS col_0, (FLOAT '-1942393819') AS col_1, (BIGINT '822') AS col_2, ((REAL '-2147483648') * (REAL '151')) AS col_3 FROM with_1 WHERE false) SELECT ARRAY[true] AS col_0, TIME '22:11:35' AS col_1 FROM with_0 WHERE false;
CREATE MATERIALIZED VIEW m2 AS SELECT t_2.r_comment AS col_0, (t_2.r_regionkey % t_2.r_regionkey) AS col_1, ((INT '858')) AS col_2 FROM region AS t_2 WHERE false GROUP BY t_2.r_regionkey, t_2.r_comment HAVING true;
CREATE MATERIALIZED VIEW m3 AS SELECT TIME '22:12:56' AS col_0 FROM alltypes2 AS t_0 RIGHT JOIN (SELECT t_5.p_mfgr AS col_0, t_5.p_container AS col_1, (FLOAT '798841111') AS col_2, ('srC49t4Y6P') AS col_3 FROM (WITH with_1 AS (SELECT ARRAY[TIMESTAMP '2023-09-01 22:12:56', TIMESTAMP '2023-09-01 22:11:32', TIMESTAMP '2023-09-01 22:11:30', TIMESTAMP '2023-09-01 22:12:49'] AS col_0 FROM tumble(bid, bid.date_time, INTERVAL '13') AS tumble_2 JOIN nation AS t_3 ON tumble_2.url = t_3.n_name AND true GROUP BY tumble_2.date_time, tumble_2.channel, tumble_2.bidder, t_3.n_regionkey) SELECT (INT '1269866846') AS col_0, (2147483647) AS col_1, ARRAY[(REAL '2'), (REAL '398'), (REAL '1319936708'), (REAL '219')] AS col_2, max('B30jddfrqy') FILTER(WHERE (false)) AS col_3 FROM with_1 WHERE true) AS sq_4 RIGHT JOIN part AS t_5 ON sq_4.col_3 = t_5.p_mfgr AND true AND sq_4.col_0 = t_5.p_size AND sq_4.col_3 = t_5.p_comment AND sq_4.col_3 = t_5.p_brand AND sq_4.col_3 = t_5.p_container AND sq_4.col_1 = t_5.p_retailprice AND sq_4.col_3 = t_5.p_type AND sq_4.col_3 = t_5.p_name WHERE false GROUP BY t_5.p_brand, sq_4.col_1, t_5.p_partkey, sq_4.col_3, t_5.p_mfgr, t_5.p_container) AS sq_6 ON t_0.c9 = sq_6.col_0 AND true AND t_0.c6 = sq_6.col_2 AND t_0.c9 = sq_6.col_3 WHERE t_0.c1 GROUP BY sq_6.col_1, t_0.c14, t_0.c11, t_0.c3, t_0.c6 HAVING false ORDER BY t_0.c14 ASC NULLS LAST;
CREATE MATERIALIZED VIEW m4 AS SELECT (2116697999) AS col_0, t_1.l_receiptdate AS col_1 FROM (tumble(auction, auction.expires, INTERVAL '9') AS tumble_0 FULL JOIN lineitem AS t_1 ON tumble_0.seller = t_1.l_orderkey AND true AND tumble_0.id = t_1.l_orderkey AND tumble_0.category = t_1.l_orderkey AND tumble_0.description = t_1.l_linestatus AND tumble_0.extra = t_1.l_shipmode AND tumble_0.description = t_1.l_shipmode AND tumble_0.description = t_1.l_returnflag AND tumble_0.item_name = t_1.l_shipmode AND tumble_0.item_name = t_1.l_shipinstruct) JOIN orders AS t_2 ON t_1.l_shipmode = t_2.o_comment AND true AND t_1.l_linenumber = t_2.o_custkey AND t_1.l_suppkey = t_2.o_custkey AND tumble_0.item_name = t_2.o_orderstatus AND t_1.l_comment = t_2.o_comment AND tumble_0.extra = t_2.o_clerk AND t_1.l_extendedprice = t_2.o_totalprice AND t_1.l_returnflag = t_2.o_orderpriority AND t_1.l_shipinstruct = t_2.o_orderstatus AND t_1.l_discount = t_2.o_totalprice AND t_1.l_shipmode = t_2.o_orderpriority AND tumble_0.seller = t_2.o_orderkey AND t_1.l_linestatus = t_2.o_orderpriority AND t_1.l_shipinstruct = t_2.o_orderpriority AND tumble_0.category = t_2.o_orderkey AND t_1.l_linestatus = t_2.o_comment AND t_1.l_comment = t_2.o_clerk AND tumble_0.description = t_2.o_comment WHERE false GROUP BY t_1.l_orderkey, t_1.l_linenumber, tumble_0.item_name, t_1.l_tax, t_1.l_extendedprice, t_1.l_receiptdate, tumble_0.expires, t_2.o_clerk, t_1.l_shipmode, tumble_0.id, t_2.o_orderpriority, t_1.l_linestatus, tumble_0.extra, tumble_0.category, tumble_0.seller, t_1.l_quantity, tumble_0.initial_bid HAVING true;
CREATE MATERIALIZED VIEW m5 AS SELECT tumble_1.c2 AS col_0, t_2.city AS col_1 FROM (person AS t_0 FULL JOIN tumble(alltypes1, alltypes1.c11, INTERVAL '2') AS tumble_1 ON t_0.credit_card = tumble_1.c9 AND true) JOIN person AS t_2 ON t_0.city = t_2.extra WHERE (TIMESTAMP '2023-08-31 22:12:58') NOT IN (SELECT hop_4.date_time AS col_0 FROM (alltypes1 AS t_3 JOIN hop(bid, bid.date_time, INTERVAL '33', INTERVAL '462') AS hop_4 ON t_3.c4 = hop_4.price) FULL JOIN tumble(bid, bid.date_time, INTERVAL '5') AS tumble_5 ON t_3.c4 = tumble_5.auction AND true AND hop_4.price = tumble_5.auction AND hop_4.url = tumble_5.extra AND hop_4.auction = tumble_5.bidder AND hop_4.channel = tumble_5.channel AND hop_4.channel = tumble_5.url AND t_3.c9 = tumble_5.channel AND hop_4.extra = tumble_5.channel AND hop_4.bidder = tumble_5.auction AND hop_4.bidder = tumble_5.price AND hop_4.url = tumble_5.channel AND hop_4.extra = tumble_5.extra AND t_3.c4 = tumble_5.price AND hop_4.channel = tumble_5.extra AND t_3.c4 = tumble_5.bidder AND hop_4.date_time = tumble_5.date_time AND hop_4.extra = tumble_5.url AND t_3.c9 = tumble_5.url AND hop_4.bidder = tumble_5.bidder AND hop_4.url = tumble_5.url AND t_3.c9 = tumble_5.extra AND hop_4.price = tumble_5.bidder AND hop_4.price = tumble_5.price AND hop_4.auction = tumble_5.auction WHERE t_3.c1 GROUP BY hop_4.url, hop_4.price, tumble_5.auction, tumble_5.extra, tumble_5.price, t_3.c15, hop_4.auction, t_3.c16, t_3.c4, tumble_5.bidder, tumble_5.date_time, hop_4.extra, hop_4.date_time, t_3.c3, t_3.c9) GROUP BY t_0.date_time, tumble_1.c10, t_2.state, t_2.city, tumble_1.c2, t_0.name, t_2.credit_card, tumble_1.c14, tumble_1.c7 ORDER BY tumble_1.c2 DESC LIMIT 33;
CREATE MATERIALIZED VIEW m6 AS WITH with_0 AS (SELECT t_2.col_0 AS col_0, t_1.p_comment AS col_1, t_3.c2 AS col_2, (t_1.p_partkey >> (SMALLINT '527')) AS col_3 FROM (part AS t_1 LEFT JOIN m2 AS t_2 ON t_1.p_comment = t_2.col_0) JOIN alltypes1 AS t_3 ON t_2.col_0 = t_3.c9 AND true GROUP BY t_1.p_brand, t_1.p_size, t_3.c4, t_3.c13, t_2.col_0, t_3.c2, t_3.c5, t_1.p_partkey, t_1.p_comment HAVING (max(DISTINCT (REAL '729')) = t_3.c5)) SELECT (SMALLINT '32767') AS col_0 FROM with_0 WHERE false;
CREATE MATERIALIZED VIEW m7 AS SELECT ARRAY['aH6XriL6ih', 'YFKDIoQnks', '8DQoIcfWS8'] AS col_0, hop_1.extra AS col_1, min(DISTINCT (REAL '619')) FILTER(WHERE true) AS col_2, hop_1.extra AS col_3 FROM supplier AS t_0 LEFT JOIN hop(auction, auction.date_time, INTERVAL '11', INTERVAL '33') AS hop_1 ON t_0.s_comment = hop_1.item_name WHERE true GROUP BY hop_1.extra, t_0.s_acctbal, hop_1.date_time, t_0.s_address, hop_1.item_name, hop_1.id, t_0.s_suppkey, hop_1.initial_bid;
-- Failing query
CREATE MATERIALIZED VIEW m8 AS
SELECT
    (DATE '2023-09-01') AS col_0,
    first_value(DISTINCT t_0.c9 ORDER BY t_0.c9 ASC NULLS LAST, t_0.c9 DESC, t_0.c9 DESC) FILTER (WHERE TRUE) AS col_1
FROM
    alltypes1 AS t_0
    FULL JOIN hop (alltypes1, alltypes1.c11, INTERVAL '93', INTERVAL '279') AS hop_1 ON t_0.c4 = hop_1.c4
WHERE
    hop_1.c1
GROUP BY
    t_0.c5,
    hop_1.c8,
    hop_1.c15,
    hop_1.c16,
    hop_1.c4,
    t_0.c14,
    t_0.c3,
    t_0.c13,
    t_0.c9,
    t_0.c8,
    t_0.c16,
    t_0.c11,
    hop_1.c14;

You should see the error either in the CN logs or the meta node logs.

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

Found in ci https://buildkite.com/risingwavelabs/sqlsmith-tests/builds/1935#018a52c7-7fc9-41c7-b14a-320987144a67.

Although the error given was "timeout" the actual failure is in CN logs https://buildkite.com/organizations/risingwavelabs/pipelines/sqlsmith-tests/builds/1935/jobs/018a52c7-7fc9-41c7-b14a-320987144a67/artifacts/018a52cf-2eac-40fd-820e-6ae08b2cbb3f.
@kwannoel kwannoel added type/bug Something isn't working help wanted Issues that need help from contributors found-by-sqlsmith labels Sep 7, 2023
@github-actions github-actions bot added this to the release-1.2 milestone Sep 7, 2023
@kwannoel kwannoel mentioned this issue Sep 7, 2023
Closed
@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 7, 2023

I'm thinking that we should enable another layer of checks, state_table.get before state_table.insert, in debug mode.
Similar to how we check for inconsistent op in state_store layer.

@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 7, 2023

Otherwise we only find the inconsistent op on flush, further more we don't have the actual key and value in original encoding form.

@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 7, 2023

Or alternatively, AFTER each executor, we could have a post check executor, where we check for inconsistent op. This post check has some stream buffer, so if op within the buffer are inconsistent, it will know.

Otherwise currently it's a little hard to find the source of it.

@st1page
Copy link
Contributor

st1page commented Sep 7, 2023 •
edited

We have met this kind of error a lot in different executors.
I suggest introducing a new error type and adding it to the executor's interface, making the caller decide to panic with more content(in debug mode) or log a warning and ignore the exception(in release mode). But it needs we review every panic carefully in our codebase such as panic! and unwrap.
#11588

@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 7, 2023 •
edited

We have meet this kind of error a lot in different executors.
I suggest introducing a new error type and adding it to the executor's interface, making the caller decide to panic with more content or ignore the exception. But it needs we review every panic in our codebase such as pacnic! and unwrap.
#11588

That may not necessarily find the issue. For instance suppose some upstream executor emitted 2 duplicate rows or some inconsistent chunk downstream. Only when downstream processes it, then it will error. But the error source is actually in the upstream executor.

Edit: i guess your suggestion can still help handle the case where inconsistency is caused by the executor itself, so its complementary

@st1page
Copy link
Contributor

st1page commented Sep 7, 2023

Oh I misunderstand this issue... In fact we have three place to check the inconsistent input

  • in operator cache
  • in memtable
  • sanity check(read to check before write down the key value)

@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 8, 2023 •
edited

Add somemore findings, error is emitted here:

risingwave/src/storage/src/hummock/utils.rs

Lines 417 to 422 in 8bd524b

None => Err(Box::new(MemTableError::InconsistentOperation {
key,
prev: KeyOp::Delete(Bytes::default()),
new: KeyOp::Delete(old_value),
})
.into()),

The delete key is missing from local state store.

Maybe it got cleaned somehow? Or the delete key is wrong?

@st1page
Copy link
Contributor

st1page commented Sep 8, 2023

Would you please explain the streaming sql and find the upstream's plan? The issue must comes from the upstream.

@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 8, 2023 

                                                                                                                              QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                    
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 StreamMaterialize { columns: [col_0, col_1, alltypes1.c3(hidden), alltypes1.c5(hidden), alltypes1.c8(hidden), alltypes1.c9(hidden), alltypes1.c11(hidden), alltypes1.c13(hidden), alltypes1.c14(hidden), alltypes1.c16(hidden), alltypes1.c4(hidden), alltypes1.c8#1(hidden), alltypes1.c14#1(hidden), alltypes1.c15(hidden), alltypes1.c16#1(hidden)], stream_key: [alltypes1.c3, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1.c4, alltypes1.c8#1, alltypes1.c14#1, alltypes1.c15, alltypes1.c16#1], pk_columns: [alltypes1.c3, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1.c4, alltypes1.c8#1, alltypes1.c14#1, alltypes1.c15, alltypes1.c16#1], pk_conflict: NoCheck }
 └─StreamProject { exprs: ['2023-09-01':Date, first_value(distinct alltypes1.c9 order_by(alltypes1.c9 ASC, alltypes1.c9 DESC, alltypes1.c9 DESC)), alltypes1.c3, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1.c4, alltypes1.c8, alltypes1.c14, alltypes1.c15, alltypes1.c16] }
   └─StreamHashAgg { group_key: [alltypes1.c3, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1.c4, alltypes1.c8, alltypes1.c14, alltypes1.c15, alltypes1.c16], aggs: [first_value(distinct alltypes1.c9 order_by(alltypes1.c9 ASC, alltypes1.c9 DESC, alltypes1.c9 DESC)), count] }
     └─StreamExchange { dist: HashShard(alltypes1.c3, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1.c4, alltypes1.c8, alltypes1.c14, alltypes1.c15, alltypes1.c16) }
       └─StreamFilter { predicate: alltypes1.c1 }
         └─StreamFilter { predicate: ((IsNotNull(alltypes1._row_id) OR IsNotNull(alltypes1._row_id)) OR IsNotNull(window_start)) }
           └─StreamHashJoin { type: FullOuter, predicate: alltypes1.c4 = alltypes1.c4, output: [alltypes1.c3, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1.c1, alltypes1.c4, alltypes1.c8, alltypes1.c14, alltypes1.c15, alltypes1.c16, alltypes1._row_id, alltypes1.c4, alltypes1._row_id, window_start] }
             ├─StreamExchange { dist: HashShard(alltypes1.c4) }
             │ └─StreamTableScan { table: alltypes1, columns: [alltypes1.c3, alltypes1.c4, alltypes1.c5, alltypes1.c8, alltypes1.c9, alltypes1.c11, alltypes1.c13, alltypes1.c14, alltypes1.c16, alltypes1._row_id], pk: [alltypes1._row_id], dist: UpstreamHashShard(alltypes1._row_id) }
             └─StreamExchange { dist: HashShard(alltypes1.c4) }
               └─StreamHopWindow { time_col: alltypes1.c11, slide: 00:01:33, size: 00:04:39, output: [alltypes1.c1, alltypes1.c4, alltypes1.c8, alltypes1.c14, alltypes1.c15, alltypes1.c16, window_start, alltypes1._row_id] }
                 └─StreamFilter { predicate: IsNotNull(alltypes1.c11) }
                   └─StreamTableScan { table: alltypes1, columns: [alltypes1.c1, alltypes1.c4, alltypes1.c8, alltypes1.c11, alltypes1.c14, alltypes1.c15, alltypes1.c16, alltypes1._row_id], pk: [alltypes1._row_id], dist: UpstreamHashShard(alltypes1._row_id) }
(13 rows)

@kwannoel

This comment was marked as outdated.

Sign in to view
@kwannoel
Copy link
Contributor Author

kwannoel commented Sep 8, 2023 •
edited

Shrunk it further again:

CREATE MATERIALIZED VIEW m8 AS
SELECT
    first_value(DISTINCT t_0.c9 ORDER BY t_0.c9 ASC NULLS LAST)
FROM
    alltypes1 AS t_0
    FULL JOIN hop (alltypes1, alltypes1.c11, INTERVAL '93', INTERVAL '279') AS hop_1 ON t_0.c4 = hop_1.c4
WHERE
    hop_1.c1;

Plan:

 StreamMaterialize { columns: [first_value], stream_key: [], pk_columns: [], pk_conflict: NoCheck }
 └─StreamProject { exprs: [first_value(distinct alltypes1.c9 order_by(alltypes1.c9 ASC))] }
   └─StreamSimpleAgg { aggs: [first_value(distinct alltypes1.c9 order_by(alltypes1.c9 ASC)), count] }
     └─StreamExchange { dist: Single }
       └─StreamFilter { predicate: alltypes1.c1 }
         └─StreamFilter { predicate: ((IsNotNull(alltypes1._row_id) OR IsNotNull(alltypes1._row_id)) OR IsNotNull(window_start)) }
           └─StreamHashJoin { type: FullOuter, predicate: alltypes1.c4 = alltypes1.c4, output: [alltypes1.c9, alltypes1.c1, alltypes1._row_id, alltypes1.c4, alltypes1._row_id, window_start, alltypes1.c4] }
             ├─StreamExchange { dist: HashShard(alltypes1.c4) }
             │ └─StreamTableScan { table: alltypes1, columns: [alltypes1.c4, alltypes1.c9, alltypes1._row_id], pk: [alltypes1._row_id], dist: UpstreamHashShard(alltypes1._row_id) }
             └─StreamExchange { dist: HashShard(alltypes1.c4) }
               └─StreamHopWindow { time_col: alltypes1.c11, slide: 00:01:33, size: 00:04:39, output: [alltypes1.c1, alltypes1.c4, window_start, alltypes1._row_id] }
                 └─StreamFilter { predicate: IsNotNull(alltypes1.c11) }
                   └─StreamTableScan { table: alltypes1, columns: [alltypes1.c1, alltypes1.c4, alltypes1.c11, alltypes1._row_id], pk: [alltypes1._row_id], dist: UpstreamHashShard(alltypes1._row_id) }
(13 rows)

After I removed ASC NULL LAST issue disappears. Not sure if it is somehow the cause. If we look at the duplicate issue, it surfaces there as well: #11073

@st1page
Copy link
Contributor

st1page commented Sep 8, 2023 •
edited

#8084 Maybe related

@fuyufjh fuyufjh changed the title Sqlsmith bug: MemTable error: Inconsistent operation with empty Delete Key bug: MemTable error: Inconsistent operation with empty Delete Key Sep 13, 2023
@kwannoel kwannoel modified the milestones: release-1.3, release-1.4 Oct 10, 2023
This was referenced Oct 24, 2023
Closed
Merged
@KeXiangWang
Copy link
Contributor

After investigation, the root cause is:

When there's a distinct agg, e.g., first_value(DISTINCT t_0.c9 ORDER BY t_0.c9 ASC), the MaterializedInputState use orderby_key + pk as its table key. The correct key should be orderby_key + distinct_key.

Here's a minimal reproducible example:

CREATE TABLE t (c3 INT, c9 CHARACTER VARYING);
INSERT INTO t VALUES (1, 'interesting');
INSERT INTO t VALUES (2, 'interesting');
INSERT INTO t VALUES (3, 'interesting');

CREATE MATERIALIZED VIEW mv AS
SELECT
    first_value(DISTINCT t.c9 ORDER BY t.c9 ASC)
FROM
    t;

DELETE FROM t WHERE c3 = 1;
DELETE FROM t WHERE c3 = 2;
DELETE FROM t WHERE c3 = 3;

In this example, MaterializedInputState's key is c9(orderby_key) + raw_id(pk). But in distinct executor, the key is just c9. And when handling insert and delete rows, it use a LIFO strategy (code) . As a result, when executing the first 3 insert statements, only the row with c3 = 1 is kept and then inserted into MaterializedInputState. When executing the later 3 delete statements, only the row with c3 = 3 is kept and is deleted from MaterializedInputState. As MaterializedInputState also include pk as a part of its table key. The deleting row(c3 = 3) mismatched the previous inserting row(c3 = 1) on pk, causing an error.

The solution is just remove the pk from MaterializedInputState and add the distinct_key when the aggcall is a distinct agg. The corresponding fixing pr is #13015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@KeXiangWang KeXiangWang

Labels
found-by-sqlsmith help wanted Issues that need help from contributors type/bug Something isn't working
Projects
None yet
Milestone
release-1.4
3 participants
@KeXiangWang @st1page @kwannoel