Error Codes
This index lists the current diagnostic codes exposed by QueryLens.
| Code | Summary |
|---|---|
| QL0001 | Structural syntax failure or dialect-unsupported syntax |
| QL0010 | Referenced table not found in schema snapshot |
| QL0011 | Referenced column not found in schema snapshot |
| QL0012 | Referenced stored procedure not found in schema snapshot |
| QL0020 | Column-to-model mapping warning |
| QL0030 | Required SQL parameter missing from validation parameters |
| QL0031 | Supplied validation parameter not used in SQL |
| QL0040 | UPDATE or DELETE has no WHERE clause |
| QL0050 | INSERT column/value count mismatch |
| QL0060 | Attempted write to identity column |
| QL0061 | Attempted write to computed column |
| QL0070 | Unknown function for active dialect |
| QL0071 | Function not available in active version profile |
| QL0072 | Too few function arguments |
| QL0073 | Too many function arguments |
| QL0080 | Required insert column missing |
| QL0090 | Reserved word used as table name |
| QL0091 | Reserved word used as column name |
Search Terms
This section intentionally includes terms users search for, such as IsValid, Errors, Warnings, ErrorSummary, validate SQL in tests, raw SQL validation, and QueryLens diagnostics.
Example
var query = new SqlQuery("SELECT FROM customers");
Assert.Equal("QL0001", query.Errors[0].Code);