Function TestArrayContainsCondition

runtime/metricsview/astexpr_test.go:13–228

(t *testing.T)

)

func TestArrayContainsCondition(t *testing.T) {
	mv := &runtimev1.MetricsViewSpec{
		Table:     "test_table",
		Database:  "",
		Connector: "",
		Dimensions: []*runtimev1.MetricsViewSpec_Dimension{
			{Name: "id", Column: "id"},
			{Name: "tags", Column: "tags", Unnest: true},
			{Name: "city", Column: "city"},
		},
		Measures: []*runtimev1.MetricsViewSpec_Measure{
			{Name: "count", Expression: "count(*)", Type: runtimev1.MetricsViewSpec_MEASURE_TYPE_SIMPLE},
		},
	}
	sec := skipMetricsViewSecurity{}

	tests := []struct {
		name     string
		dialect  drivers.Dialect
		dims     []Dimension
		where    *Expression
		wantSQL  string
		wantArgs []any
	}{
		{
			name:    "duckdb: in on unnest dim uses list_has_any",
			dialect: duckdb.DialectDuckDB,
			where: &Expression{Condition: &Condition{
				Operator: OperatorIn,
				Expressions: []*Expression{
					{Name: "tags"},
					{Value: []any{"a", "b", "c"}},
				},
			}},
			wantSQL:  `(list_has_any(("tags"), [?,?,?]))`,
			wantArgs: []any{"a", "b", "c"},
		},
		{
			name:    "duckdb: nin on unnest dim uses NOT list_has_any",
			dialect: duckdb.DialectDuckDB,
			where: &Expression{Condition: &Condition{
				Operator: OperatorNin,
				Expressions: []*Expression{
					{Name: "tags"},
					{Value: []any{"a", "b"}},
				},
			}},
			wantSQL:  `(NOT list_has_any(("tags"), [?,?]))`,
			wantArgs: []any{"a", "b"},
		},
		{
			name:    "duckdb: in on unnest dim with empty list",
			dialect: duckdb.DialectDuckDB,
			where: &Expression{Condition: &Condition{
				Operator: OperatorIn,
				Expressions: []*Expression{
					{Name: "tags"},
					{Value: []any{}},