randgen team mailing list archive

[Philip Stoev <733162@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Simplification causes the ON clause to be simplfieid to a single field
reference, which is an edge and unrealistic test case. Instead, the ON
should retain the 2 original fields , or be convertede to ON (f1 != 0).

** 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/733162

Title:
  Do not simplify JOINs to have an unrealistic ON clause

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

Bug description:
  Simplification causes the ON clause to be simplfieid to a single field
  reference, which is an edge and unrealistic test case. Instead, the ON
  should retain the 2 original fields , or be convertede to ON (f1 !=
  0).