GeezerVison is showing github.com — sqlparser/keywords_test.go at master · smlxl/sqlparser

This repository was archived by the owner on Apr 24, 2025. It is now read-only.

Expand file tree

keywords_test.go

Copy path

More file actions

Latest commit

History

55 lines (48 loc) · 1.2 KB

keywords_test.go

Copy path

File metadata and controls

55 lines (48 loc) · 1.2 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

package sqlparser

import (

"bufio"

"fmt"

"os"

"path"

"strings"

"testing"

"github.com/stretchr/testify/require"

)

func TestKeywordTable(t *testing.T) {

for _, kw := range keywords {

lookup, ok := keywordLookupTable.LookupString(kw.name)

require.Truef(t, ok, "keyword %q failed to match", kw.name)

require.Equalf(t, lookup, kw.id, "keyword %q matched to %d (expected %d)", kw.name, lookup, kw.id)

}

var vitessReserved = map[string]bool{

"ESCAPE": true,

"NEXT": true,

"OFF": true,

"SAVEPOINT": true,

"SQL_NO_CACHE": true,

}

func TestCompatibility(t *testing.T) {

file, err := os.Open(path.Join("testdata", "mysql_keywords.txt"))

require.NoError(t, err)

defer file.Close()

parser := NewTestParser()

scanner := bufio.NewScanner(file)

skipStep := 4

for scanner.Scan() {

if skipStep != 0 {

skipStep--

continue

}

afterSplit := strings.SplitN(scanner.Text(), "\t", 2)

word, reserved := afterSplit[0], afterSplit[1] == "1"

if reserved || vitessReserved[word] {

word = "`" + word + "`"

}

sql := fmt.Sprintf("create table %s(c1 int)", word)

_, err := parser.ParseStrictDDL(sql)

if err != nil {

t.Errorf("%s is not compatible with mysql", word)

}