1 /* Copyright (c) 2011, 2021, Oracle and/or its affiliates.
2
3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License, version 2.0,
5 as published by the Free Software Foundation.
6
7 This program is also distributed with certain software (including
8 but not limited to OpenSSL) that is licensed under separate terms,
9 as designated in a particular file or component or in included license
10 documentation. The authors of MySQL hereby grant you an additional
11 permission to link the program and your derivative works with the
12 separately licensed software that they have included with MySQL.
13
14 This program is distributed in the hope that it will be useful,
15 but WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 GNU General Public License, version 2.0, for more details.
18
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software Foundation,
21 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA */
22
23 // First include (the generated) my_config.h, to get correct platform defines.
24 #include "my_config.h"
25 #include <gtest/gtest.h>
26
27 #include "fake_table.h"
28 #include "mock_field_timestamp.h"
29 #include "test_utils.h"
30
31 namespace field_timestamp_unittests {
32
33
34 using my_testing::Server_initializer;
35 using my_testing::Mock_error_handler;
36
37
38 /*
39 Tests of the public interface of Field_timestamp.
40 */
41 class FieldTimestampTest : public ::testing::Test
42 {
43 protected:
SetUp()44 virtual void SetUp() { initializer.SetUp(); }
TearDown()45 virtual void TearDown() { initializer.TearDown(); }
46
get_thd()47 THD *get_thd() { return initializer.thd(); }
48
49 Server_initializer initializer;
50 };
51
52
TEST_F(FieldTimestampTest,hasInsertDefaultFunction)53 TEST_F(FieldTimestampTest, hasInsertDefaultFunction)
54 {
55 {
56 Mock_field_timestamp field_dn(Field::TIMESTAMP_DN_FIELD);
57 EXPECT_TRUE(field_dn.has_insert_default_function());
58 }
59 {
60 Mock_field_timestamp field_un(Field::TIMESTAMP_UN_FIELD);
61 EXPECT_FALSE(field_un.has_insert_default_function());
62 }
63 {
64 Mock_field_timestamp field_dnun(Field::TIMESTAMP_DNUN_FIELD);
65 EXPECT_TRUE(field_dnun.has_insert_default_function());
66 }
67 }
68
69
TEST_F(FieldTimestampTest,hasUpdateDefaultFunction)70 TEST_F(FieldTimestampTest, hasUpdateDefaultFunction)
71 {
72 {
73 Mock_field_timestamp field_dn(Field::TIMESTAMP_DN_FIELD);
74 EXPECT_FALSE(field_dn.has_update_default_function());
75 }
76 {
77 Mock_field_timestamp field_un(Field::TIMESTAMP_UN_FIELD);
78 EXPECT_TRUE(field_un.has_update_default_function());
79 }
80 {
81 Mock_field_timestamp field_dnun(Field::TIMESTAMP_DNUN_FIELD);
82 EXPECT_TRUE(field_dnun.has_update_default_function());
83 }
84 }
85
86
87 /*
88 Test of DEFAULT CURRENT_TIMESTAMP functionality. Note that CURRENT_TIMESTAMP
89 should be truncated to whole seconds.
90 */
TEST_F(FieldTimestampTest,EvaluateInsertDefaultFunction)91 TEST_F(FieldTimestampTest, EvaluateInsertDefaultFunction)
92 {
93 const timeval now= { 1, 1 };
94 get_thd()->set_time(&now);
95
96 {
97 Mock_field_timestamp field_dn(Field::TIMESTAMP_DN_FIELD);
98 field_dn.evaluate_insert_default_function();
99 EXPECT_EQ(now.tv_sec, field_dn.to_timeval().tv_sec);
100 EXPECT_EQ(0, field_dn.to_timeval().tv_usec);
101 }
102 {
103 Mock_field_timestamp field_un(Field::TIMESTAMP_UN_FIELD);
104 field_un.evaluate_insert_default_function();
105 EXPECT_EQ(0, field_un.to_timeval().tv_sec);
106 EXPECT_EQ(0, field_un.to_timeval().tv_usec);
107 }
108 {
109 Mock_field_timestamp field_dnun(Field::TIMESTAMP_DNUN_FIELD);
110 field_dnun.evaluate_insert_default_function();
111 EXPECT_EQ(now.tv_sec, field_dnun.to_timeval().tv_sec);
112 EXPECT_EQ(0, field_dnun.to_timeval().tv_usec);
113 }
114 }
115
116
117 /*
118 Test of ON UPDATE CURRENT_TIMESTAMP functionality. Note that
119 CURRENT_TIMESTAMP should be truncated to whole seconds.
120 */
TEST_F(FieldTimestampTest,EvaluateUpdateDefaultFunction)121 TEST_F(FieldTimestampTest, EvaluateUpdateDefaultFunction)
122 {
123 const timeval now= { 1, 1 };
124 get_thd()->set_time(&now);
125
126 {
127 Mock_field_timestamp field_dn(Field::TIMESTAMP_DN_FIELD);
128 field_dn.evaluate_update_default_function();
129 EXPECT_EQ(0, field_dn.to_timeval().tv_sec);
130 EXPECT_EQ(0, field_dn.to_timeval().tv_usec);
131 }
132 {
133 Mock_field_timestamp field_un(Field::TIMESTAMP_UN_FIELD);
134 field_un.evaluate_update_default_function();
135 EXPECT_EQ(now.tv_sec, field_un.to_timeval().tv_sec);
136 EXPECT_EQ(0, field_un.to_timeval().tv_usec);
137 }
138 {
139 Mock_field_timestamp field_dnun(Field::TIMESTAMP_DNUN_FIELD);
140 field_dnun.evaluate_update_default_function();
141 EXPECT_EQ(now.tv_sec, field_dnun.to_timeval().tv_sec);
142 EXPECT_EQ(0, field_dnun.to_timeval().tv_usec);
143 }
144 }
145
146 }
147