randgen team mailing list archive

[Philip Stoev <854548@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The following two "silent" scenarios are possible:

- an optimization transformation is disabled in DisableChosenPlan, and
is therefore not tested at all.

- an optimization transformation is enabled in DisableChosenPlan, but is
not exercised by the particular grammar or combination of optimizer
switches;

A partial solution to the second one would be to print out a warning if
there were transformations in DisableChosenPlan that were not triggered
by any incoming qurey.

The solution for the first would be to fail the test if most queries
passed through DisableChosenPlan without modification, as visible in
EXPLAIN.

** Affects: randgen
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/854548

Title:
  Cross check between enabled optimizations and triggered optimizations

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  New

Bug description:
  The following two "silent" scenarios are possible:

  - an optimization transformation is disabled in DisableChosenPlan, and
  is therefore not tested at all.

  - an optimization transformation is enabled in DisableChosenPlan, but
  is not exercised by the particular grammar or combination of optimizer
  switches;

  A partial solution to the second one would be to print out a warning
  if there were transformations in DisableChosenPlan that were not
  triggered by any incoming qurey.

  The solution for the first would be to fail the test if most queries
  passed through DisableChosenPlan without modification, as visible in
  EXPLAIN.

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/854548/+subscriptions