Function TestParseError

pkg/sql/parser/parse_test.go:2364–2948

(t *testing.T)

}

func TestParseError(t *testing.T) {
	testData := []struct {
		sql      string
		expected string
	}{
		{`SELECT2 1`,
			`at or near "select2": syntax error
DETAIL: source SQL:
SELECT2 1
^`},
		{`SELECT 1 FROM (t)`,
			`at or near ")": syntax error
DETAIL: source SQL:
SELECT 1 FROM (t)
                ^
HINT: try \h <SOURCE>`},
		{`SET TIME ZONE INTERVAL 'foobar'`,
			`at or near "EOF": syntax error: could not parse "foobar" as type interval: interval: missing unit at position 0: "foobar"
DETAIL: source SQL:
SET TIME ZONE INTERVAL 'foobar'
                               ^`},
		{`SELECT INTERVAL 'foo'`,
			`at or near "EOF": syntax error: could not parse "foo" as type interval: interval: missing unit at position 0: "foo"
DETAIL: source SQL:
SELECT INTERVAL 'foo'
                     ^`},
		{`SELECT 1 /* hello`,
			`lexical error: unterminated comment
DETAIL: source SQL:
SELECT 1 /* hello
         ^`},
		{`SELECT '1`,
			`lexical error: unterminated string
DETAIL: source SQL:
SELECT '1
       ^
HINT: try \h SELECT`},
		{`SELECT * FROM t WHERE k=`,
			`at or near "EOF": syntax error
DETAIL: source SQL:
SELECT * FROM t WHERE k=
                        ^
HINT: try \h SELECT`,
		},
		{`CREATE TABLE test (
  CONSTRAINT foo INDEX (bar)
)`,
			`at or near "index": syntax error
DETAIL: source SQL:
CREATE TABLE test (
  CONSTRAINT foo INDEX (bar)
                 ^
HINT: try \h CREATE TABLE`},
		{`CREATE TABLE test (
  foo BIT(0)
)`,
			`at or near ")": syntax error: length for type bit must be at least 1
DETAIL: source SQL: