Acknowledging Defects

From SQLBrowser

Jump to: navigation, search
  • Sometimes, SQLBrowser reports a defect that you know about but that you can not or do not want to address.
  • You can 'acknowledge' such defects.
  • To do this, insert a pragma in the form of a comment just before the statement which generates the defect.


The pragma has the following syntax: 

 -- pragma acknowledge next defect <DEFECTCODE> comment_explaining_why_we_acknowledge

for example: 

 -- pragma acknowledge next defect QAFM key of currency is wrong but we know we have a single row
 select @id_ccy = id_currency
 from narval..currency where 
 cd_iso_ccy = @cd_iso_ccy


  • The pragma comment must appear before the token which provoked the defect
  • It can be just before the executable statement which provokeds the defect
  • The pragma is considered valid only if it has a comment in the end explaining the reason of the acknowledge
  • The defect will then appear differently (ticked with green) in both the editor and in the batch analysis
  • You can untick 'Detect acknowledged defects' in the Option / Defects pane to stop detection of such defects
  • The list of defect codes is here
Retrieved from "http://www.sqlbrowser.com/wiki/index.php/Acknowledging_Defects"
Personal tools