featurebase/sql3/planner/compilecreateview.go
Pat Okeeffe 5c74b64722
A bug fix roundup (#2242)
* fb-1940 re-implemented some changes that got missed private-public

* fb-1939 fixes to between + decimals

* fb-1935 - avg() on and id type + fixed some tests

* fb-1953 add min/max for string types

* fb-1938 - remove internal_type column from show columns

* fb-1964 - fix space_used in fb_cluster_nodes to be int

* fb-1996 - make sure all Idents that are being used as object references to schema objects are lowercased

* fixed failing test

* added some missed changes

* fb-1969 found another case issue with identifier used for column idents
2023-02-13 12:28:34 -06:00

67 lines
1.8 KiB
Go

// Copyright 2022 Molecula Corp. All rights reserved.
package planner
import (
"context"
"strings"
"github.com/featurebasedb/featurebase/v3/sql3/parser"
"github.com/featurebasedb/featurebase/v3/sql3/planner/types"
)
// compileCreateViewStatement compiles a parser.CreateViewStatement AST into a PlanOperator
func (p *ExecutionPlanner) compileCreateViewStatement(stmt *parser.CreateViewStatement) (types.PlanOperator, error) {
viewName := strings.ToLower(parser.IdentName(stmt.Name))
view := &viewSystemObject{
name: viewName,
}
// compile select
_, err := p.compileSelectStatement(stmt.Select, true)
if err != nil {
return nil, err
}
view.statement = stmt.Select.String()
query := NewPlanOpQuery(p, NewPlanOpCreateView(p, stmt.IfNotExists.IsValid(), view), p.sql)
return query, nil
}
// compileAlterViewStatement compiles a parser.AlterViewStatement AST into a PlanOperator
func (p *ExecutionPlanner) compileAlterViewStatement(stmt *parser.AlterViewStatement) (types.PlanOperator, error) {
viewName := strings.ToLower(parser.IdentName(stmt.Name))
view := &viewSystemObject{
name: viewName,
}
// compile select
_, err := p.compileSelectStatement(stmt.Select, true)
if err != nil {
return nil, err
}
view.statement = stmt.Select.String()
query := NewPlanOpQuery(p, NewPlanOpAlterView(p, view), p.sql)
return query, nil
}
func (p *ExecutionPlanner) analyzeCreateViewStatement(ctx context.Context, stmt *parser.CreateViewStatement) error {
//analyze the select
_, err := p.analyzeSelectStatement(ctx, stmt.Select)
if err != nil {
return err
}
return nil
}
func (p *ExecutionPlanner) analyzeAlterViewStatement(ctx context.Context, stmt *parser.AlterViewStatement) error {
//analyze the select
_, err := p.analyzeSelectStatement(ctx, stmt.Select)
if err != nil {
return err
}
return nil
}