Versions Compared

Old Version 4

changes.mady.by.user Elliot West

Saved on

compared with

New Version 5

changes.mady.by.user Elliot West

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: typo

...

This query has a very broad set of responsibilities which cannot be easily verified in isolation. On closer inspection it appears that it is in fact formed of at least 7 distinct queries. To effectively unit test the process that this query represents an approach must be applied that separates and encapsulates each of the subqueries so that they can be tested independently. Possibly  Possible approaches to this include: VIEWs, sequential execution of components with intermediate (possibly TEMPORARY) tables, and even variable substitution of query fragments.

...