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 redshift
import "github.com/bytebase/bytebase/backend/plugin/parser/base"
// isMixedQuery checks whether the query accesses the user table and system table at the same time.
func isMixedQuery(m base.SourceColumnSet) (bool, bool) {
hasSystem, hasUser := false, false
for table := range m {
if isSystemResource(table) {
hasSystem = true
} else {
hasUser = true
}
}
if hasSystem && hasUser {
return false, true
}
return !hasUser && hasSystem, false
}
func isSystemResource(resource base.ColumnResource) bool {
// User can access the system table/view by name directly without database/schema name.
// For example: `SELECT * FROM pg_database`, which will access the system table `pg_database`.
// Additionally, user can create a table/view with the same name with system table/view and access them
// by specify the schema name, for example:
// `CREATE TABLE pg_database(id INT); SELECT * FROM public.pg_database;` which will access the user table `pg_database`.
if isSystemSchema(resource.Schema) {
return true
}
if resource.Schema == "" && isSystemView(resource.Table) {
return true
}
if resource.Schema == "" && isSystemTable(resource.Table) {
return true
}
return false
}