Bug report #12429

Run only the selected part of a SQL query

Added by Etienne Trimaille about 5 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:2.8.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:Yes Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:20600

Description

In the DB Manager, since 2.8, you can now run only the selected part of a sql query.
This feature works only with the "execute" button to see the table in the window.
You can't load the selected part in QGIS or save the selected part in a preset.

This PR [1] on the master branch should fix this when you are using the "load in qgis" button and then you save the query in a preset.

1 : https://github.com/qgis/QGIS/pull/1955

Associated revisions

Revision b1dd253f
Added by Etienne Trimaille about 5 years ago

fix selected query (fixes #12429)

Revision acd003e0
Added by Giuseppe Sucameli about 5 years ago

Merge pull request #2000 from Gustry/fix-selected-query-backport

[db_manager] backport 2.8.2 fix #12429 run only the selected query

History

#1 Updated by Etienne Trimaille about 5 years ago

Can you please review these two PR ?
The PR above 1955 was too old to be merged automatically. I had some conflicts and it was easier to start a new one.

2.9 : https://github.com/qgis/QGIS/pull/1999
2.8.2 : https://github.com/qgis/QGIS/pull/2000

This feature was in the 2.8 changelog, that's why there is also a backport.

#2 Updated by Giovanni Manghi about 5 years ago

  • Target version changed from Version 2.8.2 to Version 2.10

#3 Updated by Etienne Trimaille about 5 years ago

Let me know if there is a problem with these two PR.
Can you please review them ? 2.8.2 is already out.

#4 Updated by Etienne Trimaille about 5 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF