| // Licensed to the Apache Software Foundation (ASF) under one |
| // or more contributor license agreements. See the NOTICE file |
| // distributed with this work for additional information |
| // regarding copyright ownership. The ASF licenses this file |
| // to you under the Apache License, Version 2.0 (the |
| // "License"); you may not use this file except in compliance |
| // with the License. You may obtain a copy of the License at |
| // |
| // http://www.apache.org/licenses/LICENSE-2.0 |
| // |
| // Unless required by applicable law or agreed to in writing, |
| // software distributed under the License is distributed on an |
| // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| // KIND, either express or implied. See the License for the |
| // specific language governing permissions and limitations |
| // under the License. |
| |
| #include <gtest/gtest.h> |
| |
| #include "arrow/util/logging_internal.h" |
| #include "gandiva/execution_context.h" |
| #include "gandiva/precompiled/testing.h" |
| #include "gandiva/precompiled/time_constants.h" |
| #include "gandiva/precompiled/types.h" |
| |
| namespace gandiva { |
| |
| TEST(TestTime, TestCastDate) { |
| ExecutionContext context; |
| int64_t context_ptr = reinterpret_cast<int64_t>(&context); |
| |
| EXPECT_EQ(castDATE_utf8(context_ptr, "1967-12-1", 9), -65836800000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "2067-12-1", 9), 3089923200000); |
| |
| EXPECT_EQ(castDATE_utf8(context_ptr, "7-12-1", 6), 1196467200000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "67-12-1", 7), 3089923200000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "067-12-1", 8), 3089923200000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "0067-12-1", 9), -60023980800000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "00067-12-1", 10), -60023980800000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "167-12-1", 8), -56868307200000); |
| |
| EXPECT_EQ(castDATE_utf8(context_ptr, "1972-12-1", 9), 92016000000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "72-12-1", 7), 92016000000); |
| |
| EXPECT_EQ(castDATE_utf8(context_ptr, "1972222222", 10), 0); |
| EXPECT_EQ(context.get_error(), "Not a valid date value 1972222222"); |
| context.Reset(); |
| |
| EXPECT_EQ(castDATE_utf8(context_ptr, "blahblah", 8), 0); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "1967-12-1bb", 11), -65836800000); |
| |
| EXPECT_EQ(castDATE_utf8(context_ptr, "67-12-1", 7), 3089923200000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "67-1-1", 6), 3061065600000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "71-1-1", 6), 31536000000); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "71-45-1", 7), 0); |
| EXPECT_EQ(castDATE_utf8(context_ptr, "71-12-XX", 8), 0); |
| |
| EXPECT_EQ(castDATE_date32(1), 86400000); |
| } |
| |
| TEST(TestTime, TestCastTimestamp) { |
| ExecutionContext context; |
| int64_t context_ptr = reinterpret_cast<int64_t>(&context); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "1967-12-1", 9), -65836800000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2067-12-1", 9), 3089923200000); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "7-12-1", 6), 1196467200000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "67-12-1", 7), 3089923200000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "067-12-1", 8), 3089923200000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "0067-12-1", 9), -60023980800000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "00067-12-1", 10), -60023980800000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "167-12-1", 8), -56868307200000); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "1972-12-1", 9), 92016000000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "72-12-1", 7), 92016000000); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "1972-12-1", 9), 92016000000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "67-12-1", 7), 3089923200000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "67-1-1", 6), 3061065600000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "71-1-1", 6), 31536000000); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30", 18), 969702330000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.920", 22), 969702330920); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.920 +08:00", 29), |
| 969673530920); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.920 -11:45", 29), |
| 969744630920); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "65-03-04 00:20:40.920 +00:30", 28), |
| 3003349840920); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "1932-05-18 11:30:00.920 +11:30", 30), |
| -1187308799080); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "1857-02-11 20:31:40.920 -05:30", 30), |
| -3562264699080); |
| EXPECT_EQ(castTIMESTAMP_date64( |
| castDATE_utf8(context_ptr, "2000-09-23 9:45:30.920 +08:00", 29)), |
| castTIMESTAMP_utf8(context_ptr, "2000-09-23 0:00:00.000 +00:00", 29)); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.1", 20), |
| castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30", 18) + 100); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.10", 20), |
| castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30", 18) + 100); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.100", 20), |
| castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30", 18) + 100); |
| |
| // error cases |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 24:00:00", 19), 0); |
| EXPECT_EQ(context.get_error(), |
| "Not a valid time for timestamp value 2000-01-01 24:00:00"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:60:00", 19), 0); |
| EXPECT_EQ(context.get_error(), |
| "Not a valid time for timestamp value 2000-01-01 00:60:00"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:100", 20), 0); |
| EXPECT_EQ(context.get_error(), |
| "Not a valid time for timestamp value 2000-01-01 00:00:100"); |
| context.Reset(); |
| |
| // Test truncation of subseconds to 3 digits (milliseconds) |
| // "2000-01-01 00:00:00.0001" should truncate to "2000-01-01 00:00:00.000" |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.0001", 24), |
| castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.000", 23)); |
| |
| // "2000-01-01 00:00:00.1000" should truncate to "2000-01-01 00:00:00.100" |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.1000", 24), |
| castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.100", 23)); |
| |
| // "2000-01-01 00:00:00.123456789" should truncate to "2000-01-01 00:00:00.123" |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.123456789", 29), |
| castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.123", 23)); |
| |
| // "2000-01-01 00:00:00.1999" should truncate to "2000-01-01 00:00:00.199" |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.1999", 24), |
| castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.199", 23)); |
| |
| // "2000-01-01 00:00:00.1994" should truncate to "2000-01-01 00:00:00.199" |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.1994", 24), |
| castTIMESTAMP_utf8(context_ptr, "2000-01-01 00:00:00.199", 23)); |
| } |
| |
| TEST(TestTime, TestCastTimeUtf8) { |
| ExecutionContext context; |
| auto context_ptr = reinterpret_cast<int64_t>(&context); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "9:45:30", 7), 35130000); |
| EXPECT_EQ(castTIME_utf8(context_ptr, "9:45:30.920", 11), 35130920); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "9:45:30.1", 9), |
| castTIME_utf8(context_ptr, "9:45:30", 7) + 100); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "9:45:30.10", 10), |
| castTIME_utf8(context_ptr, "9:45:30", 7) + 100); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "9:45:30.100", 11), |
| castTIME_utf8(context_ptr, "9:45:30", 7) + 100); |
| |
| // error cases |
| EXPECT_EQ(castTIME_utf8(context_ptr, "24H00H00", 8), 0); |
| EXPECT_EQ(context.get_error(), "Invalid character in time 24H00H00"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "24:00:00", 8), 0); |
| EXPECT_EQ(context.get_error(), "Not a valid time value 24:00:00"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "00:60:00", 8), 0); |
| EXPECT_EQ(context.get_error(), "Not a valid time value 00:60:00"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIME_utf8(context_ptr, "00:00:100", 9), 0); |
| EXPECT_EQ(context.get_error(), "Not a valid time value 00:00:100"); |
| context.Reset(); |
| |
| // Test truncation of subseconds to 3 digits (milliseconds) |
| // "00:00:00.0001" should truncate to "00:00:00.000" |
| EXPECT_EQ(castTIME_utf8(context_ptr, "00:00:00.0001", 13), |
| castTIME_utf8(context_ptr, "00:00:00.000", 12)); |
| |
| // "00:00:00.1000" should truncate to "00:00:00.100" |
| EXPECT_EQ(castTIME_utf8(context_ptr, "00:00:00.1000", 13), |
| castTIME_utf8(context_ptr, "00:00:00.100", 12)); |
| |
| // "9:45:30.123456789" should truncate to "9:45:30.123" |
| EXPECT_EQ(castTIME_utf8(context_ptr, "9:45:30.123456789", 17), |
| castTIME_utf8(context_ptr, "9:45:30.123", 11)); |
| |
| // "00:00:00.1999" should truncate to "00:00:00.199" |
| EXPECT_EQ(castTIME_utf8(context_ptr, "00:00:00.1999", 13), |
| castTIME_utf8(context_ptr, "00:00:00.199", 12)); |
| |
| // "00:00:00.1994" should truncate to "00:00:00.199" |
| EXPECT_EQ(castTIME_utf8(context_ptr, "00:00:00.1994", 13), |
| castTIME_utf8(context_ptr, "00:00:00.199", 12)); |
| } |
| |
| #ifndef _WIN32 |
| |
| // TODO(wesm): ARROW-4495. Need to address TZ database issues on Windows |
| |
| TEST(TestTime, TestCastTimestampWithTZ) { |
| ExecutionContext context; |
| int64_t context_ptr = reinterpret_cast<int64_t>(&context); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.920 Canada/Pacific", 37), |
| 969727530920); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2012-02-28 23:30:59 Asia/Kolkata", 32), |
| 1330452059000); |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "1923-10-07 03:03:03 America/New_York", 36), |
| -1459094217000); |
| } |
| |
| TEST(TestTime, TestCastTimestampErrors) { |
| ExecutionContext context; |
| int64_t context_ptr = reinterpret_cast<int64_t>(&context); |
| |
| // error cases |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "20000923", 8), 0); |
| EXPECT_EQ(context.get_error(), "Not a valid day for timestamp value 20000923"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-2b", 10), 0); |
| EXPECT_EQ(context.get_error(), |
| "Invalid timestamp or unknown zone for timestamp value 2000-09-2b"); |
| context.Reset(); |
| |
| EXPECT_EQ(castTIMESTAMP_utf8(context_ptr, "2000-09-23 9:45:30.920 Unknown/Zone", 35), |
| 0); |
| EXPECT_EQ(context.get_error(), |
| "Invalid timestamp or unknown zone for timestamp value 2000-09-23 " |
| "9:45:30.920 Unknown/Zone"); |
| context.Reset(); |
| } |
| |
| #endif |
| |
| TEST(TestTime, TestExtractTime) { |
| // 10:20:33 |
| gdv_int32 time_as_millis_in_day = 37233000; |
| |
| EXPECT_EQ(extractHour_time32(time_as_millis_in_day), 10); |
| EXPECT_EQ(extractMinute_time32(time_as_millis_in_day), 20); |
| EXPECT_EQ(extractSecond_time32(time_as_millis_in_day), 33); |
| } |
| |
| TEST(TestTime, TestDateDiff) { |
| gdv_timestamp ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| gdv_timestamp ts2 = StringToTimestamp("2019-05-31 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), 30); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-02-28 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), 122); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-03-31 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), 91); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-06-30 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), 0); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-01 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), -1); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-31 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), -31); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-30 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), -30); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-29 00:00:00"); |
| EXPECT_EQ(datediff_timestamp_timestamp(ts1, ts2), -29); |
| } |
| |
| TEST(TestTime, TestTimestampDiffMonth) { |
| gdv_timestamp ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| gdv_timestamp ts2 = StringToTimestamp("2019-05-31 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), -1); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-02-28 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), -4); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-03-31 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), -3); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-06-30 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), 0); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-31 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), 1); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-30 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), 1); |
| |
| ts1 = StringToTimestamp("2019-06-30 00:00:00"); |
| ts2 = StringToTimestamp("2019-07-29 00:00:00"); |
| EXPECT_EQ(timestampdiffMonth_timestamp_timestamp(ts1, ts2), 0); |
| } |
| |
| TEST(TestTime, TestExtractTimestamp) { |
| gdv_timestamp ts = StringToTimestamp("1970-05-02 10:20:33"); |
| |
| EXPECT_EQ(extractMillennium_timestamp(ts), 2); |
| EXPECT_EQ(extractCentury_timestamp(ts), 20); |
| EXPECT_EQ(extractDecade_timestamp(ts), 197); |
| EXPECT_EQ(extractYear_timestamp(ts), 1970); |
| EXPECT_EQ(extractDoy_timestamp(ts), 122); |
| EXPECT_EQ(extractMonth_timestamp(ts), 5); |
| EXPECT_EQ(extractDow_timestamp(ts), 7); |
| EXPECT_EQ(extractDay_timestamp(ts), 2); |
| EXPECT_EQ(extractHour_timestamp(ts), 10); |
| EXPECT_EQ(extractMinute_timestamp(ts), 20); |
| EXPECT_EQ(extractSecond_timestamp(ts), 33); |
| } |
| |
| TEST(TestTime, TimeStampTrunc) { |
| EXPECT_EQ(date_trunc_Second_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-05-05 10:20:34")); |
| EXPECT_EQ(date_trunc_Minute_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-05-05 10:20:00")); |
| EXPECT_EQ(date_trunc_Hour_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-05-05 10:00:00")); |
| EXPECT_EQ(date_trunc_Day_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-05-05 00:00:00")); |
| EXPECT_EQ(date_trunc_Month_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-05-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Quarter_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-04-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Year_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2015-01-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Decade_date64(StringToTimestamp("2015-05-05 10:20:34")), |
| StringToTimestamp("2010-01-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Century_date64(StringToTimestamp("2115-05-05 10:20:34")), |
| StringToTimestamp("2101-01-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Millennium_date64(StringToTimestamp("2115-05-05 10:20:34")), |
| StringToTimestamp("2001-01-01 00:00:00")); |
| |
| // truncate week going to previous year |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-01 10:10:10")), |
| StringToTimestamp("2010-12-27 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-02 10:10:10")), |
| StringToTimestamp("2010-12-27 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-03 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-04 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-05 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-06 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-07 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-08 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2011-01-09 10:10:10")), |
| StringToTimestamp("2011-01-03 00:00:00")); |
| |
| // truncate week for Feb in a leap year |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-02-28 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-02-29 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-03-01 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-03-02 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-03-03 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-03-04 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-03-05 10:10:10")), |
| StringToTimestamp("2000-02-28 00:00:00")); |
| EXPECT_EQ(date_trunc_Week_timestamp(StringToTimestamp("2000-03-06 10:10:10")), |
| StringToTimestamp("2000-03-06 00:00:00")); |
| |
| // Test dates before epoch (1970-01-01) |
| EXPECT_EQ(date_trunc_Second_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-12-31 23:45:15")); |
| EXPECT_EQ(date_trunc_Minute_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-12-31 23:45:00")); |
| EXPECT_EQ(date_trunc_Hour_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-12-31 23:00:00")); |
| EXPECT_EQ(date_trunc_Day_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-12-31 00:00:00")); |
| EXPECT_EQ(date_trunc_Month_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-12-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Quarter_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-10-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Year_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1969-01-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Decade_date64(StringToTimestamp("1969-12-31 23:45:15")), |
| StringToTimestamp("1960-01-01 00:00:00")); |
| |
| // Test date further in the past |
| EXPECT_EQ(date_trunc_Second_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-05-15 12:34:56")); |
| EXPECT_EQ(date_trunc_Minute_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-05-15 12:34:00")); |
| EXPECT_EQ(date_trunc_Hour_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-05-15 12:00:00")); |
| EXPECT_EQ(date_trunc_Day_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-05-15 00:00:00")); |
| EXPECT_EQ(date_trunc_Day_date64(StringToTimestamp("1940-02-29 12:00:00")), |
| StringToTimestamp("1940-02-29 00:00:00")); |
| EXPECT_EQ(date_trunc_Month_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-05-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Quarter_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-04-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Year_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1930-01-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Decade_date64(StringToTimestamp("1931-05-15 12:34:56")), |
| StringToTimestamp("1930-01-01 00:00:00")); |
| EXPECT_EQ(date_trunc_Century_date64(StringToTimestamp("1930-05-15 12:34:56")), |
| StringToTimestamp("1901-01-01 00:00:00")); |
| } |
| |
| TEST(TestTime, TimeStampAdd) { |
| EXPECT_EQ( |
| timestampaddSecond_int32_timestamp(30, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2000-05-01 10:21:04")); |
| |
| EXPECT_EQ( |
| timestampaddSecond_timestamp_int32(StringToTimestamp("2000-05-01 10:20:34"), 30), |
| StringToTimestamp("2000-05-01 10:21:04")); |
| |
| EXPECT_EQ( |
| timestampaddMinute_int64_timestamp(-30, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2000-05-01 09:50:34")); |
| |
| EXPECT_EQ( |
| timestampaddMinute_timestamp_int64(StringToTimestamp("2000-05-01 10:20:34"), -30), |
| StringToTimestamp("2000-05-01 09:50:34")); |
| |
| EXPECT_EQ( |
| timestampaddHour_int32_timestamp(20, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2000-05-02 06:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddHour_timestamp_int32(StringToTimestamp("2000-05-01 10:20:34"), 20), |
| StringToTimestamp("2000-05-02 06:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddDay_int64_timestamp(-35, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2000-03-27 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddDay_timestamp_int64(StringToTimestamp("2000-05-01 10:20:34"), -35), |
| StringToTimestamp("2000-03-27 10:20:34")); |
| |
| EXPECT_EQ(timestampaddWeek_int32_timestamp(4, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2000-05-29 10:20:34")); |
| |
| EXPECT_EQ(timestampaddWeek_timestamp_int32(StringToTimestamp("2000-05-01 10:20:34"), 4), |
| StringToTimestamp("2000-05-29 10:20:34")); |
| |
| EXPECT_EQ(timestampaddWeek_timestamp_int32(StringToTimestamp("2000-05-01 10:20:34"), 4), |
| StringToTimestamp("2000-05-29 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddMonth_int64_timestamp(10, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2001-03-01 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddMonth_int64_timestamp(1, StringToTimestamp("2000-01-31 10:20:34")), |
| StringToTimestamp("2000-2-29 10:20:34")); |
| EXPECT_EQ( |
| timestampaddMonth_int64_timestamp(13, StringToTimestamp("2001-01-31 10:20:34")), |
| StringToTimestamp("2002-02-28 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddMonth_int64_timestamp(11, StringToTimestamp("2000-05-31 10:20:34")), |
| StringToTimestamp("2001-04-30 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddMonth_timestamp_int64(StringToTimestamp("2000-05-31 10:20:34"), 11), |
| StringToTimestamp("2001-04-30 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddQuarter_int32_timestamp(-2, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("1999-11-01 10:20:34")); |
| |
| EXPECT_EQ(timestampaddYear_int64_timestamp(2, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("2002-05-01 10:20:34")); |
| |
| EXPECT_EQ( |
| timestampaddQuarter_int32_timestamp(-5, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("1999-02-01 10:20:34")); |
| EXPECT_EQ( |
| timestampaddQuarter_int32_timestamp(-6, StringToTimestamp("2000-05-01 10:20:34")), |
| StringToTimestamp("1998-11-01 10:20:34")); |
| |
| // date_add |
| EXPECT_EQ(date_add_int32_timestamp(7, StringToTimestamp("2000-05-01 00:00:00")), |
| StringToTimestamp("2000-05-08 00:00:00")); |
| |
| EXPECT_EQ(add_int32_timestamp(4, StringToTimestamp("2000-05-01 00:00:00")), |
| StringToTimestamp("2000-05-05 00:00:00")); |
| |
| EXPECT_EQ(add_int64_timestamp(7, StringToTimestamp("2000-05-01 00:00:00")), |
| StringToTimestamp("2000-05-08 00:00:00")); |
| |
| EXPECT_EQ(date_add_int64_timestamp(4, StringToTimestamp("2000-05-01 00:00:00")), |
| StringToTimestamp("2000-05-05 00:00:00")); |
| |
| EXPECT_EQ(date_add_int64_timestamp(4, StringToTimestamp("2000-02-27 00:00:00")), |
| StringToTimestamp("2000-03-02 00:00:00")); |
| |
| EXPECT_EQ(add_date64_int64(StringToTimestamp("2000-02-27 00:00:00"), 4), |
| StringToTimestamp("2000-03-02 00:00:00")); |
| |
| // date_sub |
| EXPECT_EQ(date_sub_timestamp_int32(StringToTimestamp("2000-05-01 00:00:00"), 7), |
| StringToTimestamp("2000-04-24 00:00:00")); |
| |
| EXPECT_EQ(subtract_timestamp_int32(StringToTimestamp("2000-05-01 00:00:00"), -7), |
| StringToTimestamp("2000-05-08 00:00:00")); |
| |
| EXPECT_EQ(date_diff_timestamp_int64(StringToTimestamp("2000-05-01 00:00:00"), 365), |
| StringToTimestamp("1999-05-02 00:00:00")); |
| |
| EXPECT_EQ(date_diff_timestamp_int64(StringToTimestamp("2000-03-01 00:00:00"), 1), |
| StringToTimestamp("2000-02-29 00:00:00")); |
| |
| EXPECT_EQ(date_diff_timestamp_int64(StringToTimestamp("2000-02-29 00:00:00"), 365), |
| StringToTimestamp("1999-03-01 00:00:00")); |
| } |
| |
| // test cases from http://www.staff.science.uu.nl/~gent0113/calendar/isocalendar.htm |
| TEST(TestTime, TestExtractWeek) { |
| std::vector<std::string> data; |
| |
| // A type |
| // Jan 1, 2 and 3 |
| data.push_back("2006-01-01 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2006-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2006-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2006-04-24 10:10:10"); |
| data.push_back("17"); |
| data.push_back("2006-04-30 10:10:10"); |
| data.push_back("17"); |
| // Dec 29-31 |
| data.push_back("2006-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2006-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2006-12-31 10:10:10"); |
| data.push_back("52"); |
| // B(C) type |
| // Jan 1, 2 and 3 |
| data.push_back("2011-01-01 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2011-01-02 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2011-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2011-07-18 10:10:10"); |
| data.push_back("29"); |
| data.push_back("2011-07-24 10:10:10"); |
| data.push_back("29"); |
| // Dec 29-31 |
| data.push_back("2011-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2011-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2011-12-31 10:10:10"); |
| data.push_back("52"); |
| // B(DC) type |
| // Jan 1, 2 and 3 |
| data.push_back("2005-01-01 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2005-01-02 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2005-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2005-11-07 10:10:10"); |
| data.push_back("45"); |
| data.push_back("2005-11-13 10:10:10"); |
| data.push_back("45"); |
| // Dec 29-31 |
| data.push_back("2005-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2005-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2005-12-31 10:10:10"); |
| data.push_back("52"); |
| // C type |
| // Jan 1, 2 and 3 |
| data.push_back("2010-01-01 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2010-01-02 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2010-01-03 10:10:10"); |
| data.push_back("53"); |
| // middle, Monday and Sunday |
| data.push_back("2010-09-13 10:10:10"); |
| data.push_back("37"); |
| data.push_back("2010-09-19 10:10:10"); |
| data.push_back("37"); |
| // Dec 29-31 |
| data.push_back("2010-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2010-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2010-12-31 10:10:10"); |
| data.push_back("52"); |
| // D type |
| // Jan 1, 2 and 3 |
| data.push_back("2037-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2037-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2037-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2037-08-17 10:10:10"); |
| data.push_back("34"); |
| data.push_back("2037-08-23 10:10:10"); |
| data.push_back("34"); |
| // Dec 29-31 |
| data.push_back("2037-12-29 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2037-12-30 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2037-12-31 10:10:10"); |
| data.push_back("53"); |
| // E type |
| // Jan 1, 2 and 3 |
| data.push_back("2014-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2014-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2014-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2014-01-13 10:10:10"); |
| data.push_back("3"); |
| data.push_back("2014-01-19 10:10:10"); |
| data.push_back("3"); |
| // Dec 29-31 |
| data.push_back("2014-12-29 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2014-12-30 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2014-12-31 10:10:10"); |
| data.push_back("1"); |
| // F type |
| // Jan 1, 2 and 3 |
| data.push_back("2019-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2019-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2019-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2019-02-11 10:10:10"); |
| data.push_back("7"); |
| data.push_back("2019-02-17 10:10:10"); |
| data.push_back("7"); |
| // Dec 29-31 |
| data.push_back("2019-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2019-12-30 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2019-12-31 10:10:10"); |
| data.push_back("1"); |
| // G type |
| // Jan 1, 2 and 3 |
| data.push_back("2001-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2001-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2001-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2001-03-19 10:10:10"); |
| data.push_back("12"); |
| data.push_back("2001-03-25 10:10:10"); |
| data.push_back("12"); |
| // Dec 29-31 |
| data.push_back("2001-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2001-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2001-12-31 10:10:10"); |
| data.push_back("1"); |
| // AG type |
| // Jan 1, 2 and 3 |
| data.push_back("2012-01-01 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2012-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2012-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2012-04-02 10:10:10"); |
| data.push_back("14"); |
| data.push_back("2012-04-08 10:10:10"); |
| data.push_back("14"); |
| // Dec 29-31 |
| data.push_back("2012-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2012-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2012-12-31 10:10:10"); |
| data.push_back("1"); |
| // BA type |
| // Jan 1, 2 and 3 |
| data.push_back("2000-01-01 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2000-01-02 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2000-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2000-05-22 10:10:10"); |
| data.push_back("21"); |
| data.push_back("2000-05-28 10:10:10"); |
| data.push_back("21"); |
| // Dec 29-31 |
| data.push_back("2000-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2000-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2000-12-31 10:10:10"); |
| data.push_back("52"); |
| // CB type |
| // Jan 1, 2 and 3 |
| data.push_back("2016-01-01 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2016-01-02 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2016-01-03 10:10:10"); |
| data.push_back("53"); |
| // middle, Monday and Sunday |
| data.push_back("2016-06-20 10:10:10"); |
| data.push_back("25"); |
| data.push_back("2016-06-26 10:10:10"); |
| data.push_back("25"); |
| // Dec 29-31 |
| data.push_back("2016-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2016-12-30 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2016-12-31 10:10:10"); |
| data.push_back("52"); |
| // DC type |
| // Jan 1, 2 and 3 |
| data.push_back("2004-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2004-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2004-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2004-07-19 10:10:10"); |
| data.push_back("30"); |
| data.push_back("2004-07-25 10:10:10"); |
| data.push_back("30"); |
| // Dec 29-31 |
| data.push_back("2004-12-29 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2004-12-30 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2004-12-31 10:10:10"); |
| data.push_back("53"); |
| // ED type |
| // Jan 1, 2 and 3 |
| data.push_back("2020-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2020-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2020-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2020-08-17 10:10:10"); |
| data.push_back("34"); |
| data.push_back("2020-08-23 10:10:10"); |
| data.push_back("34"); |
| // Dec 29-31 |
| data.push_back("2020-12-29 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2020-12-30 10:10:10"); |
| data.push_back("53"); |
| data.push_back("2020-12-31 10:10:10"); |
| data.push_back("53"); |
| // FE type |
| // Jan 1, 2 and 3 |
| data.push_back("2008-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2008-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2008-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2008-09-15 10:10:10"); |
| data.push_back("38"); |
| data.push_back("2008-09-21 10:10:10"); |
| data.push_back("38"); |
| // Dec 29-31 |
| data.push_back("2008-12-29 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2008-12-30 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2008-12-31 10:10:10"); |
| data.push_back("1"); |
| // GF type |
| // Jan 1, 2 and 3 |
| data.push_back("2024-01-01 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2024-01-02 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2024-01-03 10:10:10"); |
| data.push_back("1"); |
| // middle, Monday and Sunday |
| data.push_back("2024-10-07 10:10:10"); |
| data.push_back("41"); |
| data.push_back("2024-10-13 10:10:10"); |
| data.push_back("41"); |
| // Dec 29-31 |
| data.push_back("2024-12-29 10:10:10"); |
| data.push_back("52"); |
| data.push_back("2024-12-30 10:10:10"); |
| data.push_back("1"); |
| data.push_back("2024-12-31 10:10:10"); |
| data.push_back("1"); |
| |
| for (uint32_t i = 0; i < data.size(); i += 2) { |
| gdv_timestamp ts = StringToTimestamp(data.at(i).c_str()); |
| gdv_int64 exp = atol(data.at(i + 1).c_str()); |
| EXPECT_EQ(extractWeek_timestamp(ts), exp); |
| } |
| } |
| |
| TEST(TestTime, TestIsNullInterval) { |
| EXPECT_EQ(isnull_day_time_interval(150, true), false); |
| EXPECT_EQ(isnull_day_time_interval(150, false), true); |
| } |
| |
| TEST(TestTime, TestMonthsBetween) { |
| std::vector<std::string> testStrings = { |
| "1995-03-02 00:00:00", "1995-02-02 00:00:00", "1.0", |
| "1995-02-02 00:00:00", "1995-03-02 00:00:00", "-1.0", |
| "1995-03-31 00:00:00", "1995-02-28 00:00:00", "1.0", |
| "1996-03-31 00:00:00", "1996-02-28 00:00:00", "1.09677418", |
| "1996-03-31 00:00:00", "1996-02-29 00:00:00", "1.0", |
| "1996-05-31 00:00:00", "1996-04-30 00:00:00", "1.0", |
| "1996-05-31 00:00:00", "1996-03-31 00:00:00", "2.0", |
| "1996-05-31 00:00:00", "1996-03-30 00:00:00", "2.03225806", |
| "1996-03-15 00:00:00", "1996-02-14 00:00:00", "1.03225806", |
| "1995-02-02 00:00:00", "1995-01-01 00:00:00", "1.03225806", |
| "1995-02-02 10:00:00", "1995-01-01 11:00:00", "1.03091397"}; |
| |
| for (uint32_t i = 0; i < testStrings.size();) { |
| gdv_timestamp endTs = StringToTimestamp(testStrings[i++].c_str()); |
| gdv_timestamp startTs = StringToTimestamp(testStrings[i++].c_str()); |
| |
| double expectedResult = atof(testStrings[i++].c_str()); |
| double actualResult = months_between_timestamp_timestamp(endTs, startTs); |
| |
| double diff = actualResult - expectedResult; |
| if (diff < 0) { |
| diff = expectedResult - actualResult; |
| } |
| |
| EXPECT_TRUE(diff < 0.001); |
| } |
| } |
| |
| TEST(TestTime, castVarcharTimestamp) { |
| ExecutionContext context; |
| int64_t context_ptr = reinterpret_cast<int64_t>(&context); |
| gdv_int32 out_len; |
| gdv_timestamp ts = StringToTimestamp("2000-05-01 10:20:34"); |
| const char* out = castVARCHAR_timestamp_int64(context_ptr, ts, 30L, &out_len); |
| EXPECT_EQ(std::string(out, out_len), "2000-05-01 10:20:34.000"); |
| |
| out = castVARCHAR_timestamp_int64(context_ptr, ts, 19L, &out_len); |
| EXPECT_EQ(std::string(out, out_len), "2000-05-01 10:20:34"); |
| |
| out = castVARCHAR_timestamp_int64(context_ptr, ts, 0L, &out_len); |
| EXPECT_EQ(std::string(out, out_len), ""); |
| |
| ts = StringToTimestamp("2-5-1 00:00:04"); |
| out = castVARCHAR_timestamp_int64(context_ptr, ts, 24L, &out_len); |
| EXPECT_EQ(std::string(out, out_len), "0002-05-01 00:00:04.000"); |
| } |
| |
| TEST(TestTime, TestCastTimestampToDate) { |
| gdv_timestamp ts = StringToTimestamp("2000-05-01 10:20:34"); |
| auto out = castDATE_timestamp(ts); |
| EXPECT_EQ(StringToTimestamp("2000-05-01 00:00:00"), out); |
| } |
| |
| TEST(TestTime, TestNextDay) { |
| ExecutionContext context; |
| int64_t context_ptr = reinterpret_cast<int64_t>(&context); |
| |
| gdv_timestamp ts = StringToTimestamp("2021-11-08 10:20:34"); |
| auto out = next_day_from_timestamp(context_ptr, ts, "FR", 2); |
| EXPECT_EQ(StringToTimestamp("2021-11-12 00:00:00"), out); |
| |
| out = next_day_from_timestamp(context_ptr, ts, "FRI", 3); |
| EXPECT_EQ(StringToTimestamp("2021-11-12 00:00:00"), out); |
| |
| out = next_day_from_timestamp(context_ptr, ts, "FRIDAY", 6); |
| EXPECT_EQ(StringToTimestamp("2021-11-12 00:00:00"), out); |
| |
| ts = StringToTimestamp("2015-08-06 11:12:30"); |
| out = next_day_from_timestamp(context_ptr, ts, "THU", 3); |
| EXPECT_EQ(StringToTimestamp("2015-08-13 00:00:00"), out); |
| |
| ts = StringToTimestamp("2012-08-14 11:12:30"); |
| out = next_day_from_timestamp(context_ptr, ts, "TUE", 3); |
| EXPECT_EQ(StringToTimestamp("2012-08-21 00:00:00"), out); |
| |
| ts = StringToTimestamp("2012-12-12 12:00:00"); |
| out = next_day_from_timestamp(context_ptr, ts, "TU", 2); |
| EXPECT_EQ(StringToTimestamp("2012-12-18 00:00:00"), out); |
| |
| ts = StringToTimestamp("2000-01-01 20:15:00"); |
| out = next_day_from_timestamp(context_ptr, ts, "SATURDAY", 8); |
| EXPECT_EQ(StringToTimestamp("2000-01-08 00:00:00"), out); |
| |
| ts = StringToTimestamp("2015-08-06 11:12:30"); |
| out = next_day_from_timestamp(context_ptr, ts, "AHSRK", 5); |
| EXPECT_EQ(context.get_error(), "The weekday in this entry is invalid"); |
| context.Reset(); |
| } |
| |
| TEST(TestTime, TestCastTimestampToTime) { |
| gdv_timestamp ts = StringToTimestamp("2000-05-01 10:20:34"); |
| auto expected_response = |
| static_cast<int32_t>(ts - StringToTimestamp("2000-05-01 00:00:00")); |
| auto out = castTIME_timestamp(ts); |
| EXPECT_EQ(expected_response, out); |
| |
| // Test when the defined value is midnight, so the returned value must 0 |
| ts = StringToTimestamp("1998-12-01 00:00:00"); |
| expected_response = 0; |
| out = castTIME_timestamp(ts); |
| EXPECT_EQ(expected_response, out); |
| |
| ts = StringToTimestamp("2015-09-16 23:59:59"); |
| expected_response = static_cast<int32_t>(ts - StringToTimestamp("2015-09-16 00:00:00")); |
| out = castTIME_timestamp(ts); |
| EXPECT_EQ(expected_response, out); |
| } |
| |
| TEST(TestTime, TestIntToTime) { |
| int32_t val = 1000; |
| int32_t expected_response = val; |
| auto out = castTIME_int32(val); |
| EXPECT_EQ(expected_response, out); |
| |
| val = MILLIS_IN_DAY - 1; |
| expected_response = val; |
| out = castTIME_int32(val); |
| EXPECT_EQ(expected_response, out); |
| |
| val = MILLIS_IN_DAY + 1; |
| expected_response = 1; |
| out = castTIME_int32(val); |
| EXPECT_EQ(expected_response, out); |
| |
| val = -1; |
| expected_response = 0; |
| out = castTIME_int32(val); |
| EXPECT_EQ(expected_response, out); |
| } |
| |
| TEST(TestTime, TestLastDay) { |
| // leap year test |
| gdv_timestamp ts = StringToTimestamp("2016-02-11 03:20:34"); |
| auto out = last_day_from_timestamp(ts); |
| EXPECT_EQ(StringToTimestamp("2016-02-29 00:00:00"), out); |
| |
| ts = StringToTimestamp("2016-02-29 23:59:59"); |
| out = last_day_from_timestamp(ts); |
| EXPECT_EQ(StringToTimestamp("2016-02-29 00:00:00"), out); |
| |
| ts = StringToTimestamp("2016-01-30 23:59:00"); |
| out = last_day_from_timestamp(ts); |
| EXPECT_EQ(StringToTimestamp("2016-01-31 00:00:00"), out); |
| |
| // normal year |
| ts = StringToTimestamp("2017-02-03 23:59:59"); |
| out = last_day_from_timestamp(ts); |
| EXPECT_EQ(StringToTimestamp("2017-02-28 00:00:00"), out); |
| |
| // december |
| ts = StringToTimestamp("2015-12-03 03:12:59"); |
| out = last_day_from_timestamp(ts); |
| EXPECT_EQ(StringToTimestamp("2015-12-31 00:00:00"), out); |
| } |
| |
| TEST(TestTime, TestToTimestamp) { |
| auto ts = StringToTimestamp("1970-01-01 00:00:00"); |
| EXPECT_EQ(ts, to_timestamp_int32(0)); |
| EXPECT_EQ(ts, to_timestamp_int64(0)); |
| EXPECT_EQ(ts, to_timestamp_float32(0)); |
| EXPECT_EQ(ts, to_timestamp_float64(0)); |
| |
| ts = StringToTimestamp("1970-01-01 00:00:01"); |
| EXPECT_EQ(ts, to_timestamp_int32(1)); |
| EXPECT_EQ(ts, to_timestamp_int64(1)); |
| EXPECT_EQ(ts, to_timestamp_float32(1)); |
| EXPECT_EQ(ts, to_timestamp_float64(1)); |
| |
| ts = StringToTimestamp("2021-07-14 09:31:39"); |
| EXPECT_EQ(ts, to_timestamp_int32(1626255099)); |
| EXPECT_EQ(ts, to_timestamp_int64(1626255099)); |
| |
| ts = StringToTimestamp("1970-01-01 00:01:00"); |
| EXPECT_EQ(ts, to_timestamp_int32(60)); |
| EXPECT_EQ(ts, to_timestamp_int64(60)); |
| EXPECT_EQ(ts, to_timestamp_float32(60)); |
| EXPECT_EQ(ts, to_timestamp_float64(60)); |
| |
| ts = StringToTimestamp("1970-01-01 01:00:00"); |
| EXPECT_EQ(ts, to_timestamp_int32(3600)); |
| EXPECT_EQ(ts, to_timestamp_int64(3600)); |
| EXPECT_EQ(ts, to_timestamp_float32(3600)); |
| EXPECT_EQ(ts, to_timestamp_float64(3600)); |
| |
| ts = StringToTimestamp("1970-01-02 00:00:00"); |
| EXPECT_EQ(ts, to_timestamp_int32(86400)); |
| EXPECT_EQ(ts, to_timestamp_int64(86400)); |
| EXPECT_EQ(ts, to_timestamp_float32(86400)); |
| EXPECT_EQ(ts, to_timestamp_float64(86400)); |
| |
| // tests with fractional part |
| ts = StringToTimestamp("1970-01-01 00:00:01") + 500; |
| EXPECT_EQ(ts, to_timestamp_float32(1.500f)); |
| EXPECT_EQ(ts, to_timestamp_float64(1.500)); |
| |
| ts = StringToTimestamp("1970-01-01 00:01:01") + 600; |
| EXPECT_EQ(ts, to_timestamp_float32(61.600f)); |
| EXPECT_EQ(ts, to_timestamp_float64(61.600)); |
| |
| ts = StringToTimestamp("1970-01-01 01:00:01") + 400; |
| EXPECT_EQ(ts, to_timestamp_float32(3601.400f)); |
| EXPECT_EQ(ts, to_timestamp_float64(3601.400)); |
| } |
| |
| TEST(TestTime, TestToTimeNumeric) { |
| // input timestamp in seconds: 1970-01-01 00:00:00 |
| int64_t expected_output = 0; // 0 milliseconds |
| EXPECT_EQ(expected_output, to_time_int32(0)); |
| EXPECT_EQ(expected_output, to_time_int64(0)); |
| EXPECT_EQ(expected_output, to_time_float32(0.000f)); |
| EXPECT_EQ(expected_output, to_time_float64(0.000)); |
| |
| // input timestamp in seconds: 1970-01-01 00:00:01 |
| expected_output = 1000; // 1 seconds |
| EXPECT_EQ(expected_output, to_time_int32(1)); |
| EXPECT_EQ(expected_output, to_time_int64(1)); |
| EXPECT_EQ(expected_output, to_time_float32(1.000f)); |
| EXPECT_EQ(expected_output, to_time_float64(1.000)); |
| |
| // input timestamp in seconds: 1970-01-01 01:00:00 |
| expected_output = 3600000; // 3600 seconds |
| EXPECT_EQ(expected_output, to_time_int32(3600)); |
| EXPECT_EQ(expected_output, to_time_int64(3600)); |
| EXPECT_EQ(expected_output, to_time_float32(3600.000f)); |
| EXPECT_EQ(expected_output, to_time_float64(3600.000)); |
| |
| // input timestamp in seconds: 1970-01-01 23:59:59 |
| expected_output = 86399000; // 86399 seconds |
| EXPECT_EQ(expected_output, to_time_int32(86399)); |
| EXPECT_EQ(expected_output, to_time_int64(86399)); |
| EXPECT_EQ(expected_output, to_time_float32(86399.000f)); |
| EXPECT_EQ(expected_output, to_time_float64(86399.000)); |
| |
| // input timestamp in seconds: 2020-01-01 00:00:01 |
| expected_output = 1000; // 1 second |
| EXPECT_EQ(expected_output, to_time_int64(1577836801)); |
| EXPECT_EQ(expected_output, to_time_float64(1577836801.000)); |
| |
| // tests with fractional part |
| // input timestamp in seconds: 1970-01-01 00:00:01.500 |
| expected_output = 1500; // 1.5 seconds |
| EXPECT_EQ(expected_output, to_time_float32(1.500f)); |
| EXPECT_EQ(expected_output, to_time_float64(1.500)); |
| |
| // input timestamp in seconds: 1970-01-01 00:01:01.500 |
| expected_output = 61500; // 61.5 seconds |
| EXPECT_EQ(expected_output, to_time_float32(61.500f)); |
| EXPECT_EQ(expected_output, to_time_float64(61.500)); |
| |
| // input timestamp in seconds: 1970-01-01 01:00:01.500 |
| expected_output = 3601500; // 3601.5 seconds |
| EXPECT_EQ(expected_output, to_time_float32(3601.500f)); |
| EXPECT_EQ(expected_output, to_time_float64(3601.500)); |
| } |
| |
| TEST(TestTime, TestCastIntDayInterval) { |
| EXPECT_EQ(castBIGINT_daytimeinterval(10), 864000000); |
| EXPECT_EQ(castBIGINT_daytimeinterval(-100), -8640000001); |
| EXPECT_EQ(castBIGINT_daytimeinterval(-0), 0); |
| } |
| |
| TEST(TestTime, TestCastIntYearInterval) { |
| EXPECT_EQ(castINT_year_interval(24), 2); |
| EXPECT_EQ(castINT_year_interval(-24), -2); |
| EXPECT_EQ(castINT_year_interval(-23), -1); |
| |
| EXPECT_EQ(castBIGINT_year_interval(24), 2); |
| EXPECT_EQ(castBIGINT_year_interval(-24), -2); |
| EXPECT_EQ(castBIGINT_year_interval(-23), -1); |
| } |
| |
| TEST(TestTime, TestCastNullableInterval) { |
| ExecutionContext context; |
| auto context_ptr = reinterpret_cast<int64_t>(&context); |
| // Test castNULLABLEINTERVALDAY for int and bigint |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int32(1), 1); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int32(12), 12); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int32(-55), -55); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int32(-1201), -1201); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int64(1), 1); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int64(12), 12); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int64(-55), -55); |
| EXPECT_EQ(castNULLABLEINTERVALDAY_int64(-1201), -1201); |
| |
| // Test castNULLABLEINTERVALYEAR for int and bigint |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int32(context_ptr, 1), 1); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int32(context_ptr, 12), 12); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int32(context_ptr, 55), 55); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int32(context_ptr, 1201), 1201); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int64(context_ptr, 1), 1); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int64(context_ptr, 12), 12); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int64(context_ptr, 55), 55); |
| EXPECT_EQ(castNULLABLEINTERVALYEAR_int64(context_ptr, 1201), 1201); |
| // validate overflow error when using bigint as input |
| castNULLABLEINTERVALYEAR_int64(context_ptr, INT64_MAX); |
| EXPECT_EQ(context.get_error(), "Integer overflow"); |
| context.Reset(); |
| } |
| |
| } // namespace gandiva |
