]> git.sur5r.net Git - openldap/blob - tests/data/sql-read.out
ITS#4877
[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:9012/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:9012/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:9012/
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:9012/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:9012/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:9012/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:9012/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:9012/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:9012/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:9012/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:9012/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:9012/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:9012/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:9012/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 undefined attribute in filter...
386 # refldap://localhost:9012/dc=example,dc=com??sub
387
388 dn: dc=example,dc=com
389 objectClass: organization
390 objectClass: dcObject
391 o: Example
392 dc: example
393
394 # Testing objectClass inheritance in filter...
395 dn: cn=Mitya Kovalev,dc=example,dc=com
396 objectClass: inetOrgPerson
397 cn: Mitya Kovalev
398 sn: Kovalev
399 seeAlso: documentTitle=book1,dc=example,dc=com
400 seeAlso: documentTitle=book2,dc=example,dc=com
401 givenName: Mitya
402 telephoneNumber: 222-3234
403 telephoneNumber: 332-2334
404
405 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
406 objectClass: inetOrgPerson
407 cn: Torvlobnor Puzdoy
408 sn: Puzdoy
409 seeAlso: documentTitle=book1,dc=example,dc=com
410 givenName: Torvlobnor
411 telephoneNumber: 545-4563
412
413 dn: cn=Akakiy Zinberstein,dc=example,dc=com
414 objectClass: inetOrgPerson
415 cn: Akakiy Zinberstein
416 sn: Zinberstein
417 givenName: Akakiy
418
419 # Testing "auxiliary" objectClass in filter...
420 dn: dc=example,dc=com
421 objectClass: organization
422 objectClass: dcObject
423 o: Example
424 dc: example
425
426 # Testing hasSubordinates in filter...
427 # refldap://localhost:9012/dc=example,dc=com??sub
428
429 dn: dc=example,dc=com
430 objectClass: organization
431 objectClass: dcObject
432 o: Example
433 dc: example
434
435 # Testing entryUUID in filter...
436 dn: cn=Mitya Kovalev,dc=example,dc=com
437 objectClass: inetOrgPerson
438 cn: Mitya Kovalev
439 sn: Kovalev
440 seeAlso: documentTitle=book1,dc=example,dc=com
441 seeAlso: documentTitle=book2,dc=example,dc=com
442 givenName: Mitya
443 telephoneNumber: 222-3234
444 telephoneNumber: 332-2334
445
446 # Testing attribute inheritance in requested attributes...
447 # refldap://localhost:9012/dc=example,dc=com??sub
448
449 dn: cn=Mitya Kovalev,dc=example,dc=com
450 cn: Mitya Kovalev
451 sn: Kovalev
452 givenName: Mitya
453
454 # Testing objectClass in requested attributes...
455 dn: documentTitle=book1,dc=example,dc=com
456 objectClass: document
457
458 dn: documentTitle=book2,dc=example,dc=com
459 objectClass: document
460
461 # refldap://localhost:9012/dc=example,dc=com??sub
462
463 dn: dc=example,dc=com
464 objectClass: organization
465 objectClass: dcObject
466
467 dn: cn=Mitya Kovalev,dc=example,dc=com
468 objectClass: inetOrgPerson
469
470 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
471 objectClass: inetOrgPerson
472
473 dn: cn=Akakiy Zinberstein,dc=example,dc=com
474 objectClass: inetOrgPerson
475
476 # Testing operational attributes in request...
477 dn: documentTitle=book1,dc=example,dc=com
478 structuralObjectClass: document
479 entryDN: documentTitle=book1,dc=example,dc=com
480 subschemaSubentry: cn=Subschema
481 hasSubordinates: FALSE
482 entryUUID: 00000002-0000-0001-0000-000000000000
483
484 dn: documentTitle=book2,dc=example,dc=com
485 structuralObjectClass: document
486 entryDN: documentTitle=book2,dc=example,dc=com
487 subschemaSubentry: cn=Subschema
488 hasSubordinates: FALSE
489 entryUUID: 00000002-0000-0002-0000-000000000000
490
491 # refldap://localhost:9012/dc=example,dc=com??sub
492
493 dn: dc=example,dc=com
494 structuralObjectClass: organization
495 entryDN: dc=example,dc=com
496 subschemaSubentry: cn=Subschema
497 hasSubordinates: TRUE
498 entryUUID: 00000003-0000-0001-0000-000000000000
499
500 dn: cn=Mitya Kovalev,dc=example,dc=com
501 structuralObjectClass: inetOrgPerson
502 entryDN: cn=Mitya Kovalev,dc=example,dc=com
503 subschemaSubentry: cn=Subschema
504 hasSubordinates: FALSE
505 entryUUID: 00000001-0000-0001-0000-000000000000
506
507 dn: cn=Torvlobnor Puzdoy,dc=example,dc=com
508 structuralObjectClass: inetOrgPerson
509 entryDN: cn=Torvlobnor Puzdoy,dc=example,dc=com
510 subschemaSubentry: cn=Subschema
511 hasSubordinates: FALSE
512 entryUUID: 00000001-0000-0002-0000-000000000000
513
514 dn: cn=Akakiy Zinberstein,dc=example,dc=com
515 structuralObjectClass: inetOrgPerson
516 entryDN: cn=Akakiy Zinberstein,dc=example,dc=com
517 subschemaSubentry: cn=Subschema
518 hasSubordinates: FALSE
519 entryUUID: 00000001-0000-0003-0000-000000000000
520