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

Fuzz test panic: Option::unwrap() on a None value in generic/agg.rs:354:46 #13889

Open
kwannoel opened this issue Dec 9, 2023 · 9 comments
Open

Fuzz test panic: Option::unwrap() on a None value in generic/agg.rs:354:46 #13889

kwannoel opened this issue Dec 9, 2023 · 9 comments
Assignees
@st1page
Labels
found-by-sqlsmith no-issue-activity type/bug Something isn't working
Milestone
release-2.2

Comments

@kwannoel
Copy link
Contributor

kwannoel commented Dec 9, 2023 •
edited
Loading

https://buildkite.com/risingwavelabs/main-cron/builds/1295#018c4a29-c812-49a1-8a81-22487ff9cc1e

See frontend logs of the fuzz test. Still need to debug which query triggered it. See comment below for sql.

called `Option::unwrap()` on a `None` value
stack backtrace:
   0: rust_begin_unwind
             at /rustc/249624b5043013d18c00f0401ca431c1a6baa8cd/library/std/src/panicking.rs:597:5
   1: core::panicking::panic_fmt
             at /rustc/249624b5043013d18c00f0401ca431c1a6baa8cd/library/core/src/panicking.rs:72:14
   2: core::panicking::panic
             at /rustc/249624b5043013d18c00f0401ca431c1a6baa8cd/library/core/src/panicking.rs:127:5
   3: unwrap<&[usize]>
             at /rustc/249624b5043013d18c00f0401ca431c1a6baa8cd/library/core/src/option.rs:925:21
   4: infer_stream_agg_state<risingwave_frontend::optimizer::plan_node::PlanRef, &&risingwave_frontend::optimizer::plan_node::plan_base::PlanBase<risingwave_frontend::optimizer::plan_node::Stream>>
             at ./src/frontend/src/optimizer/plan_node/generic/agg.rs:354:46
   5: infer_tables<risingwave_frontend::optimizer::plan_node::PlanRef,
@github-actions github-actions bot added this to the release-1.6 milestone Dec 9, 2023
@kwannoel kwannoel changed the title Fuzz test panic Fuzz test panic: Option::unwrap() on a None value in generic/agg.rs:354:46 Dec 9, 2023
@kwannoel
Copy link
Contributor Author

kwannoel commented Dec 15, 2023 •
edited
Loading 

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[]);

CREATE MATERIALIZED VIEW m0 AS SELECT tumble_1.c2 AS col_0, (BIGINT '1') AS col_1, t_0.l_shipdate AS col_2, tumble_1.c13 AS col_3 FROM lineitem AS t_0 FULL JOIN tumble(alltypes2, alltypes2.c11, INTERVAL '18') AS tumble_1 ON t_0.l_returnflag = tumble_1.c9 WHERE (false) GROUP BY tumble_1.c13, tumble_1.c10, t_0.l_commitdate, t_0.l_quantity, tumble_1.c5, tumble_1.c7, tumble_1.c4, t_0.l_tax, tumble_1.c2, t_0.l_linenumber, t_0.l_comment, t_0.l_discount, t_0.l_shipdate, tumble_1.c16, t_0.l_shipinstruct ORDER BY tumble_1.c5 LIMIT 41;
CREATE MATERIALIZED VIEW m10 AS SELECT t_0.price AS col_0, t_1.col_0 AS col_1 FROM bid AS t_0 JOIN m0 AS t_1 ON t_0.auction = t_1.col_1 AND (TIME '16:29:29' = t_1.col_3) WHERE false GROUP BY t_0.extra, t_1.col_3, t_1.col_2, t_0.price, t_1.col_0 ORDER BY t_1.col_2 ASC NULLS LAST LIMIT 89;

