BIND 10 #2968: Database upgrade tests fail with sqlite3 sqlite-3.7.17

[BIND 10 Development]

#2968: Database upgrade tests fail with sqlite3 sqlite-3.7.17
-------------------------------------+-------------------------------------
            Reporter:  vorner        |                        Owner:
                Type:  defect        |  UnAssigned
            Priority:  medium        |                       Status:
           Component:  Unclassified  |  reviewing
            Keywords:                |                    Milestone:
           Sensitive:  0             |  Sprint-20130611
         Sub-Project:  DNS           |                   Resolution:
Estimated Difficulty:  4             |                 CVSS Scoring:
         Total Hours:  0             |              Defect Severity:  N/A
                                     |  Feature Depending on Ticket:
                                     |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------

Comment (by vorner):

 It still does not pass here :-(.

 {{{
 2013-06-10 09:37:21.649 INFO  [b10-dbutil.dbutil/23905] DBUTIL_FILE
 Database file:
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_tempfile_23861

 2013-06-10 09:37:21.649 INFO  [b10-dbutil.dbutil/23905] DBUTIL_BACKUP
 created backup of
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_tempfile_23861
 in
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_tempfile_23861.backup

 2013-06-10 09:37:21.650 INFO  [b10-dbutil.dbutil/23905] DBUTIL_UPGRADING
 upgrading database from V1.0 to V2.0

 2013-06-10 09:37:21.653 INFO  [b10-dbutil.dbutil/23905] DBUTIL_UPGRADING
 upgrading database from V2.0 to V2.1

 2013-06-10 09:37:21.653 INFO  [b10-dbutil.dbutil/23905] DBUTIL_UPGRADING
 upgrading database from V2.1 to V2.2

 2013-06-10 09:37:21.653 INFO  [b10-dbutil.dbutil/23905]
 DBUTIL_UPGRADE_SUCCESFUL database upgrade successfully completed
 ERROR: upgraded schema not as expected
 *** FAIL

 2013-06-10 09:37:21.736 INFO  [b10-dbutil.dbutil/23925] DBUTIL_FILE
 Database file:
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_verfile_23861

 2013-06-10 09:37:21.736 INFO  [b10-dbutil.dbutil/23925]
 DBUTIL_VERSION_CURRENT database version V2.2
 2013-06-10 09:37:21.736 INFO  [b10-dbutil.dbutil/23925] DBUTIL_CHECK_OK
 this is the latest version of the database schema. No upgrade is required
 --- PASS
 6.1. Database is new V1 database - check

 2013-06-10 09:37:21.879 INFO  [b10-dbutil.dbutil/23934] DBUTIL_FILE
 Database file:
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_verfile_23861

 2013-06-10 09:37:21.880 INFO  [b10-dbutil.dbutil/23934] DBUTIL_VERSION_LOW
 database version V1.0, latest version is V2.2.

 2013-06-10 09:37:21.880 INFO  [b10-dbutil.dbutil/23934]
 DBUTIL_CHECK_UPGRADE_NEEDED re-run this program with the --upgrade switch
 to upgrade
 --- PASS
 6.2. Database is a new V1 database - upgrade

 2013-06-10 09:37:22.010 INFO  [b10-dbutil.dbutil/23941] DBUTIL_FILE
 Database file:
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_tempfile_23861

 2013-06-10 09:37:22.011 INFO  [b10-dbutil.dbutil/23941] DBUTIL_BACKUP
 created backup of
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_tempfile_23861
 in
 /tmp/bind10/bind10-3/bind10-20130529/_build/src/bin/dbutil/tests/dbutil_test_tempfile_23861.backup

 2013-06-10 09:37:22.011 INFO  [b10-dbutil.dbutil/23941] DBUTIL_UPGRADING
 upgrading database from V1.0 to V2.0

 2013-06-10 09:37:22.023 INFO  [b10-dbutil.dbutil/23941] DBUTIL_UPGRADING
 upgrading database from V2.0 to V2.1

 2013-06-10 09:37:22.023 INFO  [b10-dbutil.dbutil/23941] DBUTIL_UPGRADING
 upgrading database from V2.1 to V2.2

 2013-06-10 09:37:22.025 INFO  [b10-dbutil.dbutil/23941]
 DBUTIL_UPGRADE_SUCCESFUL database upgrade successfully completed
 ERROR: upgraded schema not as expected
 *** FAIL
 }}}

 IMO the bigger problem is using (unportable) shell and unportable output
 of the sqlite3 command line utility.

-- 
Ticket URL: <http://bind10.isc.org/ticket/2968#comment:6>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development