v.24.6Improvement

Forbid QUALIFY Clause in Old Analyzer to Prevent Data Loss

Official CH changelog text
Forbid QUALIFY clause in the old analyzer. The old analyzer ignored QUALIFY, so it could lead to unexpected data removal in mutations. #65356 (Dmitry Novik).
Forbid the use of the QUALIFY clause in the old query analyzer to prevent unexpected data removal in mutations.

Why it matters

The old analyzer ignored the QUALIFY clause, which could cause unintended data loss during mutation operations. This feature ensures data integrity by disallowing QUALIFY in the old analyzer, preventing such issues.

How to use it

Users should avoid using the QUALIFY clause with the old analyzer. The system now forbids QUALIFY when the old analyzer is in use, so using QUALIFY requires the new query analyzer.

Related resources

PreviousNext