Fixes issue 23996: String is compared in constraint after being upper cased
authorAugusto Mauch <augusto.mauch@openbravo.com>
Wed, 05 Jun 2013 15:57:57 +0200
changeset 20512 02b4db5308b3
parent 20511 e426b7ccc826
child 20513 72a6ddafde71
Fixes issue 23996: String is compared in constraint after being upper cased
src-db/database/model/tables/AD_TABLE.xml
--- a/src-db/database/model/tables/AD_TABLE.xml	Wed Jun 05 14:03:22 2013 +0200
+++ b/src-db/database/model/tables/AD_TABLE.xml	Wed Jun 05 15:57:57 2013 +0200
@@ -167,8 +167,8 @@
       <unique name="AD_TABLE_TREETYPE_UN">
         <unique-column name="TREETYPE"/>
       </unique>
-      <check name="AD_TABLE_CLASSNAME_CHK"><![CDATA[((DATAORIGINTYPE) = 'DATASOURCE') OR (CLASSNAME IS NOT NULL)]]></check>
-      <check name="AD_TABLE_DATASOURCE_CHK"><![CDATA[((DATAORIGINTYPE) = 'TABLE') OR (OBSERDS_DATASOURCE_ID IS NOT NULL)]]></check>
+      <check name="AD_TABLE_CLASSNAME_CHK"><![CDATA[(UPPER((DATAORIGINTYPE)) = 'DATASOURCE') OR (CLASSNAME IS NOT NULL)]]></check>
+      <check name="AD_TABLE_DATASOURCE_CHK"><![CDATA[(UPPER((DATAORIGINTYPE)) = 'TABLE') OR (OBSERDS_DATASOURCE_ID IS NOT NULL)]]></check>
       <check name="AD_TABLE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_TABLE_ISAUDITINS_CHK"><![CDATA[ISAUDITINSERTS IN ('Y', 'N')]]></check>
       <check name="AD_TABLE_ISDELETEABLE_CHK"><![CDATA[ISDELETEABLE IN ('Y', 'N')]]></check>