Changes between Version 10 and Version 11 of DifferenceDesign


Ignore:
Timestamp:
Nov 16, 2011, 10:48:29 AM (6 years ago)
Author:
stephen
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DifferenceDesign

    v10 v11  
    298298   in the "zones" table.
    299299 operation::
    300    Eiher 0 (delete) or 1 (add)
     300   Either 0 (add) or 1 (delete)
    301301 name::
    302302   Textual representation of the owner name of the updated RR, e.g. "example.com."
     
    335335select * from diffs where
    336336  zone_id = Z and
    337   id >= (select id from diffs where version = B and operation = 0
     337  id >= (select id from diffs where version = B and operation = 1
    338338         order by id asc limit 1)
    339339  and
    340   id <= (select id from diffs where version = E and operation = 1
     340  id <= (select id from diffs where version = E and operation = 0
    341341         order by id desc limit 1);
    342342}}}
     
    346346compare versions.
    347347
    348 Partily because of this the statement is complicated and involves
     348Partly because of this the statement is complicated and involves
    349349multiple subqueries (which might be less efficient).  There may be alternate
    350350approaches; see the "Open Issues" section.