Bug report #15605
Query Builder Test button returns message with inadequate number of rows
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||23528|
Tested in provider filter layer property on a postgis layer. When generating a where clause with Query Builder and hitting Test button the message comes up and says 'The where clause returned N rows'. N in this case is the total number of rows in the table, not the number of filtered rows. Then the filter itself works fine - I can see an expected number of rows in attribute table, etc.
I guess this was done to speed up this message, but it's quite handy and gets a bit confusing seeing the same number of rows (total) returned when testing different queries.
Tested on master (e7c9400, python3, qt5), 2.16 and 2.14.
#1 Updated by Alexander Bruy about 6 years ago
- Operating System deleted (
- Category changed from Forms to Data Provider
#2 Updated by Giovanni Manghi about 6 years ago
- Easy fix? set to No
- Regression? set to No
#3 Updated by Giovanni Manghi about 4 years ago
- Status changed from Open to Feedback
Please check if this issue is still valid on QGIS 3.4.5 or 3.6.