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

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