Function TestTSQL_NationalStringLiteral

pkg/sql/tokenizer/tsql_test.go:166–205

(t *testing.T)

}

func TestTSQL_NationalStringLiteral(t *testing.T) {
	tkz := newSQLServerTokenizer(t)

	tests := []struct {
		name      string
		input     string
		wantValue string
	}{
		{"N'hello'", "N'hello'", "hello"},
		{"n'hello' lowercase", "n'hello'", "hello"},
		{"N'unicode chars'", "N'こんにちは'", "こんにちは"},
		{"N'' empty", "N''", ""},
		{"in expression", "SELECT N'test'", "test"},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			tokens := tokenize(t, tkz, tt.input)
			found := false
			for _, tok := range tokens {
				if tok.Token.Type == models.TokenTypeNationalStringLiteral {
					if tok.Token.Value != tt.wantValue {
						t.Errorf("expected value %q, got %q", tt.wantValue, tok.Token.Value)
					}
					if tok.Token.Quote != 'N' {
						t.Errorf("expected Quote='N', got %q", tok.Token.Quote)
					}
					found = true
					break
				}
			}
			if !found {
				t.Errorf("did not find TokenTypeNationalStringLiteral in tokens:")
				for i, tok := range tokens {
					t.Logf("  [%d] type=%v value=%q", i, tok.Token.Type, tok.Token.Value)
				}
			}
		})
	}
}

func TestTSQL_NWithoutQuoteIsIdentifier(t *testing.T) {
	// N not followed by quote should be a regular identifier