[JBoss JIRA] Created: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
5:44 a.m.
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
8:56 a.m.
New subject: [JBoss JIRA] Assigned: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Manik Surtani reassigned ISPN-965:
----------------------------------
Assignee: Mircea Markus (was: Manik Surtani)
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: Mircea Markus
Fix For: 4.2.1.FINAL
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
8:56 a.m.
New subject: [JBoss JIRA] Updated: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Manik Surtani updated ISPN-965:
-------------------------------
Fix Version/s: 4.2.1.FINAL
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: Mircea Markus
Fix For: 4.2.1.FINAL
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
12:40 p.m.
New subject: [JBoss JIRA] Updated: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Manik Surtani updated ISPN-965:
-------------------------------
Fix Version/s: 5.0.0.BETA2
5.0.0.FINAL
(was: 4.2.1.FINAL)
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: Mircea Markus
Fix For: 5.0.0.BETA2, 5.0.0.FINAL
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
4:38 a.m.
New subject: [JBoss JIRA] Updated: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Galder Zamarreño updated ISPN-965:
----------------------------------
Fix Version/s: 5.0.0.CR1
(was: 5.0.0.BETA2)
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: Mircea Markus
Fix For: 5.0.0.CR1, 5.0.0.FINAL
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
9:36 a.m.
New subject: [JBoss JIRA] Updated: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Galder Zamarreño updated ISPN-965:
----------------------------------
Fix Version/s: 5.0.0.CR2
(was: 5.0.0.CR1)
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: Mircea Markus
Fix For: 5.0.0.CR2, 5.0.0.FINAL
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
5:59 p.m.
New subject: [JBoss JIRA] Updated: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Manik Surtani updated ISPN-965:
-------------------------------
Fix Version/s: 5.0.0.CR3
(was: 5.0.0.CR2)
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: Mircea Markus
Fix For: 5.0.0.CR3, 5.0.0.FINAL
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
8:56 a.m.
New subject: [JBoss JIRA] Commented: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Mircea Markus commented on ISPN-965:
------------------------------------
TOP can be used for HASQL as well: http://hsqldb.org/doc/guide/ch09.html
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: Mircea Markus
Fix For: 5.0.0.CR3, 5.0.0.FINAL
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
8:56 a.m.
New subject: [JBoss JIRA] Commented: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Mircea Markus commented on ISPN-965:
------------------------------------
//Small program I used for testing.
public static void main(String[] args) throws Exception {
try {
Class.forName("org.hsqldb.jdbcDriver" );
} catch (Exception e) {
System.out.println("ERROR: failed to load HSQLDB JDBC driver.");
e.printStackTrace();
return;
}
Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:aname",
"sa", "");
PreparedStatement preparedStatement = c.prepareStatement("create table
testt(id1 INT, id2 INT)");
preparedStatement.executeUpdate();
preparedStatement.close();
preparedStatement = c.prepareStatement("insert into testt(id1, id2)
values(?,?)");
for (int i = 0;i < 10; i++) {
preparedStatement.setInt(1, i);
preparedStatement.setInt(2, 100 + i);
preparedStatement.addBatch();
}
preparedStatement.executeBatch();
preparedStatement.close();
String toRun = String.format("SELECT TOP ? %s, %s FROM %s ",
"id1", "id2", "testt");
PreparedStatement ps = c.prepareStatement(toRun);
ps.setInt(1,7);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
System.out.println("rs.getString(\"id1\") = " +
rs.getString("id1"));
// System.out.println("rs.getString(\"id2\") = " +
rs.getString("id2"));
}
System.out.println("c = " + c);
}
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: Mircea Markus
Fix For: 5.0.0.CR3, 5.0.0.FINAL
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
8:58 a.m.
New subject: [JBoss JIRA] Updated: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Mircea Markus updated ISPN-965:
-------------------------------
Git Pull Request: https://github.com/infinispan/infinispan/pull/324
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: Mircea Markus
Fix For: 5.0.0.CR3, 5.0.0.FINAL
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
9:25 a.m.
New subject: [JBoss JIRA] Resolved: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
[
https://issues.jboss.org/browse/ISPN-965?page=com.atlassian.jira.plugin.s...
]
Manik Surtani resolved ISPN-965.
--------------------------------
Resolution: Done
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: Mircea Markus
Fix For: 5.0.0.CR3, 5.0.0.FINAL
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
4966
days inactive
5041
days old
infinispan-issues@lists.jboss.org
10 comments
4 participants
participants (4)
-
Anatoliy Bazko (JIRA) -
Galder Zamarreño (JIRA)
-
Manik Surtani (JIRA)
-
Mircea Markus (JIRA)