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 oceanbase
import (
"testing"
"github.com/stretchr/testify/require"
storepb "github.com/bytebase/bytebase/backend/generated-go/store"
"github.com/bytebase/bytebase/backend/plugin/parser/base"
)
func TestParseStatements(t *testing.T) {
statement := "SELECT 1; SELECT 2;"
statements, err := base.ParseStatements(storepb.Engine_OCEANBASE, statement)
require.NoError(t, err)
require.Len(t, statements, 2)
// Check first statement
require.Equal(t, "SELECT 1;", statements[0].Text)
require.False(t, statements[0].Empty)
require.NotNil(t, statements[0].AST)
require.NotNil(t, statements[0].Start)
// Check second statement
require.Contains(t, statements[1].Text, "SELECT 2")
require.False(t, statements[1].Empty)
require.NotNil(t, statements[1].AST)
}
func TestParseStatementsSyntaxErrorColumnOnSharedLine(t *testing.T) {
for _, tc := range []struct {
engine storepb.Engine
statement string
want *storepb.Position
}{
// The error is at the ')' after DEFAULT, column 51 of the line.
{storepb.Engine_OCEANBASE, "SELECT 1; CREATE TABLE t (a INT DEFAULT);", &storepb.Position{Line: 1, Column: 40}},
{storepb.Engine_OCEANBASE, "SELECT 1;\nSELECT 2; CREATE TABLE t (a INT DEFAULT);", &storepb.Position{Line: 2, Column: 40}},
} {
_, err := base.ParseStatements(tc.engine, tc.statement)
var syntaxErr *base.SyntaxError
require.ErrorAs(t, err, &syntaxErr, tc.statement)
require.Equal(t, tc.want, syntaxErr.Position, tc.statement)
}
}
func TestParseStatementsRejectsMariaDBSyntax(t *testing.T) {
for _, engine := range []storepb.Engine{storepb.Engine_OCEANBASE} {
_, err := base.ParseStatements(engine, "CREATE OR REPLACE TABLE t (a INT);")
var syntaxErr *base.SyntaxError
require.ErrorAs(t, err, &syntaxErr, engine.String())
}
}