[SQOOP-449] Use regular expression to verify output in compatibility tests

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Assignee: Cheolsoo Park
• Reporter: Cheolsoo Park
• Created: 29/Feb/12 22:08
• Updated: 09/Mar/12 01:42
• Resolved: 02/Mar/12 18:45

Description

One of OracleCompatTest tests (timestamp2) fails w/ Oracle 11g XE. The problem is that the verifyReadback function in testutil does string comparison to verify output, but the output string does not exactly match with any of expected values.

In fact, doing string comparison is problematic since newer versions of DBs/drivers may have different output formats, and this test will be broken again. The better way to write this test would be to use regular expression rather than string comparison. In addition, there are several tests where the output string is compared against multiple expected values until succeed. Using regular expression will eliminate multiple tries as well.

Issue Links

• is related to: SQOOP-459 Remove redundant steps in compatibility tests: verifyReadback() method