Hello,
we are trying to excute the query with hibernate and yuor driver from dbaseIII.
It seems it return not all records. We have more than 1000 records, but it returns only 265-302 records, but no more. Maybe there is some kind of limitation?
select
studyentit0_.StudyInsta as col_0_0_,
studyentit0_.StudyDate as col_1_0_,
studyentit0_.StudyTime as col_2_0_,
studyentit0_.StudyDescr as col_3_0_,
patientent1_.PatientNam as col_4_0_,
patientent1_.PatientID as col_5_0_,
studyentit0_.AccessionN as col_6_0_,
seriesenti2_.Modality as col_7_0_
from
DICOMStudies studyentit0_
inner join
DICOMPatients patientent1_
on (
patientent1_.PatientID=studyentit0_.PatientID
)
inner join
DICOMSeries seriesenti2_
on (
seriesenti2_.StudyInsta=studyentit0_.StudyInsta
)
order by
studyentit0_.StudyDate DESC,
studyentit0_.StudyTime DESC limit 1001
|
Hi,
we noticed that if we are setting maxResult to 1001, the queries ruturn 250 - 300 rows.
try(ScrollableResults queryResults = requestQuery
.setReadOnly(true)
.setMaxResults(1001)
.setCacheable(false)
.scroll(ScrollMode.FORWARD_ONLY)) { ..}
If we set it to 4000 it return more than 1000.
try(ScrollableResults queryResults = requestQuery
.setReadOnly(true)
.setMaxResults(4000)
.setCacheable(false)
.scroll(ScrollMode.FORWARD_ONLY)) { ..}
|
Yeah.
Differences between the trial version and the licensed version: .
The trial version of the driver is available to use free for a 30-day trial period.
The trial version of the driver allows executing not more than 50 queries once.
SELECT queries return the first 1000 rows in the result set.
|
Hello,
We have commercial licence and we want to limit result to 1000 rows. The problem is that when we limit it to 1000 rows, it return only 250-300 rows.
We use inner join in our queries. See the sample above.
|
Failed to recur your issue with v7.1.017 ion October 23, 2020
For test data with the same SQL,
1. Without limit 1001, it return 2042 rows.
2.With limit 1001, it return 1001 rows.
stmt.setMaxRows(4000); , it return 1001 rows.
stmt.setMaxRows(1001); , it return 1001 rows.
stmt.setMaxRows(400); , it return 400 rows.
|
Main
webmaster@hxtt.com