Fix people / groups order to match testdata

[openldap] / tests / data / slapd-sql.conf

diff --git a/tests/data/slapd-sql.conf b/tests/data/slapd-sql.conf
index 997672f10d82b428e94c4f5a877b09106249841f..08facd1f9ede536bceac08b05ccba2c3f7923877 100644 (file)
--- a/tests/data/slapd-sql.conf
+++ b/tests/data/slapd-sql.conf
@@ -2,7 +2,7 @@
 # $OpenLDAP$
 ## This work is part of OpenLDAP Software <http://www.openldap.org/>.
 ##
-## Copyright 1998-2003 The OpenLDAP Foundation.
+## Copyright 1998-2005 The OpenLDAP Foundation.
 ## All rights reserved.
 ##
 ## Redistribution and use in source and binary forms, with or without
@@ -22,8 +22,6 @@ include ./schema/nis.schema
 pidfile     ./testrun/slapd.1.pid
 argsfile    ./testrun/slapd.1.args
 
-#mod#modulepath        ../servers/slapd/back-@BACKEND@/
-#mod#moduleload        back_@BACKEND@.la
 #sqlmod#modulepath ../servers/slapd/back-sql/
 #sqlmod#moduleload back_sql.la
 #monitormod#modulepath ../servers/slapd/back-monitor/
@@ -46,24 +44,32 @@ access to *
 #######################################################################
 
 database        sql
-suffix          "o=Example,c=RU"
-rootdn         "cn=Manager,o=Example,c=RU"
+suffix          "dc=example,dc=com"
+rootdn         "cn=Manager,dc=example,dc=com"
 rootpw          secret
 dbname          example
 dbuser          manager
 dbpasswd        secret
 
-#insentry_query  "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values ((select max(id)+1 from ldap_entries),?,?,?,?)"
 #
 # rdbms specific directives
 #
+# IBM db2
+#ibmdb2#upper_func             "ucase"
+#ibmdb2#upper_needs_cast       "yes"
+#ibmdb2#concat_pattern         "?||?"
+#ibmdb2#children_cond          "ucase(ldap_entries.dn)=ucase(cast(? as varchar(255)))"
+#ibmdb2#create_needs_select    "yes"
+#ibmdb2#insentry_stmt          "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values ((select case when max(id) is null then 1 else max(id) + 1 end from ldap_entries),?,?,?,?)"
+#
 # PostgreSQL
-#postgres#upper_func      "upper"
-#postgres#strcast_func    "text"
-#postgres#concat_pattern  "?||?"
+#pgsql#insentry_stmt           "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values ((select case when max(id) is null then 1 else max(id) + 1 end from ldap_entries),?,?,?,?)"
+#pgsql#upper_func              "upper"
+#pgsql#strcast_func            "text"
+#pgsql#concat_pattern  "?||?"
 #
 # MySQL
-#mysql#concat_pattern  "concat(?,?)"
+#mysql#concat_pattern  "concat(?,?)"
 
 has_ldapinfo_dn_ru      no