doris/regression-test/data/insert_p0/insert.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !insert --
\N	\N	\N	\N	\N	\N	\N	\N
\N	\N	\N	\N	\N	\N	\N	\N
\N	98.52	\N	\N	\N	true	181.18	\N
\N	98.52	\N	\N	\N	true	181.18	\N
\N	98.52	\N	\N	\N	true	181.18	\N
\N	98.52	\N	\N	\N	true	181.18	\N
\N	98.52	\N	\N	\N	true	181.18	\N
\N	113.52	\N	\N	\N	true	90.59	\N
\N	113.52	\N	\N	\N	true	90.59	\N
1	\N	abc	2014-01-01	\N	false	123.22	123456789012345678.0123456780
1	\N	abc	2014-01-01	\N	false	123.22	123456789012345678.0123456780
1	0.245	abc	2014-01-01	2005-01-09T04:05:06	false	123.22	123456789012345678.0123456780
1	0.245	abc	2014-01-01	2005-01-09T04:05:06	false	123.22	123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	2.1	abc	2014-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
1	2.1	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.1	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.2	abc	2014-01-01	2015-01-01T03:15:16	false	123.22	123456789012345678.0123456780
1	2.34567	a	2014-01-01	2015-01-01T03:15:16	true	123.22	123456789012345678.0123456780
1	9.877700000000001	abc	2014-01-01	2010-01-02T05:09:06	false	123.22	123456789012345678.0123456780
1	9.877700000000001	abc	2014-01-01	2010-01-02T05:09:06	false	123.22	123456789012345678.0123456780
1	12.25	abc	2014-01-01	1999-01-08T02:05:06	false	123.22	123456789012345678.0123456780
1	12.25	abc	2014-01-01	1999-01-08T02:05:06	false	123.22	123456789012345678.0123456780
1	12.25	abc	2014-01-01	2002-01-07T01:05:06	false	123.22	123456789012345678.0123456780
1	12.25	abc	2014-01-01	2002-01-07T01:05:06	false	123.22	123456789012345678.0123456780
1	12.25	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	12.25	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	12.8788	abc	2014-01-01	2010-01-02T02:05:06	false	123.22	123456789012345678.0123456780
1	12.8788	abc	2014-01-01	2010-01-02T02:05:06	false	123.22	123456789012345678.0123456780
1	55.52	abc	2014-01-01	1989-01-08T04:05:06	false	123.22	123456789012345678.0123456780
1	55.52	abc	2014-01-01	1989-01-08T04:05:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	67.87	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	98.52	abc	2014-01-01	\N	false	123.22	123456789012345678.0123456780
1	98.52	abc	2014-01-01	\N	false	123.22	123456789012345678.0123456780
1	98.8777	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	98.8777	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	99.8777	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
1	99.8777	abc	2014-01-01	2010-01-02T04:03:06	false	123.22	123456789012345678.0123456780
4	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
4	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
4	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
4	1.1	a	2016-01-01	2015-01-01T03:15:16	false	-123.22	-123456789012345678.0123456780
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
12	12.25	String1	1999-01-08	1999-01-08T02:05:06	true	123.22	12345678901234567890.0123456789
25	55.52	test	1952-01-05	1989-01-08T04:05:06	false	321.21	-12345678901234567890.0123456789
25	55.52	test	1952-01-05	1989-01-08T04:05:06	false	321.21	-12345678901234567890.0123456789
25	55.52	test	1952-01-05	1989-01-08T04:05:06	false	321.21	-12345678901234567890.0123456789
25	55.52	test	1952-01-05	1989-01-08T04:05:06	false	321.21	-12345678901234567890.0123456789
50	9.1	abc	2014-01-01	2015-01-01T03:15:16	true	123.22	123456789012345678.0123456780
60	27.25	String1	1999-01-08	1999-01-08T02:05:06	true	61.61	0.0123456790
60	27.25	String1	1999-01-08	1999-01-08T02:05:06	true	61.61	0.0123456790
100	9.877700000000001	STRING1	1923-04-08	2010-01-02T05:09:06	true	10.01	2.0000000000
100	9.877700000000001	STRING1	1923-04-08	2010-01-02T05:09:06	true	10.01	2.0000000000
100	9.877700000000001	STRING1	1923-04-08	2010-01-02T05:09:06	true	10.01	2.0000000000
100	9.877700000000001	STRING1	1923-04-08	2010-01-02T05:09:06	true	10.01	2.0000000000
100	9.877700000000001	STRING1	1923-04-08	2010-01-02T05:09:06	true	10.01	2.0000000000
100	9.877700000000001	STRING1	1923-04-08	2010-01-02T05:09:06	true	10.01	2.0000000000
100	12.25	testing	1949-07-08	2002-01-07T01:05:06	true	-393.22	-98765432109876543210.9876543210
100	12.25	testing	1949-07-08	2002-01-07T01:05:06	true	-393.22	-98765432109876543210.9876543210
100	12.25	testing	1949-07-08	2002-01-07T01:05:06	true	-393.22	-98765432109876543210.9876543210
100	12.25	testing	1949-07-08	2002-01-07T01:05:06	true	-393.22	-98765432109876543210.9876543210
100	12.25	testing	1949-07-08	2002-01-07T01:05:06	true	-393.22	-98765432109876543210.9876543210
100	12.25	testing	1949-07-08	2002-01-07T01:05:06	true	-393.22	-98765432109876543210.9876543210
100	12.8788	string1	1922-04-02	2010-01-02T02:05:06	true	999.99	-99999999999999999999.9999999999
100	12.8788	string1	1922-04-02	2010-01-02T02:05:06	true	999.99	-99999999999999999999.9999999999
100	12.8788	string1	1922-04-02	2010-01-02T02:05:06	true	999.99	-99999999999999999999.9999999999
100	12.8788	string1	1922-04-02	2010-01-02T02:05:06	true	999.99	-99999999999999999999.9999999999
100	12.8788	string1	1922-04-02	2010-01-02T02:05:06	true	999.99	-99999999999999999999.9999999999
100	12.8788	string1	1922-04-02	2010-01-02T02:05:06	true	999.99	-99999999999999999999.9999999999
100	99.8777	AGAIN	1987-04-09	2010-01-02T04:03:06	true	0.00	0E-10
100	99.8777	AGAIN	1987-04-09	2010-01-02T04:03:06	true	0.00	0E-10
100	99.8777	AGAIN	1987-04-09	2010-01-02T04:03:06	true	0.00	0E-10
100	99.8777	AGAIN	1987-04-09	2010-01-02T04:03:06	true	0.00	0E-10
125	70.52000000000001	test	1952-01-05	1989-01-08T04:05:06	false	160.60	-0.0123456790
125	70.52000000000001	test	1952-01-05	1989-01-08T04:05:06	false	160.60	-0.0123456790
500	24.8777	STRING1	1923-04-08	2010-01-02T05:09:06	true	5.01	2.0000000000
500	24.8777	STRING1	1923-04-08	2010-01-02T05:09:06	true	5.01	2.0000000000
500	27.25	testing	1949-07-08	2002-01-07T01:05:06	true	-196.61	-0.9876543210
500	27.25	testing	1949-07-08	2002-01-07T01:05:06	true	-196.61	-0.9876543210
500	27.8788	string1	1922-04-02	2010-01-02T02:05:06	true	500.00	-10.0000000000
500	27.8788	string1	1922-04-02	2010-01-02T02:05:06	true	500.00	-10.0000000000
500	114.8777	AGAIN	1987-04-09	2010-01-02T04:03:06	true	0.00	0E-10
500	114.8777	AGAIN	1987-04-09	2010-01-02T04:03:06	true	0.00	0E-10
964	0.245	Again	1936-02-08	2005-01-09T04:05:06	false	333.82	98765432109876543210.9876543210
964	0.245	Again	1936-02-08	2005-01-09T04:05:06	false	333.82	98765432109876543210.9876543210
964	0.245	Again	1936-02-08	2005-01-09T04:05:06	false	333.82	98765432109876543210.9876543210
964	0.245	Again	1936-02-08	2005-01-09T04:05:06	false	333.82	98765432109876543210.9876543210
964	0.245	Again	1936-02-08	2005-01-09T04:05:06	false	333.82	98765432109876543210.9876543210
964	0.245	Again	1936-02-08	2005-01-09T04:05:06	false	333.82	98765432109876543210.9876543210
4820	15.245	Again	1936-02-08	2005-01-09T04:05:06	false	166.91	0.9876543210
4820	15.245	Again	1936-02-08	2005-01-09T04:05:06	false	166.91	0.9876543210
5000	67.87	testing	\N	2010-01-02T04:03:06	\N	\N	\N
5000	67.87	testing	\N	2010-01-02T04:03:06	\N	\N	\N
5000	67.87	testing	\N	2010-01-02T04:03:06	\N	\N	\N
5000	67.87	testing	\N	2010-01-02T04:03:06	\N	\N	\N
5252	12.25	sample	1987-04-09	2010-01-02T04:03:06	true	123.00	1.0000000000
5252	12.25	sample	1987-04-09	2010-01-02T04:03:06	true	123.00	1.0000000000
5252	12.25	sample	1987-04-09	2010-01-02T04:03:06	true	123.00	1.0000000000
5252	12.25	sample	1987-04-09	2010-01-02T04:03:06	true	123.00	1.0000000000
5252	12.25	sample	1987-04-09	2010-01-02T04:03:06	true	123.00	1.0000000000
5252	12.25	sample	1987-04-09	2010-01-02T04:03:06	true	123.00	1.0000000000
5748	67.87	Sample	1987-04-06	2010-01-02T04:03:06	true	181.18	-1E-10
5748	67.87	Sample	1987-04-06	2010-01-02T04:03:06	true	181.18	-1E-10
5748	67.87	Sample	1987-04-06	2010-01-02T04:03:06	true	181.18	-1E-10
5748	67.87	Sample	1987-04-06	2010-01-02T04:03:06	true	181.18	-1E-10
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	-999.99	1E-10
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	-999.99	1E-10
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	-999.99	1E-10
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	-999.99	1E-10
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
5748	67.87	sample	1987-04-06	2010-01-02T04:03:06	true	181.18	12345678901234567890.0123456789
6000	\N	\N	1987-04-06	\N	true	\N	\N
6000	\N	\N	1987-04-06	\N	true	\N	\N
6000	\N	\N	1987-04-06	\N	true	\N	\N
6000	\N	\N	1987-04-06	\N	true	\N	\N
8996	98.8777	again	1987-04-09	2010-01-02T04:03:06	false	-0.01	99999999999999999999.9999999999
8996	98.8777	again	1987-04-09	2010-01-02T04:03:06	false	-0.01	99999999999999999999.9999999999
8996	98.8777	again	1987-04-09	2010-01-02T04:03:06	false	-0.01	99999999999999999999.9999999999
8996	98.8777	again	1987-04-09	2010-01-02T04:03:06	false	-0.01	99999999999999999999.9999999999
25000	82.87	testing	\N	2010-01-02T04:03:06	\N	\N	\N
25000	82.87	testing	\N	2010-01-02T04:03:06	\N	\N	\N
26260	27.25	sample	1987-04-09	2010-01-02T04:03:06	true	61.50	1.0000000000
26260	27.25	sample	1987-04-09	2010-01-02T04:03:06	true	61.50	1.0000000000
28740	82.87	Sample	1987-04-06	2010-01-02T04:03:06	true	90.59	0E-10
28740	82.87	Sample	1987-04-06	2010-01-02T04:03:06	true	90.59	0E-10
28740	82.87	sample	1987-04-06	2010-01-02T04:03:06	true	-500.00	0E-10
28740	82.87	sample	1987-04-06	2010-01-02T04:03:06	true	-500.00	0E-10
28740	82.87	sample	1987-04-06	2010-01-02T04:03:06	true	90.59	0.0123456790
28740	82.87	sample	1987-04-06	2010-01-02T04:03:06	true	90.59	0.0123456790
28740	82.87	sample	1987-04-06	2010-01-02T04:03:06	true	90.59	0.0123456790
28740	82.87	sample	1987-04-06	2010-01-02T04:03:06	true	90.59	0.0123456790
30000	\N	\N	1987-04-06	\N	true	\N	\N
30000	\N	\N	1987-04-06	\N	true	\N	\N
44980	113.8777	again	1987-04-09	2010-01-02T04:03:06	false	-0.01	10.0000000000
44980	113.8777	again	1987-04-09	2010-01-02T04:03:06	false	-0.01	10.0000000000

-- !select1 --
1994-12-08	1	1
1994-12-14	1	1
1994-12-14	2	1
2000-12-08	1	1