diff options
| author | Vitaly Stoyan <[email protected]> | 2025-02-14 19:01:11 +0300 |
|---|---|---|
| committer | GitHub <[email protected]> | 2025-02-14 19:01:11 +0300 |
| commit | a539b17ec14e870e4e104e9598120f19d8426af1 (patch) | |
| tree | 0adda0386ff5eef497e8e1ea438ecad7e0ce9a52 | |
| parent | f5dae2afcb3c807038953ca9e8525555e54a00c4 (diff) | |
Drop v0 udf tests (#14590)
39 files changed, 0 insertions, 1311 deletions
diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/result.json b/ydb/library/yql/udfs/common/datetime/test/canondata/result.json deleted file mode 100644 index 8357acf5bb0..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/result.json +++ /dev/null @@ -1,62 +0,0 @@ -{ - "test.test[FromStringFormat]": [ - { - "uri": "file://test.test_FromStringFormat_/results.txt" - } - ], - "test.test[FromString]": [ - { - "uri": "file://test.test_FromString_/results.txt" - } - ], - "test.test[From]": [ - { - "uri": "file://test.test_From_/results.txt" - } - ], - "test.test[Get]": [ - { - "uri": "file://test.test_Get_/results.txt" - } - ], - "test.test[RoundTrip]": [ - { - "uri": "file://test.test_RoundTrip_/results.txt" - } - ], - "test.test[StartOfDay]": [ - { - "uri": "file://test.test_StartOfDay_/results.txt" - } - ], - "test.test[StartOf]": [ - { - "uri": "file://test.test_StartOf_/results.txt" - } - ], - "test.test[Timezone]": [ - { - "uri": "file://test.test_Timezone_/results.txt" - } - ], - "test.test[ToString]": [ - { - "uri": "file://test.test_ToString_/results.txt" - } - ], - "test.test[To]": [ - { - "uri": "file://test.test_To_/results.txt" - } - ], - "test.test[TypedFromString]": [ - { - "uri": "file://test.test_TypedFromString_/results.txt" - } - ], - "test.test[TypedStartOf]": [ - { - "uri": "file://test.test_TypedStartOf_/results.txt" - } - ] -} diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_FromStringFormat_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_FromStringFormat_/results.txt deleted file mode 100644 index d72caeef363..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_FromStringFormat_/results.txt +++ /dev/null @@ -1,46 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "column0"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column1"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - [ - "2017-02-01T00:00:00Z" - ]; - [ - "2017-01-01T00:00:00Z" - ] - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_FromString_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_FromString_/results.txt deleted file mode 100644 index fdaa824df49..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_FromString_/results.txt +++ /dev/null @@ -1,48 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "column0"; - [ - "OptionalType"; - [ - "DataType"; - "Uint64" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - [ - "0" - ] - ]; - [ - [ - "1" - ] - ]; - [ - [ - "144542035790076" - ] - ]; - [ - [ - "1479854322000000" - ] - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_From_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_From_/results.txt deleted file mode 100644 index 99530a468cb..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_From_/results.txt +++ /dev/null @@ -1,88 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "uint"; - [ - "OptionalType"; - [ - "DataType"; - "Uint64" - ] - ] - ]; - [ - "timestamp"; - [ - "OptionalType"; - [ - "DataType"; - "Timestamp" - ] - ] - ]; - [ - "interval"; - [ - "OptionalType"; - [ - "DataType"; - "Interval" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - [ - "0" - ]; - [ - "0" - ]; - [ - "0" - ] - ]; - [ - [ - "3600000000" - ]; - [ - "3600000000" - ]; - [ - "3600000000" - ] - ]; - [ - [ - "44442000000000" - ]; - [ - "44442000000000" - ]; - [ - "44442000000000" - ] - ]; - [ - [ - "4444444404000000000" - ]; - #; - # - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_Get_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_Get_/results.txt deleted file mode 100644 index 70a98fa86aa..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_Get_/results.txt +++ /dev/null @@ -1,124 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "value"; - [ - "DataType"; - "String" - ] - ]; - [ - "second"; - [ - "DataType"; - "Uint8" - ] - ]; - [ - "minute"; - [ - "DataType"; - "Uint8" - ] - ]; - [ - "hour"; - [ - "DataType"; - "Uint8" - ] - ]; - [ - "day"; - [ - "DataType"; - "Uint8" - ] - ]; - [ - "month"; - [ - "DataType"; - "Uint8" - ] - ]; - [ - "year"; - [ - "DataType"; - "Uint32" - ] - ]; - [ - "is_weekend"; - [ - "DataType"; - "Bool" - ] - ] - ] - ] - ]; - "Data" = [ - [ - "1970-01-01T00:00:00.000000Z"; - "0"; - "0"; - "0"; - "1"; - "1"; - "1970"; - %false - ]; - [ - "1970-01-02T23:59:59.000001Z"; - "59"; - "59"; - "23"; - "2"; - "1"; - "1970"; - %false - ]; - [ - "1974-07-31T22:33:55.790076Z"; - "55"; - "33"; - "22"; - "31"; - "7"; - "1974"; - %false - ]; - [ - "2015-10-09T23:57:23.000000Z"; - "23"; - "57"; - "23"; - "9"; - "10"; - "2015"; - %false - ]; - [ - "2016-08-13T10:00:00.000000Z"; - "0"; - "0"; - "10"; - "13"; - "8"; - "2016"; - %true - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_RoundTrip_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_RoundTrip_/results.txt deleted file mode 100644 index d3b233ef522..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_RoundTrip_/results.txt +++ /dev/null @@ -1,139 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "value"; - [ - "DataType"; - "String" - ] - ]; - [ - "result"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - "1970-01-01T00:00:00.000001Z"; - [ - "1970-01-01T00:00:00.000001Z" - ] - ]; - [ - "2000-01-01T00:00:00.000000Z"; - [ - "2000-01-01T00:00:00.000000Z" - ] - ]; - [ - "Sun, 06 Nov 1994 08:49:37 GMT"; - [ - "1994-11-06T08:49:37.000000Z" - ] - ]; - [ - "Sun Nov 6 08:49:37 1994"; - [ - "1994-11-06T08:49:37.000000Z" - ] - ]; - [ - "Wed, 02 Oct 2002 08:00:00 EST"; - [ - "2002-10-02T13:00:00.000000Z" - ] - ]; - [ - "Wed, 02 Oct 2002 15:00:00 +0200"; - [ - "2002-10-02T13:00:00.000000Z" - ] - ]; - [ - "20161122"; - [ - "2016-11-22T00:00:00.000000Z" - ] - ]; - [ - "2016-11-22"; - [ - "2016-11-22T00:00:00.000000Z" - ] - ]; - [ - "2016-11-22 22:38"; - [ - "2016-11-22T22:38:00.000000Z" - ] - ]; - [ - "2016-11-22 22:38:42"; - [ - "2016-11-22T22:38:42.000000Z" - ] - ]; - [ - "1990-03-15t15:16:17z"; - [ - "1990-03-15T15:16:17.000000Z" - ] - ]; - [ - "20091014165533Z"; - [ - "2009-10-14T16:55:33.000000Z" - ] - ]; - [ - "2016-11-22 22:38:42.006000"; - [ - "2016-11-22T22:38:42.006000Z" - ] - ] - ] - } - ] - }; - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "seconds"; - [ - "DataType"; - "Uint64" - ] - ] - ] - ] - ]; - "Data" = [ - [ - "123456789" - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_StartOfDay_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_StartOfDay_/results.txt deleted file mode 100644 index 01fe5675039..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_StartOfDay_/results.txt +++ /dev/null @@ -1,85 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "ts"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "start_d"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "start_dt"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "start_ts"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "day_time"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - [ - "2016-11-22T18:38:42.123456Z" - ]; - [ - "2016-11-22" - ]; - [ - "2016-11-22T00:00:00Z" - ]; - [ - "2016-11-22T00:00:00Z" - ]; - [ - "PT18H38M42.123456S" - ] - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_StartOf_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_StartOf_/results.txt deleted file mode 100644 index 9973c1d232a..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_StartOf_/results.txt +++ /dev/null @@ -1,109 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "Date"; - [ - "DataType"; - "String" - ] - ]; - [ - "Week"; - [ - "DataType"; - "String" - ] - ]; - [ - "Month"; - [ - "DataType"; - "String" - ] - ]; - [ - "Quarter"; - [ - "DataType"; - "String" - ] - ]; - [ - "Year"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ]; - "Data" = [ - [ - "1970-01-01"; - "1970-01-01"; - "1970-01-01"; - "1970-01-01"; - "1970-01-01" - ]; - [ - "1970-01-01"; - "1970-01-01"; - "1970-01-01"; - "1970-01-01"; - "1970-01-01" - ]; - [ - "2015-10-21"; - "2015-10-19"; - "2015-10-01"; - "2015-10-01"; - "2015-01-01" - ]; - [ - "2015-09-05"; - "2015-08-31"; - "2015-09-01"; - "2015-07-01"; - "2015-01-01" - ]; - [ - "2012-04-26"; - "2012-04-23"; - "2012-04-01"; - "2012-04-01"; - "2012-01-01" - ]; - [ - "2015-10-28"; - "2015-10-26"; - "2015-10-01"; - "2015-10-01"; - "2015-01-01" - ]; - [ - "2015-12-20"; - "2015-12-14"; - "2015-12-01"; - "2015-10-01"; - "2015-01-01" - ]; - [ - "2016-02-29"; - "2016-02-29"; - "2016-02-01"; - "2016-01-01"; - "2016-01-01" - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_Timezone_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_Timezone_/results.txt deleted file mode 100644 index d7aaa2d9d1e..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_Timezone_/results.txt +++ /dev/null @@ -1,59 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "value"; - [ - "DataType"; - "String" - ] - ]; - [ - "absolute"; - [ - "DataType"; - "String" - ] - ]; - [ - "civil"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ]; - "Data" = [ - [ - "1970-01-02T23:59:59.000001Z"; - "1970-01-02T20:59:59.000001Z"; - "1970-01-03T02:59:59.000001Z" - ]; - [ - "1974-07-31T22:33:55.790076Z"; - "1974-07-31T19:33:55.790076Z"; - "1974-08-01T01:33:55.790076Z" - ]; - [ - "2015-10-09T23:57:23.000000Z"; - "2015-10-09T20:57:23.000000Z"; - "2015-10-10T02:57:23.000000Z" - ]; - [ - "2016-08-13T10:00:00.000000Z"; - "2016-08-13T07:00:00.000000Z"; - "2016-08-13T13:00:00.000000Z" - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_ToString_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_ToString_/results.txt deleted file mode 100644 index af5142d4c8c..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_ToString_/results.txt +++ /dev/null @@ -1,34 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "column0"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ]; - "Data" = [ - [ - "1970-01-01T00:00:00.000000Z" - ]; - [ - "1970-01-01T00:00:00.000001Z" - ]; - [ - "1974-07-31T22:33:55.790076Z" - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_To_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_To_/results.txt deleted file mode 100644 index f07569183ab..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_To_/results.txt +++ /dev/null @@ -1,119 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "hours"; - [ - "OptionalType"; - [ - "DataType"; - "Uint64" - ] - ] - ]; - [ - "timestamp"; - [ - "OptionalType"; - [ - "DataType"; - "Double" - ] - ] - ]; - [ - "interval"; - [ - "OptionalType"; - [ - "DataType"; - "Int64" - ] - ] - ]; - [ - "negative_interval"; - [ - "OptionalType"; - [ - "DataType"; - "Int64" - ] - ] - ]; - [ - "negative_interval_double"; - [ - "OptionalType"; - [ - "DataType"; - "Double" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - [ - "0" - ]; - [ - "0" - ]; - [ - "0" - ]; - [ - "0" - ]; - [ - "0" - ] - ]; - [ - [ - "0" - ]; - [ - "0.000002" - ]; - [ - "0" - ]; - [ - "-3" - ]; - [ - "-0.000003" - ] - ]; - [ - [ - "0" - ]; - [ - "617.283945" - ]; - [ - "617" - ]; - [ - "-617283945" - ]; - [ - "-617.283945" - ] - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_TypedFromString_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_TypedFromString_/results.txt deleted file mode 100644 index 8eed8b71523..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_TypedFromString_/results.txt +++ /dev/null @@ -1,48 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "column0"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - [ - "1970-01-01T00:00:00Z" - ] - ]; - [ - [ - "1970-01-01T00:00:00.000001Z" - ] - ]; - [ - [ - "1974-07-31T22:33:55.790076Z" - ] - ]; - [ - [ - "2016-11-22T22:38:42Z" - ] - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_TypedStartOf_/results.txt b/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_TypedStartOf_/results.txt deleted file mode 100644 index 730ab7540ac..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/canondata/test.test_TypedStartOf_/results.txt +++ /dev/null @@ -1,184 +0,0 @@ -[ - { - "Write" = [ - { - "Type" = [ - "ListType"; - [ - "StructType"; - [ - [ - "value"; - [ - "DataType"; - "String" - ] - ]; - [ - "column1"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column2"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column3"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column4"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column5"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column6"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column7"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column8"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column9"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column10"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column11"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ]; - [ - "column12"; - [ - "OptionalType"; - [ - "DataType"; - "String" - ] - ] - ] - ] - ] - ]; - "Data" = [ - [ - "2017-11-16"; - [ - "2017-11-13" - ]; - [ - "2017-11-13T00:00:00Z" - ]; - [ - "2017-11-13T00:00:00Z" - ]; - [ - "2017-11-01" - ]; - [ - "2017-11-01T00:00:00Z" - ]; - [ - "2017-11-01T00:00:00Z" - ]; - [ - "2017-10-01" - ]; - [ - "2017-10-01T00:00:00Z" - ]; - [ - "2017-10-01T00:00:00Z" - ]; - [ - "2017-01-01" - ]; - [ - "2017-01-01T00:00:00Z" - ]; - [ - "2017-01-01T00:00:00Z" - ] - ] - ] - } - ] - } -]
\ No newline at end of file diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/From.in b/ydb/library/yql/udfs/common/datetime/test/cases/From.in deleted file mode 100644 index bc6dfd97008..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/From.in +++ /dev/null @@ -1,4 +0,0 @@ -{"key"="1";"subkey"="2";"value"="0"}; -{"key"="2";"subkey"="2";"value"="1"}; -{"key"="3";"subkey"="3";"value"="12345"}; -{"key"="3";"subkey"="3";"value"="1234567890"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/From.sql b/ydb/library/yql/udfs/common/datetime/test/cases/From.sql deleted file mode 100644 index 22224c02be6..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/From.sql +++ /dev/null @@ -1,8 +0,0 @@ -/* syntax version 0 */ -$value = CAST(value AS Uint64); -SELECT - DateTime::FromHours($value) AS uint, - DateTime::TimestampFromHours($value) AS timestamp, - DateTime::IntervalFromHours($value) AS interval -FROM Input; - diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/FromString.in b/ydb/library/yql/udfs/common/datetime/test/cases/FromString.in deleted file mode 100644 index 4812e498e66..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/FromString.in +++ /dev/null @@ -1,4 +0,0 @@ -{"key"="1";"subkey"="1";"value"="1970-01-01T00:00:00.000000Z"}; -{"key"="2";"subkey"="2";"value"="1970-01-01T00:00:00.000001Z"}; -{"key"="3";"subkey"="3";"value"="1974-07-31T22:33:55.790076Z"}; -{"key"="4";"subkey"="4";"value"="2016-11-22 22:38:42"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/FromString.sql b/ydb/library/yql/udfs/common/datetime/test/cases/FromString.sql deleted file mode 100644 index 8d9eba28112..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/FromString.sql +++ /dev/null @@ -1,2 +0,0 @@ -/* syntax version 0 */ -SELECT DateTime::FromString(value) FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/FromStringFormat.in b/ydb/library/yql/udfs/common/datetime/test/cases/FromStringFormat.in deleted file mode 100644 index 44a4cf835e1..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/FromStringFormat.in +++ /dev/null @@ -1 +0,0 @@ -{"key"="1";"subkey"="1";"value"="20170203"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/FromStringFormat.sql b/ydb/library/yql/udfs/common/datetime/test/cases/FromStringFormat.sql deleted file mode 100644 index c126e846ff5..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/FromStringFormat.sql +++ /dev/null @@ -1,5 +0,0 @@ -/* syntax version 0 */ -SELECT - CAST(DateTime::TimestampFromStringFormat(value, '%Y%m') AS String), - CAST(DateTime::TimestampFromStringFormat(value, '%Y') as String) -FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/Get.in b/ydb/library/yql/udfs/common/datetime/test/cases/Get.in deleted file mode 100644 index 8fa829b173e..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/Get.in +++ /dev/null @@ -1,5 +0,0 @@ -{"key"="1";"subkey"="1";"value"="1970-01-01T00:00:00.000000Z"}; -{"key"="2";"subkey"="2";"value"="1970-01-02T23:59:59.000001Z"}; -{"key"="3";"subkey"="3";"value"="1974-07-31T22:33:55.790076Z"}; -{"key"="4";"subkey"="4";"value"="2015-10-09T23:57:23.000000Z"}; -{"key"="1";"subkey"="1";"value"="2016-08-13T10:00:00.000000Z"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/Get.sql b/ydb/library/yql/udfs/common/datetime/test/cases/Get.sql deleted file mode 100644 index 5ec67142e30..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/Get.sql +++ /dev/null @@ -1,12 +0,0 @@ -/* syntax version 0 */ -$ts = COALESCE(DateTime::FromString(value), 0); -SELECT - value, - DateTime::GetSecond($ts) AS second, - DateTime::GetMinute($ts) AS minute, - DateTime::GetHour($ts) AS hour, - DateTime::GetDayOfMonth($ts) AS day, - DateTime::GetMonth($ts) AS month, - DateTime::GetYear($ts) AS year, - DateTime::IsWeekend($ts) AS is_weekend -FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/RoundTrip.in b/ydb/library/yql/udfs/common/datetime/test/cases/RoundTrip.in deleted file mode 100644 index 8b4319c2447..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/RoundTrip.in +++ /dev/null @@ -1,13 +0,0 @@ -{"key"="";"subkey"="";"value"="1970-01-01T00:00:00.000001Z"}; -{"key"="";"subkey"="";"value"="2000-01-01T00:00:00.000000Z"}; -{"key"="Http";"subkey"="";"value"="Sun, 06 Nov 1994 08:49:37 GMT"}; -{"key"="Http";"subkey"="";"value"="Sun Nov 6 08:49:37 1994"}; -{"key"="Rfc822";"subkey"="";"value"="Wed, 02 Oct 2002 08:00:00 EST"}; -{"key"="Rfc822";"subkey"="";"value"="Wed, 02 Oct 2002 15:00:00 +0200"}; -{"key"="Iso8601";"subkey"="";"value"="20161122"}; -{"key"="Iso8601";"subkey"="";"value"="2016-11-22"}; -{"key"="Iso8601";"subkey"="";"value"="2016-11-22 22:38"}; -{"key"="Iso8601";"subkey"="";"value"="2016-11-22 22:38:42"}; -{"key"="Iso8601";"subkey"="";"value"="1990-03-15t15:16:17z"}; -{"key"="X509";"subkey"="";"value"="20091014165533Z"}; -{"key"="YQL-2273";"subkey"="";"value"="2016-11-22 22:38:42.006000"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/RoundTrip.sql b/ydb/library/yql/udfs/common/datetime/test/cases/RoundTrip.sql deleted file mode 100644 index 5fd08e1fc5b..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/RoundTrip.sql +++ /dev/null @@ -1,12 +0,0 @@ -/* syntax version 0 */ -$result = DateTime::ToString(DateTime::FromString(value)); - -SELECT - value, - $result AS result -FROM Input; - -SELECT - DateTime::ToSeconds( - DateTime::FromSeconds(123456789) - ) AS seconds; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/StartOf.in b/ydb/library/yql/udfs/common/datetime/test/cases/StartOf.in deleted file mode 100644 index 6e184dd2383..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/StartOf.in +++ /dev/null @@ -1,8 +0,0 @@ -{"key"="1";"subkey"="1";"value"="0"}; -{"key"="2";"subkey"="2";"value"="1"}; -{"key"="3";"subkey"="3";"value"="1445420357900760"}; -{"key"="4";"subkey"="4";"value"="1441421357900760"}; -{"key"="5";"subkey"="5";"value"="1335421457900760"}; -{"key"="6";"subkey"="6";"value"="1446044144000000"}; -{"key"="7";"subkey"="7";"value"="1450626268481094"}; -{"key"="8";"subkey"="8";"value"="1456782839000000"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/StartOf.sql b/ydb/library/yql/udfs/common/datetime/test/cases/StartOf.sql deleted file mode 100644 index 65c17872032..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/StartOf.sql +++ /dev/null @@ -1,9 +0,0 @@ -/* syntax version 0 */ -$ts = COALESCE(CAST(value AS Uint64), 0); -SELECT - DateTime::ToDate($ts) as Date, - DateTime::ToDate(DateTime::StartOfWeek($ts)) as Week, - DateTime::ToDate(DateTime::StartOfMonth($ts)) as Month, - DateTime::ToDate(DateTime::StartOfQuarter($ts)) as Quarter, - DateTime::ToDate(DateTime::StartOfYear($ts)) as Year -FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/StartOfDay.in b/ydb/library/yql/udfs/common/datetime/test/cases/StartOfDay.in deleted file mode 100644 index 87191717541..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/StartOfDay.in +++ /dev/null @@ -1 +0,0 @@ -{"key"="1";"subkey"="1";"value"="2016-11-22T22:38:42.123456"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/StartOfDay.sql b/ydb/library/yql/udfs/common/datetime/test/cases/StartOfDay.sql deleted file mode 100644 index d13bcc777d6..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/StartOfDay.sql +++ /dev/null @@ -1,8 +0,0 @@ -/* syntax version 0 */ -SELECT - cast(DateTime::TimestampFromString(value) as string) as ts, - cast(DateTime::DateStartOfDay(cast(DateTime::TimestampFromString(value) as date)) as string) as start_d, - cast(DateTime::DatetimeStartOfDay(cast(DateTime::TimestampFromString(value) as datetime)) as string) as start_dt, - cast(DateTime::TimestampStartOfDay(DateTime::TimestampFromString(value)) as string) as start_ts, - cast(DateTime::GetTimeOfDay(DateTime::TimestampFromString(value)) as string) as day_time -FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/Timezone.in b/ydb/library/yql/udfs/common/datetime/test/cases/Timezone.in deleted file mode 100644 index ada23d3a4dd..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/Timezone.in +++ /dev/null @@ -1,4 +0,0 @@ -{"key"="2";"subkey"="2";"value"="1970-01-02T23:59:59.000001Z"}; -{"key"="3";"subkey"="3";"value"="1974-07-31T22:33:55.790076Z"}; -{"key"="4";"subkey"="4";"value"="2015-10-09T23:57:23.000000Z"}; -{"key"="1";"subkey"="1";"value"="2016-08-13T10:00:00.000000Z"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/Timezone.sql b/ydb/library/yql/udfs/common/datetime/test/cases/Timezone.sql deleted file mode 100644 index e93518c0fcb..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/Timezone.sql +++ /dev/null @@ -1,7 +0,0 @@ -/* syntax version 0 */ -$ts = COALESCE(DateTime::FromString(value), 0); -SELECT - value, - DateTime::ToString(DateTime::FromTimeZone($ts, "Europe/Moscow")) AS absolute, - DateTime::ToString(DateTime::ToTimeZone($ts, "Europe/Moscow")) AS civil -FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/To.in b/ydb/library/yql/udfs/common/datetime/test/cases/To.in deleted file mode 100644 index 9b211df1b9a..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/To.in +++ /dev/null @@ -1,3 +0,0 @@ -{"key"="1";"subkey"="2";"value"="0"}; -{"key"="2";"subkey"="2";"value"="5"}; -{"key"="3";"subkey"="3";"value"="1234567890"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/To.sql b/ydb/library/yql/udfs/common/datetime/test/cases/To.sql deleted file mode 100644 index 075b451d504..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/To.sql +++ /dev/null @@ -1,12 +0,0 @@ -/* syntax version 0 */ -$value = CAST(CAST(value AS Uint64) AS Timestamp); -$half_value = CAST(CAST(value AS Uint64) / 2 AS Timestamp); - -SELECT - DateTime::ToHours($value) AS hours, - DateTime::ToSecondsFloat($half_value) AS timestamp, - DateTime::IntervalToSeconds($value - $half_value) AS interval, - DateTime::IntervalToMicroSeconds($half_value - $value) AS negative_interval, - DateTime::IntervalToSecondsFloat($half_value - $value) AS negative_interval_double -FROM Input; - diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/ToString.in b/ydb/library/yql/udfs/common/datetime/test/cases/ToString.in deleted file mode 100644 index 9a9ae5af3b2..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/ToString.in +++ /dev/null @@ -1,3 +0,0 @@ -{"key"="1";"subkey"="1";"value"="0"}; -{"key"="2";"subkey"="2";"value"="1"}; -{"key"="3";"subkey"="3";"value"="144542035790076"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/ToString.sql b/ydb/library/yql/udfs/common/datetime/test/cases/ToString.sql deleted file mode 100644 index ec4e6fee6d2..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/ToString.sql +++ /dev/null @@ -1,2 +0,0 @@ -/* syntax version 0 */ -SELECT DateTime::ToString(COALESCE(CAST(value AS Uint64), CAST(0 as Uint64))) FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/TypedFromString.in b/ydb/library/yql/udfs/common/datetime/test/cases/TypedFromString.in deleted file mode 100644 index 4812e498e66..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/TypedFromString.in +++ /dev/null @@ -1,4 +0,0 @@ -{"key"="1";"subkey"="1";"value"="1970-01-01T00:00:00.000000Z"}; -{"key"="2";"subkey"="2";"value"="1970-01-01T00:00:00.000001Z"}; -{"key"="3";"subkey"="3";"value"="1974-07-31T22:33:55.790076Z"}; -{"key"="4";"subkey"="4";"value"="2016-11-22 22:38:42"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/TypedFromString.sql b/ydb/library/yql/udfs/common/datetime/test/cases/TypedFromString.sql deleted file mode 100644 index f7fa482ce16..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/TypedFromString.sql +++ /dev/null @@ -1,2 +0,0 @@ -/* syntax version 0 */ -SELECT cast(DateTime::TimestampFromString(value) as string) FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/TypedStartOf.in b/ydb/library/yql/udfs/common/datetime/test/cases/TypedStartOf.in deleted file mode 100644 index 6668c4f7288..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/TypedStartOf.in +++ /dev/null @@ -1 +0,0 @@ -{"key"="1";"subkey"="1";"value"="2017-11-16"}; diff --git a/ydb/library/yql/udfs/common/datetime/test/cases/TypedStartOf.sql b/ydb/library/yql/udfs/common/datetime/test/cases/TypedStartOf.sql deleted file mode 100644 index 1b5af700bc2..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/cases/TypedStartOf.sql +++ /dev/null @@ -1,17 +0,0 @@ -/* syntax version 0 */ -$ts = cast(value as Date); -SELECT - value, - cast(DateTime::DateStartOfWeek($ts) as string), - cast(DateTime::DatetimeStartOfWeek($ts) as string), - cast(DateTime::TimestampStartOfWeek($ts) as string), - cast(DateTime::DateStartOfMonth($ts) as string), - cast(DateTime::DatetimeStartOfMonth($ts) as string), - cast(DateTime::TimestampStartOfMonth($ts) as string), - cast(DateTime::DateStartOfQuarter($ts) as string), - cast(DateTime::DatetimeStartOfQuarter($ts) as string), - cast(DateTime::TimestampStartOfQuarter($ts) as string), - cast(DateTime::DateStartOfYear($ts) as string), - cast(DateTime::DatetimeStartOfYear($ts) as string), - cast(DateTime::TimestampStartOfYear($ts) as string) -FROM Input; diff --git a/ydb/library/yql/udfs/common/datetime/test/ya.make b/ydb/library/yql/udfs/common/datetime/test/ya.make deleted file mode 100644 index 5f06e613233..00000000000 --- a/ydb/library/yql/udfs/common/datetime/test/ya.make +++ /dev/null @@ -1,15 +0,0 @@ -YQL_UDF_TEST() - -DEPENDS(ydb/library/yql/udfs/common/datetime) - -SIZE(MEDIUM) - -IF (SANITIZER_TYPE OR NOT OPENSOURCE) - REQUIREMENTS(ram:10) -ENDIF() - -IF (SANITIZER_TYPE == "memory") - TAG(ya:not_autocheck) # YQL-15385 -ENDIF() - -END() diff --git a/ydb/library/yql/udfs/common/datetime/ya.make b/ydb/library/yql/udfs/common/datetime/ya.make index fb1aa7cce12..104456eb4fd 100644 --- a/ydb/library/yql/udfs/common/datetime/ya.make +++ b/ydb/library/yql/udfs/common/datetime/ya.make @@ -15,7 +15,3 @@ PEERDIR( util/draft ) END() - -RECURSE_FOR_TESTS( - test -) |