[Opendnssec-develop] [OpenDNSSEC] #216: migrate_keyshare_sqlite3.pl broken

[OpenDNSSEC]

#216: migrate_keyshare_sqlite3.pl broken
-----------------------------------------------------+----------------------
Reporter:  Marc Dequènes (Duck) <duck@…>             |       Owner:  sion              
    Type:  defect                                    |      Status:  new               
Priority:  major                                     |   Component:  Enforcer          
 Version:  1.2.0                                     |    Keywords:  database migration
-----------------------------------------------------+----------------------
 The script fails during repopulate keypairs phase. The logic is good, but
 unfortunately SQLite3 has got a silly limitation, which does not allow
 having a different number of columns in a INSERT…SELECT statement, even if
 these missing columns have a DEFAULT clause. As pre_backup is not set, the
 query fails.

 The following patch fixes this issue.

 Priotity major as it breaks upgrades.

-- 
Ticket URL: <http://trac.opendnssec.org/ticket/216>
OpenDNSSEC <http://www.opendnssec.org/>
OpenDNSSEC