madrob commented on a change in pull request #191:
URL: https://github.com/apache/solr/pull/191#discussion_r658259169
##########
File path: solr/core/src/java/org/apache/solr/handler/sql/SolrTable.java
##########
@@ -275,25 +277,43 @@ private TupleStream handleSelect(String zk,
String fl = getFields(fields);
- if(orders.size() > 0) {
+ if (!orders.isEmpty()) {
params.add(SORT, getSort(orders));
} else {
- if(limit == null) {
+ if (limit == null) {
params.add(SORT, "_version_ desc");
fl = fl+",_version_";
} else {
params.add(SORT, "score desc");
- if(fl.indexOf("score") == -1) {
+ if (!fl.contains("score")) {
fl = fl + ",score";
}
}
}
params.add(CommonParams.FL, fl);
-
+
+ if (offset != null && limit == null) {
+ throw new IOException("OFFSET without LIMIT not supported by Solr!
Specify desired limit using 'FETCH NEXT <LIMIT> ROWS ONLY'");
+ }
+
if (limit != null) {
- params.add(CommonParams.ROWS, limit);
- return new LimitStream(new CloudSolrStream(zk, collection, params),
Integer.parseInt(limit));
+ int limitInt = Integer.parseInt(limit);
+ // if there's an offset, then we need to fetch offset + limit rows from
each shard and then sort accordingly
+ LimitStream limitStream;
+ if (offset != null) {
+ int offsetInt = Integer.parseInt(offset);
+ int rows = limitInt + offsetInt;
+ params.add(CommonParams.START, "0"); // tricky ... we need all rows up
to limit + offset
Review comment:
This makes me nervous... at what point do we need to get back into
cursor mark world?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]