Running test scenarios

Learn how to run test queries on the Netezza Performance Server test database.

Before you begin

Make sure that you completed the steps from .

About this task

Available test queries

With the sample database, you can test following scenarios. You can run all of the tests or run a single test.
  • test_select
  • test_insert
  • test_create
  • test_mview
  • test_comparison_operators
  • test_aggregate
  • test_clauses
  • test_set_operators
  • test_inner_join
  • test_right_outer_join
  • test_left_outer_join
  • test_full_outer_join
  • test_cross_join
  • test_udx
  • test_corelated
  • test_stored_procedure
  • test_new_datatypes_JSON_JSONB_JSONPATH
  • test_alter
  • test_update
  • test_delete
  • test_truncate

Procedure

  1. Go to the sample-databases directory.
  2. Run a test scenario. 
    python 3 test_sample_test_cases.py test-case-name
    Example:
    python 3 test_sample_test_cases.py test_truncate

    Tip:
    1. For help, run:
      python3 test_sample_test_cases.py --help
    2. For all test cases, run:
      python3 test_sample_test_cases.py --all
    3. For multiple test cases, run:
      python3 test_sample_test_cases.py test-case-name1 test-case-name2...
  3. When the script is finished, you can check the output folder inside the sample-databases folder.
    The output folder consists of the following items:
    .out files
    Output of the completed test cases.
    .diff files
    Diffs that are generated for failed test cases.