| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !aggregate -- |
| TESTING AGAIN |
| |
| -- !aggregate -- |
| 3309.4 50.12646 |
| |
| -- !aggregate -- |
| 3566.333333333333 50.65743333333333 |
| |
| -- !aggregate -- |
| 15 15 14 14 14 15 |
| |
| -- !aggregate -- |
| 9 9 10 8 7 2 |
| |
| -- !aggregate -- |
| 8996 99.8777 testing 1999-01-08 2010-01-02T05:09:06 |
| |
| -- !aggregate -- |
| 12 0.245 AGAIN 1922-04-02 1989-01-08T04:05:06 |
| |
| -- !aggregate -- |
| 15 15 14 14 14 14 14 15 |
| |
| -- !aggregate -- |
| 9 9 10 8 7 7 7 2 |
| |
| -- !aggregate -- |
| 8996 99.8777 testing 1999-01-08 2010-01-02T05:09:06 2010-01-02T05:09:06.111 2010-01-02T05:09:06.111111 |
| |
| -- !aggregate -- |
| 12 0.245 AGAIN 1922-04-02 1989-01-08T04:05:06 1989-01-08T04:05:06.111 1989-01-08T04:05:06.111111 |
| |
| -- !aggregate -- |
| 14 99.8777 3309.4 |
| |
| -- !aggregate -- |
| 3037.078372383564 35.21027303154199 |
| |
| -- !aggregate -- |
| 3145.057639464746 35.21027303154199 |
| |
| -- !aggregate -- |
| 3037.078372383564 40.09062957713574 |
| |
| -- !aggregate -- |
| 3143.674778708147 36.44609513116206 |
| |
| -- !aggregate -- |
| 3335.837376132116 36.44609513116205 |
| |
| -- !aggregate -- |
| 3143.674778708147 42.52253405404598 |
| |
| -- !aggregate -- |
| 49641 751.8969000000001 |
| |
| -- !aggregate -- |
| 32097 455.9169 |
| |
| -- !aggregate -- |
| 9223845.040000001 1239.763326955734 |
| |
| -- !aggregate -- |
| 9891387.555555556 1239.763326955733 |
| |
| -- !aggregate -- |
| 9223845.040000001 1607.258579891111 |
| |
| -- !aggregate -- |
| 9882691.114285717 1328.317850309715 |
| |
| -- !aggregate -- |
| 11127811 1328.317850309714 |
| |
| -- !aggregate -- |
| 9882691.114285713 1808.1659023775 |
| |
| -- !aggregate -- |
| 9223845.040000001 1239.763326955734 |
| |
| -- !aggregate -- |
| 9891387.555555556 1239.763326955733 |
| |
| -- !aggregate -- |
| 9223845.040000001 1607.258579891111 |
| |
| -- !aggregate -- |
| 1 2 \N 98.52 |
| 1 2 12 12.25 |
| 1 2 25 55.52 |
| 1 2 100 134.8842 |
| 1 2 964 0.245 |
| 1 2 5000 67.87 |
| 1 2 5252 12.25 |
| 1 2 5748 271.48 |
| 1 2 6000 \N |
| 1 2 8996 98.8777 |
| |
| -- !aggregate -- |
| \N |
| 36 |
| 75 |
| 300 |
| 2892 |
| 15000 |
| 15756 |
| 17244 |
| 18000 |
| 26988 |
| |
| -- !aggregate32 -- |
| ["sample", "again", "Sample"] |
| |
| -- !aggregate33 -- |
| 65.73903964620426 |
| |
| -- !aggregate34 -- |
| [100, 5000, 5899.2] |
| |
| -- !aggregate -- |
| \N other 98.52 |
| 12 other 12.25 |
| 25 other 55.52 |
| 100 again 99.8777 |
| 100 other 11.66883333333333 |
| 964 again 0.245 |
| 5000 other 67.87 |
| 5252 sample 12.25 |
| 5748 sample 67.87 |
| 6000 other \N |
| 8996 other 98.8777 |
| |
| -- !aggregate -- |
| 12 12.25 String1 1999-01-08 1999-01-08T02:05:06 1999-01-08 1999-01-08T02:05:06 \N 1999-01-08T02:05:06.111111 true \N 123456789012345678.01234567800 |
| |
| -- !aggregate1 -- |
| \N \N |
| -32767 2147484649 |
| -32767 2147484649 |
| 255 2147483750 |
| 255 2147483750 |
| 1985 5014 |
| 1986 1001 |
| 1989 27702 |
| 1989 27702 |
| 1989 27702 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1992 3021 |
| 32767 -2147480626 |
| 32767 -2147480626 |
| |
| -- !aggregate2 -- |
| -32767 2147484649 |
| -32767 2147484649 |
| 255 2147483750 |
| 255 2147483750 |
| 1985 5014 |
| 1986 1001 |
| 1989 27702 |
| 1989 27702 |
| 1989 27702 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1992 3021 |
| 32767 -2147480626 |
| 32767 -2147480626 |
| |
| -- !aggregate3 -- |
| \N \N |
| -32767 2147484649 |
| -32767 2147484649 |
| 255 2147483750 |
| 255 2147483750 |
| 1985 5014 |
| 1986 1001 |
| 1989 27702 |
| 1989 27702 |
| 1989 27702 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1992 3021 |
| 32767 -2147480626 |
| 32767 -2147480626 |
| |
| -- !aggregate4 -- |
| \N \N |
| -32767 1002 |
| -32767 1002 |
| 1985 5014 |
| 1986 1001 |
| 1989 1001 |
| 1989 1001 |
| 1989 1001 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1992 3021 |
| 255 103 |
| 255 103 |
| 32767 -2147483647 |
| 32767 -2147483647 |
| |
| -- !aggregate5 -- |
| -32767 1002 |
| -32767 1002 |
| 255 103 |
| 255 103 |
| 1985 5014 |
| 1986 1001 |
| 1989 1001 |
| 1989 1001 |
| 1989 1001 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1992 3021 |
| 32767 -2147483647 |
| 32767 -2147483647 |
| |
| -- !aggregate6 -- |
| \N \N |
| -32767 2147483647 |
| -32767 2147483647 |
| 255 2147483647 |
| 255 2147483647 |
| 1985 5014 |
| 1986 1001 |
| 1989 25699 |
| 1989 25699 |
| 1989 25699 |
| 1991 5014 |
| 1991 5014 |
| 1991 5014 |
| 1992 3021 |
| 32767 3021 |
| 32767 3021 |
| |
| -- !aggregate7 -- |
| -32767 2147483647 |
| -32767 2147483647 |
| 255 2147483647 |
| 255 2147483647 |
| 1985 5014 |
| 1986 1001 |
| 1989 25699 |
| 1989 25699 |
| 1989 25699 |
| 1991 5014 |
| 1991 5014 |
| 1991 5014 |
| 1992 3021 |
| 32767 3021 |
| 32767 3021 |
| |
| -- !aggregate8 -- |
| \N 0 |
| -32767 2 |
| -32767 2 |
| 255 2 |
| 255 2 |
| 1985 1 |
| 1986 1 |
| 1989 3 |
| 1989 3 |
| 1989 3 |
| 1991 3 |
| 1991 3 |
| 1991 3 |
| 1992 1 |
| 32767 2 |
| 32767 2 |
| |
| -- !aggregate9 -- |
| -32767 2 |
| -32767 2 |
| 255 2 |
| 255 2 |
| 1985 1 |
| 1986 1 |
| 1989 3 |
| 1989 3 |
| 1989 3 |
| 1991 3 |
| 1991 3 |
| 1991 3 |
| 1992 1 |
| 32767 2 |
| 32767 2 |
| |
| -- !aggregate10 -- |
| \N \N 0 |
| -32767 jiw3n4 1 |
| -32767 wenlsfnl 1 |
| 255 1 |
| 255 wangjuoo5 1 |
| 1985 du3lnvl 1 |
| 1986 wangynnsf 1 |
| 1989 wangjuoo4 1 |
| 1989 yunlj8@nk 2 |
| 1989 yunlj8@nk 2 |
| 1991 wangjuoo4 1 |
| 1991 wangynnsf 1 |
| 1991 yanvjldjlll 1 |
| 1992 1 |
| 32767 lifsno 1 |
| 32767 yanavnd 1 |
| |
| -- !aggregate11 -- |
| \N 0 |
| -32767 2 |
| -32767 2 |
| 255 2 |
| 255 2 |
| 1985 1 |
| 1986 1 |
| 1989 3 |
| 1989 3 |
| 1989 3 |
| 1991 3 |
| 1991 3 |
| 1991 3 |
| 1992 1 |
| 32767 2 |
| 32767 2 |
| |
| -- !aggregate12 -- |
| \N 0 |
| -32767 2 |
| -32767 2 |
| 255 2 |
| 255 2 |
| 1985 1 |
| 1986 1 |
| 1989 3 |
| 1989 3 |
| 1989 3 |
| 1991 3 |
| 1991 3 |
| 1991 3 |
| 1992 1 |
| 32767 2 |
| 32767 2 |
| |
| -- !aggregate13 -- |
| -32767 2 |
| -32767 2 |
| 255 2 |
| 255 2 |
| 1985 1 |
| 1986 1 |
| 1989 3 |
| 1989 3 |
| 1989 3 |
| 1991 3 |
| 1991 3 |
| 1991 3 |
| 1992 1 |
| 32767 2 |
| 32767 2 |
| |
| -- !aggregate14 -- |
| -32767 jiw3n4 1 |
| -32767 wenlsfnl 1 |
| 255 1 |
| 255 wangjuoo5 1 |
| 1985 du3lnvl 1 |
| 1986 wangynnsf 1 |
| 1989 wangjuoo4 1 |
| 1989 yunlj8@nk 2 |
| 1989 yunlj8@nk 2 |
| 1991 wangjuoo4 1 |
| 1991 wangynnsf 1 |
| 1991 yanvjldjlll 1 |
| 1992 1 |
| 32767 lifsno 1 |
| 32767 yanavnd 1 |
| |
| -- !aggregate15 -- |
| \N \N \N |
| -32767 jiw3n4 1002 |
| -32767 wenlsfnl 2147483647 |
| 255 103 |
| 255 wangjuoo5 2147483647 |
| 1985 du3lnvl 5014 |
| 1986 wangynnsf 1001 |
| 1989 wangjuoo4 1001 |
| 1989 yunlj8@nk 25699 |
| 1989 yunlj8@nk 25699 |
| 1991 wangjuoo4 -2147483647 |
| 1991 wangynnsf 5014 |
| 1991 yanvjldjlll 3021 |
| 1992 3021 |
| 32767 lifsno -2147483647 |
| 32767 yanavnd 3021 |
| |
| -- !aggregate16 -- |
| \N \N |
| -32767 2147483647 |
| -32767 2147483647 |
| 255 2147483647 |
| 255 2147483647 |
| 1985 5014 |
| 1986 1001 |
| 1989 25699 |
| 1989 25699 |
| 1989 25699 |
| 1991 5014 |
| 1991 5014 |
| 1991 5014 |
| 1992 3021 |
| 32767 3021 |
| 32767 3021 |
| |
| -- !aggregate17 -- |
| \N \N |
| -32767 2147483647 |
| -32767 2147483647 |
| 255 2147483647 |
| 255 2147483647 |
| 1985 5014 |
| 1986 1001 |
| 1989 25699 |
| 1989 25699 |
| 1989 25699 |
| 1991 5014 |
| 1991 5014 |
| 1991 5014 |
| 1992 3021 |
| 32767 3021 |
| 32767 3021 |
| |
| -- !aggregate18 -- |
| -32767 2147483647 |
| -32767 2147483647 |
| 255 2147483647 |
| 255 2147483647 |
| 1985 5014 |
| 1986 1001 |
| 1989 25699 |
| 1989 25699 |
| 1989 25699 |
| 1991 5014 |
| 1991 5014 |
| 1991 5014 |
| 1992 3021 |
| 32767 3021 |
| 32767 3021 |
| |
| -- !aggregate19 -- |
| -32767 jiw3n4 1002 |
| -32767 wenlsfnl 2147483647 |
| 255 103 |
| 255 wangjuoo5 2147483647 |
| 1985 du3lnvl 5014 |
| 1986 wangynnsf 1001 |
| 1989 wangjuoo4 1001 |
| 1989 yunlj8@nk 25699 |
| 1989 yunlj8@nk 25699 |
| 1991 wangjuoo4 -2147483647 |
| 1991 wangynnsf 5014 |
| 1991 yanvjldjlll 3021 |
| 1992 3021 |
| 32767 lifsno -2147483647 |
| 32767 yanavnd 3021 |
| |
| -- !aggregate20 -- |
| \N \N \N |
| -32767 jiw3n4 1002 |
| -32767 wenlsfnl 2147483647 |
| 255 103 |
| 255 wangjuoo5 2147483647 |
| 1985 du3lnvl 5014 |
| 1986 wangynnsf 1001 |
| 1989 wangjuoo4 1001 |
| 1989 yunlj8@nk 1002 |
| 1989 yunlj8@nk 1002 |
| 1991 wangjuoo4 -2147483647 |
| 1991 wangynnsf 5014 |
| 1991 yanvjldjlll 3021 |
| 1992 3021 |
| 32767 lifsno -2147483647 |
| 32767 yanavnd 3021 |
| |
| -- !aggregate21 -- |
| \N \N |
| -32767 1002 |
| -32767 1002 |
| 255 103 |
| 255 103 |
| 1985 5014 |
| 1986 1001 |
| 1989 1001 |
| 1989 1001 |
| 1989 1001 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1992 3021 |
| 32767 -2147483647 |
| 32767 -2147483647 |
| |
| -- !aggregate22 -- |
| \N \N |
| -32767 1002 |
| -32767 1002 |
| 255 103 |
| 255 103 |
| 1985 5014 |
| 1986 1001 |
| 1989 1001 |
| 1989 1001 |
| 1989 1001 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1992 3021 |
| 32767 -2147483647 |
| 32767 -2147483647 |
| |
| -- !aggregate23 -- |
| -32767 1002 |
| -32767 1002 |
| 255 103 |
| 255 103 |
| 1985 5014 |
| 1986 1001 |
| 1989 1001 |
| 1989 1001 |
| 1989 1001 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1991 -2147483647 |
| 1992 3021 |
| 32767 -2147483647 |
| 32767 -2147483647 |
| |
| -- !aggregate24 -- |
| -32767 jiw3n4 1002 |
| -32767 wenlsfnl 2147483647 |
| 255 103 |
| 255 wangjuoo5 2147483647 |
| 1985 du3lnvl 5014 |
| 1986 wangynnsf 1001 |
| 1989 wangjuoo4 1001 |
| 1989 yunlj8@nk 1002 |
| 1989 yunlj8@nk 1002 |
| 1991 wangjuoo4 -2147483647 |
| 1991 wangynnsf 5014 |
| 1991 yanvjldjlll 3021 |
| 1992 3021 |
| 32767 lifsno -2147483647 |
| 32767 yanavnd 3021 |
| |
| -- !aggregate25 -- |
| \N \N \N |
| -32767 jiw3n4 1002 |
| -32767 wenlsfnl 2147483647 |
| 255 103 |
| 255 wangjuoo5 2147483647 |
| 1985 du3lnvl 5014 |
| 1986 wangynnsf 1001 |
| 1989 wangjuoo4 1001 |
| 1989 yunlj8@nk 26701 |
| 1989 yunlj8@nk 26701 |
| 1991 wangjuoo4 -2147483647 |
| 1991 wangynnsf 5014 |
| 1991 yanvjldjlll 3021 |
| 1992 3021 |
| 32767 lifsno -2147483647 |
| 32767 yanavnd 3021 |
| |
| -- !aggregate26 -- |
| \N \N |
| -32767 2147484649 |
| -32767 2147484649 |
| 255 2147483750 |
| 255 2147483750 |
| 1985 5014 |
| 1986 1001 |
| 1989 27702 |
| 1989 27702 |
| 1989 27702 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1992 3021 |
| 32767 -2147480626 |
| 32767 -2147480626 |
| |
| -- !aggregate27 -- |
| \N \N |
| -32767 2147484649 |
| -32767 2147484649 |
| 255 2147483750 |
| 255 2147483750 |
| 1985 5014 |
| 1986 1001 |
| 1989 27702 |
| 1989 27702 |
| 1989 27702 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1992 3021 |
| 32767 -2147480626 |
| 32767 -2147480626 |
| |
| -- !aggregate28 -- |
| -32767 2147484649 |
| -32767 2147484649 |
| 255 2147483750 |
| 255 2147483750 |
| 1985 5014 |
| 1986 1001 |
| 1989 27702 |
| 1989 27702 |
| 1989 27702 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1991 -2147475612 |
| 1992 3021 |
| 32767 -2147480626 |
| 32767 -2147480626 |
| |
| -- !aggregate29 -- |
| -32767 jiw3n4 1002 |
| -32767 wenlsfnl 2147483647 |
| 255 103 |
| 255 wangjuoo5 2147483647 |
| 1985 du3lnvl 5014 |
| 1986 wangynnsf 1001 |
| 1989 wangjuoo4 1001 |
| 1989 yunlj8@nk 26701 |
| 1989 yunlj8@nk 26701 |
| 1991 wangjuoo4 -2147483647 |
| 1991 wangynnsf 5014 |
| 1991 yanvjldjlll 3021 |
| 1992 3021 |
| 32767 lifsno -2147483647 |
| 32767 yanavnd 3021 |
| |
| -- !aggregate30 -- |
| 987456.123 |
| |
| -- !aggregate_2phase_0 -- |
| 8 1227.533333333333 |
| |
| -- !aggregate_2phase_1 -- |
| \N 0 \N 1 |
| 1 1 11011902 1 |
| 2 1 11011903 1 |
| 3 1 11011905 1 |
| 4 1 -11011907 1 |
| 5 1 -11011903 1 |
| 6 1 123456 1 |
| 7 1 7210457 1 |
| 8 1 11011920 1 |
| 9 1 11011902 1 |
| 10 1 9223372036854775807 1 |
| 11 1 -9223372036854775807 1 |
| 12 1 9223372036854775807 1 |
| 13 1 -9223372036854775807 1 |
| 14 1 11011902 1 |
| 15 1 11011920 1 |
| |
| -- !aggregate31 -- |
| 15 |
| |
| -- !aggregate32 -- |
| 1 1989 |
| 2 1986 |
| 3 1989 |
| 4 1991 |
| 5 1985 |
| 6 32767 |
| 7 -32767 |
| 8 255 |
| 9 1991 |
| |
| -- !aggregate -- |
| 3566.333333333333 50.65743333333333 |
| |
| -- !aggregate -- |
| 9 9 10 8 7 7 7 2 |
| |
| -- !subquery_with_inner_predicate -- |
| 16 |
| |
| -- !subquery_without_inner_predicate -- |
| 7 |
| |
| -- !aggregate_limit_contain_null -- |
| 16 \N |
| |
| -- !aggregate35 -- |
| 12.25 32.625 43.75 54.99999999999999 77.49999999999994 \N |
| |
| -- !select_quantile_percent -- |
| 5000 |
| |
| -- !aggregate -- |
| 1 1 |
| 1 1 |
| 1 1 |
| 1 1 |
| 1 1 |
| 1 1 |
| 1 1 |
| 1 1 |
| 1 1 |
| 2 1 |
| 2 1 |
| |
| -- !having_with_limit -- |
| 7 -32767 |
| |
| -- !four_phase_full_distribute -- |
| hello 1 1 |
| world 1 1 |
| |
