]> git.sur5r.net Git - openldap/blob - tests/data/sql-read.out
Sync with HEAD
[openldap] / tests / data / sql-read.out
1 # Testing baseobject search...
2 dn: dc=example,dc=com
3 objectClass: organization
4 objectClass: dcObject
5 o: Example
6 dc: example
7
8 # Testing onelevel search...
9 dn: documentTitle=book1,dc=example,dc=com
10 objectClass: document
11 description: abstract1
12 documentTitle: book1
13 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
14 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
15 documentIdentifier: document 1
16
17 dn: documentTitle=book2,dc=example,dc=com
18 objectClass: document
19 description: abstract2
20 documentTitle: book2
21 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
22 documentIdentifier: document 2
23
24 # refldap://localhost:9010/dc=example,dc=com??one
25
26 dn: cn=Mitya Kovalev,dc=example,dc=com
27 objectClass: inetOrgPerson
28 cn: Mitya Kovalev
29 sn: Kovalev
30 seeAlso: documentTitle=book1,dc=example,dc=com
31 seeAlso: documentTitle=book2,dc=example,dc=com
32 givenName: Mitya
33 telephoneNumber: 222-3234
34 telephoneNumber: 332-2334
35
36 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
37 objectClass: inetOrgPerson
38 cn: Torvlobnor Puzdoy
39 sn: Puzdoy
40 seeAlso: documentTitle=book1,dc=example,dc=com
41 givenName: Torvlobnor
42 telephoneNumber: 545-4563
43
44 dn: cn=Akakiy Zinberstein,dc=example,dc=com
45 objectClass: inetOrgPerson
46 cn: Akakiy Zinberstein
47 sn: Zinberstein
48 givenName: Akakiy
49
50 # Testing subtree search...
51 dn: documentTitle=book1,dc=example,dc=com
52 objectClass: document
53 description: abstract1
54 documentTitle: book1
55 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
56 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
57 documentIdentifier: document 1
58
59 dn: documentTitle=book2,dc=example,dc=com
60 objectClass: document
61 description: abstract2
62 documentTitle: book2
63 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
64 documentIdentifier: document 2
65
66 # refldap://localhost:9010/dc=example,dc=com??sub
67
68 dn: dc=example,dc=com
69 objectClass: organization
70 objectClass: dcObject
71 o: Example
72 dc: example
73
74 dn: cn=Mitya Kovalev,dc=example,dc=com
75 objectClass: inetOrgPerson
76 cn: Mitya Kovalev
77 sn: Kovalev
78 seeAlso: documentTitle=book1,dc=example,dc=com
79 seeAlso: documentTitle=book2,dc=example,dc=com
80 givenName: Mitya
81 telephoneNumber: 222-3234
82 telephoneNumber: 332-2334
83
84 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
85 objectClass: inetOrgPerson
86 cn: Torvlobnor Puzdoy
87 sn: Puzdoy
88 seeAlso: documentTitle=book1,dc=example,dc=com
89 givenName: Torvlobnor
90 telephoneNumber: 545-4563
91
92 dn: cn=Akakiy Zinberstein,dc=example,dc=com
93 objectClass: inetOrgPerson
94 cn: Akakiy Zinberstein
95 sn: Zinberstein
96 givenName: Akakiy
97
98 # Testing subtree search with manageDSAit...
99 dn: documentTitle=book1,dc=example,dc=com
100 objectClass: document
101 description: abstract1
102 documentTitle: book1
103 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
104 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
105 documentIdentifier: document 1
106
107 dn: documentTitle=book2,dc=example,dc=com
108 objectClass: document
109 description: abstract2
110 documentTitle: book2
111 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
112 documentIdentifier: document 2
113
114 dn: ou=Referral,dc=example,dc=com
115 objectClass: referral
116 objectClass: extensibleObject
117 ou: Referral
118 ref: ldap://localhost:9010/
119
120 dn: dc=example,dc=com
121 objectClass: organization
122 objectClass: dcObject
123 o: Example
124 dc: example
125
126 dn: cn=Mitya Kovalev,dc=example,dc=com
127 objectClass: inetOrgPerson
128 cn: Mitya Kovalev
129 sn: Kovalev
130 seeAlso: documentTitle=book1,dc=example,dc=com
131 seeAlso: documentTitle=book2,dc=example,dc=com
132 givenName: Mitya
133 telephoneNumber: 222-3234
134 telephoneNumber: 332-2334
135
136 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
137 objectClass: inetOrgPerson
138 cn: Torvlobnor Puzdoy
139 sn: Puzdoy
140 seeAlso: documentTitle=book1,dc=example,dc=com
141 givenName: Torvlobnor
142 telephoneNumber: 545-4563
143
144 dn: cn=Akakiy Zinberstein,dc=example,dc=com
145 objectClass: inetOrgPerson
146 cn: Akakiy Zinberstein
147 sn: Zinberstein
148 givenName: Akakiy
149
150 # Testing invalid filter...
151 # Testing exact search...
152 # refldap://localhost:9010/dc=example,dc=com??sub
153
154 dn: cn=Mitya Kovalev,dc=example,dc=com
155 objectClass: inetOrgPerson
156 cn: Mitya Kovalev
157 sn: Kovalev
158 seeAlso: documentTitle=book1,dc=example,dc=com
159 seeAlso: documentTitle=book2,dc=example,dc=com
160 givenName: Mitya
161 telephoneNumber: 222-3234
162 telephoneNumber: 332-2334
163
164 # Testing substrings initial search...
165 # refldap://localhost:9010/dc=example,dc=com??sub
166
167 dn: cn=Mitya Kovalev,dc=example,dc=com
168 objectClass: inetOrgPerson
169 cn: Mitya Kovalev
170 sn: Kovalev
171 seeAlso: documentTitle=book1,dc=example,dc=com
172 seeAlso: documentTitle=book2,dc=example,dc=com
173 givenName: Mitya
174 telephoneNumber: 222-3234
175 telephoneNumber: 332-2334
176
177 # Testing substrings any search...
178 # refldap://localhost:9010/dc=example,dc=com??sub
179
180 dn: cn=Mitya Kovalev,dc=example,dc=com
181 objectClass: inetOrgPerson
182 cn: Mitya Kovalev
183 sn: Kovalev
184 seeAlso: documentTitle=book1,dc=example,dc=com
185 seeAlso: documentTitle=book2,dc=example,dc=com
186 givenName: Mitya
187 telephoneNumber: 222-3234
188 telephoneNumber: 332-2334
189
190 # Testing substrings final search...
191 # refldap://localhost:9010/dc=example,dc=com??sub
192
193 dn: cn=Mitya Kovalev,dc=example,dc=com
194 objectClass: inetOrgPerson
195 cn: Mitya Kovalev
196 sn: Kovalev
197 seeAlso: documentTitle=book1,dc=example,dc=com
198 seeAlso: documentTitle=book2,dc=example,dc=com
199 givenName: Mitya
200 telephoneNumber: 222-3234
201 telephoneNumber: 332-2334
202
203 # Testing approx search...
204 # refldap://localhost:9010/dc=example,dc=com??sub
205
206 dn: cn=Mitya Kovalev,dc=example,dc=com
207 objectClass: inetOrgPerson
208 cn: Mitya Kovalev
209 sn: Kovalev
210 seeAlso: documentTitle=book1,dc=example,dc=com
211 seeAlso: documentTitle=book2,dc=example,dc=com
212 givenName: Mitya
213 telephoneNumber: 222-3234
214 telephoneNumber: 332-2334
215
216 # Testing extensible filter search...
217 # refldap://localhost:9010/dc=example,dc=com??sub
218
219 dn: cn=Mitya Kovalev,dc=example,dc=com
220 objectClass: inetOrgPerson
221 cn: Mitya Kovalev
222 sn: Kovalev
223 seeAlso: documentTitle=book1,dc=example,dc=com
224 seeAlso: documentTitle=book2,dc=example,dc=com
225 givenName: Mitya
226 telephoneNumber: 222-3234
227 telephoneNumber: 332-2334
228
229 # Testing search for telephoneNumber...
230 # refldap://localhost:9010/dc=example,dc=com??sub
231
232 dn: cn=Mitya Kovalev,dc=example,dc=com
233 objectClass: inetOrgPerson
234 cn: Mitya Kovalev
235 sn: Kovalev
236 seeAlso: documentTitle=book1,dc=example,dc=com
237 seeAlso: documentTitle=book2,dc=example,dc=com
238 givenName: Mitya
239 telephoneNumber: 222-3234
240 telephoneNumber: 332-2334
241
242 # Testing AND search...
243 # refldap://localhost:9010/dc=example,dc=com??sub
244
245 dn: cn=Mitya Kovalev,dc=example,dc=com
246 objectClass: inetOrgPerson
247 cn: Mitya Kovalev
248 sn: Kovalev
249 seeAlso: documentTitle=book1,dc=example,dc=com
250 seeAlso: documentTitle=book2,dc=example,dc=com
251 givenName: Mitya
252 telephoneNumber: 222-3234
253 telephoneNumber: 332-2334
254
255 # Testing AND search on objectClass...
256 dn: dc=example,dc=com
257 objectClass: organization
258 objectClass: dcObject
259 o: Example
260 dc: example
261
262 # Testing OR search...
263 # refldap://localhost:9010/dc=example,dc=com??sub
264
265 dn: cn=Mitya Kovalev,dc=example,dc=com
266 objectClass: inetOrgPerson
267 cn: Mitya Kovalev
268 sn: Kovalev
269 seeAlso: documentTitle=book1,dc=example,dc=com
270 seeAlso: documentTitle=book2,dc=example,dc=com
271 givenName: Mitya
272 telephoneNumber: 222-3234
273 telephoneNumber: 332-2334
274
275 # Testing OR search on objectClass...
276 dn: documentTitle=book1,dc=example,dc=com
277 objectClass: document
278 description: abstract1
279 documentTitle: book1
280 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
281 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
282 documentIdentifier: document 1
283
284 dn: documentTitle=book2,dc=example,dc=com
285 objectClass: document
286 description: abstract2
287 documentTitle: book2
288 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
289 documentIdentifier: document 2
290
291 dn: dc=example,dc=com
292 objectClass: organization
293 objectClass: dcObject
294 o: Example
295 dc: example
296
297 # Testing NOT search...
298 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
299 objectClass: inetOrgPerson
300 cn: Torvlobnor Puzdoy
301 sn: Puzdoy
302 seeAlso: documentTitle=book1,dc=example,dc=com
303 givenName: Torvlobnor
304 telephoneNumber: 545-4563
305
306 dn: cn=Akakiy Zinberstein,dc=example,dc=com
307 objectClass: inetOrgPerson
308 cn: Akakiy Zinberstein
309 sn: Zinberstein
310 givenName: Akakiy
311
312 # Testing NOT search on objectClass...
313 dn: documentTitle=book1,dc=example,dc=com
314 objectClass: document
315 description: abstract1
316 documentTitle: book1
317 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
318 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
319 documentIdentifier: document 1
320
321 dn: documentTitle=book2,dc=example,dc=com
322 objectClass: document
323 description: abstract2
324 documentTitle: book2
325 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
326 documentIdentifier: document 2
327
328 # refldap://localhost:9010/dc=example,dc=com??sub
329
330 dn: dc=example,dc=com
331 objectClass: organization
332 objectClass: dcObject
333 o: Example
334 dc: example
335
336 # Testing NOT search on "auxiliary" objectClass...
337 dn: documentTitle=book1,dc=example,dc=com
338 objectClass: document
339 description: abstract1
340 documentTitle: book1
341 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
342 documentAuthor: cn=Torvlobnor Puzdoy,dc=example,dc=com
343 documentIdentifier: document 1
344
345 dn: documentTitle=book2,dc=example,dc=com
346 objectClass: document
347 description: abstract2
348 documentTitle: book2
349 documentAuthor: cn=Mitya Kovalev,dc=example,dc=com
350 documentIdentifier: document 2
351
352 # refldap://localhost:9010/dc=example,dc=com??sub
353
354 dn: cn=Mitya Kovalev,dc=example,dc=com
355 objectClass: inetOrgPerson
356 cn: Mitya Kovalev
357 sn: Kovalev
358 seeAlso: documentTitle=book1,dc=example,dc=com
359 seeAlso: documentTitle=book2,dc=example,dc=com
360 givenName: Mitya
361 telephoneNumber: 222-3234
362 telephoneNumber: 332-2334
363
364 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
365 objectClass: inetOrgPerson
366 cn: Torvlobnor Puzdoy
367 sn: Puzdoy
368 seeAlso: documentTitle=book1,dc=example,dc=com
369 givenName: Torvlobnor
370 telephoneNumber: 545-4563
371
372 dn: cn=Akakiy Zinberstein,dc=example,dc=com
373 objectClass: inetOrgPerson
374 cn: Akakiy Zinberstein
375 sn: Zinberstein
376 givenName: Akakiy
377
378 # Testing attribute inheritance in filter...
379 dn: dc=example,dc=com
380 objectClass: organization
381 objectClass: dcObject
382 o: Example
383 dc: example
384
385 # Testing objectClass inheritance in filter...
386 dn: cn=Mitya Kovalev,dc=example,dc=com
387 objectClass: inetOrgPerson
388 cn: Mitya Kovalev
389 sn: Kovalev
390 seeAlso: documentTitle=book1,dc=example,dc=com
391 seeAlso: documentTitle=book2,dc=example,dc=com
392 givenName: Mitya
393 telephoneNumber: 222-3234
394 telephoneNumber: 332-2334
395
396 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
397 objectClass: inetOrgPerson
398 cn: Torvlobnor Puzdoy
399 sn: Puzdoy
400 seeAlso: documentTitle=book1,dc=example,dc=com
401 givenName: Torvlobnor
402 telephoneNumber: 545-4563
403
404 dn: cn=Akakiy Zinberstein,dc=example,dc=com
405 objectClass: inetOrgPerson
406 cn: Akakiy Zinberstein
407 sn: Zinberstein
408 givenName: Akakiy
409
410 # Testing "auxiliary" objectClass in filter...
411 dn: dc=example,dc=com
412 objectClass: organization
413 objectClass: dcObject
414 o: Example
415 dc: example
416
417 # Testing hasSubordinates in filter...
418 # refldap://localhost:9010/dc=example,dc=com??sub
419
420 dn: dc=example,dc=com
421 objectClass: organization
422 objectClass: dcObject
423 o: Example
424 dc: example
425
426 # Testing entryUUID in filter...
427 dn: cn=Mitya Kovalev,dc=example,dc=com
428 objectClass: inetOrgPerson
429 cn: Mitya Kovalev
430 sn: Kovalev
431 seeAlso: documentTitle=book1,dc=example,dc=com
432 seeAlso: documentTitle=book2,dc=example,dc=com
433 givenName: Mitya
434 telephoneNumber: 222-3234
435 telephoneNumber: 332-2334
436
437 # Testing attribute inheritance in requested attributes...
438 # refldap://localhost:9010/dc=example,dc=com??sub
439
440 dn: cn=Mitya Kovalev,dc=example,dc=com
441 cn: Mitya Kovalev
442 sn: Kovalev
443 givenName: Mitya
444
445 # Testing objectClass in requested attributes...
446 dn: documentTitle=book1,dc=example,dc=com
447 objectClass: document
448
449 dn: documentTitle=book2,dc=example,dc=com
450 objectClass: document
451
452 # refldap://localhost:9010/dc=example,dc=com??sub
453
454 dn: dc=example,dc=com
455 objectClass: organization
456 objectClass: dcObject
457
458 dn: cn=Mitya Kovalev,dc=example,dc=com
459 objectClass: inetOrgPerson
460
461 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
462 objectClass: inetOrgPerson
463
464 dn: cn=Akakiy Zinberstein,dc=example,dc=com
465 objectClass: inetOrgPerson
466
467 # Testing operational attributes in request...
468 dn: documentTitle=book1,dc=example,dc=com
469 structuralObjectClass: document
470 entryDN: documentTitle=book1,dc=example,dc=com
471 subschemaSubentry: cn=Subschema
472 hasSubordinates: FALSE
473 entryUUID: 00000002-0000-0001-0000-000000000000
474
475 dn: documentTitle=book2,dc=example,dc=com
476 structuralObjectClass: document
477 entryDN: documentTitle=book2,dc=example,dc=com
478 subschemaSubentry: cn=Subschema
479 hasSubordinates: FALSE
480 entryUUID: 00000002-0000-0002-0000-000000000000
481
482 # refldap://localhost:9010/dc=example,dc=com??sub
483
484 dn: dc=example,dc=com
485 structuralObjectClass: organization
486 entryDN: dc=example,dc=com
487 subschemaSubentry: cn=Subschema
488 hasSubordinates: TRUE
489 entryUUID: 00000003-0000-0001-0000-000000000000
490
491 dn: cn=Mitya Kovalev,dc=example,dc=com
492 structuralObjectClass: inetOrgPerson
493 entryDN: cn=Mitya Kovalev,dc=example,dc=com
494 subschemaSubentry: cn=Subschema
495 hasSubordinates: FALSE
496 entryUUID: 00000001-0000-0001-0000-000000000000
497
498 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
499 structuralObjectClass: inetOrgPerson
500 entryDN: cn=Torvlobnor Puzdoy,dc=example,dc=com
501 subschemaSubentry: cn=Subschema
502 hasSubordinates: FALSE
503 entryUUID: 00000001-0000-0002-0000-000000000000
504
505 dn: cn=Akakiy Zinberstein,dc=example,dc=com
506 structuralObjectClass: inetOrgPerson
507 entryDN: cn=Akakiy Zinberstein,dc=example,dc=com
508 subschemaSubentry: cn=Subschema
509 hasSubordinates: FALSE
510 entryUUID: 00000001-0000-0003-0000-000000000000
511