Details
-
Bug
-
Resolution: Won't Fix
-
Medium
-
None
-
4.0
-
4
-
Description
Hello,
when connected to a Sybase DBMS upgrade task UpgradeTask_Build401 will fail throwing an exception due to bad SQL:
2009-10-14 09:58:51,957 http-8080-4 ERROR anonymous 35884x9x1 1lj127n /secure/SetupImport.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT MAX(CG.CREATED), CG.issueid FROM changegroup CG INNER JOIN changeitem CI ON CG.ID = CI.groupid WHERE (CG.issueid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) AND ((CI.FIELD = ? ) OR (CI.FIELD = ? )) AND (CI.NEWSTRING IS NOT NULL ) AND (CI.OLDVALUE IS NULL ) GROUP BY CG.issueid (TEXT-, IMAGE- und UNITEXT-Datentypen dürfen in WHERE-Klausel nur mit dem Ausdruck LIKE verwendet werden.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT MAX(CG.CREATED), CG.issueid FROM changegroup CG INNER JOIN changeitem CI ON CG.ID = CI.groupid WHERE (CG.issueid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) AND ((CI.FIELD = ? ) OR (CI.FIELD = ? )) AND (CI.NEWSTRING IS NOT NULL ) AND (CI.OLDVALUE IS NULL ) GROUP BY CG.issueid (TEXT-, IMAGE- und UNITEXT-Datentypen dürfen in WHERE-Klausel nur mit dem Ausdruck LIKE verwendet werden.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:174) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401$CalculatingResolutionDateConsumer.processBatch(UpgradeTask_Build401.java:279) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.calculateResolutionDateForAllIssues(UpgradeTask_Build401.java:179) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.doUpgrade(UpgradeTask_Build401.java:114) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:508)
Running the query directly returns the following error:
TEXT, IMAGE and UNITEXT datatypes may not be used in a WHERE clause, except with the LIKE expression.
Best Regards,
Edoardo