github.com/whtcorpsinc/milevadb-prod@v0.0.0-20211104133533-f57f4be3b597/dbs/memristed/memex/builtin_compare_test.go

// Copyright 2020 WHTCORPS INC, Inc.
//
// Licensed 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,
// See the License for the specific language governing permissions and
// limitations under the License.

package memex

import (
	"time"

	. "github.com/whtcorpsinc/check"
	"github.com/whtcorpsinc/errors"
	"github.com/whtcorpsinc/BerolinaSQL/ast"
	"github.com/whtcorpsinc/BerolinaSQL/perceptron"
	"github.com/whtcorpsinc/BerolinaSQL/allegrosql"
	"github.com/whtcorpsinc/milevadb/types"
	"github.com/whtcorpsinc/milevadb/types/json"
	"github.com/whtcorpsinc/milevadb/soliton/chunk"
)

func (s *testEvaluatorSuite) TestCompareFunctionWithRefine(c *C) {
	tblInfo := newTestBlockBuilder("").add("a", allegrosql.TypeLong).build()
	tests := []struct {
		exprStr string
		result  string
	}{
		{"a < '1.0'", "lt(a, 1)"},
		{"a <= '1.0'", "le(a, 1)"},
		{"a > '1'", "gt(a, 1)"},
		{"a >= '1'", "ge(a, 1)"},
		{"a = '1'", "eq(a, 1)"},
		{"a <=> '1'", "nulleq(a, 1)"},
		{"a != '1'", "ne(a, 1)"},
		{"a < '1.1'", "lt(a, 2)"},
		{"a <= '1.1'", "le(a, 1)"},
		{"a > 1.1", "gt(a, 1)"},
		{"a >= '1.1'", "ge(a, 2)"},
		{"a = '1.1'", "0"},
		{"a <=> '1.1'", "0"},
		{"a != '1.1'", "ne(cast(a, double BINARY), 1.1)"},
		{"'1' < a", "lt(1, a)"},
		{"'1' <= a", "le(1, a)"},
		{"'1' > a", "gt(1, a)"},
		{"'1' >= a", "ge(1, a)"},
		{"'1' = a", "eq(1, a)"},
		{"'1' <=> a", "nulleq(1, a)"},
		{"'1' != a", "ne(1, a)"},
		{"'1.1' < a", "lt(1, a)"},
		{"'1.1' <= a", "le(2, a)"},
		{"'1.1' > a", "gt(2, a)"},
		{"'1.1' >= a", "ge(1, a)"},
		{"'1.1' = a", "0"},
		{"'1.1' <=> a", "0"},
		{"'1.1' != a", "ne(1.1, cast(a, double BINARY))"},
		{"'123456789123456711111189' = a", "0"},
		{"123456789123456789.12345 = a", "0"},
		{"123456789123456789123456789.12345 > a", "1"},
		{"-123456789123456789123456789.12345 > a", "0"},
		{"123456789123456789123456789.12345 < a", "0"},
		{"-123456789123456789123456789.12345 < a", "1"},
		{"'aaaa'=a", "eq(0, a)"},
	}
	defcaus, names, err := DeferredCausetInfos2DeferredCausetsAndNames(s.ctx, perceptron.NewCIStr(""), tblInfo.Name, tblInfo.DefCauss(), tblInfo)
	c.Assert(err, IsNil)
	schemaReplicant := NewSchema(defcaus...)
	for _, t := range tests {
		f, err := ParseSimpleExprsWithNames(s.ctx, t.exprStr, schemaReplicant, names)
		c.Assert(err, IsNil)
		c.Assert(f[0].String(), Equals, t.result)
	}
}

