X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=tests%2Fdata%2Fslapd-sql.conf;h=08facd1f9ede536bceac08b05ccba2c3f7923877;hb=6aca95bd01df2e2f5a0183832fe65a97e3c25c41;hp=997672f10d82b428e94c4f5a877b09106249841f;hpb=a696045179f4deaeeda2b7518625b5cbcdfeba78;p=openldap

diff --git a/tests/data/slapd-sql.conf b/tests/data/slapd-sql.conf
index 997672f10d..08facd1f9e 100644
--- 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