INSERT INTO supplier VALUES ((INT '-10464800'), 'SNUQpk6rhz', '4HtLtyu1jh', (INT '1'), 'W0Sr1RTQ4s', (-2147483648), 't1BZY6V9qV'), ((INT '-2147483648'), 'MDcg6jvuvT', '1HbfdqhIsw', (INT '425'), 'aPsx1C3OoD', (226381080), 'OWBL1DfiIK'), ((INT '537'), 'gZPJMuhNRf', 'rsjy51GEni', (INT '184'), 'InAbg5AKin', (76), 'F8p5ouhSmo'), ((INT '983'), 'CvRzdFkNWl', 'n3FVdzxReH', (INT '946'), '3UgQs329rt', (624), '1i14YaP4nW'), ((INT '651'), 'EfVTHpIaUQ', 'ceTFDHZXIy', (INT '2147483647'), 'IW4qOujvWc', (-2147483648), 'twAymOcesC'), ((INT '485782819'), 'YwwlrFfaav', 'FUVCxEaIeh', (INT '-843961065'), '7l8TNSkkd0', (563), 'xPtZHWRx4S'), ((INT '-263045772'), '0Yf3bKQ9iQ', 'ao7WR57Rjx', (INT '408'), 'QXL3MaGv5R', (1), 'DwJdYJzYKC'), ((INT '2147483647'), '2il0pTVZm8', 'SQATFly2Kz', (INT '120'), 'yiKMpoCINv', (610), '9zT4SOk8e8'), ((INT '358'), 'vJkus8ZnWd', 'Mx2H7MVBtk', (INT '133'), 'h2z3mPMRMs', (825), 'S3ThGJHIAc'), ((INT '119'), 'QzEGXqx8rf', 'NE48sodRtM', (INT '755'), 'K3yDOtOFW6', (233), 'uzRjoEVk24'), ((INT '992'), 'TwxItoCkbN', '3P0qJizd8n', (INT '340'), 'O390NmyhY3', (182), 'DGzyPajLAq'), ((INT '-2147483648'), 'pQWd0ZiFZQ', 'hxf3o2u0Cw', (INT '923'), 'Jvxele5hG2', (139), 'VEjOvPhqcv'), ((INT '-993188552'), '4Us6XgC4g1', '4JPok1n9bW', (INT '407'), 'Q8qCFYZxFt', (687), 'OC3qWOt9d5'), ((INT '441'), 'WW6khGxbzQ', 'cWJeIUiETG', (INT '1'), 'z81xuxVdoy', (761), 'lkQwpOeW2w'), ((INT '550'), 'tXXqVCp8qC', 'E2BAIbTLLJ', (INT '342'), 'QQ4mPSsBkd', (615), 'YgmOV1hIlY'), ((INT '65'), 't19oDPrcTe', 'G9rRT4V8ev', (INT '-1733241945'), 'N3iIU2JQSW', (1167182895), 'XyXCDZiELV'), ((INT '797'), 'eLTkIX4ffi', 'vP4Rt2qnia', (INT '351'), '8Ixy3TuiON', (1882248816), '7KEFlDKpui'), ((INT '723'), 'uf0z1PS5Fy', 'ZlnC82ozmx', (INT '320'), '8phBJuMQxH', (1), 'tzV6GSipJj'), ((INT '0'), 'vjixvANBij', 'IyyGNjAKiC', (INT '1'), '3Qbw3tMYMG', (454), 'qo46Ldavq1'), ((INT '741'), 'ReoliINVCH', 'vUAflUBlsV', (INT '546'), 'vs92WXkEGP', (-712790966), 'JQH2Fx1laj'), ((INT '1946386049'), 'e2P2BRIkWf', 'cTH01aOZIs', (INT '713'), 'EWBJNZRqWl', (986), 'nyv3s8ocMV'), ((INT '1'), '5h74PhLNQn', 'uhkSylbX9u', (INT '-2147483648'), 'RWPHiMAQJ2', (629), 'NHlWmpiDKn'), ((INT '684'), 'sYrIkT3ZHu', 'VusHm0OMTo', (INT '186'), 'v4hGlyIxGW', (1), '5v9VfkiOyy'), ((INT '762'), 'y06KP01ceN', 'ZTSgj6D5zH', (INT '306'), '9l84l5ncXl', (971), 'owilGwczIt'), ((INT '80'), 'qcxZ7xnlS2', 'xPaELznWKK', (INT '497'), 'iOXqm78tnH', (483), 'qBqcg7cpK2'), ((INT '64'), 'LQKOaeTVRp', 'wBQhGQ2pWb', (INT '296'), 'L5DEnSQIVY', (551), 'nqlbvU5ztU'), ((INT '1'), 'ycREtwSb7V', 'S8l6WgsXkv', (INT '1'), 'hNY2fEfp6k', (-1987647743), 'HjOYmeLuPL'), ((INT '604'), 'IB0opdPf1d', 'f0Zz8i6Z8w', (INT '54660993'), 'IOyXFDV8Ho', (203), 'yZSNP9aou4'), ((INT '943'), 'exb77EBCS4', 'ORbH7cKHqE', (INT '1'), 'daGgY5OL0y', (0), 'UveVPRA9bG'), ((INT '306'), 'QNrFvHCNuz', '9DXjIqbdR5', (INT '160'), 'tdKeALiAY3', (2147483647), 'Y65nC0ap8G'), ((INT '63'), '2Rk1wHggSj', '8ZjukZJ8fr', (INT '874'), 'wmJ4EbyKUz', (654), 'j3ccxlenMZ'), ((INT '-2147483648'), '5rvLKXfe6K', 'rjIoZmJlV6', (INT '-125953502'), 'kFWyVnLIQa', (2147483647), 'uHiUrr5K6X'), ((INT '60'), 'pzZEXB8hw8', 'oAY0Is6lG9', (INT '547'), 'CcQq88LOv8', (96), 'X5wa9fSvvz'), ((INT '844'), 'nCM62VrcYn', 'MNkv1syZgH', (INT '222'), 'xWXOuF5W0e', (0), 'LLqUa2xiI0'), ((INT '451'), 'N918JfW0Nw', 'GbD5495KD5', (INT '-2147483648'), 'ZBC241uFCg', (124), 'QL4j9qdhOu'), ((INT '320'), 'Y9g2ouhdGZ', 'hG3KM5pXwc', (INT '238'), 'JItlTBeYSJ', (868), 'HSczfyU63S'), ((INT '820'), 'J16UNev895', 'F7ldjrYAqB', (INT '802'), 'qocasXaUJ7', (1), '6e7jZ2Vvm7'), ((INT '-2147483648'), 'nxUZ64gdF8', 'eLSYdyZbza', (INT '-1755173040'), 'sBWmKIkObN', (1), 'f8uoKqEopJ'), ((INT '861'), 'NbYG6ShtWK', 'q3LjXb9zqR', (INT '1'), 'QwgaRZt62q', (716), 'XxFozTNS95'), ((INT '714'), 'EcsWULh2lW', 'V0vhBqsZ6I', (INT '845'), 'Cm5PknaPX1', (2147483647), 'QqH9jifs4r'), ((INT '0'), 'owywzaA5G5', 'DbDoiYv2KZ', (INT '0'), 'j8XBqkTspN', (323), 'YRP7CObOoS'), ((INT '682'), 'VPhpgc7QgR', 'caPJRLoXXS', (INT '1'), 'X5QTpR3I4L', (695), 'vzYwe8MM70'), ((INT '0'), 'SCJyMCSZ5f', 'hoQNGyDrB7', (INT '1'), 'qZUaffJDNe', (479), 'ehPGFu8eN4'), ((INT '-499286825'), 'Ru1MgoZ4TN', 'sny5EqLoHJ', (INT '609'), 'U9EklcjQR7', (255), '9Qrjay1zVw'), ((INT '0'), 'G1USJiwr5R', 'UFOsUSImAh', (INT '152'), '9y1ZWA6oKg', (0), '2zZKPm6YxO'), ((INT '335'), 'nutK7xCafQ', 'hDWUSQBPaB', (INT '2147483647'), 'Ib1CvZhWu6', (174), 'iu4mVoHuZ7'), ((INT '448'), 'MjEeEul2uj', 'FZzyQ8rPnN', (INT '577'), 'bF2ebApONp', (215), 'rmw7myXqXG'), ((INT '937'), 'j1bTjGsQ5n', 'BST6C29tbX', (INT '961'), 'tOcCRvszr3', (0), 'f1xwBJ5bes'), ((INT '1079067151'), 'ROXsbqPkH9', '1arArCYVeH', (INT '775555604'), 'dWm0Fl4rJA', (606), 'yPhUbtCCjy'), ((INT '-2147483648'), 'cyFz9lHgBG', '52Xhp1Nqbf', (INT '983'), 'dfoCTG4ysN', (838), '5yuq5U61p1');
INSERT INTO part VALUES ((INT '969'), 'Ytm5JU43jA', 'waxUFnxbJC', 'MntQgQJInb', 'pwMfBHuzcl', (INT '913'), 'GJzukxKB9c', (2147483647), 'S9rzlSX5fI'), ((INT '677'), 'sdUIjR7sSn', 'TKjdbPv04y', 'lcfQ4E18pJ', 'hwHrAiNioM', (INT '749'), 'lSlhXpjdgZ', (983), 'sQIgkGUjzv'), ((INT '1'), 'LbZC39SRgD', '1cdfI8hk7I', 'FkeX1iRB3E', '2HnYvBthLt', (INT '417'), 'YGAzOvT0t5', (720), 'IxsX40rZfI'), ((INT '977'), 'YU4D7qB3IW', 'xqWdd51kpf', 'zUyJDPFbab', 'VoDq36rOWP', (INT '1'), 'Hmjrju4zpd', (195), 'jm1ZTC85qH'), ((INT '1'), 'brTwVJiJTm', 'MHr4KkwkeM', 'jaidwoMOuD', 'eIinHyEchX', (INT '121'), 'GFIxFQ6TpO', (426), 'py51CP55Qr'), ((INT '560'), 'kPzjsLww6H', 'fKgjYFKfSH', 'Rc7huEgmHe', 'kc6v0dIA4Q', (INT '30'), 'OCm52a8eQ9', (2147483647), 'MJOgL9Erxh'), ((INT '557'), 'xASSjjrrsa', 'fp4NSrC8FK', 'aq5ZjR2J94', 'HDinHoDNts', (INT '367'), 'rsoMxvvnfM', (605), 'SrgFbR2vYk'), ((INT '2147483647'), 'ljZZgSvHcs', 'QrSyUYJNH7', 'fkpyvMs0Bz', 'aDCCJNXTBm', (INT '340'), 'PZ1zTazrcO', (1014418380), 'vjNMxc59ye'), ((INT '809'), 'yfCDMe1OYu', 'Qhj7IIqqtd', 'bZ62ObNfMe', 'fWxFz6t7CO', (INT '959'), 'Jkh4eWkXZL', (107), 'x5GNSBHaBR'), ((INT '1914403993'), 'IuZoF9tkrJ', 'vkwLp3N8vn', 'Yv7M9AqmYY', 'nPwFYtE9NJ', (INT '628'), 'vwjoOrVkLr', (178), '75iBFZwr3U'), ((INT '0'), 'izqmlNLuX2', 'j9vgFfqZOM', 'LXqY5GDPxa', 'ErNrmACiDq', (INT '990'), 'Xjod8GzPxa', (1), 'QF1lxIRoly'), ((INT '-2147483648'), 'zGcK7oJh8n', 'pLULuloe4A', 'MB3wCZwHJw', 'vVaqDUw5NI', (INT '-2063482837'), 'MmfOfEXXFf', (341), 'YJqpjeR9PG'), ((INT '355'), 'AecovSq1Lx', 's8zNFKbBdR', 'S5rgOfCw7h', 'vpxfMazrEY', (INT '296'), 'EI38mUwoo3', (-2147483648), 'oYdvv4zzWG'), ((INT '462'), 'WiDDskBraT', '8xTDwVnCbI', 'yC06UWPcaE', 'isQX3ub0YA', (INT '-1582925004'), 'JjJ9jdBHl8', (184), 'cAeFp9E8KD'), ((INT '633'), '9NyIOuxxVZ', 'I1aj0QMpHW', '5AJ1WGxl5x', 'awd5AGkpo4', (INT '376'), 'DOl81GhnFs', (337), 'fthHiKryDo'), ((INT '423'), 'SGFGWmBTym', 'vuVhnLMh7W', 'fPVFUlTsyN', 'UCD3slvX82', (INT '550'), '9huWg1W484', (785), '5KKMV1rnFf'), ((INT '103'), 'Ja32n9wAYe', 'hf7cscoczT', 'yZue90FCCK', '1X9KXJELiv', (INT '518'), 'NZarEpfVIL', (-2147483648), 'pyJ2WGckaO'), ((INT '-1402053298'), '7porXn5saD', 'Cg39POLKXT', 'kHFXzvjwX5', 'EdXJUT0JFY', (INT '688'), 'brCtS7iNRa', (838), '19tf3ZAXdG'), ((INT '289'), '8iZIWU1z0D', 'IdA4VAARal', 'Mh7o1Fv0vO', 'i9rAkuPYjN', (INT '1523832540'), 'nOTcFxGqaR', (0), 'IKPAIdDNa5'), ((INT '-45843711'), 'e49rPKnVDC', 'w8HHSoRZ0V', 'hggsJtbV6c', 'XBISc5EhkE', (INT '149'), '0YipEVMHPe', (489), 'EOx5Izi3Ze'), ((INT '-2147483648'), 'qen9OVWFHU', '4eS2NpeiCn', 'rI90y4Zd6J', 'SqKhcGXcBM', (INT '979'), 'UkqO8mCc5x', (433), 'VbVbGEi32y'), ((INT '336'), 'zPqn11WkQm', 'IQhzsbX6Go', 'PTM0c4fhP5', 'LsHEev3e3u', (INT '724'), 'GQwAhVQBXo', (251), 'P4SUusgF40'), ((INT '909'), '1Wl1xkUCWy', 'fMNBpefLBN', 'u86NrHMnLA', '9SVlkYrhnF', (INT '-1333235664'), 'IekyASRiNs', (347), 'Jzt4zMwXRk'), ((INT '834'), 'QqOOTNzA1R', 'NW3yq7OegT', 'vfK0aOiYOo', 'V5qscsmHNF', (INT '311'), 'K4GF2Ybzkz', (5), '2Z8x9Icmeq'), ((INT '554'), '4wk2iB2Uyu', 'gkfbqNgGoi', 'hKNo8UrCi3', 'dCW3tQ8MXa', (INT '1'), 'VXxFeUEQu1', (1544743703), 'ctpzs1bEHx'), ((INT '2147483647'), 'LlTz07zv5y', 'AFxPdbIY56', 'nB8YTaOT8S', 'abIDAmOteo', (INT '426'), 'GIHLI1zaTX', (2147483647), 'v1rcjd49eN'), ((INT '51'), 'mLPdtKVSJF', 'wAKrmasaPg', 'lemrNH8fGd', 'PcZYmddMql', (INT '452'), 'Yy7MWuP5pp', (-2147483648), 'KCQMFbSq6h'), ((INT '831'), '90fBYl8avZ', 'ashuBjUqUU', '4zOwEHPpsO', 'i20eSoETMX', (INT '24'), 'lHCcZLB1D8', (12), '7f1P5iO1fY'), ((INT '284'), 'JvGbTOzxNB', 'ipvNIQgGzF', 'AlvTbzt01J', 'jcNaTU6t9F', (INT '918'), 'G8UrRuRxmk', (1), 'FIbzUbpJLH'), ((INT '1'), 'L6tseIVZJy', 'Jt1Nm1Rg2h', '571Mdi18o6', 'LQ27pprUj4', (INT '518'), 'IJwu9Idmff', (250), '7F3b3XeLby'), ((INT '184'), 'rAKQJ4VLSX', 'MRXh3O834Y', 'lpCXlKe68d', 'Rdm1y8ugOm', (INT '320'), 'vz0Oq37sm3', (410), 'EodnKZ77dM'), ((INT '292'), '9rPCph4RjE', 'VNX7mCJO91', 'UXVxO75ofy', 'zvqr6E7ICy', (INT '353'), 'h8VrLWihaz', (211), 'shuzZAnWRe'), ((INT '258'), 'LiYyC9n4Fr', 'IBEYcEcKgN', '1UWzhLFXrR', 'Xir7njndmw', (INT '245'), 'xeuMKhancR', (1), '3xmtjqsrr1'), ((INT '23'), 'HJx1sKgaB6', 'GqpjAQPjOX', 'PtGKhHpMzK', 'n1HGvZNesk', (INT '837406077'), 'Z2ZYbOSB2q', (47), 'LCcB9D3KtC'), ((INT '149'), 'hiXlEKlsn6', 'dgoNkDKXc5', 'DlOW1etjXm', 'PJdO35tUqQ', (INT '354'), 'zdaABYkpH6', (525), 'yIx7AQ5qzN'), ((INT '862'), 'CJMPZOqWBY', '0WejOdPDsg', 'TgTzbMEu1N', 'sPgSD1hGLK', (INT '809704644'), 'VWtgbAtxkP', (419), 'CCViuddR0e'), ((INT '1194520912'), '7rvF6fVSzl', '4VzmOUUkJN', 'jDRTfVKupr', 'isoYRL13XT', (INT '798'), 'hfBoELCsrG', (2147483647), '4PO94tDsLa'), ((INT '0'), 'WitCzCxbex', 'TRIfHTBrf6', '8rU3Gv4mTE', 'BNhmfsy3Ay', (INT '2147483647'), 'ZiiF53vbNl', (2147483647), 'V1GxLZjt7n'), ((INT '461'), 'jFoTWGn6bk', 'V7E8zYnOmH', 'exe9glK5ee', 'D0wAk7LUQR', (INT '496'), 'Uu4THszRfe', (1895553876), '2YZjhRDJND'), ((INT '841'), 'uqvAH4nk9g', 'fx42OfJDFh', 'qPDDsXkOmS', '88xys44O0N', (INT '413'), 'rPNbPPA38l', (692), '8oCNoRott2'), ((INT '-215028241'), 'eT6JCAeymk', 'okDRe6bmuv', 'nVCc3DbIsn', 'TEzOALM6uP', (INT '534'), 'shVV3D4QT2', (685), '6Cvl6Nsjzf'), ((INT '942'), '2OjNCIwKZB', 'aaBRTiPHvx', 'Hh9tesZNOt', 'iUvyc517jC', (INT '15'), 'Qvidick6Eh', (-1366766725), 'FvO955W8wN'), ((INT '2147483647'), 'HXyXFuCoYM', 'Ilk3PmHIqw', '4XF7MHyXeC', 'uNFqet1H0j', (INT '87'), 'XINrdpzBuV', (425), 'JjPmWDuoFT'), ((INT '1047269199'), 'OkNFgXPVJd', 'zwNAeFeOjj', 'iBm9twBGTv', 'vwpWTHQL6M', (INT '930'), 'LPQrcjQVhk', (993), '8rrj6k5GED'), ((INT '110'), 'Xop6yjslhm', 'KYNCqlNMug', 'wPeQuaMMwA', 'HyHvpMgax0', (INT '173'), 'BsyGU8N6IL', (668), 'ga3V37HZtP'), ((INT '985'), 'HDExYLt8JH', 'eXV8qWDfrn', 'qWGHDXzTK3', 'yQEEdQPRtX', (INT '741'), 'RekmD6X7U3', (0), '8LQuXzbeSC'), ((INT '416'), '1N5vXuQOzG', 'zjVTrnmTZY', 'aYAG9HDqw4', 'NvpUBcFvJC', (INT '209'), 'fx9BefuCNr', (591), '9sZwoxHrYa'), ((INT '781'), 'dm0jbxXRwJ', 'IaFTVFxqOv', 'awMnMOwmFn', 'MgcQIFU3Vx', (INT '451'), 'T4zO9Ngmz8', (444), 'RwZydQGORK'), ((INT '335'), 'Fj0CeZvSbm', '68SYjQLki9', 'WtHD9oUlGW', 'gNIyBvLgK3', (INT '148'), 'gLrmRjPDQW', (969), '5XhtjQodrE'), ((INT '2147483647'), 'fEfDMeA57w', '7IQt8B8h0n', 'OzL4oUMkjp', 'qhBAT1ZKCq', (INT '189'), 'L2yd6NIsbl', (368), 'RFrp6aONac');
INSERT INTO partsupp VALUES ((INT '141'), (INT '125'), (INT '306'), (0), 'LdxiWSHXSk'), ((INT '473'), (INT '6'), (INT '225'), (1), 'Ap1P2pgmTo'), ((INT '-1693589765'), (INT '310'), (INT '283'), (724), 'OEb1LOv4AP'), ((INT '880'), (INT '122'), (INT '174'), (525), 'MjT2nIHLzb'), ((INT '364'), (INT '168'), (INT '2147483647'), (42), 'BKFHcrYGp6'), ((INT '-2147483648'), (INT '943721182'), (INT '226'), (599), 'tfP39W7FWz'), ((INT '62'), (INT '769'), (INT '431'), (956), 'nhNwXHGPbY'), ((INT '836'), (INT '1'), (INT '211'), (805), 'Ev4WsiXx13'), ((INT '662'), (INT '577'), (INT '642'), (2147483647), 'JsBV59VWMl'), ((INT '844'), (INT '142'), (INT '1'), (-2147483648), 'N8qtH09Scr'), ((INT '-139387251'), (INT '481'), (INT '892'), (585), 'aTpXffrr68'), ((INT '476'), (INT '50'), (INT '149'), (656), 'SuXbT5iLcX'), ((INT '2147483647'), (INT '118'), (INT '351'), (406), 'sCXZdVSVuB'), ((INT '515'), (INT '577'), (INT '247'), (788), 'h4r4pwOjGO'), ((INT '254'), (INT '538'), (INT '30'), (0), 'nvLveiQyPQ'), ((INT '2147483647'), (INT '350'), (INT '-2147483648'), (398), 'c9B0rfnaFD'), ((INT '82'), (INT '-2147483648'), (INT '-527452755'), (-419634079), 'SCbhWK1mYQ'), ((INT '927'), (INT '724'), (INT '815'), (1877858414), 'PcT13SBZOP'), ((INT '372'), (INT '1'), (INT '819'), (-2147483648), 'OJ94xZzneQ'), ((INT '142'), (INT '817'), (INT '178'), (327), 'pCLB5abCPk'), ((INT '976'), (INT '-2147483648'), (INT '0'), (985721842), 'hZcsIUSq3d'), ((INT '246'), (INT '1'), (INT '481'), (0), 'oERpLKKOhV'), ((INT '217'), (INT '293'), (INT '358'), (762), 'uQLvqKyucM'), ((INT '-1569144360'), (INT '779'), (INT '646'), (134), '8PvjS0YDWp'), ((INT '168'), (INT '857'), (INT '183'), (386), 'XPLfYvOAQo'), ((INT '150'), (INT '561'), (INT '159'), (160), 'RvxMz9ViIX'), ((INT '412'), (INT '259'), (INT '317'), (405), 'O267n2m1be'), ((INT '131'), (INT '-2147483648'), (INT '745'), (344388387), 'wXBtt5Jwr4'), ((INT '297'), (INT '113194332'), (INT '627'), (-88208386), 'C8wqR7r5Ig'), ((INT '1444935211'), (INT '420'), (INT '2147483647'), (454), 'eUaMMDDSCK'), ((INT '515'), (INT '-2147483648'), (INT '279'), (476), 'a3BaLbns4R'), ((INT '85'), (INT '1'), (INT '374'), (802), '4JsAxlbrZv'), ((INT '563'), (INT '-2147483648'), (INT '112'), (875), 'KwwF4ZK9tw'), ((INT '561'), (INT '-876311399'), (INT '234'), (787), '2N1xwBI6kA'), ((INT '392'), (INT '631'), (INT '824'), (193160739), 'WtFsZKABbZ'), ((INT '1'), (INT '1'), (INT '68'), (510), 'LuzVrQKXVo'), ((INT '886'), (INT '757'), (INT '824'), (862), '3HhorowfBl'), ((INT '107'), (INT '691'), (INT '2147483647'), (70), 'bVGw9XBL8h'), ((INT '890'), (INT '54'), (INT '405'), (139), 'uyJPawoUYu'), ((INT '972'), (INT '1'), (INT '569'), (373), 'obtdX5aWhl'), ((INT '975'), (INT '-2147483648'), (INT '57'), (653), 'TU61iEpk67'), ((INT '-2147483648'), (INT '244'), (INT '-2147483648'), (222), 'QBoMDh8sQj'), ((INT '453'), (INT '-1228109563'), (INT '178'), (420), 'gceFpkjoLf'), ((INT '393'), (INT '546'), (INT '372'), (159), '1QhcGvC7oj'), ((INT '-62860513'), (INT '951'), (INT '625'), (353), '4FxkeZCHbU'), ((INT '1205170637'), (INT '109'), (INT '1'), (490), 'RWoEQ38093'), ((INT '1188693450'), (INT '671'), (INT '370'), (55), 'lYCTRcdLaQ'), ((INT '0'), (INT '99'), (INT '1'), (534), '2k23qSEqay'), ((INT '731'), (INT '849'), (INT '120'), (806), '0DYdZnGskj'), ((INT '-1983044798'), (INT '948'), (INT '791'), (2147483647), 'HXVilX4ztV');
INSERT INTO customer VALUES ((INT '394'), 'wjoygmVeXH', 'zFoxMmIQC5', (INT '321'), 'T7nIsYfrFl', (564), '1LpAgitxHI', '3oQywP1vpk'), ((INT '837'), 'oxxaYtohrv', 'ozrlWw11Nw', (INT '241'), 'qT4J4Xlwfe', (-2147483648), 'WDHUntc9Ku', 'QdnJiSOnqF'), ((INT '522'), 'tx5LvWDnhi', 'erTlRlqGNC', (INT '919'), 'sPlEu8Am6F', (120), '9POdkmgVyL', 'xbsTa0f1Fn'), ((INT '-2147483648'), 'ODyqp0sX6z', 'mvPscu1LCV', (INT '210'), 'jbIfdt5hZJ', (553), 'N5dNcOAZRe', 'RpbpqWyJm3'), ((INT '144'), 'nPutu9rfdk', 'eX08t3xlus', (INT '-2147483648'), 'jFgLoGQ8Bt', (2147483647), 'mfsxskBz9u', 'BR2B8SD0Ug'), ((INT '880'), 'EFVt6PpraA', '4xQfZfLJ3B', (INT '9'), 'MVf9YFInfQ', (226), 'VvWtxjVeIs', 'qm1jc1HEci'), ((INT '2147483647'), 'B4UXxMhoLq', 'k4bi5Xxxuq', (INT '510'), 'dOQ1mq8R1h', (2147483647), 'M8swLqtDop', 'OXfIPISPIr'), ((INT '488'), 'cIIonwqLhW', 'Dl5lEI4Osg', (INT '769'), 'DouwYfi2VR', (329), '5xsE9J1uKx', 'ZsacXmGyVJ'), ((INT '309'), 'DrUtBKKfZu', 'NQXlWoMuhq', (INT '-2031063276'), 'Vz7iTrTjT2', (2147483647), 'ZFCWSMA1PH', 'bUfclFPKGF'), ((INT '-843418314'), 'ZwdZJ6xEgw', '1MF5JzgVvE', (INT '-2147483648'), 'la7C0fwHna', (896), 'RKUlDClngA', 'BCUf5NfAvq'), ((INT '385'), 'vdLAgq8g7B', 'MpLztOBMMP', (INT '512'), 'HQqhFy0Qtc', (717), '540MNO3CNo', 'TdZnyvtMqS'), ((INT '470'), 'YrG94pipi2', 'xheKLvJnU9', (INT '840'), 'BrEJOGxvx2', (1), 'LQr9ymi7EW', 'q9rn7RPJg0'), ((INT '10'), 'uteeKVi0gO', 'Y9AqmIVnhn', (INT '167'), 'HpMnIuVlL7', (687), 'eWBR1tzGGE', 'lHWikZefCu'), ((INT '816'), 'E7IUuTJSPk', 'fXEFYBmC7w', (INT '621'), 'f9dz04VewH', (345377277), '43ymXsKGG2', 'rcWhc4ifV4'), ((INT '210'), 'fcsYSMzg3V', 'az3iXVHEs9', (INT '637'), 'NoLrLI8bBS', (972), 'kLXKmyGs65', '808MAMYbeO'), ((INT '810'), 't6Pqlq1rNu', 'dtdVvRrNv8', (INT '510'), 'bKIZMBwRy6', (1), 'EdRLkcmki7', 'C5WSYu6Sxh'), ((INT '118'), 'hlUfn21yhr', 'TABi9jtjGg', (INT '31'), 'Y6FTt75lbS', (-436563279), '560HSWzeWJ', 'LudEtjb8Aa'), ((INT '795'), 'p9dLPECO1p', 'NJ9l6rKhMp', (INT '-2147483648'), 'KMwqV3D58K', (134), 'LDD8dxNDGh', '2xSGXHLctk'), ((INT '-2147483648'), 'KPzbQEUkFI', 'o40vUAGG5U', (INT '0'), 'nnWU04wJkp', (761), 'iZ3zrZkKrT', 'uERtI686uN'), ((INT '487'), 'IKlgev0S5C', 'iSBB4V1yuw', (INT '2147483647'), '9XS7mNGqQ0', (534), 'CcOAuSucSz', 'XQIaBdoTnW'), ((INT '600'), '8WwSUYsDVa', '8xhO35ab8q', (INT '402'), 'AUwsbwr0iZ', (444), 'SRzw9MiHXy', 'uM8BmNUfoz'), ((INT '2147483647'), 'gZpmz262IW', 'yom1ekgqon', (INT '924'), 'l8OIqOn4t8', (254), 'bjzuuhojW0', '1B6Wh82NCW'), ((INT '655'), 'lljjrXZ0yh', 'Ze80PWXzYJ', (INT '816'), 'eh7t8VxGj5', (85), 'oFb8c1Yw5z', 'JL5BqnWkZN'), ((INT '-2147483648'), 'qebArYmEwu', 'vvUI0KWnDp', (INT '1721147683'), 'ZltMWK76ik', (117), 'TNsbDnMbLz', 'vtklF2Fq2Z'), ((INT '828'), 'G0yJ84yAeh', 'vcJil7Bfxh', (INT '443'), 'HljBApUNqq', (489), 'UvG2yro9A3', 'fJbwsDsNHR'), ((INT '-2147483648'), '1yRymZtLrW', 'IcCaQkjYkD', (INT '2147483647'), 'EgMgod62i0', (24), 'WeSkKf0Y0u', 'iTsKMxtxPy'), ((INT '704'), '3Yi9KqGrlF', 'zYxHw3AU0Y', (INT '-1855083481'), 'Zr3GTnBEsx', (979), 'iOumCwPZWE', 'g076wQd7dY'), ((INT '319'), 'Si73FNfRPH', '8pBsf1HB6j', (INT '242'), 'YzgEHZ8OkB', (1009259329), 'lf0ePgL2rg', 'qmWyaZKLgk'), ((INT '2147483647'), '06e98KHYRH', 'NcwwC72I7x', (INT '1'), '2yYAwAAi1B', (203), '5rgPdYCdYk', 'pxiPriXNnF'), ((INT '0'), 'sbvcrxleHN', 'vU4VhYNQ0Q', (INT '794'), '9FwMQIpizW', (1759958778), 'SiPEY9vmI4', 'fcYsk4R0op'), ((INT '-2147483648'), 'uNLpMVPKiA', 'lTo9NJzdkc', (INT '84'), 'yqO1JdsSXf', (1755451660), 'CNxTVJYWsT', 'EJa3udL2fl'), ((INT '695'), 'XaRX8mmi8l', 'e9ErHpzz3j', (INT '133'), 'XFYzyvhZNk', (492), 'ewQ9wkRs3s', '0qzwJcq4Gb'), ((INT '575'), 'GCuaUN2Iys', 'q3Y0Fo4kXB', (INT '1339164097'), 'zoWbVo7Qiq', (-1607527431), 'Jqbk3sCM58', 'd4yMTNgQLJ'), ((INT '-2147483648'), 'a9EPlsZRYF', '2zQszpUc7j', (INT '624'), 'aEVXFlIo1q', (860), '4SQIgbW0cC', 'bY34y9MZif'), ((INT '-2147483648'), 'qsa0zzY9Xd', '9Lubmbl5xo', (INT '-1191906162'), 'sz0LhcP7Ay', (2147483647), 'Hb0DIAbPwH', 'paRyPCHmcA'), ((INT '245'), 'KGSoOu76LH', '8w1n5YU9l8', (INT '1'), '2gcNAqVxQJ', (-1632556829), 'V3e9VUeLXI', 'JMZFebWWts'), ((INT '767'), 'fBvhuSqcHh', '8bneVr2JDz', (INT '218'), 'ju0mcR3Trf', (883), 'Yq3SZY3V1j', '5CMkVQZyEc'), ((INT '439'), 'hH3Zd8Rb5Z', 'fflU2kBiU9', (INT '862'), 'SMhetj84os', (60), '6bTHtkCkwK', 'sNC2oaeFGW'), ((INT '-2147483648'), 'aYGbBw5bl6', '6ffBpOp5EA', (INT '342'), '1PJoQuM7MC', (28), 'PHVM8ayjTk', 'x6OeTcDFft'), ((INT '140'), 'IB8Tb6oZ5y', 'RZLQYqQwPQ', (INT '782'), 'IXVl72b1bH', (145), 'HzWXgZGe8z', 'bhWmFR8Wbr'), ((INT '56'), 'n0E1ajmLGf', 'BwmeW2N3WD', (INT '1119641744'), 'BYu2bJOlIc', (796), 'hst5O0bhQb', '1PrAeTNTQg'), ((INT '912'), '1aC28Gnpwk', 'JZffTaOnup', (INT '-1776187356'), 'B8SeWvLth7', (831), '6GgBH4sgW5', 'pp1Ct6LyQu'), ((INT '-1216376925'), 'IGrROuFIDv', 'prPTjVC4rt', (INT '958'), 'T0OpbEvfcb', (105), '2gyLx5D69b', 'rTP399oqBd'), ((INT '1'), 'FZkyjK88XN', 'PfEhRjoI47', (INT '2147483647'), 'svdh64XsrB', (770), 'Wtxkrpd3mb', 'k7N4fnzhUy'), ((INT '797'), 'zvPZdKBcfG', 'UMZ7abcqbN', (INT '0'), 'AdDyfVSf1v', (442), 'CT9RT616ka', 'rnAF4RvjGc'), ((INT '651'), 'AMNxZ4TmPJ', 'Lp4TInkITm', (INT '430'), 'GB1SU2c4tu', (262), 'wGUxETSDBz', '6B1TcVPpME'), ((INT '66'), 'u6eMekEVgh', 'VHG2JPk3d0', (INT '243'), 'kobPIukQur', (230), '72IhT9GxHu', '7cWis62HAn'), ((INT '574'), 'BDmEU63AqA', 'IZgkXWqsss', (INT '234'), 'qtM6UFzGD0', (-903777284), 'UCEMQd38ng', 'id3zChsMcO'), ((INT '680'), '69JQBzs6oY', 'QQz9jEzGoJ', (INT '269'), 'hhrB0bHbci', (482), 'NqZRAi4G9s', 'rNThxUHoH5'), ((INT '249'), 'JwjHMih4aT', 'bjwyOYYGLQ', (INT '410'), 'xBQrNE2fXQ', (489), 'VaUZ1ZSqzH', 'i8mEl5KZ11');
INSERT INTO orders VALUES ((BIGINT '258'), (INT '461'), '7R06PT6FPT', (881), DATE '2023-12-08', 'IgLzGp2Uco', 'vGgitufW8K', (INT '2147483647'), 'k6YDgMSwHh'), ((BIGINT '102'), (INT '481'), 'BSxDfycXAv', (336), DATE '2023-12-08', '5a2y20cJHt', 'GlbLX58ylo', (INT '652'), 'W4hsz2W2Jy'), ((BIGINT '950'), (INT '405'), 'ji7RLgd7ez', (213), DATE '2023-12-08', 'Fu2Pm3OwHw', 'D0IOnAW5wO', (INT '640'), 'yIcq1frvk8'), ((BIGINT '398'), (INT '60'), 'rXEbi9ukZH', (140), DATE '2023-12-08', '7UyGrg7rw2', 'm70XTMHY6q', (INT '456'), 'V9eWQeSQHY'), ((BIGINT '898'), (INT '78'), 'EjXiS54cNx', (1233967264), DATE '2023-12-01', '8r5HBpj09k', 'XIMPziO0up', (INT '552'), 'C23Ug2HG2B'), ((BIGINT '875'), (INT '69'), 'I2adjukLWc', (990), DATE '2023-12-08', 'Et56U0ZvjY', 'RvrVcFEQNI', (INT '600'), 'AI76mvOAhB'), ((BIGINT '132'), (INT '1'), 'SkjhiQi2PV', (-2147483648), DATE '2023-12-08', 'NUz3P36Zbb', 'DhjUCiu3Gz', (INT '257'), 'krnBWZrZpF'), ((BIGINT '845'), (INT '183'), '3bRUnIjwdr', (74), DATE '2023-12-08', 'IlqwyjjifV', 'oc3R1gkv4E', (INT '464'), 'mtP0IGeY4f'), ((BIGINT '414'), (INT '402'), 'aqvSVfpsML', (758), DATE '2023-12-08', 'BwScfd338t', 'nEjIocw6Fa', (INT '816'), '9ADnsaLNv4'), ((BIGINT '-9223372036854775808'), (INT '24'), 'uuUwVn0LJ1', (0), DATE '2023-12-08', 'mFBKq1W2pM', 'RKyCunvgwO', (INT '-2147483648'), 'TWIfqOE7dj'), ((BIGINT '441'), (INT '483'), '8F7e2fK2V1', (1), DATE '2023-12-08', 'nb4yB6efis', 'bOtqk7DMFv', (INT '534'), 'GkDQ7uwV6G'), ((BIGINT '28'), (INT '624'), 'ERYWxQDxiW', (983), DATE '2023-12-08', 'TV87hOrQUQ', 'a8g1FKF310', (INT '1467564419'), 'JPqGou78oO'), ((BIGINT '-713506688063259140'), (INT '580'), 'UsqESlFS6k', (0), DATE '2023-12-08', '0LwsIlv3Yk', '6Wcodvbj63', (INT '2147483647'), 'FpKcQAYqA3'), ((BIGINT '725'), (INT '-819790553'), 'mtDf0ZiXJa', (1082801358), DATE '2023-12-08', 'eyMdReT5R3', '0GoA4BgkRk', (INT '217'), 'vVM18ZwwFm'), ((BIGINT '-9223372036854775808'), (INT '753'), '4z9B1pWTIN', (719), DATE '2023-12-07', 'qxR4occsdH', '4plyNpIibh', (INT '623'), 'khfeFSNZpJ'), ((BIGINT '243'), (INT '2147483647'), 'zLuRwJ0gvm', (-298498242), DATE '2023-12-08', 'GA1Cy0xbz0', 'd3wTu5hod9', (INT '259'), 'obiJcgpAgy'), ((BIGINT '36'), (INT '804'), 'uQn1OtunJr', (865), DATE '2023-12-08', 'v1nyQsMZrR', 'h2IwBYekyo', (INT '304'), 'XqAWBXWOEj'), ((BIGINT '4560453334409314415'), (INT '103'), 'L2WHCqZWct', (252), DATE '2023-12-07', 'KsS6ViWg4Z', 'Po80k0yRH3', (INT '630'), 'gzwxSVIWur'), ((BIGINT '1'), (INT '-2147483648'), 'spsCvAd0kx', (-2147483648), DATE '2023-12-08', 'TaYqzJoIdy', 'J6u4He4uwa', (INT '359'), 'wmgqCi6O9R'), ((BIGINT '294'), (INT '390454631'), '1ZFvrI3CkX', (67568696), DATE '2023-12-08', 'l7K4r20u6H', 'mDsh2as1Wi', (INT '-2147483648'), 'yFSByTlOIj'), ((BIGINT '1'), (INT '747'), 'qQ37seHDKd', (839), DATE '2023-12-01', 'UrSRWNugWm', '81RJuZlr8x', (INT '230'), 'LSKN42bV4f'), ((BIGINT '27'), (INT '997'), 'cNk4UKrvQR', (496), DATE '2023-12-08', 'ud5ATQTqes', 'dNjt2bNPAX', (INT '647'), 'fSCrHNc7W6'), ((BIGINT '833'), (INT '0'), 'TlAVFPbE3S', (139), DATE '2023-12-08', 'YMFwrjwO8X', 'SdrXU1wGJy', (INT '0'), 'pTvakt5KEK'), ((BIGINT '0'), (INT '284'), 'fsbjlnGyRN', (104), DATE '2023-12-08', 'bpDeGiCSmr', 'G6NGumYUy8', (INT '946'), 'S5FUioG82s'), ((BIGINT '-5271247499871374050'), (INT '919'), 'yQbVgpd4HV', (188), DATE '2023-12-08', 'CuzipSIsV3', 'VZHaCfvKFl', (INT '496493856'), '65KzJ5gkU9'), ((BIGINT '291'), (INT '-1509200195'), 'rfx67xBVYf', (786), DATE '2023-12-08', 'liNDKGNMVv', 'gz8kn4qIpk', (INT '462'), 'x0XEs7bNSO'), ((BIGINT '958'), (INT '513'), 'gPTHbNXnbe', (2147483647), DATE '2023-12-08', 'Qj5KnZIZ9T', 'OGZIkqlixQ', (INT '84'), 'OVw9Ak28fe'), ((BIGINT '294'), (INT '982'), 'IUA6IYfZTu', (1451234890), DATE '2023-12-07', 'lC84NW4sss', 'pWRw0ezXgr', (INT '-2147483648'), 'zVY60yHB5g'), ((BIGINT '973'), (INT '608'), 'KM220WPMW7', (0), DATE '2023-12-07', '4YIQZrU5qE', 'DftRqVb0G7', (INT '587'), 'zk3kkpsoVw'), ((BIGINT '345'), (INT '431'), 'mi8LWeoCyU', (609614673), DATE '2023-12-08', 'ND5WdwmHph', 'suHNc1U0cq', (INT '515'), 'EcW5sFFpI9'), ((BIGINT '241'), (INT '678'), 'bGH1BDYVdP', (64), DATE '2023-12-08', 'OBCtt4tlGI', 'PWxfYBdXru', (INT '608'), 'c0Xlcil6s7'), ((BIGINT '934'), (INT '625'), 'AQKaQ5d9IR', (923), DATE '2023-12-08', 'xjFXAeMPwh', 'FLPelT7J6Y', (INT '444'), '6eDJV5b9Cs'), ((BIGINT '6379279545499060538'), (INT '0'), '5dXFniO0Xk', (2147483647), DATE '2023-12-08', 'Cl272uvlSa', 'GyCpzvm7ye', (INT '671'), 'rLyjPOsM33'), ((BIGINT '356'), (INT '0'), 'Csr3OCKOV5', (562), DATE '2023-12-01', 'f3BAZm9Qku', 'aN4Q6ToDoU', (INT '303'), '5Q324tsC98'), ((BIGINT '0'), (INT '0'), 'ecmiIbBIFM', (927), DATE '2023-12-08', '4GH0QgEUrY', 'OLhyJbEMp4', (INT '-2147483648'), 'JIL36X3hHN'), ((BIGINT '468'), (INT '0'), 'm6KEFyKEd8', (1), DATE '2023-12-08', 'd6zVQG2WGK', '69woiqcn9o', (INT '830'), 'Di8dj68NNZ'), ((BIGINT '657'), (INT '6'), 'ktUs20SIz9', (-1371292077), DATE '2023-12-08', 'lT1sjZpr45', 'vXdUYI8v7X', (INT '548'), '6Ew3HBt5g2'), ((BIGINT '139'), (INT '244'), 'SLV1nQTafa', (527), DATE '2023-12-08', 'TyAmSxPUHt', 'MYtuDSJyZL', (INT '2147483647'), 'zTxWym53HO'), ((BIGINT '705'), (INT '180'), '1B4PW6awx4', (380), DATE '2023-12-08', 'mX0b2acYFB', 'p3WL7ywjxq', (INT '1'), 'hUUc76EMi0'), ((BIGINT '665'), (INT '1'), 'HXNEHd4W0G', (343), DATE '2023-12-08', 'GjXBSzhM4Z', '1arSiqboYC', (INT '342'), 'Yy6hZg3it9'), ((BIGINT '72'), (INT '135'), 'PydwGMcVRY', (938), DATE '2023-12-08', 'jtw6V8Zjgu', 'MlxmCkUTcX', (INT '244'), 'frf3W1oxuk'), ((BIGINT '371'), (INT '142'), 'UYn155X46d', (2147483647), DATE '2023-12-08', 'YvkCoZ1hIO', '7nIYGuW1vZ', (INT '278'), 'LfOuNF7yFa'), ((BIGINT '0'), (INT '899'), '1vJacnnfIz', (931), DATE '2023-12-07', 'vvA1LZdiRr', 'lHpbpNLvto', (INT '173'), 'bLeekyHQOj'), ((BIGINT '775'), (INT '795'), 'FrDmFt352A', (2147483647), DATE '2023-12-08', 'RwiUBnUTaw', '5deIRZ8p4O', (INT '264'), 'tLnq92UNpG'), ((BIGINT '866'), (INT '896'), '9su3s28X4k', (63), DATE '2023-12-08', 'MdkeX5q52c', 'cKhSy2CpU0', (INT '62'), 'farIRnGCLZ'), ((BIGINT '853'), (INT '376'), 'xfu64rkN71', (170), DATE '2023-12-08', 'dkttl4NkN9', 'ni6axd9BCj', (INT '632'), '7MIgvYiFC0'), ((BIGINT '136'), (INT '573'), '4haSPT8fd0', (1548677744), DATE '2023-12-01', 'Cyb0etzb6f', 'JUZD4nJyBH', (INT '657'), 'QF1zOrda2O'), ((BIGINT '938'), (INT '1'), 'Y6WP7af4yb', (628), DATE '2023-12-08', 'WieZhmGe5Y', 'eP3PO5v49i', (INT '278'), '62EsCyog5e'), ((BIGINT '768'), (INT '1'), 'ZbufuIuj8C', (-866504609), DATE '2023-12-08', 'nzNl0gpRas', 'nF2S6jdp3x', (INT '592'), 'elbKgWuVgR'), ((BIGINT '-9223372036854775808'), (INT '739'), 'lMxHDaxNOe', (1), DATE '2023-12-08', 'DxtDmZHkXL', 'PZWgK7lYDZ', (INT '-2147483648'), 'KCQl3TwJQQ');
INSERT INTO lineitem VALUES ((BIGINT '0'), (INT '1959752693'), (INT '180'), (INT '212'), (248), (121), (723), (390), 'DyMwcKob0z', 'N75RskHaZv', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'DQIylGaixE', '52e09cxASW', 'DfBJvYdjYv'), ((BIGINT '634'), (INT '568'), (INT '-1302427925'), (INT '1'), (949), (454504604), (281785164), (425), 'sias9u0Kh3', '6eIUQKLGo4', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'JXPjjAw4PI', 'lZQsu6f3Sl', '4yWLf8uKxV'), ((BIGINT '2717952894854940006'), (INT '393392338'), (INT '-1551711452'), (INT '-355033757'), (1), (2147483647), (966), (152), 'rBLyr46c6E', 'vg4AZNeByZ', DATE '2023-12-07', DATE '2023-12-08', DATE '2023-12-08', 'BzB0hpIE0U', 'xDl8IyHL4D', 'Gofio5Wals'), ((BIGINT '826'), (INT '934'), (INT '693'), (INT '114'), (773), (611), (498), (682), 'cSADteQ11h', 'MVVNniTSaa', DATE '2023-12-08', DATE '2023-12-01', DATE '2023-12-08', 'T9SCkJSdYG', 'fyIFDWx3l5', 'Cl7xBj7Jjb'), ((BIGINT '993'), (INT '-2147483648'), (INT '944868629'), (INT '456'), (632), (-873661110), (1733446305), (374), 'kXSyeOQ2oR', 'yRy4j2yRkl', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'NenJNQFjKX', 'Cflot5ehiu', 'LY8Db319N8'), ((BIGINT '535'), (INT '443665198'), (INT '-2147483648'), (INT '3'), (1), (920), (2147483647), (1), 'yj8QwxeYPN', 'dncDlV0HLm', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'k8Z1XEewdp', 'Cf7NC6h2ef', 'KIXdk6rp1t'), ((BIGINT '369'), (INT '156'), (INT '520'), (INT '392'), (617), (-1351389037), (224809687), (190), 'A8mzYN6mEg', '5ahHM96MJR', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'oG0rdB1FUY', 'KRWGCZVVaq', 'xXSUGUHnSO'), ((BIGINT '-6625534887823968815'), (INT '501'), (INT '2147483647'), (INT '632'), (856), (220), (800), (-2034453192), 'XU09qYo6ot', '7MfD3SbIXK', DATE '2023-12-08', DATE '2023-12-01', DATE '2023-12-08', 'ernHvHESap', 'dMqh9kRA8g', 'MAdoSTKdqn'), ((BIGINT '477'), (INT '254'), (INT '-1180426756'), (INT '552'), (544), (430), (674), (1), 'tYpkxpPCvU', 'D6pIrQ02I0', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'PzjVdzJUU0', 'vFKwZ3c1W2', '28se2aXlqo'), ((BIGINT '234'), (INT '147'), (INT '381'), (INT '-1234669504'), (185), (19), (368), (-1377678379), '6uVqZIr80i', 'cxiYcx8RyW', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', '6GwW0uA5db', 'RaPo7yExB8', '52oB9TgxAW'), ((BIGINT '2264986501900275054'), (INT '170'), (INT '944'), (INT '929'), (503), (110), (628), (491), 'mSGAnUTIL7', '8hH0Lt8gmg', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'thzgrj281f', 'EWpghQwubn', 'jExQTORBGF'), ((BIGINT '19'), (INT '785'), (INT '0'), (INT '14'), (667), (346), (899), (1), '8Y1izb5rmm', 'AYLajbgvrN', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'Q9lTogcjUi', 'zrMkWJREeo', 'ZLZVyXxqre'), ((BIGINT '293'), (INT '370'), (INT '737'), (INT '235'), (-2147483648), (-454723495), (919), (971), 'DNq1FZyf1x', 'KuCWhjNcfd', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'grw1ekLNXO', 'RPgwsLJhkP', 'g73ohPqo29'), ((BIGINT '-203001525774322747'), (INT '974'), (INT '689'), (INT '-1938330078'), (276), (576), (721), (610), 'm3nk7Wf4wb', 'u84bosYqTC', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'RybhrX9GWE', 'HoKhfkfGOi', '4If01F0Ktx'), ((BIGINT '181'), (INT '141'), (INT '151'), (INT '351'), (178), (789), (424493357), (0), 'cP37TAmnER', 'Wrr8BXCEUe', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'Gmtx5sdrd9', 'VvruzVQEHn', 'qwIIhN3tNG'), ((BIGINT '448'), (INT '966'), (INT '224'), (INT '192'), (1681930642), (1), (149), (1), 'iAwIKDD1Pk', 'uYzb1huGmd', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'NrCM5lH3Up', 'RZZZNR2DdM', 'oRYqBCzF8E'), ((BIGINT '801'), (INT '-2147483648'), (INT '848'), (INT '481'), (743), (142), (925), (157), 'p6v8LS8Qah', 'qXyhVm5fFw', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', '92OEza16hq', 'LvHSsWgECv', 'N5xZD71qfs'), ((BIGINT '199'), (INT '821'), (INT '0'), (INT '472'), (781), (270), (715), (217), '8VJlUxcan3', '8u1eiBdF1M', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'bbNtWzLy9Z', 'XfJDzfRnyd', 'RQyb9TPV8f'), ((BIGINT '0'), (INT '734'), (INT '-1590571798'), (INT '720'), (846), (415), (0), (1), 'MMhWa1Q1pq', 'mOYZqY33UQ', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'ODSDmhqT6W', 'Lpqtg2ustT', 'RltPukIvTr'), ((BIGINT '573'), (INT '276'), (INT '274'), (INT '642'), (-409832511), (177), (317), (2147483647), '8DV1MS0Cve', 'JmYsVSJvUq', DATE '2023-12-08', DATE '2023-12-07', DATE '2023-12-08', 'urM7pEcdGI', '3eA1TcWK49', 'oGodRhePHZ'), ((BIGINT '741'), (INT '906'), (INT '984'), (INT '425'), (25), (274), (606), (105), 'iuz3n8jSHL', 'ZhDOeGTzuc', DATE '2023-12-08', DATE '2023-12-01', DATE '2023-12-08', 'bh3ft0PSBF', 'eTa3m706Uj', 'g0ofInIEep'), ((BIGINT '0'), (INT '409'), (INT '34'), (INT '928'), (144), (299), (601), (44), 'o5OtsnoIhd', 'PQbAgowKMR', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'conu1DV7mf', 'EkMetqlTKx', '9SNrZ3vGdF'), ((BIGINT '9223372036854775807'), (INT '795'), (INT '872'), (INT '0'), (582), (1), (147), (204), 'QQ1IZ8oSvb', 'HpquitGiLO', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'xtMFxyIM77', 'U8QbtvI9K9', 'oQTZcJzvcg'), ((BIGINT '355'), (INT '0'), (INT '895'), (INT '2147483647'), (952), (578), (329), (697), 'PavgbrVflC', 'es4odMCmVD', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'jSD6elZ5bB', 'XyuBpgtG6z', 'aLePO4Gkyx'), ((BIGINT '452'), (INT '648334276'), (INT '671'), (INT '1590836992'), (547), (126), (643), (81), '53BX8qzZdN', 'zVT2vVx5pK', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'T93Q54Cobz', 'cbmIHbVmDW', 'TWr72jK4hO'), ((BIGINT '279'), (INT '0'), (INT '917'), (INT '133210331'), (995), (957), (2147483647), (1), 'Mx143e3ixc', '8JTvrkUer1', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'UTCFHwwSdY', '8rSW7udbDK', 'YVEJ5yMVv4'), ((BIGINT '416'), (INT '457'), (INT '826'), (INT '276'), (596), (-2147483648), (298), (65), 'vjY0wxE2So', 't95Ysbt6a7', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-01', 'SCvEB8lOSR', 'B8k87nCk7b', 'CWAUr1tr7N'), ((BIGINT '4917743123397211725'), (INT '385'), (INT '2147483647'), (INT '579'), (-567367839), (0), (639), (774), 'xkpxl4gMw8', 'N6CrgJd17a', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'obEEsgkhWT', 'gzoyqjvHhp', 'MG2B9MPUlc'), ((BIGINT '364'), (INT '6'), (INT '457'), (INT '2147483647'), (2147483647), (726), (329), (0), 'BdjvJjUEW0', 'tuigryG6DC', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'OJitdBCpUl', 'uZ2AtRkjNw', 'alKIC5kza5'), ((BIGINT '502'), (INT '185'), (INT '-1518951521'), (INT '-2030103115'), (203), (490), (599), (976), 'k1QTCe5ScC', 'wK4s7ujqiq', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'JKkIvUFgnl', '9bHfN5q1Oq', '9EIgz5ZTCZ'), ((BIGINT '129'), (INT '0'), (INT '1481774426'), (INT '555'), (-1752385881), (1106805644), (495), (95), 'Wbu4MsaaG8', 'aE2I1fTKUh', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'nbAgUCnepF', 'qBdPVsipKK', '4tiI6hUwT8'), ((BIGINT '202'), (INT '136'), (INT '43'), (INT '330'), (621), (0), (236), (485), 'LJqkfwhGOE', 'ltKCkFhuoJ', DATE '2023-12-07', DATE '2023-12-08', DATE '2023-12-08', 'bUz8E7q54W', 'uf8HxQGisM', 'UUX0SST5ti'), ((BIGINT '7082962711510076770'), (INT '406'), (INT '584'), (INT '258'), (112), (525), (341), (915), 'ZlWY6m9Map', 'T6MbLmAB0S', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-07', 'HiyqO2Zw7S', 'HtoBcnG6t1', '5SPds7wDEC'), ((BIGINT '89'), (INT '673'), (INT '487796902'), (INT '720'), (710), (576), (57), (766), '4QWTZ50coc', 'BQM7ktUKEY', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'zZlHBUvxz0', 'hhqqTEKZIs', 'ZV7oQjgdpp'), ((BIGINT '0'), (INT '564'), (INT '907'), (INT '58'), (517), (704), (0), (172), 'DWkcOs015K', 'YPEmX4F6iC', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'ahAzo4xAsi', 'ulQ81VJkXf', 't5dCpC8DxZ'), ((BIGINT '-9223372036854775808'), (INT '478'), (INT '-626443618'), (INT '936'), (166478685), (234), (1190199903), (695), 'v6ZkQ9VNT8', 'vnTxzu8dSf', DATE '2023-12-07', DATE '2023-12-01', DATE '2023-12-08', 'Ea97oHL52E', 'EPhZN4pmWg', 'fONc4humDD'), ((BIGINT '319'), (INT '655'), (INT '493'), (INT '0'), (-2147483648), (-2147483648), (687), (2147483647), 'u5xlcTt28m', 'DwjBXpnXyi', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', '612u2SKgvp', 'tGDMqIEU4z', 'KKyx7dGpIm'), ((BIGINT '705'), (INT '812'), (INT '-746450315'), (INT '-252988864'), (67), (2147483647), (1), (459), 'Wrvd6i2JL4', 'A8BU6WA5Wk', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'pwTBNhNhlU', 'v1DuEZnJ97', 'da5QiSU8xJ'), ((BIGINT '97'), (INT '530'), (INT '28'), (INT '197'), (977), (252), (1), (649), 'Kzlc1C4mxQ', 'asOQb22Vcg', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'bRvslUH6ha', 'lfxVnCKbZw', 'wJvktkJZq9'), ((BIGINT '29'), (INT '-363349894'), (INT '1'), (INT '1'), (43), (47), (869), (202), '98ElZBMgBH', 'SK85Pg4RyX', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-07', '8MmXcInpN8', 'vP4gDOnsUR', 'M308yyIpbB'), ((BIGINT '-8262204832826622483'), (INT '865'), (INT '-2147483648'), (INT '1'), (492), (105), (204), (-2147483648), 'qqm7Y9oxCb', 'x4UM10uWrt', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', '4tR0VmtGf4', 'AC9vQ57ex8', 'jq88vo3MOT'), ((BIGINT '749'), (INT '158'), (INT '730'), (INT '687'), (-2147483648), (477), (372), (-2147483648), 'ncXKVfUrza', 'iaLvE96azM', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'SPcMbMJZiO', 'tV7mObRVrB', 'Rdv85BxVLS'), ((BIGINT '-9223372036854775808'), (INT '1824612883'), (INT '285'), (INT '814'), (115), (261), (259), (1), '7GAL0ws6sS', 'FZYsY85VKD', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'KmUSRwKqK2', '5KSJMKfOnF', 'UO7vZvoEFh'), ((BIGINT '796'), (INT '452'), (INT '1'), (INT '196'), (676), (779), (929), (319), 'q6Hp4L1BDV', 'HxcbOGh6cC', DATE '2023-12-08', DATE '2023-12-01', DATE '2023-12-08', 'b6jpksXktf', 'vsWxug0ZcO', 'JhHL53VoIn'), ((BIGINT '986'), (INT '807'), (INT '846'), (INT '476'), (135), (110), (160), (343), 'cnNVERj4BN', 'eiYSSt2l4P', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'w8rdknhj59', 'JA0gjmyCJ7', 'EIsE4auaxI'), ((BIGINT '870'), (INT '0'), (INT '351'), (INT '211'), (547), (114), (400664500), (2147483647), 'rJT9iFMRkN', 'iLUoo62BNF', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'mc4w6ZNOHO', '0Fzb4zGaQ3', '21UV5p7Lf1'), ((BIGINT '-9223372036854775808'), (INT '689'), (INT '45'), (INT '293'), (792), (0), (870), (-2147483648), 'owFZ6HIVjH', '88XGglBtaM', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-07', 'd56vCmFJAL', 'wykF4sJaVE', 'ydbJtfcROj'), ((BIGINT '145'), (INT '126'), (INT '52'), (INT '928792828'), (444), (185), (619), (887), 'YSIWdbqU4f', 'lFhgtFTfjt', DATE '2023-12-08', DATE '2023-12-08', DATE '2023-12-08', 'rLC6WH9iBr', 'caB8AqpuaJ', 'wn80SetrC1'), ((BIGINT '9'), (INT '295'), (INT '804'), (INT '360'), (334), (1), (819), (572), 'WtfVYd2QZd', 's2opyDXeVl', DATE '2023-12-08', DATE '2023-12-01', DATE '2023-12-08', 'OvCyWfQ0ZH', 'XXsjbe5T88', 'RtljF6bUmL'), ((BIGINT '266'), (INT '973'), (INT '2147483647'), (INT '1140783355'), (310), (0), (293), (692), 'wjHhIMmsR7', 'oT40BcqOsf', DATE '2023-12-08', DATE '2023-12-07', DATE '2023-12-08', 'IYrB2iETa1', 'CyG85TKFNl', 'giPqYQ8qyL');
INSERT INTO nation VALUES ((INT '724'), '1YZUEaL45Y', (INT '353'), 'utDOHAlH7E'), ((INT '923'), '59WTpBw0KW', (INT '552'), 'nnNvu1rEej'), ((INT '431'), 'Mw8ZCQJLMd', (INT '497'), 'FyDGz3tjKk'), ((INT '45'), '6NYBD7JAQK', (INT '746'), '8OZ0dSQmMU'), ((INT '163'), 'CQOKLCe1WS', (INT '107'), '3ogIQCPQvt'), ((INT '962'), 'I0fxZeafxL', (INT '447'), 'PvJGluYIFm'), ((INT '283'), 'ejC0sYj7Dq', (INT '0'), 'rru1SAWQ0J'), ((INT '961'), '0aNaEVY3EE', (INT '911'), '4S3zMiUZkE'), ((INT '596'), 'MIROq6Q8IA', (INT '212'), 'VD856WlP8L'), ((INT '-2147483648'), 'AQdvS0QN8q', (INT '825'), 'hc0KoOjO5o'), ((INT '530'), 'RvcCQc3P5y', (INT '673'), 'A3UTNPWnd4'), ((INT '322'), 'Fr9i4zON7w', (INT '0'), '9tQz9r2OOw'), ((INT '-2147483648'), 'ylwV1i0ia3', (INT '716'), 'IBzOlA1XdJ'), ((INT '-2147483648'), 'hHlqBatXNd', (INT '1'), 'Xj6ruHTo7L'), ((INT '2147483647'), '4ZKorEm6kD', (INT '766'), 'lYnIGSeATf'), ((INT '559'), 'UoHBExBkyI', (INT '-2036890164'), '3xmZGzmN9m'), ((INT '1490649530'), 'nDHCOl8NSy', (INT '544745221'), 'hulHlSlA8o'), ((INT '34'), 'jxFpRuCXN1', (INT '809'), 'b9lV0lLRsq'), ((INT '307'), 'QkIII28DYj', (INT '322'), 'tG6XHMYOQn'), ((INT '37'), '1rVjQtj5Gi', (INT '541'), 'ThJXRgnBDl'), ((INT '2147483647'), 'Iz5ZNUtMYE', (INT '1'), '4Y0rwrnhqH'), ((INT '74'), 'Aya6wVcM8h', (INT '847'), 'FvzYqiZqde'), ((INT '940'), 'GTEtb1Zbkt', (INT '354'), '04c1oJRc3E'), ((INT '821'), '7Wl14U4dD3', (INT '253'), 'gU8LY4xBgo'), ((INT '1'), 'zjVEwphYPL', (INT '516'), 'O0sEPfrBPz'), ((INT '23'), 'KnD5cquvzD', (INT '0'), 'RTc31V6bzK'), ((INT '671'), '2YaqliMcg3', (INT '0'), 'T5EqX5R4hI'), ((INT '166'), 'Btpx1j4hwN', (INT '918'), 'PF2OzCln1A'), ((INT '356'), 'haCMGi7MYN', (INT '674'), 'h3QAY507Lt'), ((INT '689'), '3CJZg0swsg', (INT '2147483647'), 'j4hjMXgKYe'), ((INT '121'), 'ACtteJTJbp', (INT '2147483647'), 'FIz5LyNvVH'), ((INT '2147483647'), 'nY7FNBFIcb', (INT '761'), 'ahqSUy3YO4'), ((INT '810'), '3qdMbcfNso', (INT '765'), 'Thv4srLrcl'), ((INT '401'), 'bLPFvpoNdM', (INT '309'), 'STLLi81IjW'), ((INT '604425675'), 'KRW7sWTXsG', (INT '0'), 'e7OBk3x4kz'), ((INT '599'), 'KCgUljFsjG', (INT '173'), 'L7vq4wujr0'), ((INT '114'), 'VR8a9AOtQl', (INT '300'), 'jMuUJvPofh'), ((INT '46'), 'LZWl9yXvUD', (INT '170'), 'sRhpALAT7v'), ((INT '743'), 'KtIpIEgOxr', (INT '0'), 'KnIYXGM1aZ'), ((INT '355'), 'g53HHbWo5a', (INT '288'), 'HHx5n8GzGb'), ((INT '750'), '0OMHwD0ZMx', (INT '-2147483648'), 'OeJAoJh7tv'), ((INT '432'), 'xYXtdfNGKh', (INT '665'), 'uYUUFfZbwH'), ((INT '74'), 'P8AzvDdi1P', (INT '507'), 'qp6tg0FpWC'), ((INT '-2147483648'), '81wEc4xRSQ', (INT '222'), 'cbmUidN4Io'), ((INT '989'), 'UWynRcHETQ', (INT '446'), '5Q93EMo2B7'), ((INT '2147483647'), '8aVZvDuJNl', (INT '470'), 'D2wOoEVtrJ'), ((INT '2147483647'), 'EIFNmzyEH2', (INT '899'), 'W660YhTqru'), ((INT '662'), 'VVGkCfwzae', (INT '692'), 'LjS8A2WmuT'), ((INT '1'), 'VzTy56o4Cj', (INT '840'), 'WgfpKHIxx1'), ((INT '320'), 'lwFRR3cQpK', (INT '984'), 'FzZqVO7M1e');
INSERT INTO region VALUES ((INT '98'), '3ufds7nc0V', '3yNxl1Tch3'), ((INT '334'), 'zik7nQBbEg', 'i8r24jElzs'), ((INT '430'), '8oRkmSGw1v', 'HF5Jv7Yhnl'), ((INT '-210468844'), '3YD0giK2fb', 'wmTa17Z8VU'), ((INT '205'), 'GxxFKBcu8j', 'toMvBJ0chj'), ((INT '872'), 'h7HThugGBT', 'YaQq1QeMDm'), ((INT '-2147483648'), 'sue0JApv0m', 'fWH5B2AXdo'), ((INT '189'), 'a4lVEb4DGL', 'DMrw1WA3uq'), ((INT '1'), 'hA2na2mqIN', '9bLVuHcjJf'), ((INT '2147483647'), 'zARluQ5ctu', '3ykfIKj7On'), ((INT '831'), 'Jh0qsHnbvr', 'Rk2c4w73fv'), ((INT '695'), 'LQHpmHluUi', 'XD23tnHsI4'), ((INT '205'), 'vTB3UsP5G2', 'rtydc76XsA'), ((INT '0'), 'I5gyEJhScK', 'hcqDqBZZS1'), ((INT '-1058777387'), 'rqdG70Qxz0', 'yMrUafFmGb'), ((INT '744'), 'VxNNFdJ6L7', 'yhP3HFP58G'), ((INT '915'), 'eDl387MQUr', 'PHSJDCbZr9'), ((INT '707'), 'IrdOuqFvDa', '4d9tGuHNjp'), ((INT '429'), 'OiCk8F2JoO', 'D3Mi1cwXou'), ((INT '307'), 'DJW6tGm9aq', 'PLoUCv0K7b'), ((INT '453'), '2vEBg2INCj', 'ZcvIFlRbZ4'), ((INT '90'), 'OMku3qsrk1', 'NEazPaYC8A'), ((INT '836'), 'RMqLPj88H2', 'HIX0YEi8zZ'), ((INT '833'), 'igjL8W6aH0', 'D1tgzLrovw'), ((INT '445'), 'VD7xsetuBF', '3QEJdepoIH'), ((INT '-2147483648'), 'BO7U71ABOV', 'WnGdMGwt6A'), ((INT '799'), 'swujQZ0UG2', 'e2lgBnuzGH'), ((INT '143'), '3KaRo5Niha', 'Z53yjGMDuA'), ((INT '461'), 'MwczKdLZQN', 'pQb4dS6RSP'), ((INT '576314236'), '16WxcFmwpU', 'Lre7jmdPus'), ((INT '2147483647'), '8cgnUkL8pu', 'NLBdR4mgz2'), ((INT '104'), 'W8eWCwQP0f', 'iXKSBeaBgu'), ((INT '2147483647'), '1yFfCUEkEg', 'hzZEViu7ru'), ((INT '-774986002'), 'OGKkipKH0h', '4g2Mps2JSt'), ((INT '521'), 'jz7IYxm08T', 'hW51ljyjnY'), ((INT '651'), 'PeLtNDledT', 'N2Aq3aojI8'), ((INT '225'), 'AdFfYYHFF0', '5XLNyK8cWS'), ((INT '797'), 'Ej2mL9YZx3', 'M0tZGZDEAm'), ((INT '2147483647'), 'mbrHGx3Gzd', 'D4cf9vZjHo'), ((INT '768'), 'O68PQAFfmg', 'AkJdc07VSG'), ((INT '-1123616357'), 'VZtUnOqFlv', 'RDtyH1J4tw'), ((INT '850'), 'ptBAApadVF', 'bfZwJnDOEV'), ((INT '582'), 'cXoRVq0Yfy', 'T9APs9Z73R'), ((INT '2147483647'), '1Xggbw2u2O', 'rP56VyqP5r'), ((INT '678'), 'zJS8NNmhvw', '1qEmSPdMK5'), ((INT '772'), 'apyBg14P8d', 'SohgdgknHs'), ((INT '652'), 'w6EVzcUDBz', 'p3ogzsWCuh'), ((INT '844'), '13BdKI0ZST', 'h5kC8hQmT3'), ((INT '690'), '7KC22aeaw8', '4q2sBE8C4H'), ((INT '662'), 'NJ1uSquJzY', 'oAO21Jed8G');
INSERT INTO person VALUES ((BIGINT '403'), 'LuovmT4NmK', '2eQhFD2dnM', 'KKjHIVZ8cv', 'ivz3vaHXog', 'mfAqXwHuw0', TIMESTAMP '2023-12-08 16:29:23', 'rUvPegVbhO'), ((BIGINT '-6430447119600419241'), 'WtxB7tZc7Z', 'jQfS6yYX1Z', 'FQQgYeW95Z', 'MAObkbnt71', 'GqTzEOQoaI', TIMESTAMP '2023-12-08 16:28:19', 'XP014a6p3h'), ((BIGINT '851'), '0WToF8KsSV', 'J5VQaDe1YJ', 'D2gHJ0L1Yh', 'HAcrS5z9W8', 'YEmH50hQsv', TIMESTAMP '2023-12-08 15:29:23', 'ET1wzsshnu'), ((BIGINT '640'), 'CRRA9DTQ7g', 'JbgJQPinPm', 'CJXwiXl0Wu', 'YPo3QmXLyU', '0MnBs4FaSh', TIMESTAMP '2023-12-08 15:29:23', 'QEyoU6ypSN'), ((BIGINT '0'), 'T9ul4UX62B', 'yuPDounlsJ', 'zFy0ia9RoI', 'P5yXZdbSOp', 'k4TrguOMEH', TIMESTAMP '2023-12-08 16:29:22', 'TIUUEdQAsj'), ((BIGINT '9223372036854775807'), 'k5vbbKi5iM', 't9IKNwFUAZ', 'YhDfwkdSfI', '6ldGKoEeMT', 'MIId0jCPAk', TIMESTAMP '2023-12-08 16:28:20', 'PMgwkNrzqQ'), ((BIGINT '-9223372036854775808'), 'SuzmsbMd73', '667j0VCjPD', 'CTVMBsaLSo', 'Dsv4EAvurX', 'e2WepvGigX', TIMESTAMP '2023-12-08 16:28:53', 'b9ISjGnDFi'), ((BIGINT '665'), 'fH9zxqMewk', 'gHzsvhRKCq', 'rLJ1kKBHIw', 'vOVkbjNR63', 'RC3Rez3HnD', TIMESTAMP '2023-12-01 16:29:23', '5KlOklcDpx'), ((BIGINT '1089142152420793344'), '0XVTx1xh9K', 'l8xL8SAo9k', '4zAt6dR0hu', '7sHYks1hGv', 'fU8r0KqxoD', TIMESTAMP '2023-12-08 16:28:10', '6eCAgmtrQe'), ((BIGINT '875'), 'UMJfQDFjjV', 'sT3l7Qsj8j', 'Ov8txP1Xf6', 'SYV58QeKsy', 'rBRTjlosFz', TIMESTAMP '2023-12-08 15:29:23', 'NY7A607D96'), ((BIGINT '0'), 'ZKDL8h5Qsl', '6p1aLQ8pTn', 'Cw4QmtzhJ1', 'vPCpBYrcJG', 'IO11ZIDFMq', TIMESTAMP '2023-12-08 16:29:03', 'DmWAlt8uru'), ((BIGINT '257'), 'gjkZiholo7', 'lOCQMGKzdz', 'SdvMDeLSQ8', 'afCSvZYMwY', 'Gyykf6PWK4', TIMESTAMP '2023-12-08 16:28:23', '9nMlZFaHat'), ((BIGINT '537'), 'fjuIyEsmS2', 'oS3hoN5qng', 'FljBnut54Y', 'w4hWU5qrj2', '3MDbVgjYdF', TIMESTAMP '2023-12-08 16:28:39', 'zxReXirOt8'), ((BIGINT '9223372036854775807'), 'CkjY4f9HId', 'YOCvyiWrvn', 'Xf220GsPr0', 'Fspp8Ts9wI', 'aRzcAxOjZc', TIMESTAMP '2023-12-08 16:28:08', 'b4872iBQ84'), ((BIGINT '-5060236372435234547'), '890uwEIAY5', 'obk9x5Imtb', 'BmonDoRW8u', 'czeYqiPAGT', 'tylJYlhcUX', TIMESTAMP '2023-12-01 16:29:23', '9rPZxRqOJj'), ((BIGINT '725'), 'siy578Cj6R', 'AsgPN4fL72', 'TFSqvmPOBu', 'sV77fSOjsu', 'r4RPPGHYXA', TIMESTAMP '2023-12-08 16:28:25', 'grsVDEDcqq'), ((BIGINT '503'), 'JvWKBpNSyF', 'SzemV5BR7a', 'YnY10TDS9k', '3wBZg1wHZ0', 'p6BwMrdvag', TIMESTAMP '2023-12-08 16:28:05', 'BlS70kbFU2'), ((BIGINT '-9223372036854775808'), '4MugAWoiO4', 'TMv27AYmQk', 'QP1BsP9O0W', '7SR1IFK3vd', 'BGAjmpNfAh', TIMESTAMP '2023-12-08 16:29:22', '0I1GQGZJ4s'), ((BIGINT '925'), 'RZqZ7ez1U1', 'hnsj2tDBIn', 'MnPknqkwK9', 'xpdjZhWSgo', 'FbQkPBMOPt', TIMESTAMP '2023-12-08 16:28:56', 'x6v8sEcGcy'), ((BIGINT '158'), '1aaOgGLIht', 'JUDCcQ45Rk', 'Ee3mB3wFsR', 'i1SrIxCenR', '29TCS266Kl', TIMESTAMP '2023-12-07 16:29:23', 'a48HkBaywh'), ((BIGINT '641'), 'QjU3h3Ej75', 'zvVfU0VgfE', 'c5y3snL2zn', 'q1tKhY5Pym', 'eITbtgsD5r', TIMESTAMP '2023-12-08 16:27:51', 'ySgEicJmPk'), ((BIGINT '533'), 'vk2lJvBjMV', 'TSAa6VWLPU', 'zTNOUA9cU2', '9EaUXqbAJ6', 'njJVwQZ4ql', TIMESTAMP '2023-12-08 16:29:16', 'PVOMttU4xV'), ((BIGINT '862'), 'Z19nQ1KYvR', '27rOd3IOhM', 'rN4MOlCOEs', 'bH7v11JBO4', '9nR5wsncl0', TIMESTAMP '2023-12-08 16:28:55', 'DqhlGzan2a'), ((BIGINT '153'), 'g4TfdVaNZm', 'SZDPlhgKTl', 'Rkgi05iVbU', 'TlgKaMgq7U', '9d6VcsFIgh', TIMESTAMP '2023-12-07 16:29:23', '4BnpQjO6uh'), ((BIGINT '9223372036854775807'), 'l0nVMn2Idv', 'jcFOnRmazX', '5iCurWn3Fo', 'd6biLlmNJm', '8mhzqs0rDA', TIMESTAMP '2023-12-08 16:28:31', 'Fl6XN75B3z'), ((BIGINT '752'), '9lDsfdD5Pw', 'YfJHrUmCU1', 'H8HeMFLkTn', 'YmX4fpId5b', 'pVXdRx6eoM', TIMESTAMP '2023-12-08 16:29:23', 'GqRX6FHmiX'), ((BIGINT '693'), 'jpmwA9T587', 'DVUGxMUWtK', 'gC5eXaui5O', 'jPvxxpfz1W', 'ofL2DRqZF1', TIMESTAMP '2023-12-08 16:28:20', '3agQ2FJiVD'), ((BIGINT '-3226091574658368078'), 'pUbQjcwn4b', 'I8NueUp5mM', 'GluLbO4zoe', 'sgtApyWTTu', '0CZZYoHQ86', TIMESTAMP '2023-12-08 15:29:23', 'TVCYwEkgRy'), ((BIGINT '69'), 'fUxxG7FzSE', 'rGx40p1MfU', 'QcwBCF69I3', 'NdUaQV6HoN', 'QxOXgOt6Sw', TIMESTAMP '2023-12-08 16:28:22', '6MPR46i5ah'), ((BIGINT '192'), 'V1VUxiV1dO', 'E1VnW6Sawl', '7CW6QJYvXs', 'FGx25txpBC', 'cmgBAQqmAz', TIMESTAMP '2023-12-08 16:29:00', 'KSzedbTD6g'), ((BIGINT '529'), 'Bzlneimgjt', 'rSCCUc1HuV', 'w1kqSWITU3', 'Ki2cyUK3oG', 'goc5V6KwFr', TIMESTAMP '2023-12-08 16:29:23', 'hLXN0b9dzl'), ((BIGINT '820'), 'kiW0rR3bTn', 'ZZceFiLIeI', 'uy9Wts9JJM', 'OaPE8TxIJr', 'mwzoUN5aXp', TIMESTAMP '2023-12-08 16:29:01', 'jdz8MsCsz1'), ((BIGINT '832'), '89RhUNF7Yx', 'nfHZnlWLbO', '0dfMolEYLS', '7DUQwsqCKw', 'YAKF9tdRg5', TIMESTAMP '2023-12-08 16:28:09', 'hvTJkRa8BE'), ((BIGINT '896'), 'uGdieXsKzG', '7ZOxONxH3t', 'ZYIpZc6CO9', 'IdZiHNp9n1', 'MnulSDtH7R', TIMESTAMP '2023-12-08 16:28:57', 'gqHrcZyPNF'), ((BIGINT '669'), 'B2WF0zoxuM', '09BdGj2mrh', 'HYseHUHdEC', 'TAGttGNv52', 'T3go3ho0lv', TIMESTAMP '2023-12-08 16:29:16', 'ostEggh6Ot'), ((BIGINT '1'), 'CEYrPMjXtL', 'l0Rf9JwDU3', '89g7rB6YZC', 'am9c8Y5vOa', 'OJ9bPGFEGg', TIMESTAMP '2023-12-01 16:29:23', 'vKv7G0EsTI'), ((BIGINT '0'), 'vKGSN7JtBW', '1tZXQls8VW', 'NVC8hRu8wD', 'HXeFiLAJEN', 'nbQaiF6l47', TIMESTAMP '2023-12-08 16:28:12', 'aFGA93nikS'), ((BIGINT '747'), '1SuuseBBSt', 'zFjyJ6ucEo', 'hTXEDCPYl9', '7iEi0c3azL', 'Xw0qCnfG5e', TIMESTAMP '2023-12-08 16:29:10', '5sy3cK4Of5'), ((BIGINT '778'), 'sxxt7K3rSU', 'XGL2rmdCB1', 'tphYPTHq7e', '4HMuIXGQj4', 'Ysud8kzXGM', TIMESTAMP '2023-12-08 16:28:23', '87MdLnmaTq'), ((BIGINT '-9223372036854775808'), 'r5q6KL6IS9', 'xaR0tB1jvv', '9gt0tLzntL', 'K73wSR2QH0', 'toWpisVNDt', TIMESTAMP '2023-12-08 16:28:10', 'Itn0TOqtV5'), ((BIGINT '195'), 'xItEoU5D81', 'XVTnEYwY10', 'UflsqmF10E', 'UXXSB78yNH', 'mdKnDz3whP', TIMESTAMP '2023-12-08 16:28:46', 'sbyginHFQK'), ((BIGINT '250'), 'iFqzhIeRjp', 'o11aSF5h5P', 'quAO8JFFTP', 'Q6crLFVdaj', 'ntpUTzu59I', TIMESTAMP '2023-12-08 16:29:07', 'Otff9Dga4k'), ((BIGINT '223'), '8SYtEhf2jU', 'frGhpznDNi', 'oLTivrAEZE', 'c0DCTDFB7b', 'yr3uZwROib', TIMESTAMP '2023-12-08 16:29:23', 'GCXGqHSeDR'), ((BIGINT '723'), 'S4Q3JkGJSV', 'rUC14HJ0WL', 'M2UQslB26A', 'MtyAcQvnS8', 'emwInL3p35', TIMESTAMP '2023-12-08 16:28:45', '47xmxAQNmx'), ((BIGINT '317'), 'a3ufBh1ZTa', 'N9lSHI60g0', 'HDqEvXxdsN', 'kO9PKKAEx4', 'Hj7ZRIQ6HZ', TIMESTAMP '2023-12-08 15:29:23', 'i42egjxOkZ'), ((BIGINT '585454734455175429'), 'wPHldLqAaA', '1RkJgvvEDG', 'qqw9oGflL6', 'kzo4rwY3I2', 'bLlO4ULjX2', TIMESTAMP '2023-12-07 16:29:23', 'D15ZxaEb9h'), ((BIGINT '125'), 'Bcz5X3nzEu', 'QECsfe2G6s', 'lD7bFX9P75', '6fplI3iHMt', 'KW2Wrd46hw', TIMESTAMP '2023-12-08 16:27:51', 'se7vfnjeVJ'), ((BIGINT '361'), '5I0X2Lsp0Y', 'CPLYRJHqfA', '0ei3dtu71S', 'iwGgVDZtzU', 'NlP2XxYxmd', TIMESTAMP '2023-12-08 16:28:09', 'wlZX8zfI3r'), ((BIGINT '975'), 'swtUlYZWwK', 'tQOKEoRNLy', 'dDJ7m5jEsE', 'FUkRkgfbJb', 'hv4EaXNt4O', TIMESTAMP '2023-12-08 16:28:21', 'g3znxKgLmu'), ((BIGINT '955'), '4mCaYubLcS', 'G87GmABlNi', 'aMrTcALVYx', 'LGIQ3xS8NM', 'J0rnf2komY', TIMESTAMP '2023-12-08 16:29:19', 'ELa3AqNJcj');
INSERT INTO auction VALUES ((BIGINT '377'), 'ySsWOaJeTB', 'Iv7SXqMjMP', (BIGINT '696'), (BIGINT '4802213450782753231'), TIMESTAMP '2023-12-08 16:28:04', TIMESTAMP '2023-12-07 16:29:23', (BIGINT '469'), (BIGINT '1'), '34ullgrOFS'), ((BIGINT '389'), 'KftOek2uTA', 'ND4yQEahw6', (BIGINT '-9223372036854775808'), (BIGINT '6016666439526681795'), TIMESTAMP '2023-12-01 16:29:23', TIMESTAMP '2023-12-08 16:27:54', (BIGINT '1'), (BIGINT '0'), 'voUYUlBPY8'), ((BIGINT '179'), '6GP3cdWWyN', 'cshzQm3HI8', (BIGINT '780'), (BIGINT '2320405155250089263'), TIMESTAMP '2023-12-08 16:28:23', TIMESTAMP '2023-12-08 16:28:22', (BIGINT '151'), (BIGINT '1'), 'LQy57Yzb9K'), ((BIGINT '510'), 'YiZD74tRKH', 'p7TAX5nKaA', (BIGINT '744'), (BIGINT '838'), TIMESTAMP '2023-12-08 16:27:49', TIMESTAMP '2023-12-08 16:28:34', (BIGINT '1598315909766793002'), (BIGINT '3705059942332346357'), '5dKZCg1OhM'), ((BIGINT '21'), 'Itx919kW0s', 'IWSYAUaKzT', (BIGINT '415'), (BIGINT '20'), TIMESTAMP '2023-12-08 16:29:14', TIMESTAMP '2023-12-08 16:27:59', (BIGINT '768'), (BIGINT '606'), 'WKCiU2RCt8'), ((BIGINT '994'), 'DCjzfWvCFv', 'kbDs5G9KE5', (BIGINT '62'), (BIGINT '804'), TIMESTAMP '2023-12-08 16:28:45', TIMESTAMP '2023-12-08 16:29:22', (BIGINT '445'), (BIGINT '-8849416520744290665'), 'Dl2nLOaZXi'), ((BIGINT '980'), 'YBLdhZsHme', '3GTqzmlP0E', (BIGINT '1'), (BIGINT '9223372036854775807'), TIMESTAMP '2023-12-01 16:29:23', TIMESTAMP '2023-12-08 16:28:04', (BIGINT '0'), (BIGINT '908'), 'wrvRFfxEFP'), ((BIGINT '661'), 'gRLCoPg5jr', 'isP9m2ufTb', (BIGINT '9223372036854775807'), (BIGINT '679'), TIMESTAMP '2023-12-08 16:28:43', TIMESTAMP '2023-12-08 16:29:02', (BIGINT '1'), (BIGINT '9223372036854775807'), 'xztzzRutsJ'), ((BIGINT '861'), '5Z6u4KTkT3', 'WNh21T7aYN', (BIGINT '9223372036854775807'), (BIGINT '80'), TIMESTAMP '2023-12-08 15:29:23', TIMESTAMP '2023-12-08 16:29:23', (BIGINT '969'), (BIGINT '137'), 'TIsrspgFEn'), ((BIGINT '639'), '7hylf4wOlH', 'khhetYtvrl', (BIGINT '1'), (BIGINT '9223372036854775807'), TIMESTAMP '2023-12-08 16:28:26', TIMESTAMP '2023-12-08 16:29:23', (BIGINT '276'), (BIGINT '518'), 'ig6kcbls0f'), ((BIGINT '785'), 'nEncLhRVP2', 'BgROJfkKkR', (BIGINT '413'), (BIGINT '737'), TIMESTAMP '2023-12-08 16:29:01', TIMESTAMP '2023-12-08 16:27:59', (BIGINT '9223372036854775807'), (BIGINT '944'), 'r17h4Fjymw'), ((BIGINT '508'), 'QJBEdFsVA7', 'zVrLUZPEsR', (BIGINT '-9223372036854775808'), (BIGINT '530'), TIMESTAMP '2023-12-08 16:28:43', TIMESTAMP '2023-12-08 16:29:22', (BIGINT '205'), (BIGINT '873'), 'j6R6DGtlJo'), ((BIGINT '122'), '9uaXx6xPcu', 'PhRlw2vOSR', (BIGINT '9223372036854775807'), (BIGINT '255'), TIMESTAMP '2023-12-08 16:27:50', TIMESTAMP '2023-12-08 16:29:23', (BIGINT '5455729041562477905'), (BIGINT '-9223372036854775808'), 't0Xd1HWMOK'), ((BIGINT '553'), 'MPgHG9dnDn', 'AKEPSPqwXm', (BIGINT '203'), (BIGINT '909'), TIMESTAMP '2023-12-08 16:29:16', TIMESTAMP '2023-12-08 16:28:23', (BIGINT '9223372036854775807'), (BIGINT '8091953236126595592'), '0OYoh7w3cj'), ((BIGINT '-5226388584171026903'), 'X9KSo4v4t1', 'aG7tbkijJO', (BIGINT '576'), (BIGINT '0'), TIMESTAMP '2023-12-08 16:28:06', TIMESTAMP '2023-12-08 16:28:04', (BIGINT '963'), (BIGINT '9223372036854775807'), 'MR71BFFzdq'), ((BIGINT '106'), '5noGSIeUsO', 'jyWfVtYnUI', (BIGINT '311'), (BIGINT '1'), TIMESTAMP '2023-12-08 16:28:16', TIMESTAMP '2023-12-08 16:29:23', (BIGINT '561'), (BIGINT '300'), 'PJSYOwzm6J'), ((BIGINT '678'), 'fkkv8pNihN', 'dnQxBiyWA6', (BIGINT '963'), (BIGINT '838'), TIMESTAMP '2023-12-08 16:28:02', TIMESTAMP '2023-12-08 16:29:23', (BIGINT '1'), (BIGINT '-8839406630208803712'), '6N7VOJXHRE'), ((BIGINT '509'), 'oMt1jPnKfZ', 'HPLhlyqgCe', (BIGINT '-9223372036854775808'), (BIGINT '0'), TIMESTAMP '2023-12-08 16:28:30', TIMESTAMP '2023-12-08 16:28:24', (BIGINT '214'), (BIGINT '465'), 'pPLhpwr1fp'), ((BIGINT '270'), 'ObM2snxNJI', 'ezIHdfd3Qx', (BIGINT '656'), (BIGINT '9223372036854775807'), TIMESTAMP '2023-12-08 16:28:11', TIMESTAMP '2023-12-08 16:29:13', (BIGINT '983'), (BIGINT '9223372036854775807'), 'CxSZeuFRg1'), ((BIGINT '225'), 'pm81BQ206i', '9O5Wj4Ilw6', (BIGINT '597'), (BIGINT '661'), TIMESTAMP '2023-12-08 16:29:21', TIMESTAMP '2023-12-08 15:29:23', (BIGINT '727'), (BIGINT '4336602778374532945'), 'RXZ9sXh2dF'), ((BIGINT '590'), '9wy7xJmTSK', 'kuCKWFQkEO', (BIGINT '999'), (BIGINT '273'), TIMESTAMP '2023-12-08 16:27:44', TIMESTAMP '2023-12-08 16:28:47', (BIGINT '1'), (BIGINT '6218508961091969522'), 'wMT05aruHO'), ((BIGINT '574'), 'dHM57mtoKo', 'OTTteZrl26', (BIGINT '3972807814894142792'), (BIGINT '328'), TIMESTAMP '2023-12-08 16:28:10', TIMESTAMP '2023-12-08 16:29:13', (BIGINT '424'), (BIGINT '4781680349675173400'), 'AHRvKoINLO'), ((BIGINT '926'), 'XP6a7OPzML', 'cykfZOrOOu', (BIGINT '937'), (BIGINT '1'), TIMESTAMP '2023-12-08 16:28:54', TIMESTAMP '2023-12-08 16:27:56', (BIGINT '516'), (BIGINT '0'), 'PyOChVz6Lj'), ((BIGINT '-9223372036854775808'), 'Upw4G2Xsow', 'iHSuvFvgyN', (BIGINT '437'), (BIGINT '888'), TIMESTAMP '2023-12-08 16:29:22', TIMESTAMP '2023-12-08 16:28:50', (BIGINT '69'), (BIGINT '412'), 'lMBjq1dUqw'), ((BIGINT '870'), 'HkxC6HG78y', 'RJHm9ZW03i', (BIGINT '735'), (BIGINT '443'), TIMESTAMP '2023-12-08 16:28:48', TIMESTAMP '2023-12-08 16:29:01', (BIGINT '502'), (BIGINT '719'), 'wMrnjftdDZ'), ((BIGINT '538'), 'PxOCxfCSS7', 'i8UAwTHl4Y', (BIGINT '111'), (BIGINT '142'), TIMESTAMP '2023-12-08 16:29:04', TIMESTAMP '2023-12-08 15:29:23', (BIGINT '0'), (BIGINT '726'), 'Vkajqxz5uW'), ((BIGINT '912'), 'pzl31ErQ2Q', 'GpAVg7LcT5', (BIGINT '375'), (BIGINT '873'), TIMESTAMP '2023-12-07 16:29:23', TIMESTAMP '2023-12-08 16:27:58', (BIGINT '816'), (BIGINT '96'), 'OA3S0ATNVs'), ((BIGINT '305'), 'ZD1x1WdtSG', 'uKueXtKwat', (BIGINT '27'), (BIGINT '9223372036854775807'), TIMESTAMP '2023-12-08 16:29:17', TIMESTAMP '2023-12-08 16:27:46', (BIGINT '125'), (BIGINT '0'), '8OuOq4rAOi'), ((BIGINT '534'), 'vohCUftNld', 'Ypka53mucg', (BIGINT '12'), (BIGINT '669'), TIMESTAMP '2023-12-08 16:29:06', TIMESTAMP '2023-12-08 16:28:32', (BIGINT '964'), (BIGINT '878'), '2ZzyjpkIcP'), ((BIGINT '7133582039428226820'), 'mj05InIu9P', 'anK3xcmNM6', (BIGINT '893'), (BIGINT '407'), TIMESTAMP '2023-12-08 16:29:22', TIMESTAMP '2023-12-08 16:27:54', (BIGINT '0'), (BIGINT '981'), 'HETLDInZ6D'), ((BIGINT '1940237944114095213'), '0DfFBLKI1E', 'Ut0y7yuj2L', (BIGINT '-9223372036854775808'), (BIGINT '428'), TIMESTAMP '2023-12-08 16:28:56', TIMESTAMP '2023-12-08 16:29:04', (BIGINT '895'), (BIGINT '-9223372036854775808'), 'ByyERs8FmO'), ((BIGINT '721'), 'YKxFQJ0tqR', 'VSTcMbWcmv', (BIGINT '376'), (BIGINT '973'), TIMESTAMP '2023-12-08 16:28:59', TIMESTAMP '2023-12-08 16:27:59', (BIGINT '140'), (BIGINT '1'), 'ZH3kFE9l9t'), ((BIGINT '530'), 'KfdxFcamxf', 'h1TQWdXwdG', (BIGINT '84'), (BIGINT '813'), TIMESTAMP '2023-12-08 16:28:59', TIMESTAMP '2023-12-08 16:29:11', (BIGINT '538'), (BIGINT '668'), 'oUe2c3AYrS'), ((BIGINT '0'), 'g5BJ2XjqFU', 'Gq66UDrRAp', (BIGINT '-3446619089468107573'), (BIGINT '341'), TIMESTAMP '2023-12-08 16:28:14', TIMESTAMP '2023-12-08 16:29:13', (BIGINT '580'), (BIGINT '0'), '7EO4JYHfY7'), ((BIGINT '528'), 'ot8t45dqUl', '6Q0yB9W3mj', (BIGINT '-8057067183928110420'), (BIGINT '233'), TIMESTAMP '2023-12-08 16:28:14', TIMESTAMP '2023-12-08 16:28:02', (BIGINT '-9223372036854775808'), (BIGINT '679'), 'AGnjfCs5UV'), ((BIGINT '394'), 'lLqNrwHMnR', 'hZw3FW3UKR', (BIGINT '532'), (BIGINT '546'), TIMESTAMP '2023-12-08 16:29:13', TIMESTAMP '2023-12-08 16:28:57', (BIGINT '0'), (BIGINT '9223372036854775807'), 'QcfXVOz7JB'), ((BIGINT '182'), 'mEYch5SJtn', 'MuFMNW9Shd', (BIGINT '9223372036854775807'), (BIGINT '475'), TIMESTAMP '2023-12-08 16:27:44', TIMESTAMP '2023-12-08 16:28:23', (BIGINT '520'), (BIGINT '0'), 'QhyMqQ4Syo'), ((BIGINT '1543808097930901712'), 'l1RbXnYnM8', 'UQhVZenIXL', (BIGINT '166'), (BIGINT '516'), TIMESTAMP '2023-12-08 16:27:49', TIMESTAMP '2023-12-08 16:28:37', (BIGINT '606'), (BIGINT '928'), 'sLYEoqXyLu'), ((BIGINT '467'), 'Lc6aevgipn', '19vvZpdbWX', (BIGINT '519'), (BIGINT '308'), TIMESTAMP '2023-12-01 16:29:23', TIMESTAMP '2023-12-08 16:28:48', (BIGINT '234'), (BIGINT '9223372036854775807'), 'j1tdjYxaa5'), ((BIGINT '638'), 'DWHjZ05ZkX', 'NhTVGXqY13', (BIGINT '526'), (BIGINT '705'), TIMESTAMP '2023-12-08 16:27:44', TIMESTAMP '2023-12-08 15:29:23', (BIGINT '762'), (BIGINT '915'), 'aGK4S60jVS'), ((BIGINT '913'), 'sy6Vv8ORmq', 'I9L75TS56v', (BIGINT '9223372036854775807'), (BIGINT '703'), TIMESTAMP '2023-12-08 16:29:22', TIMESTAMP '2023-12-08 16:29:23', (BIGINT '999'), (BIGINT '717'), 'vyUO7slGsW'), ((BIGINT '1'), 'dr8l6enZAo', 'xKWxK3VELe', (BIGINT '370'), (BIGINT '835'), TIMESTAMP '2023-12-08 16:27:47', TIMESTAMP '2023-12-08 16:29:08', (BIGINT '0'), (BIGINT '998'), '9b8909whdk'), ((BIGINT '1'), 'sIJdXIh1LR', 'zBtBlzwSAa', (BIGINT '833'), (BIGINT '-9223372036854775808'), TIMESTAMP '2023-12-08 16:27:56', TIMESTAMP '2023-12-08 16:28:08', (BIGINT '400'), (BIGINT '702'), '5zXsoUEe8M'), ((BIGINT '990'), 'V7CBnDwqKy', 'sYkHcob3vW', (BIGINT '660'), (BIGINT '790'), TIMESTAMP '2023-12-08 16:29:02', TIMESTAMP '2023-12-08 16:29:12', (BIGINT '-3158648858135554787'), (BIGINT '247'), 'oT2zWb82F9'), ((BIGINT '229'), 'UhUGAUzoxi', 'p3ELXqjYRA', (BIGINT '331'), (BIGINT '373'), TIMESTAMP '2023-12-08 16:29:21', TIMESTAMP '2023-12-08 16:28:04', (BIGINT '0'), (BIGINT '231'), 'jSF5O8pdJw'), ((BIGINT '155'), 'kUITlXWzFd', 'hwE7aPezS6', (BIGINT '4231457580204627074'), (BIGINT '199'), TIMESTAMP '2023-12-08 16:28:23', TIMESTAMP '2023-12-08 16:28:59', (BIGINT '6848511817151561305'), (BIGINT '1'), 'WZoboO4q5C'), ((BIGINT '683'), '1dTjUM9JEC', 'a4QVgoFucN', (BIGINT '932'), (BIGINT '0'), TIMESTAMP '2023-12-08 16:28:50', TIMESTAMP '2023-12-08 16:28:05', (BIGINT '1'), (BIGINT '866'), 'BQAHxHIKdd'), ((BIGINT '159'), '0jfAZYj4Is', 'HC26p7XvsF', (BIGINT '497'), (BIGINT '-9223372036854775808'), TIMESTAMP '2023-12-08 16:28:57', TIMESTAMP '2023-12-08 16:28:41', (BIGINT '-9223372036854775808'), (BIGINT '225'), 'MmZiVrVHJv'), ((BIGINT '-9223372036854775808'), 'zH9MQ63xvf', 'BR1M0Gi3Tf', (BIGINT '-9223372036854775808'), (BIGINT '554'), TIMESTAMP '2023-12-08 16:28:15', TIMESTAMP '2023-12-08 16:27:54', (BIGINT '904'), (BIGINT '332'), 'HITHPMQL79'), ((BIGINT '954'), 'VzqNPG2sNI', 'YFKU1pdPyJ', (BIGINT '339'), (BIGINT '602'), TIMESTAMP '2023-12-08 16:28:02', TIMESTAMP '2023-12-08 16:28:08', (BIGINT '639'), (BIGINT '1'), 'AR0fswEFeA');
INSERT INTO bid VALUES ((BIGINT '166'), (BIGINT '20'), (BIGINT '240'), 'zaac44fjtK', 'CmMQzuwxVY', TIMESTAMP '2023-12-08 16:28:26', '5e1w490pFw'), ((BIGINT '203'), (BIGINT '264'), (BIGINT '522'), '001ny2AywD', '9cQTmcYgMa', TIMESTAMP '2023-12-08 16:28:54', '138a2plSd8'), ((BIGINT '781'), (BIGINT '44'), (BIGINT '-9223372036854775808'), 'trEPWrpUOJ', 'rbeS53PmTT', TIMESTAMP '2023-12-07 16:29:23', 'y7yCgokww6'), ((BIGINT '-2456871202941530074'), (BIGINT '1'), (BIGINT '0'), 'ne3gqU9jkq', 'Rm313XmoC2', TIMESTAMP '2023-12-08 16:28:07', 'QBNist4QnT'), ((BIGINT '565'), (BIGINT '66'), (BIGINT '505'), 'O0TTf4fptc', 'L9uI6WSRD2', TIMESTAMP '2023-12-08 16:27:56', 'DPYldkTaf6'), ((BIGINT '-6322197023259383088'), (BIGINT '70'), (BIGINT '61'), 'K7cQJ21v9z', 'EuA3MfvBaZ', TIMESTAMP '2023-12-08 16:27:45', 'CnA1pSnvMK'), ((BIGINT '-9223372036854775808'), (BIGINT '9223372036854775807'), (BIGINT '711'), 'aRB6zyvKCN', 'zQf18kphE7', TIMESTAMP '2023-12-08 16:28:38', 'IvNyu4kVap'), ((BIGINT '356'), (BIGINT '3891339315647908565'), (BIGINT '785'), 'O7tmHJt7qz', 'wA4zPhFmdI', TIMESTAMP '2023-12-08 16:29:22', 'pPFIBeKrhE'), ((BIGINT '673'), (BIGINT '961'), (BIGINT '644'), 'fYgcxeZpm8', 'Z1cgdKzxBW', TIMESTAMP '2023-12-08 16:29:22', 'hmftKZPOdu'), ((BIGINT '-9223372036854775808'), (BIGINT '848'), (BIGINT '617'), 'ITKwisGMbK', 'hD9hMHT1az', TIMESTAMP '2023-12-08 15:29:23', 'hT5mIE7j4C'), ((BIGINT '624'), (BIGINT '966'), (BIGINT '232'), 'wMqIRe88qp', '5UnHM7fnt0', TIMESTAMP '2023-12-08 15:29:23', 'Kle2VI4Mwy'), ((BIGINT '-6795654244367395623'), (BIGINT '271'), (BIGINT '8407174965570223304'), 'nWAfTOYdyX', 'zmoNU6xBmz', TIMESTAMP '2023-12-08 16:29:23', 'vuAQMoFFdf'), ((BIGINT '799'), (BIGINT '-9223372036854775808'), (BIGINT '567'), 'IjRJC7vODk', 'mhm6ezMCQy', TIMESTAMP '2023-12-08 16:28:50', '9Mlxqb25EK'), ((BIGINT '583'), (BIGINT '818'), (BIGINT '-4163511236887410433'), 'SfER5jgmFw', 'GAMb90sT0l', TIMESTAMP '2023-12-01 16:29:23', '6DA8bCUTBU'), ((BIGINT '394'), (BIGINT '6'), (BIGINT '989'), 'U3kIErP8Tx', 'Ye1EcdfXQB', TIMESTAMP '2023-12-08 16:28:57', 'qtmytMSeo9'), ((BIGINT '59'), (BIGINT '867'), (BIGINT '619'), 'Y9hFFMkPqY', 'VySWayWpHt', TIMESTAMP '2023-12-08 16:28:50', 'axqk8eSsJ4'), ((BIGINT '712'), (BIGINT '496'), (BIGINT '9223372036854775807'), 'eu58rPlmyu', '5q6SmXGsyd', TIMESTAMP '2023-12-08 15:29:23', 'xCbMihBTHr'), ((BIGINT '246'), (BIGINT '377'), (BIGINT '553'), 'wn1EXbbmE5', 'lCxNV7t2LS', TIMESTAMP '2023-12-07 16:29:23', 'WMvuKbqqcE'), ((BIGINT '599'), (BIGINT '842'), (BIGINT '699'), 'ESEaa3wtXZ', 'EIVMNjyLz5', TIMESTAMP '2023-12-08 16:29:06', 'Ueg36IZi4E'), ((BIGINT '816'), (BIGINT '505'), (BIGINT '126'), 'YZ1eNVTDAb', 'THCkhSVFua', TIMESTAMP '2023-12-08 16:28:35', '8n2Es5e2Ze'), ((BIGINT '328'), (BIGINT '907'), (BIGINT '797'), 'lqChAe8QkZ', 'AWXv1NlJoq', TIMESTAMP '2023-12-08 16:28:40', '3XQrrsmkHX'), ((BIGINT '-9223372036854775808'), (BIGINT '485'), (BIGINT '886'), '3P2voDN1zS', 'QDLKYXWB1S', TIMESTAMP '2023-12-08 16:29:22', 'hKwMnX6zIs'), ((BIGINT '500'), (BIGINT '938'), (BIGINT '479'), 'dr5cjFjsZ1', 'IsnbUwFAre', TIMESTAMP '2023-12-08 16:29:19', 'XIeO4B7ZSe'), ((BIGINT '1'), (BIGINT '254'), (BIGINT '922'), 'vr6QCe6U13', 'rDcGec0yKF', TIMESTAMP '2023-12-08 16:29:19', '3J6wjtWbmo'), ((BIGINT '16'), (BIGINT '121'), (BIGINT '43'), 'pNS8bgWb6d', 'p6JLLBTnAt', TIMESTAMP '2023-12-08 16:28:23', 'cCsnZ3lRGi'), ((BIGINT '230'), (BIGINT '497'), (BIGINT '1883226523648888501'), 'etIISw9hRt', '45dP82iI15', TIMESTAMP '2023-12-08 16:28:27', 'nbMdK6mrwe'), ((BIGINT '221'), (BIGINT '9223372036854775807'), (BIGINT '969'), 'ibKQWgmTqh', '27qMkpHfyQ', TIMESTAMP '2023-12-08 16:28:12', 'iiTyWtLE1U'), ((BIGINT '4971041140652870484'), (BIGINT '557'), (BIGINT '315'), 'CATYA6yT5R', 'wiM446g3ID', TIMESTAMP '2023-12-08 16:28:19', '32W5YzVT9A'), ((BIGINT '41853928305608641'), (BIGINT '583'), (BIGINT '808'), '3pY49KreQx', 'srngJJ0kCR', TIMESTAMP '2023-12-08 16:29:08', 'Cx0MNquf6E'), ((BIGINT '830'), (BIGINT '286'), (BIGINT '263'), '7RbZDUnMuM', '4OxpEWCXeZ', TIMESTAMP '2023-12-08 16:28:38', 'JIzLl0DhIF'), ((BIGINT '953'), (BIGINT '386'), (BIGINT '429'), '7mNdSWYObb', '9LoABNw8UO', TIMESTAMP '2023-12-08 16:27:56', 'fAcmpf7EOc'), ((BIGINT '922'), (BIGINT '0'), (BIGINT '814'), 'TBjKpERSIT', 'O3Xgmwwttt', TIMESTAMP '2023-12-08 16:29:23', 'S6XJhfAu5K'), ((BIGINT '248'), (BIGINT '-255217539891537915'), (BIGINT '893'), 'TNNYCB1a0j', 'GuDxTbD5gv', TIMESTAMP '2023-12-08 16:28:30', 'xZdZsaXgE8'), ((BIGINT '524'), (BIGINT '949'), (BIGINT '126'), 'EFfU9Bcap9', 'cacPOmuhbj', TIMESTAMP '2023-12-08 16:28:11', 'rbAuqoGozG'), ((BIGINT '244'), (BIGINT '97'), (BIGINT '-9223372036854775808'), '1yfFbSYjca', 'Clnsfl59ao', TIMESTAMP '2023-12-08 16:29:22', 'P2eahMpC99'), ((BIGINT '9223372036854775807'), (BIGINT '326'), (BIGINT '440'), 'StET44zQBK', 'jpOWH1EmkN', TIMESTAMP '2023-12-08 16:29:17', 'W7NaNOJ8Hm'), ((BIGINT '551'), (BIGINT '810'), (BIGINT '415'), 'egcRATCyg4', 'bV8JwiDegl', TIMESTAMP '2023-12-07 16:29:23', 'OONwsVhHxn'), ((BIGINT '-2909140477172894830'), (BIGINT '-153083353703555203'), (BIGINT '-9223372036854775808'), 'jBqlWCYIVk', 'C8RRnhcUoh', TIMESTAMP '2023-12-08 16:29:19', 'xmqyx7OzN8'), ((BIGINT '1359359426285976580'), (BIGINT '945'), (BIGINT '945'), 'L6x6qQ5eM0', 'yJiu9D3xrp', TIMESTAMP '2023-12-08 16:28:15', 'vrzTIMyHEQ'), ((BIGINT '981'), (BIGINT '604'), (BIGINT '257'), 'p96lJatdxo', 'BCUX8vngqb', TIMESTAMP '2023-12-08 16:28:08', '5EiXIO4KQO'), ((BIGINT '459'), (BIGINT '360'), (BIGINT '392'), 'oZIySnVitb', 'fixpGuy2vl', TIMESTAMP '2023-12-08 16:29:23', '8e2T83ZH7N'), ((BIGINT '515'), (BIGINT '761'), (BIGINT '-7730907178661108712'), 'cX5aXmUDLV', 'tftD4ytSTe', TIMESTAMP '2023-12-08 16:29:10', 'uTENDXV1Pg'), ((BIGINT '338'), (BIGINT '995'), (BIGINT '-3574204657958977511'), 'lXElemrFGh', 'QYqlE5j7yM', TIMESTAMP '2023-12-08 16:28:48', '2HW9Z2nuJS'), ((BIGINT '719'), (BIGINT '708'), (BIGINT '622'), 'cXu2Fak9vt', 'fQIhj20cPs', TIMESTAMP '2023-12-08 16:29:01', 'TAjJFmakFj'), ((BIGINT '550'), (BIGINT '0'), (BIGINT '779'), 'hnpm6xOjcB', 'jhYQrJDte8', TIMESTAMP '2023-12-08 16:27:50', 'ERQdXr08gj'), ((BIGINT '556'), (BIGINT '466'), (BIGINT '0'), 'gymI0izPye', 'UANbblIKyq', TIMESTAMP '2023-12-08 16:28:07', 'oriBKiTNNF'), ((BIGINT '0'), (BIGINT '957'), (BIGINT '911'), '8F8940jEuk', '4yIoSxHLmW', TIMESTAMP '2023-12-08 16:28:42', '3y8iMd4kRf'), ((BIGINT '21'), (BIGINT '0'), (BIGINT '178'), 'A8mgMnVZcy', 'GOyaYNtDq9', TIMESTAMP '2023-12-08 16:29:23', 'gTsGFxQgR3'), ((BIGINT '674'), (BIGINT '639'), (BIGINT '9223372036854775807'), 'DjfF2S4uEk', 'RhdjMKihb0', TIMESTAMP '2023-12-08 16:28:06', '6HK21MSCAW'), ((BIGINT '209'), (BIGINT '9223372036854775807'), (BIGINT '-9223372036854775808'), 'Hp6v0gAOCJ', 'll5L2pz6XM', TIMESTAMP '2023-12-08 16:29:18', 'MDmYgDN5vO');
INSERT INTO alltypes1 VALUES (true, (SMALLINT '380'), (INT '532'), (BIGINT '997'), (REAL '935'), (FLOAT '-2147483648'), (610), DATE '2023-12-08', 'GLFPQHRJ3F', TIME '16:27:56', TIMESTAMP '2023-12-08 16:28:28', (INTERVAL '12'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '0'), (INT '80'), (INT '152')], ARRAY['JUeInCJKPw']), (true, (SMALLINT '1'), (INT '34'), (BIGINT '-9223372036854775808'), (REAL '243'), (FLOAT '56'), (259), DATE '2023-12-08', 'gl4uBGxmjh', TIME '16:29:14', TIMESTAMP '2023-12-08 15:29:23', (INTERVAL '-53'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '20'), (INT '17')], ARRAY['flfvDjfVGI']), (true, (SMALLINT '157'), (INT '732'), (BIGINT '0'), (REAL '114'), (FLOAT '795'), (166538482), DATE '2023-12-08', 'MNEnHyJr4p', TIME '16:29:23', TIMESTAMP '2023-12-08 16:29:17', (INTERVAL '57'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648'), (INT '402175295')], ARRAY['s3cRuXJy4u']), (true, (SMALLINT '-32768'), (INT '285'), (BIGINT '721'), (REAL '439'), (FLOAT '617'), (1081390591), DATE '2023-12-08', 'L5oqbtL1GC', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:13', (INTERVAL '57'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '265'), (INT '798'), (INT '111')], ARRAY['O2zfy42Ju4']), (false, (SMALLINT '8'), (INT '-2065943335'), (BIGINT '223'), (REAL '798'), (FLOAT '843'), (2147483647), DATE '2023-12-08', '467LKUTCnm', TIME '16:28:41', TIMESTAMP '2023-12-08 16:28:36', (INTERVAL '37'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '612'), (INT '395'), (INT '0'), (INT '124')], ARRAY['2bFG9cEgSk', 'mjaQQHBFhO', 'KhZpNHWASl']), (true, (SMALLINT '778'), (INT '480'), (BIGINT '806'), (REAL '344'), (FLOAT '630'), (148), DATE '2023-12-08', 'sVBxzGfAb3', TIME '16:29:11', TIMESTAMP '2023-12-08 16:28:11', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '723'), (INT '295')], ARRAY['0Q7atqCXQP']), (false, (SMALLINT '0'), (INT '756021369'), (BIGINT '298'), (REAL '42'), (FLOAT '1546082810'), (662), DATE '2023-12-08', 'ZNp9kkLoFB', TIME '16:28:23', TIMESTAMP '2023-12-08 16:28:10', (INTERVAL '5'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '669')], ARRAY['wvpCzNJIXP']), (false, (SMALLINT '741'), (INT '297'), (BIGINT '88'), (REAL '737'), (FLOAT '-2147483648'), (749), DATE '2023-12-08', 'RUhttenv5W', TIME '16:27:49', TIMESTAMP '2023-12-08 16:28:04', (INTERVAL '12'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-870710218'), (INT '1544415265'), (INT '214')], ARRAY['zTxVYEW1yc']), (true, (SMALLINT '830'), (INT '1'), (BIGINT '995'), (REAL '27'), (FLOAT '103'), (763), DATE '2023-12-08', '4mNi8cVRoj', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:02', (INTERVAL '-93'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '683')], ARRAY['aKHFHzN1hP', 'qIwKJk6o5G']), (false, (SMALLINT '953'), (INT '920'), (BIGINT '221'), (REAL '348'), (FLOAT '1'), (562), DATE '2023-12-08', 'TnxEzGJemF', TIME '16:28:31', TIMESTAMP '2023-12-01 16:29:23', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648'), (INT '815'), (INT '-2147483648'), (INT '583')], ARRAY['evx7cm08yr', 'pUhPRXoxz3', 'vr817cxbuT', '06f91aCeLd']), (true, (SMALLINT '978'), (INT '694'), (BIGINT '349'), (REAL '2147483647'), (FLOAT '-2147483648'), (914), DATE '2023-12-08', 'hYWLiHq2Ib', TIME '16:28:04', TIMESTAMP '2023-12-08 15:29:23', (INTERVAL '2'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '937'), (INT '303'), (INT '2147483647')], ARRAY['qheJ2Z2fAp']), (false, (SMALLINT '889'), (INT '288'), (BIGINT '477'), (REAL '322'), (FLOAT '134'), (76), DATE '2023-12-08', 'GFfToJALQn', TIME '16:29:22', TIMESTAMP '2023-12-08 16:28:08', (INTERVAL '-67'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647')], ARRAY['rjns6SlFSW']), (false, (SMALLINT '0'), (INT '66'), (BIGINT '17'), (REAL '683'), (FLOAT '516'), (56), DATE '2023-12-08', 'xcb60Fh5Fj', TIME '16:28:21', TIMESTAMP '2023-12-08 16:28:50', (INTERVAL '-6'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '756'), (INT '208')], ARRAY['as3KbBnG1J', 'FsYl1avbLX']), (false, (SMALLINT '332'), (INT '0'), (BIGINT '0'), (REAL '729'), (FLOAT '1100515869'), (268), DATE '2023-12-08', '1tVYRBD8IF', TIME '16:28:11', TIMESTAMP '2023-12-08 16:27:48', (INTERVAL '-91'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '175'), (INT '1'), (INT '-2147483648')], ARRAY['6rL9M85yJM', 'GAl2KsqvDV', 'BNtmG9y7i6', 'VfXn1ZKXmK']), (false, (SMALLINT '-30009'), (INT '395'), (BIGINT '794'), (REAL '398655203'), (FLOAT '1'), (616), DATE '2023-12-01', 'CFK5ZyWk74', TIME '16:28:03', TIMESTAMP '2023-12-08 16:28:43', (INTERVAL '-10'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '503'), (INT '981'), (INT '579'), (INT '2147483647')], ARRAY['cQXRPYT9BU', '6nqLb6U8fD']), (true, (SMALLINT '339'), (INT '204'), (BIGINT '586'), (REAL '720'), (FLOAT '922'), (2147483647), DATE '2023-12-08', 'sB9yz40C07', TIME '16:28:20', TIMESTAMP '2023-12-08 16:28:57', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '112'), (INT '582')], ARRAY['KKpcFFuo3F', 'VwSdKbKrHP']), (true, (SMALLINT '724'), (INT '860'), (BIGINT '4915287947902985573'), (REAL '230'), (FLOAT '2147483647'), (341), DATE '2023-12-08', 'RE46Pi1RMr', TIME '16:28:42', TIMESTAMP '2023-12-08 16:29:20', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '325'), (INT '0')], ARRAY['aV1PGlcRaP', 'vu0sMOKMvu', 'ZQZ6LY8rq7', 'RZLuDPy1Fk']), (false, (SMALLINT '589'), (INT '722'), (BIGINT '61'), (REAL '301'), (FLOAT '126'), (764), DATE '2023-12-08', 'ilxVt3szDf', TIME '16:28:55', TIMESTAMP '2023-12-08 16:28:27', (INTERVAL '11'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '990'), (INT '997')], ARRAY['eQQdNTlYd4', 'W6jXFRXyOQ', 'qZqCpwitmm']), (false, (SMALLINT '414'), (INT '368'), (BIGINT '341'), (REAL '903'), (FLOAT '889'), (331), DATE '2023-12-08', 'iZWkQkdd1H', TIME '16:28:09', TIMESTAMP '2023-12-08 16:29:22', (INTERVAL '92'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648'), (INT '591'), (INT '226'), (INT '2147483647')], ARRAY['YmyxDOQ1Mx', '2i0Hl8zQ96']), (true, (SMALLINT '933'), (INT '206'), (BIGINT '950'), (REAL '97'), (FLOAT '344'), (759), DATE '2023-12-01', 'CuOgWSZSr4', TIME '16:28:14', TIMESTAMP '2023-12-08 16:28:54', (INTERVAL '-47'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '974'), (INT '-1289160509')], ARRAY['SYkzTRhHs2', 'rTUEq0L9Vk', 'U53nAv2VgB', 'SlecGDGwfy']), (true, (SMALLINT '0'), (INT '0'), (BIGINT '767'), (REAL '1'), (FLOAT '258'), (165), DATE '2023-12-08', 't5oLt6QJOn', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:34', (INTERVAL '-24'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '0')], ARRAY['aYrZoDIy02', '2LFQRF3NyK', 'KHE4dd6FPD', 'GhWDsDLKx3']), (false, (SMALLINT '574'), (INT '243'), (BIGINT '125'), (REAL '335'), (FLOAT '664'), (874), DATE '2023-12-08', '1vfKpb4BZ7', TIME '15:29:23', TIMESTAMP '2023-12-08 16:29:11', (INTERVAL '-87'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '0'), (INT '562'), (INT '0')], ARRAY['f3zaYj8m2e', 'VaRjtkjqXF']), (true, (SMALLINT '1'), (INT '974'), (BIGINT '529'), (REAL '859059967'), (FLOAT '451'), (-2147483648), DATE '2023-12-08', 'y62SppnniS', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:07', (INTERVAL '-38'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '744'), (INT '-2147483648'), (INT '773')], ARRAY['oRU2TZtLbL', 'qBaeWZ8BkD', 'pJGqT6h5mz']), (true, (SMALLINT '-32768'), (INT '557'), (BIGINT '903'), (REAL '699'), (FLOAT '200'), (-2147483648), DATE '2023-12-08', '2BRWjV1TmS', TIME '16:29:20', TIMESTAMP '2023-12-08 16:28:33', (INTERVAL '-68'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '618'), (INT '161')], ARRAY['Xit0EGp2M7', 'dPchhzgeNy', 'fDqFP8trPN']), (false, (SMALLINT '804'), (INT '270'), (BIGINT '209'), (REAL '613348847'), (FLOAT '208'), (83), DATE '2023-12-08', 'dH4dF9jO29', TIME '16:28:14', TIMESTAMP '2023-12-08 16:28:51', (INTERVAL '-73'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '240'), (INT '545'), (INT '427')], ARRAY['acuJo4tl1n', 'Cqt3VQgLRh']), (false, (SMALLINT '324'), (INT '727'), (BIGINT '-8915114633009940666'), (REAL '587'), (FLOAT '515'), (562), DATE '2023-12-08', 'UMaKYjRSPY', TIME '16:28:19', TIMESTAMP '2023-12-08 16:28:37', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '732')], ARRAY['QzHRhuOxLm', 'ZXDSXmgrND', 'lmSZvJHjpJ', 'W8ADMyFFdT']), (false, (SMALLINT '628'), (INT '138'), (BIGINT '758'), (REAL '0'), (FLOAT '0'), (729), DATE '2023-12-08', '605ZS8QwCg', TIME '16:28:25', TIMESTAMP '2023-12-08 16:28:53', (INTERVAL '19'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '982'), (INT '840')], ARRAY['BVn7TQSaIO', 'RFcw1SLn98', 'kkBR0rEYH0']), (false, (SMALLINT '773'), (INT '370'), (BIGINT '9223372036854775807'), (REAL '151'), (FLOAT '160'), (0), DATE '2023-12-08', 'IsnuohOAlY', TIME '16:29:21', TIMESTAMP '2023-12-08 16:28:06', (INTERVAL '1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648'), (INT '905'), (INT '2147483647')], ARRAY['Lj3n5qK2LA', 'hx6EzsquYX']), (false, (SMALLINT '96'), (INT '0'), (BIGINT '116'), (REAL '382'), (FLOAT '480'), (109548712), DATE '2023-12-08', 'ihkiJALvK5', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:41', (INTERVAL '-56'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '121')], ARRAY['lHnTtos1ff']), (true, (SMALLINT '638'), (INT '2147483647'), (BIGINT '9223372036854775807'), (REAL '739'), (FLOAT '212'), (-2022349154), DATE '2023-12-08', '0BauFcotuY', TIME '16:28:35', TIMESTAMP '2023-12-07 16:29:23', (INTERVAL '-604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647')], ARRAY['ZnGtFyGaGk']), (false, (SMALLINT '74'), (INT '523'), (BIGINT '834'), (REAL '222'), (FLOAT '286'), (561), DATE '2023-12-07', 'BNG7OWAKjB', TIME '16:28:46', TIMESTAMP '2023-12-08 16:29:08', (INTERVAL '-57'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-458155996'), (INT '2147483647'), (INT '921'), (INT '0')], ARRAY['s4g5MRh6EE', 'Uh7SuPW6nv']), (false, (SMALLINT '-6038'), (INT '61'), (BIGINT '182'), (REAL '172'), (FLOAT '646'), (1320391830), DATE '2023-12-08', 'MgIh1tQeSS', TIME '16:29:23', TIMESTAMP '2023-12-08 16:29:22', (INTERVAL '-86'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '175')], ARRAY['tdkBpLDgsQ']), (false, (SMALLINT '0'), (INT '706'), (BIGINT '990'), (REAL '628'), (FLOAT '826'), (249), DATE '2023-12-08', 'OPQU1uERrB', TIME '16:28:17', TIMESTAMP '2023-12-08 16:28:52', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '215'), (INT '834'), (INT '1852785144'), (INT '1672108069')], ARRAY['vBFKozlh4X']), (true, (SMALLINT '799'), (INT '2147483647'), (BIGINT '420'), (REAL '1139115004'), (FLOAT '912'), (566), DATE '2023-12-08', '1I76Op3g8L', TIME '16:28:19', TIMESTAMP '2023-12-08 16:29:22', (INTERVAL '5'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '832'), (INT '869'), (INT '138477450'), (INT '271')], ARRAY['S8rlwvN4wi']), (false, (SMALLINT '438'), (INT '932'), (BIGINT '331'), (REAL '880'), (FLOAT '438604594'), (128), DATE '2023-12-08', 'IpUd9nbTS9', TIME '16:27:59', TIMESTAMP '2023-12-01 16:29:23', (INTERVAL '-24'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '437'), (INT '267'), (INT '96')], ARRAY['AAn555fQZV', 'TzrT6m4hSA']), (false, (SMALLINT '449'), (INT '-133686428'), (BIGINT '24'), (REAL '1614288109'), (FLOAT '176'), (999), DATE '2023-12-08', '65smQ4oCbX', TIME '16:28:23', TIMESTAMP '2023-12-08 16:29:01', (INTERVAL '-18'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '904')], ARRAY['aYNd5fGZX6', 'P01L3ODLTP', 'qfn0OClYGt']), (true, (SMALLINT '653'), (INT '-2147483648'), (BIGINT '600'), (REAL '278'), (FLOAT '440'), (650478894), DATE '2023-12-01', 'uyimjCnjDH', TIME '16:29:23', TIMESTAMP '2023-12-07 16:29:23', (INTERVAL '71'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '27'), (INT '178'), (INT '0')], ARRAY['5WiNRK5wpn', 'NfHqr9BW0Q', 'ONGhHSWodf', '9NsYtmBWyg']), (false, (SMALLINT '766'), (INT '26'), (BIGINT '1'), (REAL '710'), (FLOAT '460'), (655), DATE '2023-12-08', 'cPelfzkGnJ', TIME '16:29:22', TIMESTAMP '2023-12-08 16:29:05', (INTERVAL '28'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '0'), (INT '986')], ARRAY['tE19kY6Wag', 'NWFvNOFah5', 'sYXbxtoQDe', 'QZrpaQnRPm']), (false, (SMALLINT '11563'), (INT '267'), (BIGINT '141'), (REAL '789'), (FLOAT '253'), (320), DATE '2023-12-08', 'C6Wdl4CQS3', TIME '16:27:50', TIMESTAMP '2023-12-08 16:28:18', (INTERVAL '-21'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '251')], ARRAY['5iq9JbsMvl']), (false, (SMALLINT '256'), (INT '822'), (BIGINT '0'), (REAL '231'), (FLOAT '550'), (-2147483648), DATE '2023-12-08', 'YpaYhQbrYO', TIME '16:29:23', TIMESTAMP '2023-12-08 15:29:23', (INTERVAL '0'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-495865023'), (INT '307')], ARRAY['7eT4bXcmfk', 'QvnW6x8RZ2']), (false, (SMALLINT '953'), (INT '0'), (BIGINT '615'), (REAL '910'), (FLOAT '518'), (-2147483648), DATE '2023-12-08', '5My22NmNGK', TIME '16:28:03', TIMESTAMP '2023-12-08 16:28:19', (INTERVAL '-60'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '689')], ARRAY['FBpL5DIXKX']), (true, (SMALLINT '-21433'), (INT '898'), (BIGINT '697'), (REAL '274'), (FLOAT '521'), (0), DATE '2023-12-08', '0xjCBAzsWV', TIME '16:27:49', TIMESTAMP '2023-12-01 16:29:23', (INTERVAL '42'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '319'), (INT '6')], ARRAY['VWV6M2C2Qg', 'hoSqywmy2G', 'KgCePmJrV4', '1bGbPuMRrc']), (false, (SMALLINT '994'), (INT '305'), (BIGINT '53'), (REAL '978'), (FLOAT '20'), (65), DATE '2023-12-08', 'pLrV1sdW71', TIME '16:29:09', TIMESTAMP '2023-12-08 15:29:23', (INTERVAL '33'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '123'), (INT '968'), (INT '96')], ARRAY['pTxsqgMJEo', '6RNZb5OQ8L', 'Nt4UarpLJT', 'pgRoYnemuw']), (false, (SMALLINT '-32768'), (INT '307'), (BIGINT '9223372036854775807'), (REAL '-2147483648'), (FLOAT '-2147483648'), (731), DATE '2023-12-08', 'DtpEYMX2lo', TIME '15:29:23', TIMESTAMP '2023-12-08 16:29:13', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '907'), (INT '381'), (INT '298'), (INT '36')], ARRAY['9gd7qN86Wl', '9vCDdWxLl7', 'gFnaWyIaME', 'RiMW7P7BBw']), (true, (SMALLINT '381'), (INT '-2147483648'), (BIGINT '682'), (REAL '474'), (FLOAT '2147483647'), (995), DATE '2023-12-08', 'aU0TRS4ivP', TIME '15:29:23', TIMESTAMP '2023-12-08 15:29:23', (INTERVAL '-63'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1963754750'), (INT '885')], ARRAY['IoN8RWhBE0', '8YMjdkrhl9']), (true, (SMALLINT '81'), (INT '560'), (BIGINT '168'), (REAL '1'), (FLOAT '785'), (661), DATE '2023-12-08', 'qv9XRnKcSo', TIME '15:29:23', TIMESTAMP '2023-12-07 16:29:23', (INTERVAL '65'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647'), (INT '40'), (INT '408'), (INT '854')], ARRAY['CgmvTOB9AI']), (false, (SMALLINT '1'), (INT '949'), (BIGINT '326'), (REAL '109'), (FLOAT '294'), (541), DATE '2023-12-08', 'ZVa2byomCp', TIME '16:28:49', TIMESTAMP '2023-12-08 16:28:30', (INTERVAL '87'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '753'), (INT '224'), (INT '973'), (INT '100')], ARRAY['PZ1KQHFOLE', 'r4tHOYDXEb']), (true, (SMALLINT '998'), (INT '-1902108418'), (BIGINT '552'), (REAL '1501971153'), (FLOAT '291'), (465), DATE '2023-12-08', 'Bd36HXIclA', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:54', (INTERVAL '21'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '69588191'), (INT '2'), (INT '248')], ARRAY['8VYWOFoJY1', 'Q6KoQgPxeP', 'AW89IPqUMP', 'o8MTkFpNqd']), (true, (SMALLINT '610'), (INT '150'), (BIGINT '476'), (REAL '1'), (FLOAT '229'), (853), DATE '2023-12-08', 'tuigtXchJU', TIME '16:29:11', TIMESTAMP '2023-12-08 16:28:15', (INTERVAL '-20'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '674'), (INT '97')], ARRAY['F6mEwJw1Wu', 'piGy2rRNSl', 'C0BDauEOx9', 'Up4uqDM6pU']), (false, (SMALLINT '727'), (INT '47'), (BIGINT '-4752320870506925502'), (REAL '884'), (FLOAT '237'), (524), DATE '2023-12-08', 'sQOR9pjYb4', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:12', (INTERVAL '-11'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '1243235551'), (INT '2147483647')], ARRAY['hPwYYJ3jz3']);
INSERT INTO alltypes2 VALUES (true, (SMALLINT '472'), (INT '0'), (BIGINT '712'), (REAL '1'), (FLOAT '-1672817713'), (1), DATE '2023-12-08', 'cnLa0KmpTb', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:03', (INTERVAL '30'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '794'), (INT '916'), (INT '254'), (INT '791')], ARRAY['qDeiPjvKUj', 'EZmHVITFa1', 'SBuTJBMc6A', 'WEpiNBPlVe']), (false, (SMALLINT '94'), (INT '774'), (BIGINT '400'), (REAL '20'), (FLOAT '944'), (78), DATE '2023-12-08', 'TFog3pM4Yk', TIME '16:29:18', TIMESTAMP '2023-12-01 16:29:23', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '358'), (INT '32'), (INT '-2147483648'), (INT '1')], ARRAY['1ebDUrYnFo']), (true, (SMALLINT '32767'), (INT '836'), (BIGINT '-7471526056623320822'), (REAL '302'), (FLOAT '0'), (499), DATE '2023-12-08', 'rx5wa4QnsX', TIME '15:29:23', TIMESTAMP '2023-12-08 16:29:04', (INTERVAL '-32'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1311081206')], ARRAY['YouPdjk8kr', 'JEd2JiWIOo']), (false, (SMALLINT '757'), (INT '39804641'), (BIGINT '269'), (REAL '456'), (FLOAT '0'), (401), DATE '2023-12-07', 'II5tlR4qwQ', TIME '16:28:23', TIMESTAMP '2023-12-08 16:28:22', (INTERVAL '83'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648'), (INT '365'), (INT '-2147483648')], ARRAY['ke8zGHWHBZ', '9Bn5jP6pGG', '4VDUH1cj2R', 'XZGBqYDeJ6']), (false, (SMALLINT '514'), (INT '975'), (BIGINT '364'), (REAL '0'), (FLOAT '601'), (1), DATE '2023-12-08', 'MkuWMIHon5', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:57', (INTERVAL '1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '677')], ARRAY['7QOo0AVw7N', 'LaGbdbqf7H', 'vrVcyj0YZa', 'biYdwlSb27']), (false, (SMALLINT '32767'), (INT '210'), (BIGINT '4592304243033568628'), (REAL '804'), (FLOAT '970'), (0), DATE '2023-12-08', 'AxR03CawGe', TIME '16:29:22', TIMESTAMP '2023-12-08 16:27:55', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-1505943159'), (INT '498'), (INT '636')], ARRAY['82uzSwBLst', 'ov5MMSaIwL', 'ffKubA4sGa', 'nFQEkgnBXt']), (false, (SMALLINT '-32768'), (INT '202'), (BIGINT '278'), (REAL '49'), (FLOAT '287'), (-498586439), DATE '2023-12-08', '621agkBxmg', TIME '16:28:12', TIMESTAMP '2023-12-08 16:28:17', (INTERVAL '72'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '-705744241'), (INT '1'), (INT '-2147483648')], ARRAY['sAyXcj3Jp8', 'P0RzrW2LU8', 'PyFjrVkGe2', '80LLQduCgI']), (true, (SMALLINT '0'), (INT '527'), (BIGINT '657'), (REAL '378'), (FLOAT '432'), (2147483647), DATE '2023-12-08', 'DTyksYhc1M', TIME '16:28:15', TIMESTAMP '2023-12-08 16:28:18', (INTERVAL '62'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-1933125925'), (INT '997')], ARRAY['2zuDBYjaFg']), (false, (SMALLINT '162'), (INT '557'), (BIGINT '308'), (REAL '956'), (FLOAT '879'), (2147483647), DATE '2023-12-01', 'g9FnqsWYzh', TIME '16:27:44', TIMESTAMP '2023-12-08 16:29:07', (INTERVAL '-11'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '853'), (INT '641'), (INT '355')], ARRAY['syc5qMhlZc', 'TJJBzAbWkI']), (false, (SMALLINT '25'), (INT '2147483647'), (BIGINT '396'), (REAL '1'), (FLOAT '380'), (1), DATE '2023-12-08', 'kuw5SWpn4l', TIME '16:28:13', TIMESTAMP '2023-12-08 15:29:23', (INTERVAL '-604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-143881315'), (INT '-2147483648'), (INT '1181493799'), (INT '281')], ARRAY['rmHs09mfxs']), (false, (SMALLINT '917'), (INT '698'), (BIGINT '9223372036854775807'), (REAL '-1048793690'), (FLOAT '303'), (137), DATE '2023-12-08', 'hCHLsIh3RP', TIME '16:29:23', TIMESTAMP '2023-12-08 16:29:15', (INTERVAL '-94'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '879'), (INT '692'), (INT '366'), (INT '216')], ARRAY['cDtjwQRJSr']), (false, (SMALLINT '530'), (INT '698'), (BIGINT '113'), (REAL '572'), (FLOAT '1822501410'), (677), DATE '2023-12-08', 'jC8EaIBmfW', TIME '16:27:57', TIMESTAMP '2023-12-08 16:29:23', (INTERVAL '-54'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '123')], ARRAY['fIPT5NIywm', 'cSId7FTcae', 'OA8eNJ8sFv']), (false, (SMALLINT '721'), (INT '390'), (BIGINT '381'), (REAL '550'), (FLOAT '786'), (708), DATE '2023-12-07', '1u9G37db7e', TIME '16:28:01', TIMESTAMP '2023-12-08 16:28:15', (INTERVAL '62'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '712'), (INT '-2147483648'), (INT '2147483647')], ARRAY['dFlv2AEXMm', 'JA5VXVPYtU']), (false, (SMALLINT '0'), (INT '771'), (BIGINT '469'), (REAL '779'), (FLOAT '1166155289'), (216), DATE '2023-12-08', 'qrvuomXadb', TIME '16:29:23', TIMESTAMP '2023-12-08 16:29:03', (INTERVAL '-99'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '569'), (INT '954')], ARRAY['fEBtZiQ2pl', 'ntpl7VoQKp', 'pc93pueyLr', 'n9KuuRjEXx']), (true, (SMALLINT '1'), (INT '722'), (BIGINT '898'), (REAL '1'), (FLOAT '105'), (473), DATE '2023-12-08', 'C80yVr3M8e', TIME '15:29:23', TIMESTAMP '2023-12-08 16:29:22', (INTERVAL '2'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '897')], ARRAY['082kjSqnDH']), (true, (SMALLINT '319'), (INT '-338617431'), (BIGINT '-9223372036854775808'), (REAL '126'), (FLOAT '169'), (859), DATE '2023-12-08', 'hdcCryPMDn', TIME '15:29:23', TIMESTAMP '2023-12-08 16:28:37', (INTERVAL '-67'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1')], ARRAY['DLTaRR4HGK', 'RgZBZeDmBI', 'DixDUl5BNu', 'hZHz3tffkj']), (true, (SMALLINT '11580'), (INT '269'), (BIGINT '2768945042330826240'), (REAL '940'), (FLOAT '314918680'), (1677009105), DATE '2023-12-08', '0ysCeQ6Cg2', TIME '16:28:51', TIMESTAMP '2023-12-08 16:28:55', (INTERVAL '30'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '205'), (INT '10')], ARRAY['jCjsZfAsfL', 'fIpBCm8iTm', 'BELFqCyWbR']), (false, (SMALLINT '32767'), (INT '738'), (BIGINT '733'), (REAL '84'), (FLOAT '-2147483648'), (380), DATE '2023-12-08', 'ydWDQuRlaB', TIME '16:28:58', TIMESTAMP '2023-12-08 16:29:23', (INTERVAL '87'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-847909574')], ARRAY['wXfG25852r', '2p3aWQOvEs', 'VSrepEIRJH']), (true, (SMALLINT '0'), (INT '247'), (BIGINT '577'), (REAL '349'), (FLOAT '-2147483648'), (1), DATE '2023-12-08', 'CrDk0HaDBX', TIME '15:29:23', TIMESTAMP '2023-12-08 16:29:08', (INTERVAL '55'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '796'), (INT '-1924567806'), (INT '101')], ARRAY['5IRIys1qOq', 'KiWxLhPZWm', 'YDSwggDiSD']), (false, (SMALLINT '415'), (INT '908'), (BIGINT '390'), (REAL '30'), (FLOAT '621'), (186), DATE '2023-12-08', 'namutFZjTW', TIME '16:28:51', TIMESTAMP '2023-12-08 16:28:08', (INTERVAL '-15'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648')], ARRAY['J66IvsWQEJ']), (false, (SMALLINT '1'), (INT '0'), (BIGINT '-1395375474639926757'), (REAL '2147483647'), (FLOAT '0'), (-2147483648), DATE '2023-12-08', 'FZpe9jQy8C', TIME '16:28:11', TIMESTAMP '2023-12-08 16:29:02', (INTERVAL '-94'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '998')], ARRAY['2HoJUmHUZ2', '4oV2wAdzXh', 'LJxhgnYhlV', 'j8lFnefbDM']), (false, (SMALLINT '936'), (INT '758'), (BIGINT '706'), (REAL '101'), (FLOAT '681886374'), (0), DATE '2023-12-08', 'SYrwKXabVF', TIME '16:27:51', TIMESTAMP '2023-12-08 16:28:18', (INTERVAL '49'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '638')], ARRAY['awSkKOBy04', 'hviLFpPtrg', 'Q7TTE0Nas9']), (false, (SMALLINT '423'), (INT '-52102090'), (BIGINT '910'), (REAL '0'), (FLOAT '949'), (467), DATE '2023-12-08', 'TSqoBJgqjv', TIME '16:28:21', TIMESTAMP '2023-12-08 16:28:26', (INTERVAL '-23'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '241'), (INT '1895250995'), (INT '537'), (INT '6')], ARRAY['XOTSCXthJB']), (false, (SMALLINT '158'), (INT '429'), (BIGINT '9223372036854775807'), (REAL '427'), (FLOAT '769'), (2147483647), DATE '2023-12-07', 'IZi2we4yRt', TIME '16:28:58', TIMESTAMP '2023-12-08 16:29:23', (INTERVAL '41'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '0'), (INT '0')], ARRAY['SanmLOXPsi', 'OZ5SJuvVPG', 'O7RziysOVB']), (false, (SMALLINT '21274'), (INT '27'), (BIGINT '399'), (REAL '800'), (FLOAT '797'), (0), DATE '2023-12-08', 'iy3e28Skmt', TIME '16:29:23', TIMESTAMP '2023-12-08 16:27:51', (INTERVAL '-19'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '9')], ARRAY['B8OUiTS7BZ', '286bRdBae7', 'hyiY8uvTpT', 'iGmpyBN7eZ']), (true, (SMALLINT '32767'), (INT '239'), (BIGINT '374'), (REAL '468'), (FLOAT '-1567150111'), (1), DATE '2023-12-08', 'MAg61mQEtY', TIME '16:29:02', TIMESTAMP '2023-12-01 16:29:23', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '983'), (INT '1'), (INT '-1750849684'), (INT '628')], ARRAY['oB2Q1l1GE9', 'JtlcHg5NTC', '18ubxSfI9Z', '0pheJ2I9py']), (true, (SMALLINT '0'), (INT '954'), (BIGINT '988'), (REAL '607'), (FLOAT '680'), (172), DATE '2023-12-08', 'FhUocd5CwC', TIME '16:29:13', TIMESTAMP '2023-12-08 16:28:45', (INTERVAL '71'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '229'), (INT '32')], ARRAY['OapYY1FGHZ']), (false, (SMALLINT '32767'), (INT '608'), (BIGINT '271'), (REAL '601'), (FLOAT '423'), (686), DATE '2023-12-08', 'MDF3Vc66yi', TIME '16:28:03', TIMESTAMP '2023-12-08 16:28:52', (INTERVAL '9'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1'), (INT '53'), (INT '533')], ARRAY['YgRRDVtLFN']), (true, (SMALLINT '-4191'), (INT '367875418'), (BIGINT '952'), (REAL '955044755'), (FLOAT '690'), (107), DATE '2023-12-08', 'GXjgQyYxzM', TIME '16:29:20', TIMESTAMP '2023-12-08 16:29:22', (INTERVAL '-45'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '852'), (INT '592700105'), (INT '1'), (INT '2147483647')], ARRAY['ugrYgaBshr', 'DQ8OlJkYXf', '9F4FvpImcf']), (false, (SMALLINT '977'), (INT '12'), (BIGINT '2914170483450689188'), (REAL '860'), (FLOAT '510'), (818), DATE '2023-12-08', 'V3mcI5sf3L', TIME '16:27:58', TIMESTAMP '2023-12-08 16:28:59', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '316'), (INT '481'), (INT '707'), (INT '399')], ARRAY['7AOuit8hdY']), (true, (SMALLINT '653'), (INT '320'), (BIGINT '626'), (REAL '817'), (FLOAT '122'), (80), DATE '2023-12-08', '6eEq72rjh1', TIME '16:29:23', TIMESTAMP '2023-12-08 16:27:49', (INTERVAL '-16'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '205'), (INT '374')], ARRAY['k5MBUlJlCs']), (false, (SMALLINT '7'), (INT '404'), (BIGINT '917'), (REAL '588'), (FLOAT '872'), (842), DATE '2023-12-07', '56lOe1i1li', TIME '16:29:23', TIMESTAMP '2023-12-08 16:28:54', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '218578191'), (INT '0'), (INT '2147483647'), (INT '859')], ARRAY['ntDp4RIqSA']), (false, (SMALLINT '741'), (INT '615'), (BIGINT '761'), (REAL '623'), (FLOAT '457'), (663), DATE '2023-12-01', 'OFsoDSEgAm', TIME '16:28:47', TIMESTAMP '2023-12-08 16:29:17', (INTERVAL '43'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '634'), (INT '498'), (INT '582')], ARRAY['57WInNuGlk']), (true, (SMALLINT '320'), (INT '2147483647'), (BIGINT '734'), (REAL '915'), (FLOAT '853'), (0), DATE '2023-12-08', 'pgVMHwIomc', TIME '16:29:22', TIMESTAMP '2023-12-08 16:28:07', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '1703626629'), (INT '-1219337001'), (INT '0'), (INT '0')], ARRAY['1crteQ5POA', '5fJbo8duTW', 'mfufLNpwgM']), (true, (SMALLINT '694'), (INT '349'), (BIGINT '0'), (REAL '982'), (FLOAT '304626711'), (2147483647), DATE '2023-12-08', 'fz9dXtvX9g', TIME '16:28:56', TIMESTAMP '2023-12-08 16:29:01', (INTERVAL '58'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '246')], ARRAY['xuua15Wx0P', 'VoL1ZRAPox']), (true, (SMALLINT '907'), (INT '2147483647'), (BIGINT '312'), (REAL '1'), (FLOAT '400'), (2147483647), DATE '2023-12-08', 'B0gCUHBwpB', TIME '16:29:23', TIMESTAMP '2023-12-08 16:29:23', (INTERVAL '-40'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '168')], ARRAY['2VDVWfH4m9', '79pPO6nm3U']), (false, (SMALLINT '719'), (INT '278'), (BIGINT '0'), (REAL '838'), (FLOAT '485'), (-2147483648), DATE '2023-12-08', 'RmcSOksC5f', TIME '16:28:29', TIMESTAMP '2023-12-08 16:28:24', (INTERVAL '-8'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647'), (INT '622'), (INT '564693729'), (INT '655')], ARRAY['JfbjZke69e']), (false, (SMALLINT '6'), (INT '866'), (BIGINT '502'), (REAL '468'), (FLOAT '-2147483648'), (-994260986), DATE '2023-12-08', 'pYUagRduub', TIME '16:28:07', TIMESTAMP '2023-12-08 16:27:55', (INTERVAL '-9'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '662')], ARRAY['36LEU7kwkC', 'lhnG6OTKxh']), (true, (SMALLINT '585'), (INT '401'), (BIGINT '565'), (REAL '670'), (FLOAT '770'), (-2147483648), DATE '2023-12-01', 'dsd0kvx0SD', TIME '16:28:23', TIMESTAMP '2023-12-08 16:29:10', (INTERVAL '86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-422817247'), (INT '109'), (INT '272'), (INT '589')], ARRAY['tcjziUkDMZ', 'CLtVs0YkYn', 'TUe2I05BjP']), (true, (SMALLINT '588'), (INT '831'), (BIGINT '621'), (REAL '947'), (FLOAT '671'), (1), DATE '2023-12-08', 'xZifGhoMoC', TIME '16:28:59', TIMESTAMP '2023-12-08 16:27:53', (INTERVAL '0'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '308'), (INT '102')], ARRAY['jL2CUPcQ2U', 'xFocpKrXQP', 'BH9kW0OCto', 'ebpdA2tsdD']), (true, (SMALLINT '32767'), (INT '0'), (BIGINT '267'), (REAL '184'), (FLOAT '544'), (1456303532), DATE '2023-12-08', 'AGMVAIk8mC', TIME '15:29:23', TIMESTAMP '2023-12-01 16:29:23', (INTERVAL '-1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '116'), (INT '741')], ARRAY['SUyYsxWD8S', '7IZs3wnqjG']), (false, (SMALLINT '32767'), (INT '113'), (BIGINT '591479099740976779'), (REAL '44'), (FLOAT '1'), (-2147483648), DATE '2023-12-08', 'yStwtbZZTX', TIME '16:29:20', TIMESTAMP '2023-12-08 16:27:54', (INTERVAL '79'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '-2147483648')], ARRAY['JmNgDwEW4D']), (false, (SMALLINT '967'), (INT '608'), (BIGINT '330'), (REAL '641'), (FLOAT '725'), (0), DATE '2023-12-08', 'JwiwvT3YQN', TIME '15:29:23', TIMESTAMP '2023-12-08 16:28:44', (INTERVAL '94'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '552'), (INT '347'), (INT '1')], ARRAY['9bQOb1gXL2']), (false, (SMALLINT '0'), (INT '300'), (BIGINT '744'), (REAL '3'), (FLOAT '942'), (2147483647), DATE '2023-12-08', 'HRHvxvyhil', TIME '16:29:23', TIMESTAMP '2023-12-08 16:27:57', (INTERVAL '-96'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '484')], ARRAY['FoC5qXDgq5', 'pjLz4nDKhR', 'DQVHtDHipz']), (false, (SMALLINT '817'), (INT '-1168316912'), (BIGINT '384'), (REAL '741'), (FLOAT '528'), (111), DATE '2023-12-08', 'W9ljTveWH0', TIME '16:28:23', TIMESTAMP '2023-12-08 16:28:48', (INTERVAL '-79'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '451'), (INT '278')], ARRAY['j7QfwSHJy1']), (false, (SMALLINT '220'), (INT '203'), (BIGINT '274'), (REAL '167'), (FLOAT '444'), (223), DATE '2023-12-08', 'wPgvo9NicW', TIME '16:29:22', TIMESTAMP '2023-12-08 16:29:22', (INTERVAL '1'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '20')], ARRAY['z4nqZdtRQT', 't6rwkjKCFA', '1CvhddYIST', 'yaxINrD7sB']), (true, (SMALLINT '916'), (INT '743'), (BIGINT '9223372036854775807'), (REAL '201'), (FLOAT '128'), (316), DATE '2023-12-08', 'VCGMg18TCY', TIME '16:28:37', TIMESTAMP '2023-12-08 16:28:23', (INTERVAL '-36'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '548')], ARRAY['AYvzArHkzv']), (true, (SMALLINT '-32768'), (INT '806'), (BIGINT '610'), (REAL '-522766823'), (FLOAT '532'), (462), DATE '2023-12-08', 'Lz4wJTTLuH', TIME '16:28:00', TIMESTAMP '2023-12-08 16:27:52', (INTERVAL '-86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '713'), (INT '707'), (INT '837533691')], ARRAY['6pVmePk8JT', 'IRKQbFfOKb', 'aEYUklE1zL', 'FCGAIqH7rc']), (false, (SMALLINT '0'), (INT '1335286864'), (BIGINT '1224473797201582202'), (REAL '203'), (FLOAT '447'), (252), DATE '2023-12-08', 'XxhuhkIkfG', TIME '16:29:02', TIMESTAMP '2023-12-08 16:28:23', (INTERVAL '-86400'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '57'), (INT '110')], ARRAY['7Ebzv4UDoD', '0UJyrg5SoF', 'QHx5BPU92A']), (false, (SMALLINT '579'), (INT '981'), (BIGINT '5429967520614636162'), (REAL '425'), (FLOAT '845'), (990), DATE '2023-12-08', 'd1UwFmsa7F', TIME '16:28:13', TIMESTAMP '2023-12-08 16:28:15', (INTERVAL '-3600'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '58'), (INT '160'), (INT '799'), (INT '850')], ARRAY['komEa4y1zX', 'CA1u7AMguU', 'YqfVZ5bUmk', 'bl035g3ZQD']);
INSERT INTO alltypes1 VALUES (false, (SMALLINT '954'), (INT '-2147483648'), (BIGINT '141'), (REAL '145'), (FLOAT '-1501069800'), (1), DATE '2023-12-08', 'DjGbYoo5HO', TIME '16:28:35', TIMESTAMP '2023-12-08 16:28:35', (INTERVAL '604800'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '582'), (INT '2147483647')], ARRAY['Xapi7mzYX2']), (true, (SMALLINT '1'), (INT '-1439924981'), (BIGINT '426'), (REAL '198'), (FLOAT '729'), (748), DATE '2023-12-08', 'MkiN9OJm14', TIME '16:28:19', TIMESTAMP '2023-12-08 16:28:03', (INTERVAL '6'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '545'), (INT '806'), (INT '181')], ARRAY['bDFLwjPFuQ', 'tRjO63pHd4', 'E7GVUY48iH']), (true, (SMALLINT '110'), (INT '673'), (BIGINT '435'), (REAL '606'), (FLOAT '-2147483648'), (596), DATE '2023-12-08', 'eStJS3ur8P', TIME '16:29:29', TIMESTAMP '2023-12-08 15:29:35', (INTERVAL '75'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '565'), (INT '0'), (INT '672')], ARRAY['4GCBnlEXZB', 'lC9RPErCE7']), (false, (SMALLINT '-25351'), (INT '651'), (BIGINT '794'), (REAL '330'), (FLOAT '1'), (733), DATE '2023-12-07', 'kBvZZW5SgG', TIME '16:29:04', TIMESTAMP '2023-12-08 16:27:59', (INTERVAL '56'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '2147483647'), (INT '272')], ARRAY['CGNSiI2htn', '0WbtVYsRcU']), (false, (SMALLINT '700'), (INT '108'), (BIGINT '290'), (REAL '705'), (FLOAT '2147483647'), (2147483647), DATE '2023-12-08', 'SO6zXEoAIE', TIME '16:28:44', TIMESTAMP '2023-12-08 16:29:28', (INTERVAL '-29'), CAST(NULL AS STRUCT<a INT>), ARRAY[(INT '505'), (INT '113'), (INT '390'), (INT '410')], ARRAY['TrhOgeLeAf', 'W3VtCNMs48']);
-- SET RW_FORCE_TWO_PHASE_AGG = true;
CREATE MATERIALIZED VIEW stream_query AS
SELECT
    ((tumble_0.reserve | ((SMALLINT '901') - (SMALLINT '32767'))) * (INTERVAL '53')) AS col_0,
    ((SMALLINT '309') # tumble_0.reserve) AS col_1,
    tumble_0.reserve AS col_2,
    ((SMALLINT '689') | tumble_0.seller) AS col_3
FROM (tumble (auction, auction.date_time, INTERVAL '14') AS tumble_0
    LEFT JOIN m10 AS t_1 ON tumble_0.reserve = t_1.col_0
        AND (coalesce(NULL, NULL, NULL, NULL, NULL, NULL, FALSE, NULL, NULL, NULL)))
    FULL JOIN partsupp AS t_2 ON tumble_0.description = t_2.ps_comment
        AND CAST(t_2.ps_partkey AS boolean)
GROUP BY
    tumble_0.expires,
    tumble_0.reserve,
    tumble_0.initial_bid,
    tumble_0.seller,
    t_2.ps_comment
HAVING
    FALSE;

@kwannoel kwannoel self-assigned this Dec 15, 2023
@kwannoel
Copy link
Contributor Author

Before constant folding

 StreamProject { exprs: [((auction.reserve | (901:Int16 - 32767:Int16)) * '00:00:53':Interval) as $expr1, (309:Int16 # auction.reserve) as $expr2, auction.reserv
e, (689:Int16 | auction.seller) as $expr3, auction.expires, auction.initial_bid, auction.seller, partsupp.ps_comment] }
 └─StreamHashAgg { group_key: [auction.expires, auction.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment], aggs: [count] }
   └─StreamExchange { dist: HashShard(auction.expires, auction.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment) }
     └─StreamFilter { predicate: false:Boolean }
       └─StreamFilter { predicate: (((((((IsNotNull(auction.id) OR IsNotNull(m10.bid.extra)) OR IsNotNull(m10.col_1)) OR IsNotNull(m10.m0.col_2)) OR IsNotNull(m1
0.m0.col_3)) OR IsNotNull(auction.reserve)) OR IsNotNull(partsupp.ps_partkey)) OR IsNotNull(partsupp.ps_suppkey)) }
         └─StreamHashJoin { type: FullOuter, predicate: auction.description = partsupp.ps_comment AND partsupp.ps_partkey::Boolean, output: [auction.expires, auc
tion.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment, auction.id, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3, auction.description, pa
rtsupp.ps_partkey, partsupp.ps_suppkey], stream_key: [auction.id, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3, auction.reserve, partsupp.ps_partkey, par
tsupp.ps_suppkey, auction.description, partsupp.ps_comment] }
           ├─StreamExchange { dist: HashShard(auction.description) }
           │ └─StreamHashJoin { type: LeftOuter, predicate: auction.reserve = m10.col_0 AND Coalesce(null:Boolean, null:Boolean, null:Boolean, null:Boolean, null
:Boolean, null:Boolean, false:Boolean, null:Boolean, null:Boolean, null:Boolean), output: [auction.description, auction.initial_bid, auction.reserve, auction.exp
ires, auction.seller, auction.id, m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3], stream_key: [auction.id, m10.bid.extra, m10.col_1, m10.m0.col
_2, m10.m0.col_3, auction.reserve] }
           │   ├─StreamExchange { dist: HashShard(auction.reserve) }
           │   │ └─StreamTableScan { table: auction, columns: [auction.description, auction.initial_bid, auction.reserve, auction.expires, auction.seller, auctio
n.id], pk: [auction.id], dist: UpstreamHashShard(auction.id) }
           │   └─StreamExchange { dist: HashShard(m10.col_0) }
           │     └─StreamTableScan { table: m10, columns: [m10.col_0, m10.m0.col_2, m10.bid.extra, m10.col_1, m10.m0.col_3], pk: [m10.col_0, m10.bid.extra, m10.c
ol_1, m10.m0.col_2, m10.m0.col_3], dist: Single }
           └─StreamExchange { dist: HashShard(partsupp.ps_comment) }
             └─StreamTableScan { table: partsupp, columns: [partsupp.ps_partkey, partsupp.ps_comment, partsupp.ps_suppkey], pk: [partsupp.ps_partkey, partsupp.ps
_suppkey], dist: UpstreamHashShard(partsupp.ps_partkey, partsupp.ps_suppkey) }

After constant folding

 
 StreamProject { exprs: [((auction.reserve | -31866:Int16) * '00:00:53':Interval) as $expr1, (309:Int16 # auction.reserve) as $expr2, auction.reserve, (689:Int16
 | auction.seller) as $expr3, auction.expires, auction.initial_bid, auction.seller, partsupp.ps_comment] }
 └─StreamHashAgg { group_key: [auction.expires, auction.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment], aggs: [count] }
   └─StreamExchange { dist: HashShard(auction.expires, auction.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment) }
     └─StreamFilter { predicate: false:Boolean }
       └─StreamFilter { predicate: (((((((IsNotNull(auction.id) OR IsNotNull(m10.bid.extra)) OR IsNotNull(m10.col_1)) OR IsNotNull(m10.m0.col_2)) OR IsNotNull(m10.m0.col_3)) OR IsNotNull(auction.reserve)) OR IsNotNull(partsupp.ps_partkey)) OR IsNotNull(partsupp.ps_suppkey)) }
         └─StreamHashJoin { type: FullOuter, predicate: auction.description = partsupp.ps_comment AND partsupp.ps_partkey::Boolean, output: [auction.expires, auction.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment, auction.id, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3, auction.description, partsupp.ps_partkey, partsupp.ps_suppkey], stream_key: None }
           ├─StreamExchange { dist: HashShard(auction.description) }
           │ └─StreamHashJoin { type: LeftOuter, predicate: auction.reserve = m10.col_0 AND false:Boolean, output: [auction.description, auction.initial_bid, auction.reserve, auction.expires, auction.seller, auction.id, m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3], stream_key: [auction.id, m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3] }
           │   ├─StreamExchange { dist: HashShard(auction.reserve) }
           │   │ └─StreamTableScan { table: auction, columns: [auction.description, auction.initial_bid, auction.reserve, auction.expires, auction.seller, auction.id], pk: [auction.id], dist: UpstreamHashShard(auction.id) }
           │   └─StreamExchange { dist: HashShard(m10.col_0) }
           │     └─StreamTableScan { table: m10, columns: [m10.col_0, m10.m0.col_2, m10.bid.extra, m10.col_1, m10.m0.col_3], pk: [m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3], dist: Single }
           └─StreamExchange { dist: HashShard(partsupp.ps_comment) }
             └─StreamTableScan { table: partsupp, columns: [partsupp.ps_partkey, partsupp.ps_comment, partsupp.ps_suppkey], pk: [partsupp.ps_partkey, partsupp.ps_suppkey], dist: UpstreamHashShard(partsupp.ps_partkey, partsupp.ps_suppkey) }

@kwannoel
Copy link
Contributor Author

Highlight difference:

Left outer join before const eval:

StreamHashJoin { type: LeftOuter, predicate: auction.reserve = m10.col_0 AND Coalesce(null:Boolean, null:Boolean, null:Boolean, null:Boolean, null
:Boolean, null:Boolean, false:Boolean, null:Boolean, null:Boolean, null:Boolean), output: [auction.description, auction.initial_bid, auction.reserve, auction.exp
ires, auction.seller, auction.id, m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3], 
stream_key: [auction.id, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3, auction.reserve] }

Left outer after const eval:

StreamHashJoin { type: LeftOuter, predicate: auction.reserve = m10.col_0 AND false:Boolean, 
output: [auction.description, auction.initial_bid, auction.reserve, auction.expires, auction.seller, auction.id, m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3], 
stream_key: [auction.id, m10.col_0, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3] }

Notice how after constant folding, the stream key now has m10.col_0, and no more auction.reserve

@kwannoel
Copy link
Contributor Author

kwannoel commented Dec 15, 2023 •
edited
Loading

As a result, in the outer join, stream key is now None:

         └─StreamHashJoin { type: FullOuter, predicate: auction.description = partsupp.ps_comment AND partsupp.ps_partkey::Boolean, output: [auction.expires, auction.reserve, auction.initial_bid, auction.seller, partsupp.ps_comment, auction.id, m10.bid.extra, m10.col_1, m10.m0.col_2, m10.m0.col_3, auction.description, partsupp.ps_partkey, partsupp.ps_suppkey], 
stream_key: None }

@kwannoel
Copy link
Contributor Author

Currently trying to output_indices after constant fold step, as we did for other optimizer cases where output indices can change. Not sure if that's the ideal solution here.

@kwannoel
Copy link
Contributor Author

Not urgent to fix it, since user unlikely to write such an expression in predicate.

@kwannoel kwannoel removed this from the release-1.6 milestone Dec 18, 2023
@kwannoel kwannoel assigned st1page and unassigned kwannoel Jan 25, 2024
@kwannoel kwannoel added this to the release-1.7 milestone Jan 25, 2024
@kwannoel
Copy link
Contributor Author

Rewrite exprs is done here for StreamHashJoin:

https://github.com/risingwavelabs/risingwave/blob/c8030fc0f2179c563452afb1983411a70267c455/src/frontend/src/optimizer/plan_node/stream_hash_join.rs#L460-L465

This can change the output indices, if the predicate becomes folded into a constant value.

In that case, we need to rewrite the output indices.

Alternatively, can we just disable constant folding for predicate of stream join?

@st1page st1page modified the milestones: release-1.7, release-1.8 Mar 6, 2024
@st1page st1page modified the milestones: release-1.8, release-1.9 Apr 8, 2024
@kwannoel kwannoel added type/bug Something isn't working and removed type/feature labels Apr 15, 2024
@kwannoel
Copy link
Contributor Author

kwannoel commented Apr 15, 2024 •
edited
Loading

Another similar issue found where stream key becomes none:

fuzzing-27-shrunk.log

@kwannoel kwannoel mentioned this issue Apr 15, 2024
Merged
9 tasks
@github-actions GitHub Actions
Copy link
Contributor

github-actions bot commented Aug 1, 2024

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄

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

@st1page st1page

Labels
found-by-sqlsmith no-issue-activity type/bug Something isn't working
Projects
None yet
Milestone
release-2.2
Development

No branches or pull requests
2 participants
@st1page @kwannoel