From 53b7e6fbcf012c677734e50fe62957f836c83a33 Mon Sep 17 00:00:00 2001 From: Pierangelo Masarati Date: Tue, 15 Jul 2003 11:26:17 +0000 Subject: [PATCH] apparently Oracle does not support AS in joins (ITS#2642) --- servers/slapd/back-sql/init.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/servers/slapd/back-sql/init.c b/servers/slapd/back-sql/init.c index c1ab0572ad..2e0c282966 100644 --- a/servers/slapd/back-sql/init.c +++ b/servers/slapd/back-sql/init.c @@ -415,7 +415,7 @@ backsql_db_open( bb.bb_val.bv_len = 0; bb.bb_len = 0; backsql_strfcat( &bb, "sb", - "SELECT COUNT(distinct subordinates.id) FROM ldap_entries,ldap_entries AS subordinates WHERE subordinates.parent=ldap_entries.id AND ", + "SELECT COUNT(distinct subordinates.id) FROM ldap_entries,ldap_entries subordinates WHERE subordinates.parent=ldap_entries.id AND ", &si->children_cond ); si->has_children_query = bb.bb_val.bv_val; -- 2.39.5