Function TestNegativeParser_SQLStrings

pkg/sql/parser/negative_parser_test.go:409–446

TestNegativeParser_UsingTokenizeHelper uses the tokenizer helper from context_test.go to test SQL strings that should fail to parse.

(t *testing.T)

// TestNegativeParser_UsingTokenizeHelper uses the tokenizer helper from context_test.go
// to test SQL strings that should fail to parse.
func TestNegativeParser_SQLStrings(t *testing.T) {
	tests := []struct {
		name string
		sql  string
	}{
		{"empty string", ""},
		{"just whitespace", "   "},
		{"just semicolon", ";"},
		{"SELECT no columns", "SELECT FROM users"},
		{"unclosed string literal", "SELECT 'hello FROM users"},
		{"double FROM", "SELECT * FROM t1 FROM t2"},
		{"ORDER without BY", "SELECT * FROM t ORDER"},
		{"GROUP without BY", "SELECT * FROM t GROUP"},
		{"random keywords", "WHERE FROM SELECT JOIN ON"},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			defer func() {
				if r := recover(); r != nil {
					t.Fatalf("parser panicked on %q: %v", tt.sql, r)
				}
			}()

			p := GetParser()
			defer PutParser(p)

			// Tokenize - may fail, that's fine
			tokens := tokenizeForTest(t, tt.sql)
			if tokens == nil {
				return // tokenization failed, that's a valid outcome
			}

			_, _ = p.Parse(tokens)
			// No panic is the success criterion
		})
	}
}

// tokenizeForTest tokenizes a SQL string into parser tokens.
// Returns nil if tokenization or conversion fails (valid outcome for negative tests).