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
-------------------------------------+-------------------------------------
Changes (by muks):

 * owner:  muks => UnAssigned
 * status:  assigned => reviewing


Comment:

 Up for review.

 The bug was that with the new version of SQLite, some schema statements
 are split into multiple lines, and also the statements are in a different
 order now. So the change:

 * Converts them into single line SQL statements
 * Sorts the statements to enforce an order

 The `sed` expressions may not be compatible on all platforms. I've asked
 Jeremy to put this branch to the builders.

 Michal: You reported this bug from your system, so please check if this
 branch fixes the bug for you. I have verified it with a local install of
 SQLite 3.7.17 here.

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