Compare Stored Queries

Compare Stored Queries compares two previously stored query results. Specify symbol names as the first and second argument (without <<). The query structure must be listed in the second row. (Use Inspect Query to build it quickly if you do not want to type it.) Column structure is specified so that some columns can be ignored during comparison (just don?t list them), and for the partial row-key mapping to work. Put a question mark after the column names that do not belong to the primary key to make the comparisons better. The comparison will print out all matching rows in green (Figure 12: Comparing stored queries), and list rows that are in just one query with red (and fail the test if such rows exist). If some rows are matched partially, just by primary key, differences in individual value cells will also be shown and the test will fail.

|execute|create table testtbl (n int, name varchar(100))|

!|insert|testtbl|
|n|name|
|1|NAME1|
|3|NAME3|
|2|NAME2|

|Store Query|select * from testtbl|fromtable|

|Store Query|select n, concat('NAME',n) as name from ( select 1 as n union select 3 union select 2) x|fromdual|

|compare stored queries|fromtable|fromdual|
|name|n?|

|execute|drop table testtbl|

Previous page: Store Query Parent page: Command reference