Declare dependencies in deterministic order (RT#102859)

[dbsrgits/SQL-Translator.git] / t / 24yaml.t

diff --git a/t/24yaml.t b/t/24yaml.t
index 9c8bda3..08757d9 100644 (file)
--- a/t/24yaml.t
+++ b/t/24yaml.t
@@ -13,7 +13,8 @@ BEGIN {
 }
 
 my $sqlt_version = $SQL::Translator::VERSION;
-my $yaml = <<YAML;
+use YAML qw(Dump Load);
+my $yaml = Dump(Load(<<YAML));
 ---
 schema:
   procedures: {}
@@ -88,6 +89,7 @@ schema:
         person_id:
           data_type: INTEGER
           default_value: ~
+          is_auto_increment: 1
           is_nullable: 0
           is_primary_key: 1
           is_unique: 0
@@ -136,6 +138,19 @@ schema:
           reference_fields: []
           reference_table: ''
           type: PRIMARY KEY
+        - deferrable: 1
+          expression: ''
+          fields:
+            - person_id
+          match_type: ''
+          name: ''
+          on_delete: ''
+          on_update: ''
+          options: []
+          reference_fields:
+            - person_id
+          reference_table: person
+          type: FOREIGN KEY
       fields:
         age:
           data_type: int
@@ -197,7 +212,7 @@ schema:
       perform_action_when: after
   views:
     person_pet:
-      fields: ''
+      fields: []
       name: person_pet
       order: 1
       sql: |