[infinispan-issues] [JBoss JIRA] Created: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7

[Anatoliy Bazko (JIRA)]

Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
-----------------------------------------------------------------------------

                 Key: ISPN-965
                 URL: https://issues.jboss.org/browse/ISPN-965
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 4.2.0.Final
         Environment: JBoss AS 5.1.0.GA
HSQLDB 1.8.0.7
            Reporter: Anatoliy Bazko
            Assignee: Manik Surtani


Loading data from CacheStore using method  public final Set<InternalCacheEntry> loadSome(int maxEntries) throws CacheLoaderException failed due to query 
"SELECT %s, %s FROM %s LIMIT ?" is not correct for HSQLDB 1.8.0.7 since it required "ORDER BY" before "LIMIT"

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira