165 lines
7.4 KiB
C++
165 lines
7.4 KiB
C++
/**
|
|
* 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 <gtest/gtest.h>
|
|
#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();
|
|
}
|
|
|