changeset 421:4213dd6ca169

Fix queries for finding a user artifacts/trunk@5383 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Ricks <bjoern.ricks@intevation.de>
date Fri, 07 Sep 2012 13:01:43 +0000
parents 0f4ee5886f86
children 8032aade18f7
files ChangeLog artifact-database/src/main/resources/sql/org-h2-driver.properties artifact-database/src/main/resources/sql/org-postgresql-driver.properties
diffstat 3 files changed, 8 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/ChangeLog	Fri Sep 07 09:28:43 2012 +0000
+++ b/ChangeLog	Fri Sep 07 13:01:43 2012 +0000
@@ -1,3 +1,9 @@
+2012-09-07	Björn Ricks	<bjoern.ricks@intevation.de>
+
+	* artifact-database/src/main/resources/sql/org-h2-driver.properties,
+	  artifact-database/src/main/resources/sql/org-postgresql-driver.properties:
+	  Fix queries for finding a user.
+
 2012-09-07  Ingo Weinzierl <ingo@intevation.de>
 
 	Tagged RELEASE 2.9
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Fri Sep 07 09:28:43 2012 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Fri Sep 07 13:01:43 2012 +0000
@@ -37,7 +37,7 @@
 
 users.select.id.by.gid=SELECT id FROM users WHERE gid = ?
 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?
-users.select.account=SELECT id, name, account, role FROM users WHERE account = ?
+users.select.account=SELECT gid, name, account, role FROM users WHERE account = ?
 
 users.delete.id=DELETE FROM users WHERE id = ?
 
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Fri Sep 07 09:28:43 2012 +0000
+++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Fri Sep 07 13:01:43 2012 +0000
@@ -37,7 +37,7 @@
 
 users.select.id.by.gid=SELECT id FROM users WHERE gid = ?::uuid
 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?::uuid
-users.select.account=SELECT id, name, account, role FROM users WHERE account = ?
+users.select.account=SELECT gid, name, account, role FROM users WHERE account = ?
 
 users.delete.id=DELETE FROM users WHERE id = ?
 

http://dive4elements.wald.intevation.org