third_party/sqlite/src/test/auth2.test - Issue 2765553002: [sql] Import SQLite 3.17.0.

Side by Side Diff: third_party/sqlite/src/test/auth2.test

Issue 2765553002: [sql] Import SQLite 3.17.0. (Closed)

Patch Set: Created 3 years, 9 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:

« third_party/sqlite/patches/0010-build-Undefined-symbol-in-intrinsic-on-clang.patch ('K') | « third_party/sqlite/src/test/auth.test ('k') | third_party/sqlite/src/test/auth3.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')

OLD	NEW
1 # 2006 Aug 24	1 # 2006 Aug 24

2 #	2 #

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

4 # a legal notice, here is a blessing:	4 # a legal notice, here is a blessing:

5 #	5 #

6 # May you do good and not evil.	6 # May you do good and not evil.

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

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

9 #	9 #

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

(...skipping 80 matching lines...) Expand 10 before \| Expand all \| Expand 10 after Loading...
91 }	91 }

92 set ::authargs	92 set ::authargs

93 } {SQLITE_INSERT sqlite_master {} main {}	93 } {SQLITE_INSERT sqlite_master {} main {}

94 SQLITE_CREATE_TABLE t2 {} main {}	94 SQLITE_CREATE_TABLE t2 {} main {}

95 SQLITE_UPDATE sqlite_master type main {}	95 SQLITE_UPDATE sqlite_master type main {}

96 SQLITE_UPDATE sqlite_master name main {}	96 SQLITE_UPDATE sqlite_master name main {}

97 SQLITE_UPDATE sqlite_master tbl_name main {}	97 SQLITE_UPDATE sqlite_master tbl_name main {}

98 SQLITE_UPDATE sqlite_master rootpage main {}	98 SQLITE_UPDATE sqlite_master rootpage main {}

99 SQLITE_UPDATE sqlite_master sql main {}	99 SQLITE_UPDATE sqlite_master sql main {}

100 SQLITE_READ sqlite_master ROWID main {}	100 SQLITE_READ sqlite_master ROWID main {}

101 SQLITE_READ sqlite_master name main {}

102 SQLITE_READ sqlite_master rootpage main {}

103 SQLITE_READ sqlite_master sql main {}

104 SQLITE_READ sqlite_master tbl_name main {}

105 SQLITE_READ sqlite_master type main {}

106 SQLITE_READ sqlite_master ROWID main {}

107 }	101 }

108 do_test auth2-2.2 {	102 do_test auth2-2.2 {

109 set ::authargs {}	103 set ::authargs {}

110 db eval {	104 db eval {

111 CREATE VIEW v2 AS SELECT x+y AS a, y+z AS b from t2;	105 CREATE VIEW v2 AS SELECT x+y AS a, y+z AS b from t2;

112 }	106 }

113 set ::authargs	107 set ::authargs

114 } {SQLITE_INSERT sqlite_master {} main {}	108 } {SQLITE_INSERT sqlite_master {} main {}

115 SQLITE_CREATE_VIEW v2 {} main {}	109 SQLITE_CREATE_VIEW v2 {} main {}

116 SQLITE_UPDATE sqlite_master type main {}	110 SQLITE_UPDATE sqlite_master type main {}

117 SQLITE_UPDATE sqlite_master name main {}	111 SQLITE_UPDATE sqlite_master name main {}

118 SQLITE_UPDATE sqlite_master tbl_name main {}	112 SQLITE_UPDATE sqlite_master tbl_name main {}

119 SQLITE_UPDATE sqlite_master rootpage main {}	113 SQLITE_UPDATE sqlite_master rootpage main {}

120 SQLITE_UPDATE sqlite_master sql main {}	114 SQLITE_UPDATE sqlite_master sql main {}

121 SQLITE_READ sqlite_master ROWID main {}	115 SQLITE_READ sqlite_master ROWID main {}

122 SQLITE_READ sqlite_master name main {}

123 SQLITE_READ sqlite_master rootpage main {}

124 SQLITE_READ sqlite_master sql main {}

125 SQLITE_READ sqlite_master tbl_name main {}

126 SQLITE_READ sqlite_master type main {}

127 SQLITE_READ sqlite_master ROWID main {}

128 }	116 }

129 do_test auth2-2.3 {	117 do_test auth2-2.3 {

130 set ::authargs {}	118 set ::authargs {}

131 db eval {	119 db eval {

132 SELECT a, b FROM v2;	120 SELECT a, b FROM v2;

133 }	121 }

134 set ::authargs	122 set ::authargs

135 } {SQLITE_SELECT {} {} {} {}	123 } {SQLITE_SELECT {} {} {} {}

136 SQLITE_READ t2 x main v2	124 SQLITE_READ t2 x main v2

137 SQLITE_READ t2 y main v2	125 SQLITE_READ t2 y main v2

(...skipping 25 matching lines...) Expand all Loading...
163 SQLITE_READ t2 y main v2	151 SQLITE_READ t2 y main v2

164 SQLITE_READ t2 y main v2	152 SQLITE_READ t2 y main v2

165 SQLITE_READ t2 z main v2	153 SQLITE_READ t2 z main v2

166 SQLITE_READ v2 b main {}	154 SQLITE_READ v2 b main {}

167 SQLITE_READ v2 a main {}	155 SQLITE_READ v2 a main {}

168 SQLITE_SELECT {} {} {} v2	156 SQLITE_SELECT {} {} {} v2

169 }	157 }

170 db2 close	158 db2 close

171	159

172 finish_test	160 finish_test

OLD	NEW