]> git.sur5r.net Git - openldap/blob - tests/data/sql-read.out
rework SQL tests invocation; improve all tests
[openldap] / tests / data / sql-read.out
1 # Testing search...
2 dn: documentTitle=book1,dc=example,dc=com
3 objectClass: document
4 description: abstract1
5 documentTitle: book1
6 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
7 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
8 documentIdentifier: document 1
9
10 dn: documentTitle=book2,dc=example,dc=com
11 objectClass: document
12 description: abstract2
13 documentTitle: book2
14 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
15 documentIdentifier: document 2
16
17 dn: dc=example,dc=com
18 objectClass: organization
19 objectClass: dcObject
20 o: Example
21 dc: example
22
23 dn: cn=Mitya Kovalev,dc=example,dc=com
24 objectClass: inetOrgPerson
25 cn: Mitya Kovalev
26 sn: Kovalev
27 seeAlso: documentTitle=book1,dc=example,dc=com
28 seeAlso: documentTitle=book2,dc=example,dc=com
29 givenName: Mitya
30 telephoneNumber: 332-2334
31 telephoneNumber: 222-3234
32
33 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
34 objectClass: inetOrgPerson
35 cn: Torvlobnor Puzdoy
36 sn: Puzdoy
37 seeAlso: documentTitle=book1,dc=example,dc=com
38 givenName: Torvlobnor
39 telephoneNumber: 545-4563
40
41 # refldap://localhost/dc=example,dc=com??sub
42
43 # Testing exact search...
44 dn: cn=Mitya Kovalev,dc=example,dc=com
45 objectClass: inetOrgPerson
46 cn: Mitya Kovalev
47 sn: Kovalev
48 seeAlso: documentTitle=book1,dc=example,dc=com
49 seeAlso: documentTitle=book2,dc=example,dc=com
50 givenName: Mitya
51 telephoneNumber: 332-2334
52 telephoneNumber: 222-3234
53
54 # Testing substrings initial search...
55 dn: cn=Mitya Kovalev,dc=example,dc=com
56 objectClass: inetOrgPerson
57 cn: Mitya Kovalev
58 sn: Kovalev
59 seeAlso: documentTitle=book1,dc=example,dc=com
60 seeAlso: documentTitle=book2,dc=example,dc=com
61 givenName: Mitya
62 telephoneNumber: 332-2334
63 telephoneNumber: 222-3234
64
65 # Testing substrings any search...
66 dn: cn=Mitya Kovalev,dc=example,dc=com
67 objectClass: inetOrgPerson
68 cn: Mitya Kovalev
69 sn: Kovalev
70 seeAlso: documentTitle=book1,dc=example,dc=com
71 seeAlso: documentTitle=book2,dc=example,dc=com
72 givenName: Mitya
73 telephoneNumber: 332-2334
74 telephoneNumber: 222-3234
75
76 # Testing substrings final search...
77 dn: cn=Mitya Kovalev,dc=example,dc=com
78 objectClass: inetOrgPerson
79 cn: Mitya Kovalev
80 sn: Kovalev
81 seeAlso: documentTitle=book1,dc=example,dc=com
82 seeAlso: documentTitle=book2,dc=example,dc=com
83 givenName: Mitya
84 telephoneNumber: 332-2334
85 telephoneNumber: 222-3234
86
87 # Testing approx search...
88 dn: cn=Mitya Kovalev,dc=example,dc=com
89 objectClass: inetOrgPerson
90 cn: Mitya Kovalev
91 sn: Kovalev
92 seeAlso: documentTitle=book1,dc=example,dc=com
93 seeAlso: documentTitle=book2,dc=example,dc=com
94 givenName: Mitya
95 telephoneNumber: 332-2334
96 telephoneNumber: 222-3234
97
98 # Testing extensible filter search...
99 dn: cn=Mitya Kovalev,dc=example,dc=com
100 objectClass: inetOrgPerson
101 cn: Mitya Kovalev
102 sn: Kovalev
103 seeAlso: documentTitle=book1,dc=example,dc=com
104 seeAlso: documentTitle=book2,dc=example,dc=com
105 givenName: Mitya
106 telephoneNumber: 332-2334
107 telephoneNumber: 222-3234
108
109 # Testing search for telephoneNumber...
110 dn: cn=Mitya Kovalev,dc=example,dc=com
111 objectClass: inetOrgPerson
112 cn: Mitya Kovalev
113 sn: Kovalev
114 seeAlso: documentTitle=book1,dc=example,dc=com
115 seeAlso: documentTitle=book2,dc=example,dc=com
116 givenName: Mitya
117 telephoneNumber: 332-2334
118 telephoneNumber: 222-3234
119
120 # Testing AND search...
121 dn: cn=Mitya Kovalev,dc=example,dc=com
122 objectClass: inetOrgPerson
123 cn: Mitya Kovalev
124 sn: Kovalev
125 seeAlso: documentTitle=book1,dc=example,dc=com
126 seeAlso: documentTitle=book2,dc=example,dc=com
127 givenName: Mitya
128 telephoneNumber: 332-2334
129 telephoneNumber: 222-3234
130
131 # Testing AND search on objectClass...
132 dn: dc=example,dc=com
133 objectClass: organization
134 objectClass: dcObject
135 o: Example
136 dc: example
137
138 # Testing OR search...
139 dn: cn=Mitya Kovalev,dc=example,dc=com
140 objectClass: inetOrgPerson
141 cn: Mitya Kovalev
142 sn: Kovalev
143 seeAlso: documentTitle=book1,dc=example,dc=com
144 seeAlso: documentTitle=book2,dc=example,dc=com
145 givenName: Mitya
146 telephoneNumber: 332-2334
147 telephoneNumber: 222-3234
148
149 # Testing OR search on objectClass...
150 dn: documentTitle=book1,dc=example,dc=com
151 objectClass: document
152 description: abstract1
153 documentTitle: book1
154 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
155 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
156 documentIdentifier: document 1
157
158 dn: documentTitle=book2,dc=example,dc=com
159 objectClass: document
160 description: abstract2
161 documentTitle: book2
162 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
163 documentIdentifier: document 2
164
165 dn: dc=example,dc=com
166 objectClass: organization
167 objectClass: dcObject
168 o: Example
169 dc: example
170
171 # Testing NOT search...
172 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
173 objectClass: inetOrgPerson
174 cn: Torvlobnor Puzdoy
175 sn: Puzdoy
176 seeAlso: documentTitle=book1,dc=example,dc=com
177 givenName: Torvlobnor
178 telephoneNumber: 545-4563
179
180 # refldap://localhost/dc=example,dc=com??sub
181
182 # Testing NOT search on objectClass...
183 dn: documentTitle=book1,dc=example,dc=com
184 objectClass: document
185 description: abstract1
186 documentTitle: book1
187 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
188 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
189 documentIdentifier: document 1
190
191 dn: documentTitle=book2,dc=example,dc=com
192 objectClass: document
193 description: abstract2
194 documentTitle: book2
195 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
196 documentIdentifier: document 2
197
198 dn: dc=example,dc=com
199 objectClass: organization
200 objectClass: dcObject
201 o: Example
202 dc: example
203
204 # Testing NOT search on "auxiliary" objectClass...
205 dn: documentTitle=book1,dc=example,dc=com
206 objectClass: document
207 description: abstract1
208 documentTitle: book1
209 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
210 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
211 documentIdentifier: document 1
212
213 dn: documentTitle=book2,dc=example,dc=com
214 objectClass: document
215 description: abstract2
216 documentTitle: book2
217 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
218 documentIdentifier: document 2
219
220 dn: cn=Mitya Kovalev,dc=example,dc=com
221 objectClass: inetOrgPerson
222 cn: Mitya Kovalev
223 sn: Kovalev
224 seeAlso: documentTitle=book1,dc=example,dc=com
225 seeAlso: documentTitle=book2,dc=example,dc=com
226 givenName: Mitya
227 telephoneNumber: 332-2334
228 telephoneNumber: 222-3234
229
230 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
231 objectClass: inetOrgPerson
232 cn: Torvlobnor Puzdoy
233 sn: Puzdoy
234 seeAlso: documentTitle=book1,dc=example,dc=com
235 givenName: Torvlobnor
236 telephoneNumber: 545-4563
237
238 # refldap://localhost/dc=example,dc=com??sub
239
240 # Testing NOT search on sn...
241 # Testing attribute inheritance in filter...
242 dn: dc=example,dc=com
243 objectClass: organization
244 objectClass: dcObject
245 o: Example
246 dc: example
247
248 # Testing objectClass inheritance in filter...
249 dn: cn=Mitya Kovalev,dc=example,dc=com
250 objectClass: inetOrgPerson
251 cn: Mitya Kovalev
252 sn: Kovalev
253 seeAlso: documentTitle=book1,dc=example,dc=com
254 seeAlso: documentTitle=book2,dc=example,dc=com
255 givenName: Mitya
256 telephoneNumber: 332-2334
257 telephoneNumber: 222-3234
258
259 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
260 objectClass: inetOrgPerson
261 cn: Torvlobnor Puzdoy
262 sn: Puzdoy
263 seeAlso: documentTitle=book1,dc=example,dc=com
264 givenName: Torvlobnor
265 telephoneNumber: 545-4563
266
267 # refldap://localhost/dc=example,dc=com??sub
268
269 # Testing "auxiliary" objectClass in filter...
270 dn: dc=example,dc=com
271 objectClass: organization
272 objectClass: dcObject
273 o: Example
274 dc: example
275
276 # refldap://localhost/dc=example,dc=com??sub
277
278 # Testing hasSubordinates in filter...
279 dn: dc=example,dc=com
280 objectClass: organization
281 objectClass: dcObject
282 o: Example
283 dc: example
284
285 # refldap://localhost/dc=example,dc=com??sub
286
287 # Testing attribute inheritance in requested attributes...
288 dn: cn=Mitya Kovalev,dc=example,dc=com
289 cn: Mitya Kovalev
290 sn: Kovalev
291 givenName: Mitya
292
293 # Testing objectClass in requested attributes...
294 dn: documentTitle=book1,dc=example,dc=com
295 objectClass: document
296
297 dn: documentTitle=book2,dc=example,dc=com
298 objectClass: document
299
300 dn: dc=example,dc=com
301 objectClass: organization
302 objectClass: dcObject
303
304 dn: cn=Mitya Kovalev,dc=example,dc=com
305 objectClass: inetOrgPerson
306
307 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
308 objectClass: inetOrgPerson
309
310 # refldap://localhost/dc=example,dc=com??sub
311
312 # Testing operational attributes in request...
313 dn: documentTitle=book1,dc=example,dc=com
314 structuralObjectClass: document
315 subschemaSubentry: cn=Subschema
316 hasSubordinates: FALSE
317
318 dn: documentTitle=book2,dc=example,dc=com
319 structuralObjectClass: document
320 subschemaSubentry: cn=Subschema
321 hasSubordinates: FALSE
322
323 dn: dc=example,dc=com
324 structuralObjectClass: organization
325 subschemaSubentry: cn=Subschema
326 hasSubordinates: TRUE
327
328 dn: cn=Mitya Kovalev,dc=example,dc=com
329 structuralObjectClass: inetOrgPerson
330 subschemaSubentry: cn=Subschema
331 hasSubordinates: FALSE
332
333 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
334 structuralObjectClass: inetOrgPerson
335 subschemaSubentry: cn=Subschema
336 hasSubordinates: FALSE
337
338 # refldap://localhost/dc=example,dc=com??sub
339