[daisy] [JIRA] Created: (DSY-524) Substring() testcase in LocalQuery2Test fails with PostgreSQL as database

Wed Aug 1 16:45:50 CDT 2007

Substring() testcase in LocalQuery2Test fails with PostgreSQL as database
-------------------------------------------------------------------------

         Key: DSY-524
         URL: http://issues.cocoondev.org//browse/DSY-524
     Project: Daisy
        Type: Bug
  Components: Repository, Repository - database support, Repository - querying and indexing  
    Versions: 2.1    
 Environment: SVN 4286
 Reporter: Andreas Deininger
    Priority: Minor


One of the testcases for the substring() function inside LocalQuery2Test fails if PostgreSQL is used as SQL database (however not sure whether this is related to the use of PostgreSQL at all):
Offending test statement: select name where Substring(name, 4, 4) = 'Docu' and id = '" + document = xxx

Testcase: testQuery(org.outerj.daisy.repository.test.LocalQuery2Test):	FAILED
expected:<0> but was:<1>
junit.framework.AssertionFailedError: expected:<0> but was:<1>
	at org.outerj.daisy.repository.test.AbstractQuery2Test.testQuery(AbstractQuery2Test.java:553)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira