Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.
  • Functional equivalence could probably be determined by parsing the different SQL then analyzing the two parsed structures using various heuristics.

    I use a similar technigue with Test::PDF [] to do a basic test for "visual" similarity, by using Test::Deep to compare the data-structures CAM::PDF produces after it parses the PDF file.

    Just a thought :)

    - Stevan

    • Maybe one of the deep-structure equivalence testing methods could be called after parsing both with SQL::Statement.

      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
      • SQL::Statement won't work for me due to the sheer complexity of much of our autogenerated SQL. For example, it won't handle case statements. There are a number of other constructs it won't handle, so while I'd like to have a specific parser for this problem domain, I would like a more general solution for where parsers are not available.