FilesExpand file tree

 master

/

ast_test.go

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

81 lines (68 loc) · 2.42 KB

 master

/

ast_test.go

Copy path

Top

File metadata and controls

• Code
• Blame

81 lines (68 loc) · 2.42 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

// Copyright 2014, Google Inc. All rights reserved.

// Use of this source code is governed by a BSD-style

// license that can be found in the LICENSE file.

package sqlparser

import "testing"

func TestLimits(t *testing.T) {

var l *Limit

o, r, err := l.Limits()

if o != nil || r != nil || err != nil {

t.Errorf("got %v, %v, %v, want nils", o, r, err)

}

l = &Limit{Offset: NumVal([]byte("aa"))}

_, _, err = l.Limits()

wantErr := "strconv.ParseInt: parsing \"aa\": invalid syntax"

if err == nil || err.Error() != wantErr {

t.Errorf("got %v, want %s", err, wantErr)

}

l = &Limit{Offset: NumVal([]byte("2"))}

_, _, err = l.Limits()

wantErr = "unexpected node for rowcount: <nil>"

if err == nil || err.Error() != wantErr {

t.Errorf("got %v, want %s", err, wantErr)

}

l = &Limit{Offset: StrVal([]byte("2"))}

_, _, err = l.Limits()

wantErr = "unexpected node for offset: [50]"

if err == nil || err.Error() != wantErr {

t.Errorf("got %v, want %s", err, wantErr)

}

l = &Limit{Offset: NumVal([]byte("2")), Rowcount: NumVal([]byte("aa"))}

_, _, err = l.Limits()

wantErr = "strconv.ParseInt: parsing \"aa\": invalid syntax"

if err == nil || err.Error() != wantErr {

t.Errorf("got %v, want %s", err, wantErr)

}

l = &Limit{Offset: NumVal([]byte("2")), Rowcount: NumVal([]byte("3"))}

o, r, err = l.Limits()

if o.(int64) != 2 || r.(int64) != 3 || err != nil {

t.Errorf("got %v %v %v, want 2, 3, nil", o, r, err)

}

l = &Limit{Offset: ValArg([]byte(":a")), Rowcount: NumVal([]byte("3"))}

o, r, err = l.Limits()

if o.(string) != ":a" || r.(int64) != 3 || err != nil {

t.Errorf("got %v %v %v, want :a, 3, nil", o, r, err)

}

l = &Limit{Offset: nil, Rowcount: NumVal([]byte("3"))}

o, r, err = l.Limits()

if o != nil || r.(int64) != 3 || err != nil {

t.Errorf("got %v %v %v, want nil, 3, nil", o, r, err)

}

l = &Limit{Offset: nil, Rowcount: ValArg([]byte(":a"))}

o, r, err = l.Limits()

if o != nil || r.(string) != ":a" || err != nil {

t.Errorf("got %v %v %v, want nil, :a, nil", o, r, err)

}

l = &Limit{Offset: NumVal([]byte("-2")), Rowcount: NumVal([]byte("0"))}

_, _, err = l.Limits()

wantErr = "negative offset: -2"

if err == nil || err.Error() != wantErr {

t.Errorf("got %v, want %s", err, wantErr)

}

l = &Limit{Offset: NumVal([]byte("2")), Rowcount: NumVal([]byte("-2"))}

_, _, err = l.Limits()

wantErr = "negative limit: -2"

if err == nil || err.Error() != wantErr {

t.Errorf("got %v, want %s", err, wantErr)

}

}