End-User Documentation

Unknown Function and Version Errors

Unknown Function and Version Errors

Function diagnostics become more precise in dialect mode, which is why QueryLens can distinguish spelling mistakes, unsupported versions, and wrong argument counts.

How To Read The Codes

  • QL0070: unknown or misspelled function
  • QL0071: function exists, but not in the selected version profile
  • QL0072: too few arguments
  • QL0073: too many arguments

What To Check

  • Spelling
  • Selected dialect family
  • Selected version profile
  • Expected function signature

Example

QueryLens.Dialect = DialectProfile.SqlServer2014;
var query = new SqlQuery("SELECT STRING_AGG(name, ',') FROM dbo.departments");

Assert.Contains(query.Errors, issue => issue.Code == "QL0071");

Related