71 lines
2.2 KiB
Go
71 lines
2.2 KiB
Go
// Copyright 2023 Dolthub, 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,
|
|
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
|
// See the License for the specific language governing permissions and
|
|
// limitations under the License.
|
|
|
|
package ast
|
|
|
|
import (
|
|
"github.com/cockroachdb/errors"
|
|
|
|
vitess "github.com/dolthub/vitess/go/vt/sqlparser"
|
|
|
|
"github.com/dolthub/doltgresql/postgres/parser/sem/tree"
|
|
)
|
|
|
|
// nodeDropIndex handles *tree.DropIndex nodes.
|
|
func nodeDropIndex(ctx *Context, node *tree.DropIndex) (*vitess.AlterTable, error) {
|
|
if node == nil || len(node.IndexList) == 0 {
|
|
return nil, nil
|
|
}
|
|
switch node.DropBehavior {
|
|
case tree.DropDefault:
|
|
// Default behavior, nothing to do
|
|
case tree.DropRestrict:
|
|
return nil, errors.Errorf("RESTRICT is not yet supported")
|
|
case tree.DropCascade:
|
|
return nil, errors.Errorf("CASCADE is not yet supported")
|
|
}
|
|
if len(node.IndexList) > 1 {
|
|
return nil, errors.Errorf("multi-index dropping is not yet supported")
|
|
}
|
|
if node.Concurrently {
|
|
return nil, errors.Errorf("concurrent indexes are not yet supported")
|
|
}
|
|
var tableName vitess.TableName
|
|
ddls := make([]*vitess.DDL, len(node.IndexList))
|
|
for i, index := range node.IndexList {
|
|
newTableName, err := nodeTableName(ctx, &index.Table)
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
if !tableName.Name.IsEmpty() && tableName.String() != newTableName.String() {
|
|
return nil, errors.Errorf("only dropping indexes from the same table is currently supported")
|
|
}
|
|
tableName = newTableName
|
|
ddls[i] = &vitess.DDL{
|
|
Action: vitess.AlterStr,
|
|
Table: tableName,
|
|
IfExists: node.IfExists,
|
|
IndexSpec: &vitess.IndexSpec{
|
|
Action: vitess.DropStr,
|
|
FromName: vitess.NewColIdent(string(index.Index)),
|
|
ToName: vitess.NewColIdent(string(index.Index)),
|
|
},
|
|
}
|
|
}
|
|
return &vitess.AlterTable{
|
|
Table: tableName,
|
|
Statements: ddls,
|
|
}, nil
|
|
}
|