\i Infrastructure-TestHeader.sql

\echo '$Id: 0-integrity-AliasDoubleVotes.sql 95 2007-03-19 13:59:35Z dflater $'
\echo
\echo 'Verify that double votes resulting from write-in reconciliation are'
\echo 'detected by the integrity check.  The handling of double votes for a'
\echo 'given candidate resulting from write-in reconciliation is deliberately'
\echo 'unspecified in the VVSG, so for testing purposes it is considered an'
\echo 'error.  The "All results should be empty" notice does not apply to'
\echo 'this test case.  Refer instead to the "Expected results" printed at'
\echo 'the bottom.'

\i 0-integrity-common.sql

-- 'INCUMBENT' is an alias for 'Mr. Incumbent'
insert into Alias (ChoiceId, AliasId) values (2, 3);

\i Infrastructure-IntegrityChecks.sql

\echo 'Expected results:'
\echo '           Double Votes'
\echo ' ballotid | choiceid | count | sum '
\echo '----------+----------+-------+-----'
\echo '        7 |        2 |     2 |   2'
\echo '        6 |        2 |     2 |   2'
\echo '(2 rows)'

\i Infrastructure-TestFooter.sql
