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        |  vorner
            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 muks):

 Replying to [comment:6 vorner]:
 > IMO the bigger problem is using (unportable) shell and unportable output
 of the sqlite3 command line utility.

 You faced this issue on Gentoo, correct? So we both use GNU/Linux and have
 similar shells, sed, etc.

 The only problem I found was with the `sqlite3` `.schema` output. This
 output is now updated so that a "canonical" form is generated by making
 each SQL statement go into a single line, and then sorting the statements.

 If it still doesn't pass for you, can you apply the attached patch and
 provide output?

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