Bug report #15605

Query Builder Test button returns message with inadequate number of rows

Added by Nikolay Lebedev over 7 years ago. Updated about 5 years ago.

Category:Data Provider
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 7 years ago

  • Operating System deleted (Arch Linux)
  • Category changed from Forms to Data Provider

#2 Updated by Giovanni Manghi about 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Giovanni Manghi about 5 years ago

  • Status changed from Open to Feedback

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

Also available in: Atom PDF