github.com/whtcorpsinc/MilevaDB-Prod@v0.0.0-20211104133533-f57f4be3b597/interlock/aggfuncs/func_group_concat_test.go (about)

     1  // Copyright 2020 WHTCORPS INC, Inc.
     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  // See the License for the specific language governing permissions and
    12  // limitations under the License.
    13  
    14  package aggfuncs_test
    15  
    16  import (
    17  	"fmt"
    18  
    19  	. "github.com/whtcorpsinc/check"
    20  	"github.com/whtcorpsinc/BerolinaSQL/ast"
    21  	"github.com/whtcorpsinc/BerolinaSQL/allegrosql"
    22  	"github.com/whtcorpsinc/milevadb/stochastikctx/variable"
    23  	"github.com/whtcorpsinc/milevadb/types"
    24  )
    25  
    26  func (s *testSuite) TestMergePartialResult4GroupConcat(c *C) {
    27  	test := builPosetDaggTester(ast.AggFuncGroupConcat, allegrosql.TypeString, 5, "0 1 2 3 4", "2 3 4", "0 1 2 3 4 2 3 4")
    28  	s.testMergePartialResult(c, test)
    29  }
    30  
    31  func (s *testSuite) TestGroupConcat(c *C) {
    32  	test := builPosetDaggTester(ast.AggFuncGroupConcat, allegrosql.TypeString, 5, nil, "0 1 2 3 4")
    33  	s.testAggFunc(c, test)
    34  
    35  	test2 := buildMultiArgsAggTester(ast.AggFuncGroupConcat, []byte{allegrosql.TypeString, allegrosql.TypeString}, allegrosql.TypeString, 5, nil, "44 33 22 11 00")
    36  	test2.orderBy = true
    37  	s.testMultiArgsAggFunc(c, test2)
    38  
    39  	defer variable.SetStochastikSystemVar(s.ctx.GetStochastikVars(), variable.GroupConcatMaxLen, types.NewStringCauset("1024"))
    40  	// minimum GroupConcatMaxLen is 4
    41  	for i := 4; i <= 7; i++ {
    42  		variable.SetStochastikSystemVar(s.ctx.GetStochastikVars(), variable.GroupConcatMaxLen, types.NewStringCauset(fmt.Sprint(i)))
    43  		test2 = buildMultiArgsAggTester(ast.AggFuncGroupConcat, []byte{allegrosql.TypeString, allegrosql.TypeString}, allegrosql.TypeString, 5, nil, "44 33 22 11 00"[:i])
    44  		test2.orderBy = true
    45  		s.testMultiArgsAggFunc(c, test2)
    46  	}
    47  }