/** * Copyright (c) 2021 OceanBase * OceanBase CE is licensed under Mulan PubL v2. * You can use this software according to the terms and conditions of the Mulan PubL v2. * You may obtain a copy of Mulan PubL v2 at: * http://license.coscl.org.cn/MulanPubL-2.0 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. * See the Mulan PubL v2 for more details. */ #include #include "sql/engine/expr/ob_expr_replace.h" #include "ob_expr_test_utils.h" #include "lib/timezone/ob_time_convert.h" using namespace oceanbase::common; using namespace oceanbase::sql; class ObExprReplaceTest : public ::testing::Test { public: ObExprReplaceTest(); virtual ~ObExprReplaceTest(); virtual void SetUp(); virtual void TearDown(); private: // disallow copy ObExprReplaceTest(const ObExprReplaceTest &other); ObExprReplaceTest& operator=(const ObExprReplaceTest &other); private: // data members }; ObExprReplaceTest::ObExprReplaceTest() { } ObExprReplaceTest::~ObExprReplaceTest() { } void ObExprReplaceTest::SetUp() { } void ObExprReplaceTest::TearDown() { } #define T(t1, v1, t2, v2, t3, v3, ref_type, ref_value) EXPECT_RESULT3 (obj, &buf, calc_result3, t1, v1, t2, v2, t3, v3, ref_type, ref_value) #define F(t1, v1, t2, v2, t3, v3, ref_type, ref_value) EXPECT_FAIL_RESULT3(obj, &buf, calc_result3, t1, v1, t2, v2, t3, v3, ref_type, ref_value) TEST_F(ObExprReplaceTest, type_test) { DefaultPageAllocator buf; ObExprReplace obj(buf); ASSERT_EQ(3, obj.get_param_num()); // null type T(null , , varchar , "" , varchar , "" , null , ); T(varchar , "" , null , , varchar , "" , null , ); T(varchar , "" , varchar , "" , null , , null , ); T(null , , null , , null , , null , ); // int type T(varchar , "www.b123aidu.com" , int , 123 , int , 111 , varchar , "www.b111aidu.com"); T(varchar , "www.b123aidu.com" , int , 123 , varchar , "AAA" , varchar , "www.bAAAaidu.com"); T(varchar , "www.b123aidu.com" , varchar , "123" , int , 111 , varchar , "www.b111aidu.com"); T(int , 123456 , int , 123 , int , 111 , varchar , "111456"); T(int , 123456 , int , 123 , varchar , "AAA" , varchar , "AAA456"); T(int , 123456 , varchar , "123" , int , 111 , varchar , "111456"); T(int , 123456 , varchar , "123" , varchar , "AAA" , varchar , "AAA456"); // bool type T(bool, 1, bool, 1, int, 1, varchar , "1"); T(bool, 1, bool, 0, int, 0, varchar , "1"); T(bool, 0, bool, 1, int, 0, varchar , "0"); T(bool, 0, bool, 0, int, 1, varchar , "1"); T(bool, 0, int , 0, int, 1, varchar , "1"); T(bool, 0, int , 1, int, 0, varchar , "0"); T(bool, 1, int , 1, int, 1, varchar , "1"); T(int, 12021, bool, 1, int, 3, varchar , "32023"); T(int, 12021, bool, 0, int, 5, varchar , "12521"); T(int, 12021, bool, 0, int, 2, varchar , "12221"); // datetime type T(varchar, "www.baidu.com", varchar , "www" , datetime ,1434392608130640, varchar , "2015-06-15 18:23:28.130640.baidu.com"); T(varchar, "2015-06-15 18:23:28.130640.baidu.com" , datetime ,1434392608130640, varchar ,"www" , varchar , "www.baidu.com"); T(datetime,1434392608130640,varchar , "2015-06-15" , varchar , "www" , varchar , "www 18:23:28.130640"); // timestamp type T(varchar, "www.baidu.com", varchar , "www" , timestamp ,1434392608130640, varchar , "2015-06-15 18:23:28.130640.baidu.com"); T(varchar, "2015-06-15 18:23:28.130640.baidu.com" , timestamp ,1434392608130640, varchar ,"www" , varchar , "www.baidu.com"); T(timestamp,1434392608130640,varchar , "2015-06-15" , varchar , "www" , varchar , "www 18:23:28.130640"); // date type T(varchar, "www.baidu.com", varchar , "www" , date ,16601, varchar , "2015-06-15.baidu.com"); T(varchar, "2015-06-15.baidu.com" , date , 16601 ,varchar ,"www", varchar , "www.baidu.com"); T(date , 16601 , varchar , "2015" , varchar ,"www", varchar , "www-06-15"); // time type int64_t time1,time2; ObString str1="08:09:10"; ObString str2="12:13:14"; ObTimeConverter::str_to_time(str1, time1); ObTimeConverter::str_to_time(str2, time2); T(varchar , "www.baidu.com" , varchar , "www" , time , time1 , varchar , "08:09:10.baidu.com"); T(time , time1 , varchar , "08" , time , time2 , varchar , "12:13:14:09:10"); T(varchar , "www.baidu12:13:14.com" , time , time2 , varchar , "www" , varchar , "www.baiduwww.com"); // year type } TEST_F(ObExprReplaceTest, basic_test) { DefaultPageAllocator buf; ObExprReplace obj(buf); ASSERT_EQ(3, obj.get_param_num()); // empty varchar T(varchar , "" , varchar , "" , varchar , "" , varchar, "" ); T(varchar , "" , varchar , "" , varchar , "www" , varchar, "" ); T(varchar , "" , varchar , "www" , varchar , "" , varchar, "" ); T(varchar , "" , varchar , "www" , varchar , "www" , varchar, "" ); T(varchar , "www" , varchar , "" , varchar , "" , varchar, "www"); T(varchar , "www" , varchar , "" , varchar , "www" , varchar, "www"); T(varchar , "www" , varchar , "www" , varchar , "" , varchar, "" ); // case sensitive T(varchar , "www.baidu.com" , varchar , "w" , varchar , "A" , varchar, "AAA.baidu.com" ); T(varchar , "www.baidu.com" , varchar , "W" , varchar , "A" , varchar, "www.baidu.com" ); T(varchar , "WWW.baidu.com" , varchar , "w" , varchar , "A" , varchar, "WWW.baidu.com" ); T(varchar , "WWW.baidu.com" , varchar , "W" , varchar , "A" , varchar, "AAA.baidu.com" ); // other string type T(varchar , "www.baidu.com" , char , "w" , varchar , "A" , varchar, "AAA.baidu.com" ); T(varchar , "www.baidu.com" , char , "W" , varchar , "A" , varchar, "www.baidu.com" ); T(varchar , "www.baidu.com" , binary , "w" , varchar , "A" , varchar, "AAA.baidu.com" ); T(varchar , "www.baidu.com" , binary , "W" , varchar , "A" , varchar, "www.baidu.com" ); T(varchar , "www.baidu.com" , varbinary , "w" , varchar , "A" , varchar, "AAA.baidu.com" ); T(varchar , "www.baidu.com" , varbinary , "W" , varchar , "A" , varchar, "www.baidu.com" ); // normal T(varchar , "hhello" , varchar , "" , varchar , "" , varchar, "hhello" ); T(varchar , "www.baidu.com" , varchar , "" , varchar , "www" , varchar, "www.baidu.com" ); T(varchar , "hello" , varchar , "el" , varchar , "el" , varchar, "hello" ); T(varchar , "hello" , varchar , "el" , varchar , "E" , varchar, "hElo" ); T(varchar , "hellohel" , varchar , "el" , varchar , "E" , varchar, "hElohE" ); T(varchar , "www.baidu.com" , varchar , "ww" , varchar , "AAAA" , varchar, "AAAAw.baidu.com" ); T(varchar , "www.bau.com www.bau.com" , varchar , "ww" , varchar , "AAAA" , varchar, "AAAAw.bau.com AAAAw.bau.com"); } int main(int argc, char **argv) { oceanbase::common::ObLogger::get_logger().set_log_level("DEBUG"); ::testing::InitGoogleTest(&argc,argv); return RUN_ALL_TESTS(); }