# HG changeset patch # User Bjoern Ricks # Date 1347022903 0 # Node ID 4213dd6ca1692ac2493935e866c7dab0eab44098 # Parent 0f4ee5886f867d73428f9df934bc80b3b490b91d Fix queries for finding a user artifacts/trunk@5383 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 0f4ee5886f86 -r 4213dd6ca169 ChangeLog --- 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 + + * 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 Tagged RELEASE 2.9 diff -r 0f4ee5886f86 -r 4213dd6ca169 artifact-database/src/main/resources/sql/org-h2-driver.properties --- 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 = ? diff -r 0f4ee5886f86 -r 4213dd6ca169 artifact-database/src/main/resources/sql/org-postgresql-driver.properties --- 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 = ?