Quote: SQL comparison across database systems not effective for testing NULL, strings, and numeric type coercion; needed for portability

Quotation

The problem of validating outputs remains a tough issue. Output comparisons for different vendor's database systems proved to be extremely useful, but only for a small subset of common SQL. The differences in NULL and character string handling and numeric type coercion in expressions was particularly problematic (these are also portability issues).   Google-1   Google-2

By permission of the Very Large Database Endowment

Related Topics

Topic: software portability (43 items)
Topic: automated testing (24 items)