diff options
author | Tsoy Maksim <tsmax2004@ydb.tech> | 2024-01-16 18:32:50 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2024-01-16 18:32:50 +0300 |
commit | a2883f6e3881ddd23dc0a78f04da6f388647321c (patch) | |
tree | 931ea464c15732c847a86458ad47b4a1168175f4 | |
parent | b30a8f1062d3bfbc8c19c77d2b9dbcaba3d137c9 (diff) | |
download | ydb-a2883f6e3881ddd23dc0a78f04da6f388647321c.tar.gz |
YQ Connector: YQ-2768 fix integration tests (#1028)
-rw-r--r-- | ydb/library/yql/providers/generic/connector/tests/docker-compose.yml | 2 | ||||
-rw-r--r-- | ydb/library/yql/providers/generic/connector/tests/test_cases/select_datetime.py | 52 |
2 files changed, 27 insertions, 27 deletions
diff --git a/ydb/library/yql/providers/generic/connector/tests/docker-compose.yml b/ydb/library/yql/providers/generic/connector/tests/docker-compose.yml index 2991e0e883..0521e59630 100644 --- a/ydb/library/yql/providers/generic/connector/tests/docker-compose.yml +++ b/ydb/library/yql/providers/generic/connector/tests/docker-compose.yml @@ -19,7 +19,7 @@ services: - 19000:9000 - 18123:8123 fq-connector-go: - image: ghcr.io/ydb-platform/fq-connector-go:v0.0.6-rc.8@sha256:74ebae0530d916c1842a7fddfbddc6c018763a0401f2f627a44e8829692fe41f + image: ghcr.io/ydb-platform/fq-connector-go:v0.1.1@sha256:47e24df143aee31a83d4a4cd0acc20b4cab8c03a9c63e81a6e99cb017a31f916 ports: - 50051:50051 network_mode: host diff --git a/ydb/library/yql/providers/generic/connector/tests/test_cases/select_datetime.py b/ydb/library/yql/providers/generic/connector/tests/test_cases/select_datetime.py index 71471ff5a9..f6d07a64ca 100644 --- a/ydb/library/yql/providers/generic/connector/tests/test_cases/select_datetime.py +++ b/ydb/library/yql/providers/generic/connector/tests/test_cases/select_datetime.py @@ -88,7 +88,7 @@ class Factory: '1950-01-10', '1850-01-10', '1950-01-10 12:23:45', - '1850-01-10 12:23:45.678', + '1850-01-10 12:23:45.678910', ], # Value is OK for CH, but can be too early for YQL [ @@ -96,7 +96,7 @@ class Factory: '1970-01-10', '1950-01-10', '1980-01-10 12:23:45', - '1950-01-10 12:23:45.678', + '1950-01-10 12:23:45.678910', ], # Value is OK for both CH and YQL [ @@ -104,7 +104,7 @@ class Factory: '2004-01-10', '2004-01-10', '2004-01-10 12:23:45', - '2004-01-10 12:23:45.678', + '2004-01-10 12:23:45.678910', ], # Value is OK for CH, but too late for YQL [ @@ -112,7 +112,7 @@ class Factory: '2110-01-10', '2110-01-10', '2106-01-10 12:23:45', - '2110-01-10 12:23:45.678', + '2110-01-10 12:23:45.678910', ], # Value is too late for both OK for CH # In this case ClickHouse behaviour is undefined @@ -123,7 +123,7 @@ class Factory: '2150-01-10', '2300-01-10', '2107-01-10 12:23:45', - '2300-01-10 12:23:45.678', + '2300-01-10 12:23:45.678910', ], ] @@ -141,7 +141,7 @@ class Factory: datetime.date(2004, 1, 10), datetime.date(2004, 1, 10), datetime.datetime(2004, 1, 10, 12, 23, 45), - datetime.datetime(2004, 1, 10, 12, 23, 45, 678000), + datetime.datetime(2004, 1, 10, 12, 23, 45, 678910), ], [ 4, @@ -194,14 +194,14 @@ class Factory: # Date is OK for CH, but too early for YQL [ 1, - datetime.datetime(1950, 5, 27, 12, 23, 45, 678000), + datetime.datetime(1950, 5, 27, 12, 23, 45, 678910), ], # Date is OK for both CH and YQL - [2, datetime.datetime(1988, 11, 20, 12, 23, 45, 678000)], + [2, datetime.datetime(1988, 11, 20, 12, 23, 45, 678910)], # Date is OK for CH, but too late for YQL [ 3, - datetime.datetime(2108, 1, 1, 12, 23, 45, 678000), + datetime.datetime(2108, 1, 1, 12, 23, 45, 678910), ], ] @@ -213,7 +213,7 @@ class Factory: [ 2, # datetime.datetime(1988, 11, 20, 12, 23, 45, 678000).astimezone(ZoneInfo('UTC')).replace(tzinfo=None), - datetime.datetime(1988, 11, 20, 12, 23, 45, 678000), + datetime.datetime(1988, 11, 20, 12, 23, 45, 678910), ], [ 3, @@ -277,7 +277,7 @@ class Factory: '1950-01-10', '1850-01-10', '1950-01-10 12:23:45', - '1850-01-10 12:23:45.678', + '1850-01-10 12:23:45.678910', ], # Value is OK for CH, but can be too early for YQL [ @@ -285,7 +285,7 @@ class Factory: '1970-01-10', '1950-01-10', '1980-01-10 12:23:45', - '1950-01-10 12:23:45.678', + '1950-01-10 12:23:45.678910', ], # Value is OK for both CH and YQL [ @@ -293,7 +293,7 @@ class Factory: '2004-01-10', '2004-01-10', '2004-01-10 12:23:45', - '2004-01-10 12:23:45.678', + '2004-01-10 12:23:45.678910', ], # Value is OK for CH, but too late for YQL [ @@ -301,7 +301,7 @@ class Factory: '2110-01-10', '2110-01-10', '2106-01-10 12:23:45', - '2110-01-10 12:23:45.678', + '2110-01-10 12:23:45.678910', ], # Value is too late for both OK for CH # In this case ClickHouse behaviour is undefined @@ -312,21 +312,21 @@ class Factory: '2150-01-10', '2300-01-10', '2107-01-10 12:23:45', - '2300-01-10 12:23:45.678', + '2300-01-10 12:23:45.678910', ], ] data_out = [ - [1, '1970-01-01', '1900-01-01', '1970-01-01T00:00:00Z', '1900-01-01T12:23:45.678Z'], - [2, '1970-01-10', '1950-01-10', '1980-01-10T12:23:45Z', '1950-01-10T12:23:45.678Z'], - [3, '2004-01-10', '2004-01-10', '2004-01-10T12:23:45Z', '2004-01-10T12:23:45.678Z'], - [4, '2110-01-10', '2110-01-10', '2106-01-10T12:23:45Z', '2110-01-10T12:23:45.678Z'], + [1, '1970-01-01', '1900-01-01', '1970-01-01T00:00:00Z', '1900-01-01T12:23:45.67891Z'], + [2, '1970-01-10', '1950-01-10', '1980-01-10T12:23:45Z', '1950-01-10T12:23:45.67891Z'], + [3, '2004-01-10', '2004-01-10', '2004-01-10T12:23:45Z', '2004-01-10T12:23:45.67891Z'], + [4, '2110-01-10', '2110-01-10', '2106-01-10T12:23:45Z', '2110-01-10T12:23:45.67891Z'], [ 5, '2149-06-06', '2299-12-31', '1970-12-04T05:55:29Z', - '1900-01-01T00:00:00.000Z', # TODO: strange overflow under bottom bound for datetime64 + '1900-01-01T00:00:00Z', # TODO: strange overflow under bottom bound for datetime64 ], ] @@ -364,27 +364,27 @@ class Factory: data_in = [ [ 1, - datetime.datetime(1950, 5, 27, 12, 23, 45, 678000), + datetime.datetime(1950, 5, 27, 12, 23, 45, 678910), ], - [2, datetime.datetime(1988, 11, 20, 12, 23, 45, 678000)], + [2, datetime.datetime(1988, 11, 20, 12, 23, 45, 678910)], [ 3, - datetime.datetime(2108, 1, 1, 12, 23, 45, 678000), + datetime.datetime(2108, 1, 1, 12, 23, 45, 678910), ], ] data_out = [ [ 1, - '1950-05-27T12:23:45.678Z', + '1950-05-27T12:23:45.67891Z', ], [ 2, - '1988-11-20T12:23:45.678Z', + '1988-11-20T12:23:45.67891Z', ], [ 3, - '2108-01-01T12:23:45.678Z', + '2108-01-01T12:23:45.67891Z', ], ] |