static int ctime_mtime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out)
{
UNUSED(params);
OB_ASSERT(in.get_type() == ObCreateTimeType);
out.set_mtime(static_cast<ObModifyTime> (in.get_ctime()));
return OB_SUCCESS;
}
TEST_F(ObObjCastTest, mtime_to_xxx)
{
ObExprObj in;
const char* cases_str[] = {"1970-1-1 8:0:0", "1970-1-1 0:0:0", "2012-9-24 16:59:60"};
int64_t cases[ARRAYSIZEOF(cases_str)];
const char *varchar_expected[] = {"1970-01-01 08:00:00.000000", "1970-01-01 00:00:00.000000", "2012-09-24 17:00:00.000000"};
const char *dec_expected[] = {"0", "-28800000000", "1348477200000000"};
for (int64_t i = 0; i < static_cast<int64_t>(ARRAYSIZEOF(cases)); ++i)
{
struct tm tm;
memset(&tm, 0, sizeof(tm));
strptime(cases_str[i], "%Y-%m-%d %H:%M:%S", &tm);
cases[i] = mktime(&tm) * 1000000L;
int64_t v = cases[i];
int64_t pv = v / 1000000L;
in.set_mtime(v);
MY_EXPECT(ObModifyTimeType, in, ObNullType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObIntType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObFloatType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObDoubleType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObDateTimeType, pv, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObPreciseDateTimeType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObVarcharType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObSeqType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObCreateTimeType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObModifyTimeType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObExtendType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObBoolType, v, varchar_expected[i]);
MY_EXPECT(ObModifyTimeType, in, ObDecimalType, v, dec_expected[i]);
}
}
static int varchar_mtime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out)
{
int ret = OB_SUCCESS;
UNUSED(params);
OB_ASSERT(in.get_type() == ObVarcharType);
int64_t timestamp = 0;
ret = varchar_timestamp(in, timestamp);
if (OB_SUCCESS == ret)
{
out.set_mtime(static_cast<ObModifyTime> (timestamp));
}
else
{
const string& varchar = in.get_varchar();
jlog(WARNING, "failed to convert string `%.*s' to modifytime type",
varchar.length(), varchar.data());
out.set_mtime(static_cast<ObModifyTime> (0));
ret = OB_SUCCESS;
}
return ret;
}
static int decimal_mtime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out)
{
int ret = OB_SUCCESS;
UNUSED(params);
OB_ASSERT(in.get_type() == ObDecimalType);
int64_t i64 = 0;
if (OB_SUCCESS != (ret = in.get_decimal().cast_to_int64(i64)))
{
jlog(WARNING, "failed to cast to int64, err=%d", ret);
}
else
{
out.set_mtime(static_cast<ObModifyTime> (i64));
}
return ret;
}
