github.com/matrixorigin/matrixone@v0.7.0/pkg/sql/plan/function/builtin/binary/extract_test.go (about)

     1  // Copyright 2022 Matrix Origin
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //      http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  
    15  package binary
    16  
    17  import (
    18  	"fmt"
    19  	"testing"
    20  
    21  	"github.com/matrixorigin/matrixone/pkg/container/nulls"
    22  	"github.com/matrixorigin/matrixone/pkg/container/vector"
    23  	"github.com/matrixorigin/matrixone/pkg/testutil"
    24  	"github.com/stretchr/testify/require"
    25  )
    26  
    27  func TestExtractFromDate(t *testing.T) {
    28  	vector0 := testutil.MakeScalarVarchar("year", 4)
    29  	vector1 := testutil.MakeDateVector([]string{"2020-01-01", "2021-02-03", "2024-03-04", ""}, []uint64{3})
    30  	inputVectors := make([]*vector.Vector, 2)
    31  	inputVectors[0] = vector0
    32  	inputVectors[1] = vector1
    33  	proc := testutil.NewProc()
    34  	outputVector, err := ExtractFromDate(inputVectors, proc)
    35  	require.NoError(t, err)
    36  	outputValues, ok := outputVector.Col.([]uint32)
    37  	require.True(t, ok)
    38  	require.Equal(t, []uint32{2020, 2021, 2024, 1}, outputValues)
    39  	// XXX why?  This seems to be wrong.  ExtractFromDate "" should error out,
    40  	// but if it does not, we tested the result is 1 in prev check.
    41  	// it should not be null.
    42  	// require.True(t, nulls.Contains(outputVector.Nsp, uint64(3)))
    43  
    44  	vector0 = testutil.MakeScalarVarchar("month", 4)
    45  	vector1 = testutil.MakeDateVector([]string{"2020-01-01", "2021-02-03", "2024-03-04", ""}, []uint64{3})
    46  	inputVectors = make([]*vector.Vector, 2)
    47  	inputVectors[0] = vector0
    48  	inputVectors[1] = vector1
    49  	proc = testutil.NewProc()
    50  	outputVector, err = ExtractFromDate(inputVectors, proc)
    51  	require.NoError(t, err)
    52  	outputValues, ok = outputVector.Col.([]uint32)
    53  	fmt.Println(outputValues)
    54  	require.True(t, ok)
    55  	require.Equal(t, []uint32{1, 2, 3, 1}, outputValues)
    56  	// XXX same as above.
    57  	// require.True(t, nulls.Contains(outputVector.Nsp, uint64(3)))
    58  
    59  	vector0 = testutil.MakeScalarVarchar("day", 4)
    60  	vector1 = testutil.MakeDateVector([]string{"2020-01-01", "2021-02-03", "2024-03-04", ""}, []uint64{3})
    61  	inputVectors = make([]*vector.Vector, 2)
    62  	inputVectors[0] = vector0
    63  	inputVectors[1] = vector1
    64  	proc = testutil.NewProc()
    65  	outputVector, err = ExtractFromDate(inputVectors, proc)
    66  	require.NoError(t, err)
    67  	outputValues, ok = outputVector.Col.([]uint32)
    68  	fmt.Println(outputValues)
    69  	require.True(t, ok)
    70  	require.Equal(t, []uint32{1, 3, 4, 1}, outputValues)
    71  	// XXX Same
    72  	// require.True(t, nulls.Contains(outputVector.Nsp, uint64(3)))
    73  
    74  	vector0 = testutil.MakeScalarVarchar("year_month", 4)
    75  	vector1 = testutil.MakeDateVector([]string{"2020-01-01", "2021-02-03", "2024-03-04", ""}, []uint64{3})
    76  	inputVectors = make([]*vector.Vector, 2)
    77  	inputVectors[0] = vector0
    78  	inputVectors[1] = vector1
    79  	proc = testutil.NewProc()
    80  	outputVector, err = ExtractFromDate(inputVectors, proc)
    81  	require.NoError(t, err)
    82  	outputValues, ok = outputVector.Col.([]uint32)
    83  	fmt.Println(outputValues)
    84  	require.True(t, ok)
    85  	require.Equal(t, []uint32{202001, 202102, 202403, 101}, outputValues)
    86  	// XXX same
    87  	// require.True(t, nulls.Contains(outputVector.Nsp, uint64(3)))
    88  }
    89  
    90  func TestExtractFromDatetime(t *testing.T) {
    91  	// XXX This is broken.   empty should cause an error instead of null.
    92  	vector0 := testutil.MakeScalarVarchar("year", 4)
    93  	vector1 := testutil.MakeDateTimeVector([]string{"2020-01-01 11:12:13.0006", "2006-01-02 15:03:04.1234", "2024-03-04 12:13:14", ""}, []uint64{3})
    94  	inputVectors := make([]*vector.Vector, 2)
    95  	inputVectors[0] = vector0
    96  	inputVectors[1] = vector1
    97  	proc := testutil.NewProc()
    98  	outputVector, err := ExtractFromDatetime(inputVectors, proc)
    99  	require.NoError(t, err)
   100  	outstr := vector.GetStrVectorValues(outputVector)
   101  	require.Equal(t, []string{"2020", "2006", "2024"}, outstr[:3])
   102  	require.True(t, nulls.Contains(outputVector.Nsp, uint64(3)))
   103  }