details:   https://code.openbravo.com/erp/devel/pi/rev/a3ad3bc6723d
changeset: 33674:a3ad3bc6723d
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Tue Mar 13 10:28:31 2018 +0100
summary:   Related with issue 36226: Be coherent when querying users in 
dba_users

The query done to the dba_users table in clean.database.ORACLE is case 
insensitive, the query done to the
same table in ORACLE.structure should be case insensitive too.

diffstat:

 src-db/database/build-create.xml |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r d526512e5e96 -r a3ad3bc6723d src-db/database/build-create.xml
--- a/src-db/database/build-create.xml  Fri Mar 09 14:18:48 2018 +0100
+++ b/src-db/database/build-create.xml  Tue Mar 13 10:28:31 2018 +0100
@@ -118,7 +118,7 @@
         DECLARE
           v_count NUMBER;
         BEGIN
-          SELECT COUNT(*) INTO v_count FROM DBA_USERS WHERE USERNAME = 
'${bbdd.user}';
+          SELECT COUNT(*) INTO v_count FROM DBA_USERS WHERE UPPER(USERNAME) = 
UPPER('${bbdd.user}');
           IF (v_count > 0) THEN
             RAISE_APPLICATION_ERROR(-20100, '${bbdd.user} ALREADY EXISTS. 
SELECT ANOTHER USER OR DROP IT FIRST');
           END IF;

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to