func (s *testEvaluatorSuite) TestCompare(c *C) {
	intVal, uintVal, realVal, stringVal, decimalVal := 1, uint64(1), 1.1, "123", types.NewDecFromFloatForTest(123.123)
	timeVal := types.NewTime(types.FromGoTime(time.Now()), allegrosql.TypeDatetime, 6)
	durationVal := types.Duration{Duration: 12*time.Hour + 1*time.Minute + 1*time.Second}
	jsonVal := json.CreateBinary("123")
	// test cases for generating function signatures.
	tests := []struct {
		arg0     interface{}
		arg1     interface{}
		funcName string
		tp       byte
		expected int64
	}{
		{intVal, intVal, ast.LT, allegrosql.TypeLonglong, 0},
		{stringVal, stringVal, ast.LT, allegrosql.TypeVarString, 0},
		{intVal, decimalVal, ast.LT, allegrosql.TypeNewDecimal, 1},
		{realVal, decimalVal, ast.LT, allegrosql.TypeDouble, 1},
		{durationVal, durationVal, ast.LT, allegrosql.TypeDuration, 0},
		{realVal, realVal, ast.LT, allegrosql.TypeDouble, 0},
		{intVal, intVal, ast.NullEQ, allegrosql.TypeLonglong, 1},
		{decimalVal, decimalVal, ast.LE, allegrosql.TypeNewDecimal, 1},
		{decimalVal, decimalVal, ast.GT, allegrosql.TypeNewDecimal, 0},
		{decimalVal, decimalVal, ast.GE, allegrosql.TypeNewDecimal, 1},
		{decimalVal, decimalVal, ast.NE, allegrosql.TypeNewDecimal, 0},
		{decimalVal, decimalVal, ast.EQ, allegrosql.TypeNewDecimal, 1},
		{decimalVal, decimalVal, ast.NullEQ, allegrosql.TypeNewDecimal, 1},
		{durationVal, durationVal, ast.LE, allegrosql.TypeDuration, 1},
		{durationVal, durationVal, ast.GT, allegrosql.TypeDuration, 0},
		{durationVal, durationVal, ast.GE, allegrosql.TypeDuration, 1},
		{durationVal, durationVal, ast.EQ, allegrosql.TypeDuration, 1},
		{durationVal, durationVal, ast.NE, allegrosql.TypeDuration, 0},
		{durationVal, durationVal, ast.NullEQ, allegrosql.TypeDuration, 1},
		{nil, nil, ast.NullEQ, allegrosql.TypeNull, 1},
		{nil, intVal, ast.NullEQ, allegrosql.TypeDouble, 0},
		{uintVal, intVal, ast.NullEQ, allegrosql.TypeLonglong, 1},
		{uintVal, intVal, ast.EQ, allegrosql.TypeLonglong, 1},
		{intVal, uintVal, ast.NullEQ, allegrosql.TypeLonglong, 1},
		{intVal, uintVal, ast.EQ, allegrosql.TypeLonglong, 1},
		{timeVal, timeVal, ast.LT, allegrosql.TypeDatetime, 0},
		{timeVal, timeVal, ast.LE, allegrosql.TypeDatetime, 1},
		{timeVal, timeVal, ast.GT, allegrosql.TypeDatetime, 0},
		{timeVal, timeVal, ast.GE, allegrosql.TypeDatetime, 1},
		{timeVal, timeVal, ast.EQ, allegrosql.TypeDatetime, 1},
		{timeVal, timeVal, ast.NE, allegrosql.TypeDatetime, 0},
		{timeVal, timeVal, ast.NullEQ, allegrosql.TypeDatetime, 1},
		{jsonVal, jsonVal, ast.LT, allegrosql.TypeJSON, 0},
		{jsonVal, jsonVal, ast.LE, allegrosql.TypeJSON, 1},
		{jsonVal, jsonVal, ast.GT, allegrosql.TypeJSON, 0},
		{jsonVal, jsonVal, ast.GE, allegrosql.TypeJSON, 1},
		{jsonVal, jsonVal, ast.NE, allegrosql.TypeJSON, 0},
		{jsonVal, jsonVal, ast.EQ, allegrosql.TypeJSON, 1},
		{jsonVal, jsonVal, ast.NullEQ, allegrosql.TypeJSON, 1},
	}

	for _, t := range tests {
		bf, err := funcs[t.funcName].getFunction(s.ctx, s.primitiveValsToConstants([]interface{}{t.arg0, t.arg1}))
		c.Assert(err, IsNil)
		args := bf.getArgs()
		c.Assert(args[0].GetType().Tp, Equals, t.tp)
		c.Assert(args[1].GetType().Tp, Equals, t.tp)
		res, isNil, err := bf.evalInt(chunk.Event{})
		c.Assert(err, IsNil)
		c.Assert(isNil, IsFalse)
		c.Assert(res, Equals, t.expected)
	}

	// test <non-const decimal memex> <cmp> <const string memex>
	decimalDefCaus, stringCon := &DeferredCauset{RetType: types.NewFieldType(allegrosql.TypeNewDecimal)}, &Constant{RetType: types.NewFieldType(allegrosql.TypeVarchar)}
	bf, err := funcs[ast.LT].getFunction(s.ctx, []Expression{decimalDefCaus, stringCon})
	c.Assert(err, IsNil)
	args := bf.getArgs()
	c.Assert(args[0].GetType().Tp, Equals, allegrosql.TypeNewDecimal)
	c.Assert(args[1].GetType().Tp, Equals, allegrosql.TypeNewDecimal)

	// test <time defCausumn> <cmp> <non-time const>
	timeDefCaus := &DeferredCauset{RetType: types.NewFieldType(allegrosql.TypeDatetime)}
	bf, err = funcs[ast.LT].getFunction(s.ctx, []Expression{timeDefCaus, stringCon})
	c.Assert(err, IsNil)
	args = bf.getArgs()
	c.Assert(args[0].GetType().Tp, Equals, allegrosql.TypeDatetime)
	c.Assert(args[1].GetType().Tp, Equals, allegrosql.TypeDatetime)
}

