third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5af.test - Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory.

Side by Side Diff: third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5af.test

Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory. (Closed)

Patch Set: Created 3 years, 7 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

« no previous file with comments | « third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5ae.test ('k') | third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5ag.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')

OLD	NEW
	(Empty)
1 # 2014 June 17

2 #

3 # The author disclaims copyright to this source code. In place of

4 # a legal notice, here is a blessing:

5 #

6 # May you do good and not evil.

7 # May you find forgiveness for yourself and forgive others.

8 # May you share freely, never taking more than you give.

9 #

10 #*************************************************************************

11 # This file implements regression tests for SQLite library. The

12 # focus of this script is testing the FTS5 module.

13 #

14 # More specifically, the tests in this file focus on the built-in

15 # snippet() function.

16 #

17

18 source [file join [file dirname [info script]] fts5_common.tcl]

19 set testprefix fts5af

20

21 # If SQLITE_ENABLE_FTS5 is defined, omit this file.

22 ifcapable !fts5 {

23 finish_test

24 return

25 }

26

27

28 do_execsql_test 1.0 {

29 CREATE VIRTUAL TABLE t1 USING fts5(x, y);

30 }

31

32 proc do_snippet_test {tn doc match res} {

33

34 uplevel #0 [list set v1 $doc]

35 uplevel #0 [list set v2 $match]

36

37 do_execsql_test $tn.1 {

38 DELETE FROM t1;

39 INSERT INTO t1 VALUES($v1, NULL);

40 SELECT snippet(t1, -1, '[', ']', '...', 7) FROM t1 WHERE t1 MATCH $v2;

41 } [list $res]

42

43 do_execsql_test $tn.2 {

44 DELETE FROM t1;

45 INSERT INTO t1 VALUES(NULL, $v1);

46 SELECT snippet(t1, -1, '[', ']', '...', 7) FROM t1 WHERE t1 MATCH $v2;

47 } [list $res]

48

49 do_execsql_test $tn.3 {

50 DELETE FROM t1;

51 INSERT INTO t1 VALUES($v1, NULL);

52 SELECT snippet(t1, -1, '[', ']', '...', 7) FROM t1 WHERE t1 MATCH $v2

53 ORDER BY rank DESC;

54 } [list $res]

55

56

57 }

58

59

60 foreach {tn doc res} {

61

62 1.1 {X o o o o o o} {[X] o o o o o o}

63 1.2 {o X o o o o o} {o [X] o o o o o}

64 1.3 {o o X o o o o} {o o [X] o o o o}

65 1.4 {o o o X o o o} {o o o [X] o o o}

66 1.5 {o o o o X o o} {o o o o [X] o o}

67 1.6 {o o o o o X o} {o o o o o [X] o}

68 1.7 {o o o o o o X} {o o o o o o [X]}

69

70 2.1 {X o o o o o o o} {[X] o o o o o o...}

71 2.2 {o X o o o o o o} {o [X] o o o o o...}

72 2.3 {o o X o o o o o} {o o [X] o o o o...}

73 2.4 {o o o X o o o o} {o o o [X] o o o...}

74 2.5 {o o o o X o o o} {...o o o [X] o o o}

75 2.6 {o o o o o X o o} {...o o o o [X] o o}

76 2.7 {o o o o o o X o} {...o o o o o [X] o}

77 2.8 {o o o o o o o X} {...o o o o o o [X]}

78

79 3.1 {X o o o o o o o o} {[X] o o o o o o...}

80 3.2 {o X o o o o o o o} {o [X] o o o o o...}

81 3.3 {o o X o o o o o o} {o o [X] o o o o...}

82 3.4 {o o o X o o o o o} {o o o [X] o o o...}

83 3.5 {o o o o X o o o o} {...o o o [X] o o o...}

84 3.6 {o o o o o X o o o} {...o o o [X] o o o}

85 3.7 {o o o o o o X o o} {...o o o o [X] o o}

86 3.8 {o o o o o o o X o} {...o o o o o [X] o}

87 3.9 {o o o o o o o o X} {...o o o o o o [X]}

88

89 4.1 {X o o o o o X o o} {[X] o o o o o [X]...}

90 4.2 {o X o o o o o X o} {...[X] o o o o o [X]...}

91 4.3 {o o X o o o o o X} {...[X] o o o o o [X]}

92

93 5.1 {X o o o o X o o o} {[X] o o o o [X] o...}

94 5.2 {o X o o o o X o o} {...[X] o o o o [X] o...}

95 5.3 {o o X o o o o X o} {...[X] o o o o [X] o}

96 5.4 {o o o X o o o o X} {...o [X] o o o o [X]}

97

98 6.1 {X o o o X o o o} {[X] o o o [X] o o...}

99 6.2 {o X o o o X o o o} {o [X] o o o [X] o...}

100 6.3 {o o X o o o X o o} {...o [X] o o o [X] o...}

101 6.4 {o o o X o o o X o} {...o [X] o o o [X] o}

102 6.5 {o o o o X o o o X} {...o o [X] o o o [X]}

103

104 7.1 {X o o X o o o o o} {[X] o o [X] o o o...}

105 7.2 {o X o o X o o o o} {o [X] o o [X] o o...}

106 7.3 {o o X o o X o o o} {...o [X] o o [X] o o...}

107 7.4 {o o o X o o X o o} {...o [X] o o [X] o o}

108 7.5 {o o o o X o o X o} {...o o [X] o o [X] o}

109 7.6 {o o o o o X o o X} {...o o o [X] o o [X]}

110 } {

111 do_snippet_test 1.$tn $doc X $res

112 }

113

114 foreach {tn doc res} {

115 1.1 {X Y o o o o o} {[X Y] o o o o o}

116 1.2 {o X Y o o o o} {o [X Y] o o o o}

117 1.3 {o o X Y o o o} {o o [X Y] o o o}

118 1.4 {o o o X Y o o} {o o o [X Y] o o}

119 1.5 {o o o o X Y o} {o o o o [X Y] o}

120 1.6 {o o o o o X Y} {o o o o o [X Y]}

121

122 2.1 {X Y o o o o o o} {[X Y] o o o o o...}

123 2.2 {o X Y o o o o o} {o [X Y] o o o o...}

124 2.3 {o o X Y o o o o} {o o [X Y] o o o...}

125 2.4 {o o o X Y o o o} {...o o [X Y] o o o}

126 2.5 {o o o o X Y o o} {...o o o [X Y] o o}

127 2.6 {o o o o o X Y o} {...o o o o [X Y] o}

128 2.7 {o o o o o o X Y} {...o o o o o [X Y]}

129

130 3.1 {X Y o o o o o o o} {[X Y] o o o o o...}

131 3.2 {o X Y o o o o o o} {o [X Y] o o o o...}

132 3.3 {o o X Y o o o o o} {o o [X Y] o o o...}

133 3.4 {o o o X Y o o o o} {...o o [X Y] o o o...}

134 3.5 {o o o o X Y o o o} {...o o [X Y] o o o}

135 3.6 {o o o o o X Y o o} {...o o o [X Y] o o}

136 3.7 {o o o o o o X Y o} {...o o o o [X Y] o}

137 3.8 {o o o o o o o X Y} {...o o o o o [X Y]}

138

139 } {

140 do_snippet_test 2.$tn $doc "X + Y" $res

141 }

142

143 finish_test

144

OLD	NEW