| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !sql_array_sort_1 -- |
| [null, null, 5, 3, 2, 2, 1] |
| |
| -- !sql_array_sort_2 -- |
| [5, 3, 2, 2, 1, null, null] |
| |
| -- !sql_array_sort_3 -- |
| [5, 3, 2, 2, 1] |
| |
| -- !sql_array_sort_4 -- |
| ["dc", "bc", "ab"] |
| |
| -- !sql_array_sort_5 -- |
| ["a", "abc", "abcd"] |
| |
| -- !sql_array_sort_6 -- |
| [[1, 2], [2, 3, 1], [4, 2, 1, 4]] |
| |
| -- !sql_array_sort_7 -- |
| ["192.168.0.1", "192.168.0.2", "192.168.0.3"] |
| |
| -- !sql_array_sort_8 -- |
| [5.34, 3.00, 2.20, 1.20, -2.10] |
| |
| -- !sql_array_sort_Tinyint -- |
| [null, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Tinyint_notnull -- |
| [12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Smallint -- |
| [null, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Smallint_notnull -- |
| [12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Int -- |
| [null, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Int_notnull -- |
| [12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Bigint -- |
| [null, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Bigint_notnull -- |
| [12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Largeint -- |
| [null, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_LargeInt_notnull -- |
| [12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_Float -- |
| [null, 1.2, 1.1, 1, 0.9, 0.8, 0.7, 0.6, 0.5, 0.4, 0.3, 0.2, 0.1] |
| |
| -- !sql_array_sort_Float_notnull -- |
| [1.2, 1.1, 1, 0.9, 0.8, 0.7, 0.6, 0.5, 0.4, 0.3, 0.2, 0.1] |
| |
| -- !sql_array_sort_Double -- |
| [null, 1.2, 1.1, 1, 0.9, 0.8, 0.7, 0.6, 0.5, 0.4, 0.3, 0.2, 0.1] |
| |
| -- !sql_array_sort_Double_notnull -- |
| [1.2, 1.1, 1, 0.9, 0.8, 0.7, 0.6, 0.5, 0.4, 0.3, 0.2, 0.1] |
| |
| -- !sql_array_sort_Demical1 -- |
| [null, 1.200, 1.100, 1.000, 0.900, 0.800, 0.700, 0.600, 0.500, 0.400, 0.300, 0.200, 0.100] |
| |
| -- !sql_array_sort_Demical1_notnull -- |
| [1.200, 1.100, 1.000, 0.900, 0.800, 0.700, 0.600, 0.500, 0.400, 0.300, 0.200, 0.100] |
| |
| -- !sql_array_sort_Demical2 -- |
| [null, 1.20000, 1.10000, 1.00000, 0.90000, 0.80000, 0.70000, 0.60000, 0.50000, 0.40000, 0.30000, 0.20000, 0.10000] |
| |
| -- !sql_array_sort_Demical2_notnull -- |
| [1.20000, 1.10000, 1.00000, 0.90000, 0.80000, 0.70000, 0.60000, 0.50000, 0.40000, 0.30000, 0.20000, 0.10000] |
| |
| -- !sql_array_sort_Demical3 -- |
| [null, 1.200000000, 1.100000000, 1.000000000, 0.900000000, 0.800000000, 0.700000000, 0.600000000, 0.500000000, 0.400000000, 0.300000000, 0.200000000, 0.100000000] |
| |
| -- !sql_array_sort_Demical3_notnull -- |
| [1.200000000, 1.100000000, 1.000000000, 0.900000000, 0.800000000, 0.700000000, 0.600000000, 0.500000000, 0.400000000, 0.300000000, 0.200000000, 0.100000000] |
| |
| -- !sql_array_sort_Demical4 -- |
| [null, 1.200, 1.100, 1.000, 0.900, 0.800, 0.700, 0.600, 0.500, 0.400, 0.300, 0.200, 0.100] |
| |
| -- !sql_array_sort_Demical4_notnull -- |
| [1.200, 1.100, 1.000, 0.900, 0.800, 0.700, 0.600, 0.500, 0.400, 0.300, 0.200, 0.100] |
| |
| -- !sql_array_sort_Demical5 -- |
| [null, 1.20000, 1.10000, 1.00000, 0.90000, 0.80000, 0.70000, 0.60000, 0.50000, 0.40000, 0.30000, 0.20000, 0.10000] |
| |
| -- !sql_array_sort_Demical5_notnull -- |
| [1.20000, 1.10000, 1.00000, 0.90000, 0.80000, 0.70000, 0.60000, 0.50000, 0.40000, 0.30000, 0.20000, 0.10000] |
| |
| -- !sql_array_sort_Demical6 -- |
| [null, 1.200000000, 1.100000000, 1.000000000, 0.900000000, 0.800000000, 0.700000000, 0.600000000, 0.500000000, 0.400000000, 0.300000000, 0.200000000, 0.100000000] |
| |
| -- !sql_array_sort_Demical6_notnull -- |
| [1.200000000, 1.100000000, 1.000000000, 0.900000000, 0.800000000, 0.700000000, 0.600000000, 0.500000000, 0.400000000, 0.300000000, 0.200000000, 0.100000000] |
| |
| -- !sql_array_sort_Char -- |
| ["null", "char33", "char33", "char33", "char33", "char32", "char32", "char32", "char32", "char31", "char31", "char31", "char31"] |
| |
| -- !sql_array_sort_Char_notnull -- |
| ["char33", "char33", "char33", "char33", "char32", "char32", "char32", "char32", "char31", "char31", "char31", "char31"] |
| |
| -- !sql_array_sort_Varchar -- |
| ["varchar33", "varchar33", "varchar33", "varchar33", "varchar32", "varchar32", "varchar32", "varchar32", "varchar31", "varchar31", "varchar31", "varchar31", "null"] |
| |
| -- !sql_array_sort_Varchar_notnull -- |
| ["varchar33", "varchar33", "varchar33", "varchar33", "varchar32", "varchar32", "varchar32", "varchar32", "varchar31", "varchar31", "varchar31", "varchar31"] |
| |
| -- !sql_array_sort_String -- |
| ["string3", "string3", "string3", "string3", "string2", "string2", "string2", "string2", "string1", "string1", "string1", "string1", "null"] |
| |
| -- !sql_array_sort_String_notnull -- |
| ["string3", "string3", "string3", "string3", "string2", "string2", "string2", "string2", "string1", "string1", "string1", "string1"] |
| |
| -- !sql_array_sort_Date -- |
| [null, "2012-03-12", "2012-03-11", "2012-03-10", "2012-03-09", "2012-03-08", "2012-03-07", "2012-03-06", "2012-03-05", "2012-03-04", "2012-03-03", "2012-03-02", "2012-03-01"] |
| |
| -- !sql_array_sort_Date_notnull -- |
| ["2012-03-12", "2012-03-11", "2012-03-10", "2012-03-09", "2012-03-08", "2012-03-07", "2012-03-06", "2012-03-05", "2012-03-04", "2012-03-03", "2012-03-02", "2012-03-01"] |
| |
| -- !sql_array_sort_DateV2 -- |
| [null, "2012-03-12", "2012-03-11", "2012-03-10", "2012-03-09", "2012-03-08", "2012-03-07", "2012-03-06", "2012-03-05", "2012-03-04", "2012-03-03", "2012-03-02", "2012-03-01"] |
| |
| -- !sql_array_sort_DateV2_notnull -- |
| ["2012-03-12", "2012-03-11", "2012-03-10", "2012-03-09", "2012-03-08", "2012-03-07", "2012-03-06", "2012-03-05", "2012-03-04", "2012-03-03", "2012-03-02", "2012-03-01"] |
| |
| -- !sql_array_sort_Datetime -- |
| [null, "2012-03-12 12:11:12", "2012-03-11 11:10:11", "2012-03-10 10:09:10", "2012-03-09 09:08:09", "2012-03-08 08:07:08", "2012-03-07 07:06:07", "2012-03-06 06:05:06", "2012-03-05 05:04:05", "2012-03-04 04:03:04", "2012-03-03 03:02:03", "2012-03-02 02:01:02", "2012-03-01 01:00:01"] |
| |
| -- !sql_array_sort_Datetime_notnull -- |
| ["2012-03-12 12:11:12", "2012-03-11 11:10:11", "2012-03-10 10:09:10", "2012-03-09 09:08:09", "2012-03-08 08:07:08", "2012-03-07 07:06:07", "2012-03-06 06:05:06", "2012-03-05 05:04:05", "2012-03-04 04:03:04", "2012-03-03 03:02:03", "2012-03-02 02:01:02", "2012-03-01 01:00:01"] |
| |
| -- !sql_array_sort_DatetimeV2 -- |
| [null, "2012-03-12 12:11:12.000000", "2012-03-11 11:10:11.000000", "2012-03-10 10:09:10.000000", "2012-03-09 09:08:09.000000", "2012-03-08 08:07:08.000000", "2012-03-07 07:06:07.000000", "2012-03-06 06:05:06.000000", "2012-03-05 05:04:05.000000", "2012-03-04 04:03:04.000000", "2012-03-03 03:02:03.000000", "2012-03-02 02:01:02.000000", "2012-03-01 01:00:01.000000"] |
| |
| -- !sql_array_sort_DatetimeV2_notnull -- |
| ["2012-03-12 12:11:12.000000", "2012-03-11 11:10:11.000000", "2012-03-10 10:09:10.000000", "2012-03-09 09:08:09.000000", "2012-03-08 08:07:08.000000", "2012-03-07 07:06:07.000000", "2012-03-06 06:05:06.000000", "2012-03-05 05:04:05.000000", "2012-03-04 04:03:04.000000", "2012-03-03 03:02:03.000000", "2012-03-02 02:01:02.000000", "2012-03-01 01:00:01.000000"] |
| |
| -- !sql_array_sort_Boolean -- |
| [null, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0] |
| |
| -- !sql_array_sort_Boolean_notnull -- |
| [1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0] |
| |
| -- !sql_array_sort_lambda_multir_tinyint -- |
| 1 [null, 5, 3, 2, 1] |
| 2 [null, 9, 8, 7, 6] |
| 3 [null, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_lambda_multir_smallint -- |
| 1 [null, 5, 3, 2, 1] |
| 2 [null, 9, 8, 7, 6] |
| 3 [null, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_lambda_multir_int -- |
| 1 [null, 5, 3, 2, 1] |
| 2 [null, 9, 8, 7, 6] |
| 3 [null, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_lambda_multir_bigint -- |
| 1 [null, 5, 3, 2, 1] |
| 2 [null, 9, 8, 7, 6] |
| 3 [null, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_lambda_multir_largeint -- |
| 1 [null, 5, 3, 2, 1] |
| 2 [null, 9, 8, 7, 6] |
| 3 [null, 4, 3, 2, 1] |
| |
| -- !sql_array_sort_lambda_multir_float -- |
| 1 [null, 5.1, 3.1, 2.1, 1.1] |
| 2 [null, 9.1, 8.1, 7.1, 6.1] |
| 3 [null, 4.1, 3.1, 2.1, 1.1] |
| |
| -- !sql_array_sort_lambda_multir_double -- |
| 1 [null, 5.1, 3.1, 2.1, 1.1] |
| 2 [null, 9.1, 8.1, 7.1, 6.1] |
| 3 [null, 4.1, 3.1, 2.1, 1.1] |
| |
| -- !sql_array_sort_lambda_multir_date -- |
| 1 [null, "2024-01-05", "2024-01-03", "2024-01-02", "2024-01-01"] |
| 2 [null, "2024-02-09", "2024-02-08", "2024-02-07", "2024-02-06"] |
| 3 [null, "2024-03-04", "2024-03-03", "2024-03-02", "2024-03-01"] |
| |
| -- !sql_array_sort_lambda_multir_datetime -- |
| 1 [null, "2024-01-05 10:00:00", "2024-01-03 10:00:00", "2024-01-02 10:00:00", "2024-01-01 10:00:00"] |
| 2 [null, "2024-02-09 10:00:00", "2024-02-08 10:00:00", "2024-02-07 10:00:00", "2024-02-06 10:00:00"] |
| 3 [null, "2024-03-04 10:00:00", "2024-03-03 10:00:00", "2024-03-02 10:00:00", "2024-03-01 10:00:00"] |
| |
| -- !sql_array_sort_lambda_multir_datev2 -- |
| 1 [null, "2024-01-05", "2024-01-03", "2024-01-02", "2024-01-01"] |
| 2 [null, "2024-02-09", "2024-02-08", "2024-02-07", "2024-02-06"] |
| 3 [null, "2024-03-04", "2024-03-03", "2024-03-02", "2024-03-01"] |
| |
| -- !sql_array_sort_lambda_multir_datetimev2_0 -- |
| 1 [null, "2024-01-05 10:00:00", "2024-01-03 10:00:00", "2024-01-02 10:00:00", "2024-01-01 10:00:00"] |
| 2 [null, "2024-02-09 10:00:00", "2024-02-08 10:00:00", "2024-02-07 10:00:00", "2024-02-06 10:00:00"] |
| 3 [null, "2024-03-04 10:00:00", "2024-03-03 10:00:00", "2024-03-02 10:00:00", "2024-03-01 10:00:00"] |
| |
| -- !sql_array_sort_lambda_multir_datetimev2_6 -- |
| 1 [null, "2024-01-05 10:00:00.000000", "2024-01-03 10:00:00.000000", "2024-01-02 10:00:00.000000", "2024-01-01 10:00:00.000000"] |
| 2 [null, "2024-02-09 10:00:00.000000", "2024-02-08 10:00:00.000000", "2024-02-07 10:00:00.000000", "2024-02-06 10:00:00.000000"] |
| 3 [null, "2024-03-04 10:00:00.000000", "2024-03-03 10:00:00.000000", "2024-03-02 10:00:00.000000", "2024-03-01 10:00:00.000000"] |
| |
| -- !sql_array_sort_lambda_multir_char -- |
| 1 [null, "e", "c", "b", "a"] |
| 2 [null, "i", "h", "g", "f"] |
| 3 [null, "d", "c", "b", "a"] |
| |
| -- !sql_array_sort_lambda_multir_varchar -- |
| 1 [null, "eee", "ccc", "bbb", "aaa"] |
| 2 [null, "iii", "hhh", "ggg", "fff"] |
| 3 [null, "ddd", "ccc", "bbb", "aaa"] |
| |
| -- !sql_array_sort_lambda_multir_string -- |
| 1 [null, "eee", "ccc", "bbb", "aaa"] |
| 2 [null, "iii", "hhh", "ggg", "fff"] |
| 3 [null, "ddd", "ccc", "bbb", "aaa"] |
| |
| -- !sql_array_sort_lambda_multir_decimal38_38 -- |
| 1 [null, 0.00000000000000000000000000000000000005, 0.00000000000000000000000000000000000003, 0.00000000000000000000000000000000000002, 0.00000000000000000000000000000000000001] |
| 2 [null, 0.00000000000000000000000000000000000009, 0.00000000000000000000000000000000000008, 0.00000000000000000000000000000000000007, 0.00000000000000000000000000000000000006] |
| 3 [null, 0.00000000000000000000000000000000000004, 0.00000000000000000000000000000000000003, 0.00000000000000000000000000000000000002, 0.00000000000000000000000000000000000001] |
| |
| -- !sql_array_sort_lambda_multir_ipv4 -- |
| 1 [null, "127.0.0.5", "127.0.0.3", "127.0.0.2", "127.0.0.1"] |
| 2 [null, "127.0.0.9", "127.0.0.8", "127.0.0.7", "127.0.0.6"] |
| 3 [null, "127.0.0.4", "127.0.0.3", "127.0.0.2", "127.0.0.1"] |
| |
| -- !sql_array_sort_lambda_multir_ipv6 -- |
| 1 [null, "::5", "::3", "::2", "::1"] |
| 2 [null, "::9", "::8", "::7", "::6"] |
| 3 [null, "::4", "::3", "::2", "::1"] |
| |