func (s *testEvaluatorSuite) TestCoalesce(c *C) {
	cases := []struct {
		args     []interface{}
		expected interface{}
		isNil    bool
		getErr   bool
	}{
		{[]interface{}{nil}, nil, true, false},
		{[]interface{}{nil, nil}, nil, true, false},
		{[]interface{}{nil, nil, nil}, nil, true, false},
		{[]interface{}{nil, 1}, int64(1), false, false},
		{[]interface{}{nil, 1.1}, float64(1.1), false, false},
		{[]interface{}{1, 1.1}, float64(1), false, false},
		{[]interface{}{nil, types.NewDecFromFloatForTest(123.456)}, types.NewDecFromFloatForTest(123.456), false, false},
		{[]interface{}{1, types.NewDecFromFloatForTest(123.456)}, types.NewDecFromInt(1), false, false},
		{[]interface{}{nil, duration}, duration, false, false},
		{[]interface{}{nil, tm, nil}, tm, false, false},
		{[]interface{}{nil, dt, nil}, dt, false, false},
		{[]interface{}{tm, dt}, tm, false, false},
	}

	for _, t := range cases {
		f, err := newFunctionForTest(s.ctx, ast.Coalesce, s.primitiveValsToConstants(t.args)...)
		c.Assert(err, IsNil)

		d, err := f.Eval(chunk.Event{})

		if t.getErr {
			c.Assert(err, NotNil)
		} else {
			c.Assert(err, IsNil)
			if t.isNil {
				c.Assert(d.HoTT(), Equals, types.HoTTNull)
			} else {
				c.Assert(d.GetValue(), DeepEquals, t.expected)
			}
		}
	}

	_, err := funcs[ast.Length].getFunction(s.ctx, []Expression{NewZero()})
	c.Assert(err, IsNil)
}

func (s *testEvaluatorSuite) TestIntervalFunc(c *C) {
	sc := s.ctx.GetStochastikVars().StmtCtx
	origin := sc.IgnoreTruncate
	sc.IgnoreTruncate = true
	defer func() {
		sc.IgnoreTruncate = origin
	}()

	for _, t := range []struct {
		args   []types.Causet
		ret    int64
		getErr bool
	}{
		{types.MakeCausets(nil, 1, 2), -1, false},
		{types.MakeCausets(1, 2, 3), 0, false},
		{types.MakeCausets(2, 1, 3), 1, false},
		{types.MakeCausets(3, 1, 2), 2, false},
		{types.MakeCausets(0, "b", "1", "2"), 1, false},
		{types.MakeCausets("a", "b", "1", "2"), 1, false},
		{types.MakeCausets(23, 1, 23, 23, 23, 30, 44, 200), 4, false},
		{types.MakeCausets(23, 1.7, 15.3, 23.1, 30, 44, 200), 2, false},
		{types.MakeCausets(9007199254740992, 9007199254740993), 0, false},
		{types.MakeCausets(uint64(9223372036854775808), uint64(9223372036854775809)), 0, false},
		{types.MakeCausets(9223372036854775807, uint64(9223372036854775808)), 0, false},
		{types.MakeCausets(-9223372036854775807, uint64(9223372036854775808)), 0, false},
		{types.MakeCausets(uint64(9223372036854775806), 9223372036854775807), 0, false},
		{types.MakeCausets(uint64(9223372036854775806), -9223372036854775807), 1, false},
		{types.MakeCausets("9007199254740991", "9007199254740992"), 0, false},
		{types.MakeCausets(1, uint32(1), uint32(1)), 0, true},
		{types.MakeCausets(-1, 2333, nil), 0, false},
		{types.MakeCausets(1, nil, nil, nil), 3, false},
		{types.MakeCausets(1, nil, nil, nil, 2), 3, false},
		{types.MakeCausets(uint64(9223372036854775808), nil, nil, nil, 4), 4, false},

		// tests for appropriate precision loss
		{types.MakeCausets(9007199254740992, "9007199254740993"), 1, false},
		{types.MakeCausets("9007199254740992", 9007199254740993), 1, false},
		{types.MakeCausets("9007199254740992", "9007199254740993"), 1, false},
	} {
		fc := funcs[ast.Interval]
		f, err := fc.getFunction(s.ctx, s.datumsToConstants(t.args))
		c.Assert(err, IsNil)
		if t.getErr {
			v, err := evalBuiltinFunc(f, chunk.Event{})
			c.Assert(err, NotNil)
			c.Assert(v.GetInt64(), Equals, t.ret)
			continue
		}
		v, err := evalBuiltinFunc(f, chunk.Event{})
		c.Assert(err, IsNil)
		c.Assert(v.GetInt64(), Equals, t.ret)
	}
}

func (s *testEvaluatorSuite) TestGreatestLeastFuncs(c *C) {
	sc := s.ctx.GetStochastikVars().StmtCtx
	originIgnoreTruncate := sc.IgnoreTruncate
	sc.IgnoreTruncate = true
	defer func() {
		sc.IgnoreTruncate = originIgnoreTruncate
	}()

	for _, t := range []struct {
		args             []interface{}
		expectedGreatest interface{}
		expectedLeast    interface{}
		isNil            bool
		getErr           bool
	}{
		{
			[]interface{}{1, 2, 3, 4},
			int64(4), int64(1), false, false,
		},
		{
			[]interface{}{"a", "b", "c"},
			"c", "a", false, false,
		},
		{
			[]interface{}{"123a", "b", "c", 12},
			float64(123), float64(0), false, false,
		},
		{
			[]interface{}{tm, "123"},
			curTimeString, "123", false, false,
		},
		{
			[]interface{}{tm, 123},
			curTimeInt, int64(123), false, false,
		},
		{
			[]interface{}{tm, "invalid_time_1", "invalid_time_2", tmWithFsp},
			curTimeWithFspString, "invalid_time_1", false, false,
		},
		{
			[]interface{}{tm, "invalid_time_2", "invalid_time_1", tmWithFsp},
			curTimeWithFspString, "invalid_time_2", false, false,
		},
		{
			[]interface{}{tm, "invalid_time", nil, tmWithFsp},
			nil, nil, true, false,
		},
		{
			[]interface{}{duration, "123"},
			"12:59:59", "123", false, false,
		},
		{
			[]interface{}{"123", nil, "123"},
			nil, nil, true, false,
		},
		{
			[]interface{}{errors.New("must error"), 123},
			nil, nil, false, true,
		},
	} {
		f0, err := newFunctionForTest(s.ctx, ast.Greatest, s.primitiveValsToConstants(t.args)...)
		c.Assert(err, IsNil)
		d, err := f0.Eval(chunk.Event{})
		if t.getErr {
			c.Assert(err, NotNil)
		} else {
			c.Assert(err, IsNil)
			if t.isNil {
				c.Assert(d.HoTT(), Equals, types.HoTTNull)
			} else {
				c.Assert(d.GetValue(), DeepEquals, t.expectedGreatest)
			}
		}

		f1, err := newFunctionForTest(s.ctx, ast.Least, s.primitiveValsToConstants(t.args)...)
		c.Assert(err, IsNil)
		d, err = f1.Eval(chunk.Event{})
		if t.getErr {
			c.Assert(err, NotNil)
		} else {
			c.Assert(err, IsNil)
			if t.isNil {
				c.Assert(d.HoTT(), Equals, types.HoTTNull)
			} else {
				c.Assert(d.GetValue(), DeepEquals, t.expectedLeast)
			}
		}
	}
	_, err := funcs[ast.Greatest].getFunction(s.ctx, []Expression{NewZero(), NewOne()})
	c.Assert(err, IsNil)
	_, err = funcs[ast.Least].getFunction(s.ctx, []Expression{NewZero(), NewOne()})
	c.Assert(err, IsNil)
}