Bug report #21271

Comments in SQL query in DB Manager breaks the query

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

Status:In Progress
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:3.5(master) Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:Yes Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:29089

Description

SQL comments are highlighted in the editor, however they break SQL execution.
Easy to replicate: add a comment after SELECT clause before selected fields.

History

#1 Updated by Alessandro Pasotti over 5 years ago

  • Assignee set to Alessandro Pasotti

#2 Updated by Alessandro Pasotti over 5 years ago

  • Resolution set to fixed/implemented
  • Pull Request or Patch supplied changed from No to Yes
  • Affected QGIS version changed from 3.4.4 to 3.5(master)
  • Status changed from Open to In Progress

#3 Updated by Alessandro Pasotti over 5 years ago

  • Assignee deleted (Alessandro Pasotti)

Etienne Trimaille is handling this issue now: https://github.com/qgis/QGIS/pull/9183

Also available in: Atom PDF