Function TestValidateQuery

backend/plugin/parser/doris/query_test.go:9–172

(t *testing.T)

)

func TestValidateQuery(t *testing.T) {
	tests := []struct {
		statement   string
		valid       bool
		description string
	}{
		{
			statement:   "SELECT * FROM users",
			valid:       true,
			description: "Basic SELECT query",
		},
		{
			statement:   "SELECT * FROM users WHERE id = 1",
			valid:       true,
			description: "SELECT with WHERE clause",
		},
		{
			statement:   "SHOW DATA",
			valid:       true,
			description: "SHOW DATA statement",
		},
		{
			statement:   "SHOW DATA FROM db1",
			valid:       true,
			description: "SHOW DATA with FROM clause",
		},
		{
			statement:   "SHOW DATABASES",
			valid:       true,
			description: "SHOW DATABASES statement",
		},
		{
			statement:   "SHOW TABLES",
			valid:       true,
			description: "SHOW TABLES statement",
		},
		{
			statement:   "SHOW TABLETS FROM table1",
			valid:       true,
			description: "SHOW TABLETS statement",
		},
		{
			statement:   "SHOW VARIABLES",
			valid:       true,
			description: "SHOW VARIABLES statement",
		},
		{
			statement:   "SHOW CREATE TABLE users",
			valid:       true,
			description: "SHOW CREATE TABLE statement",
		},
		{
			statement:   "SHOW CREATE DATABASE db1",
			valid:       true,
			description: "SHOW CREATE DATABASE statement",
		},
		{
			statement:   "INSERT INTO users (id, name) VALUES (1, 'test')",