Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
package starrocks
import (
"testing"
"github.com/stretchr/testify/require"
"github.com/bytebase/bytebase/backend/plugin/parser/base"
)
func TestExplainStatement(t *testing.T) {
tests := []struct {
statement string
want string
}{
{"SELECT 1", "EXPLAIN SELECT 1"},
{"SELECT 1;", "EXPLAIN SELECT 1;"},
{"WITH x AS (SELECT 1) SELECT * FROM x", "EXPLAIN WITH x AS (SELECT 1) SELECT * FROM x"},
// A statement that already asks for a plan is rebuilt around the statement
// it plans, so no request plans a plan.
{"EXPLAIN SELECT 1", "EXPLAIN SELECT 1"},
{"EXPLAIN VERBOSE SELECT 1", "EXPLAIN SELECT 1"},
{"EXPLAIN SELECT 1 ORDER BY 1", "EXPLAIN SELECT 1 ORDER BY 1"},
{"EXPLAIN WITH x AS (SELECT 1) SELECT * FROM x", "EXPLAIN WITH x AS (SELECT 1) SELECT * FROM x"},
}
for _, tc := range tests {
got, err := explainStatement(tc.statement, base.ExplainFormatDefault)
require.NoErrorf(t, err, "%q", tc.statement)
require.Equalf(t, tc.want, got, "%q", tc.statement)
}
}
func TestExplainStatementRejects(t *testing.T) {
for _, statement := range []string{
"SELECT 1; SELECT 2",
"",
} {
_, err := explainStatement(statement, base.ExplainFormatDefault)
require.Errorf(t, err, "%q", statement)
}
}