[TASK] Tests: Include all NOT NULL fields in DataHandling fixtures 24/42624/2
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Fri, 14 Aug 2015 08:23:53 +0000 (10:23 +0200)
committerAnja Leichsenring <aleichsenring@ab-softlab.de>
Tue, 18 Aug 2015 14:02:56 +0000 (16:02 +0200)
The fixtures used by the functional tests are incomplete and don't
contain all fields that are defined as NOT NULL in the database schema.
Add the missing information to the fixtures to make tests pass when
running in MySQL strict mode.

Resolves: #69043
Resolves: #69051
Releases: master
Change-Id: I264cd809414b9b45b0bf1b14f33562ed298c4a3f
Reviewed-on: http://review.typo3.org/42624
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Daniel Goerz <ervaude@gmail.com>
Reviewed-by: Benni Mack <benni@typo3.org>
Tested-by: Benni Mack <benni@typo3.org>
Reviewed-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Tested-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
typo3/sysext/core/Tests/Functional/DataHandling/FAL/DataSet/LiveDefaultElements.csv
typo3/sysext/core/Tests/Functional/DataHandling/Group/DataSet/LiveDefaultElements.csv
typo3/sysext/core/Tests/Functional/DataHandling/IRRE/CSV/DataSet/LiveDefaultElements.csv
typo3/sysext/core/Tests/Functional/DataHandling/IRRE/ForeignField/DataSet/LiveDefaultElements.csv
typo3/sysext/core/Tests/Functional/DataHandling/ManyToMany/DataSet/LiveDefaultElements.csv
typo3/sysext/core/Tests/Functional/DataHandling/Regular/DataSet/LiveDefaultElements.csv
typo3/sysext/core/Tests/Functional/DataHandling/Select/DataSet/LiveDefaultElements.csv

index 7817c87..6551337 100644 (file)
@@ -3,25 +3,25 @@
 ,1,0,0,"Dansk","dk",,,,,,,,,,
 ,2,0,0,"Deutsch","de",,,,,,,,,,
 "sys_category",,,,,,,,,,,,,,,
-,"uid","pid","sorting","deleted","sys_language_uid","l10n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parent","items",
-,28,0,256,0,0,0,0,0,0,0,0,"Category A",0,0,
-,29,0,512,0,0,0,0,0,0,0,0,"Category B",0,0,
-,30,0,768,0,0,0,0,0,0,0,0,"Category C",0,0,
-,31,0,1024,0,0,0,0,0,0,0,0,"Category A.A",28,0,
+,"uid","pid","sorting","deleted","sys_language_uid","l10n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parent","items","l10n_diffsource","description"
+,28,0,256,0,0,0,0,0,0,0,0,"Category A",0,0,,"",""
+,29,0,512,0,0,0,0,0,0,0,0,"Category B",0,0,,"",""
+,30,0,768,0,0,0,0,0,0,0,0,"Category C",0,0,,"",""
+,31,0,1024,0,0,0,0,0,0,0,0,"Category A.A",28,0,,"",""
 sys_file
 ,uid,pid,type,storage,identifier,extension,mime_type,name,sha1,size,creation_date,modification_date,missing,metadata,identifier_hash,folder_hash,last_indexed
 ,1,0,2,1,/_migrated/pics/kasper-skarhoj1_01.jpeg,jpeg,image/jpeg,kasper-skarhoj1_01.jpeg,b841902021bbe23bd71e4a5b5b97626da7734b90,39056,1375080761,1374139442,0,0,2a4941658e4bd943048a234a5e1f305a1f736b10,f6e391567e01bdb14eac504413794a3bc1300abd,0
 ,21,0,2,1,/_migrated/pics/typo3_image5_01.jpg,jpg,image/jpeg,typo3_image5_01.jpg,ce136877a22606a6e44ce9b1f8ed3be70c74e6ee,126872,1375080761,1374139442,0,0,9df04e41b37d2c29777ee64ced3f612b2422a02e,f6e391567e01bdb14eac504413794a3bc1300abd,0
 sys_file_metadata
-,uid,pid,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,file,title,width,height,description,alternative,categories
-,1,0,0,0,0,0,0,0,0,1,"Image Kasper",401,600,,,0
-,21,0,0,0,0,0,0,0,0,21,"Image T3BOARD",1024,683,,,0
+,uid,pid,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,file,title,width,height,description,alternative,categories,l10n_diffsource
+,1,0,0,0,0,0,0,0,0,1,"Image Kasper",401,600,,,0,""
+,21,0,0,0,0,0,0,0,0,21,"Image T3BOARD",1024,683,,,0,""
 sys_file_reference
-,uid,pid,sorting,deleted,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,uid_local,uid_foreign,tablenames,fieldname,sorting_foreign,table_local,title,description,alternative,link,downloadname
-,126,89,128,0,0,0,0,0,0,0,0,1,330,tt_content,image,2,sys_file,"T3BOARD",,,,
-,127,89,64,0,0,0,0,0,0,0,0,21,330,tt_content,image,1,sys_file,"Kasper",,,,
-,128,89,32,0,0,0,0,0,0,0,0,21,331,tt_content,image,1,sys_file,"Taken at T3BOARD",,,,
-,129,89,16,0,0,0,0,0,0,0,0,1,331,tt_content,image,2,sys_file,"This is Kasper",,,,
+,uid,pid,sorting,deleted,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,uid_local,uid_foreign,tablenames,fieldname,sorting_foreign,table_local,title,description,alternative,link,downloadname,l10n_diffsource
+,126,89,128,0,0,0,0,0,0,0,0,1,330,tt_content,image,2,sys_file,"T3BOARD",,,,,""
+,127,89,64,0,0,0,0,0,0,0,0,21,330,tt_content,image,1,sys_file,"Kasper",,,,,""
+,128,89,32,0,0,0,0,0,0,0,0,21,331,tt_content,image,1,sys_file,"Taken at T3BOARD",,,,,""
+,129,89,16,0,0,0,0,0,0,0,0,1,331,tt_content,image,2,sys_file,"This is Kasper",,,,,""
 tt_content
 ,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,header,image
 ,330,89,256,0,0,0,0,0,0,0,0,"Regular Element #1",2
index e441f7c..2ae16c1 100644 (file)
@@ -7,8 +7,8 @@ tt_content
 ,297,89,256,0,0,0,0,0,0,0,0,"Regular Element #1","1,2"
 ,298,89,512,0,0,0,0,0,0,0,0,"Regular Element #2","2,3"
 tx_testdatahandler_element
-,uid,pid,sorting,deleted,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title
-,1,89,256,0,0,0,0,0,0,0,0,"Element #1"
-,2,89,512,0,0,0,0,0,0,0,0,"Element #2"
-,3,89,768,0,0,0,0,0,0,0,0,"Element #3"
+,uid,pid,sorting,deleted,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title,l10n_diffsource
+,1,89,256,0,0,0,0,0,0,0,0,"Element #1",
+,2,89,512,0,0,0,0,0,0,0,0,"Element #2",
+,3,89,768,0,0,0,0,0,0,0,0,"Element #3",
 
index 4a196a4..8597a3b 100644 (file)
@@ -7,22 +7,22 @@ tt_content
 ,297,89,256,0,0,0,0,0,0,0,0,"Regular Element #1",,"3,4"
 ,298,89,512,0,0,0,0,0,0,0,0,"Regular Element #2",,"5"
 tx_irretutorial_1ncsv_hotel
-,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title,offers
-,3,89,256,0,0,0,0,0,0,0,0,"Hotel #1","5,6"
-,4,89,128,0,0,0,0,0,0,0,0,"Hotel #2","7"
-,5,89,64,0,0,0,0,0,0,0,0,"Hotel #1","8"
+,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,l18n_diffsource,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title,offers
+,3,89,256,0,0,0,,0,0,0,0,0,"Hotel #1","5,6"
+,4,89,128,0,0,0,,0,0,0,0,0,"Hotel #2","7"
+,5,89,64,0,0,0,,0,0,0,0,0,"Hotel #1","8"
 tx_irretutorial_1ncsv_offer
-,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title,prices
-,5,89,256,0,0,0,0,0,0,0,0,"Offer #1.1","7,8,9"
-,6,89,128,0,0,0,0,0,0,0,0,"Offer #1.2","10,11"
-,7,89,64,0,0,0,0,0,0,0,0,"Offer #2.1","12"
-,8,89,32,0,0,0,0,0,0,0,0,"Offer #1.1","13"
+,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,l18n_diffsource,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title,prices
+,5,89,256,0,0,0,,0,0,0,0,0,"Offer #1.1","7,8,9"
+,6,89,128,0,0,0,,0,0,0,0,0,"Offer #1.2","10,11"
+,7,89,64,0,0,0,,0,0,0,0,0,"Offer #2.1","12"
+,8,89,32,0,0,0,,0,0,0,0,0,"Offer #1.1","13"
 tx_irretutorial_1ncsv_price
-,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title
-,7,89,256,0,0,0,0,0,0,0,0,"Price #1.1.1"
-,8,89,128,0,0,0,0,0,0,0,0,"Price #1.1.2"
-,9,89,64,0,0,0,0,0,0,0,0,"Price #1.1.3"
-,10,89,32,0,0,0,0,0,0,0,0,"Price #1.2.1"
-,11,89,16,0,0,0,0,0,0,0,0,"Price #1.2.2"
-,12,89,8,0,0,0,0,0,0,0,0,"Price #2.1.1"
-,13,89,4,0,0,0,0,0,0,0,0,"Price #1.1.1"
+,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,l18n_diffsource,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title
+,7,89,256,0,0,0,,0,0,0,0,0,"Price #1.1.1"
+,8,89,128,0,0,0,,0,0,0,0,0,"Price #1.1.2"
+,9,89,64,0,0,0,,0,0,0,0,0,"Price #1.1.3"
+,10,89,32,0,0,0,,0,0,0,0,0,"Price #1.2.1"
+,11,89,16,0,0,0,,0,0,0,0,0,"Price #1.2.2"
+,12,89,8,0,0,0,,0,0,0,0,0,"Price #2.1.1"
+,13,89,4,0,0,0,,0,0,0,0,0,"Price #1.1.1"
index bbf5c96..a32add7 100644 (file)
@@ -7,22 +7,22 @@
 ,297,89,256,0,0,0,0,0,0,0,0,"Regular Element #1","\NULL",2
 ,298,89,512,0,0,0,0,0,0,0,0,"Regular Element #2","\NULL",1
 "tx_irretutorial_1nff_hotel"
-,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parentid","parenttable","parentidentifier","offers"
-,3,89,1,0,0,0,0,0,0,0,0,"Hotel #1",297,"tt_content",,2
-,4,89,2,0,0,0,0,0,0,0,0,"Hotel #2",297,"tt_content",,1
-,5,89,1,0,0,0,0,0,0,0,0,"Hotel #1",298,"tt_content",,1
+,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","l18n_diffsource","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parentid","parenttable","parentidentifier","offers"
+,3,89,1,0,0,0,,0,0,0,0,0,"Hotel #1",297,"tt_content",,2
+,4,89,2,0,0,0,,0,0,0,0,0,"Hotel #2",297,"tt_content",,1
+,5,89,1,0,0,0,,0,0,0,0,0,"Hotel #1",298,"tt_content",,1
 "tx_irretutorial_1nff_offer"
-,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parentid","parenttable","parentidentifier","prices"
-,5,89,1,0,0,0,0,0,0,0,0,"Offer #1.1",3,"tx_irretutorial_1nff_hotel",,3
-,6,89,2,0,0,0,0,0,0,0,0,"Offer #1.2",3,"tx_irretutorial_1nff_hotel",,2
-,7,89,1,0,0,0,0,0,0,0,0,"Offer #2.1",4,"tx_irretutorial_1nff_hotel",,1
-,8,89,1,0,0,0,0,0,0,0,0,"Offer #1.1",5,"tx_irretutorial_1nff_hotel",,1
+,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","l18n_diffsource","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parentid","parenttable","parentidentifier","prices"
+,5,89,1,0,0,0,,0,0,0,0,0,"Offer #1.1",3,"tx_irretutorial_1nff_hotel",,3
+,6,89,2,0,0,0,,0,0,0,0,0,"Offer #1.2",3,"tx_irretutorial_1nff_hotel",,2
+,7,89,1,0,0,0,,0,0,0,0,0,"Offer #2.1",4,"tx_irretutorial_1nff_hotel",,1
+,8,89,1,0,0,0,,0,0,0,0,0,"Offer #1.1",5,"tx_irretutorial_1nff_hotel",,1
 "tx_irretutorial_1nff_price"
-,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parentid","parenttable","parentidentifier"
-,7,89,1,0,0,0,0,0,0,0,0,"Price #1.1.1",5,"tx_irretutorial_1nff_offer",
-,8,89,2,0,0,0,0,0,0,0,0,"Price #1.1.2",5,"tx_irretutorial_1nff_offer",
-,9,89,3,0,0,0,0,0,0,0,0,"Price #1.1.3",5,"tx_irretutorial_1nff_offer",
-,10,89,1,0,0,0,0,0,0,0,0,"Price #1.2.1",6,"tx_irretutorial_1nff_offer",
-,11,89,2,0,0,0,0,0,0,0,0,"Price #1.2.2",6,"tx_irretutorial_1nff_offer",
-,12,89,1,0,0,0,0,0,0,0,0,"Price #2.1.1",7,"tx_irretutorial_1nff_offer",
-,13,89,1,0,0,0,0,0,0,0,0,"Price #1.1.1",8,"tx_irretutorial_1nff_offer",
+,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","l18n_diffsource","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parentid","parenttable","parentidentifier"
+,7,89,1,0,0,0,,0,0,0,0,0,"Price #1.1.1",5,"tx_irretutorial_1nff_offer",
+,8,89,2,0,0,0,,0,0,0,0,0,"Price #1.1.2",5,"tx_irretutorial_1nff_offer",
+,9,89,3,0,0,0,,0,0,0,0,0,"Price #1.1.3",5,"tx_irretutorial_1nff_offer",
+,10,89,1,0,0,0,,0,0,0,0,0,"Price #1.2.1",6,"tx_irretutorial_1nff_offer",
+,11,89,2,0,0,0,,0,0,0,0,0,"Price #1.2.2",6,"tx_irretutorial_1nff_offer",
+,12,89,1,0,0,0,,0,0,0,0,0,"Price #2.1.1",7,"tx_irretutorial_1nff_offer",
+,13,89,1,0,0,0,,0,0,0,0,0,"Price #1.1.1",8,"tx_irretutorial_1nff_offer",
index 2686e8c..195cf0a 100644 (file)
@@ -3,11 +3,11 @@
 ,1,0,0,"Dansk","dk",,,,,,,,,,
 ,2,0,0,"Deutsch","de",,,,,,,,,,
 "sys_category",,,,,,,,,,,,,,,
-,"uid","pid","sorting","deleted","sys_language_uid","l10n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parent","items",
-,28,0,256,0,0,0,0,0,0,0,0,"Category A",0,0,
-,29,0,512,0,0,0,0,0,0,0,0,"Category B",0,0,
-,30,0,768,0,0,0,0,0,0,0,0,"Category C",0,0,
-,31,0,1024,0,0,0,0,0,0,0,0,"Category A.A",28,0,
+,"uid","pid","sorting","deleted","sys_language_uid","l10n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parent","items","l10n_diffsource","description"
+,28,0,256,0,0,0,0,0,0,0,0,"Category A",0,0,,,
+,29,0,512,0,0,0,0,0,0,0,0,"Category B",0,0,,,
+,30,0,768,0,0,0,0,0,0,0,0,"Category C",0,0,,,
+,31,0,1024,0,0,0,0,0,0,0,0,"Category A.A",28,0,,,
 "sys_category_record_mm",,,,,,,,,,,,,,,
 ,"uid_local","uid_foreign","tablenames","sorting","sorting_foreign","fieldname",,,,,,,,,
 ,28,297,"tt_content",0,1,"categories",,,,,,,,,
index 6ca8584..1e60d90 100644 (file)
@@ -3,14 +3,14 @@
 ,1,0,0,"Dansk","dk",,,,,,,,,,
 ,2,0,0,"Deutsch","de",,,,,,,,,,
 "sys_category",,,,,,,,,,,,,,,
-,"uid","pid","sorting","deleted","sys_language_uid","l10n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parent","items",
-,28,0,256,0,0,0,0,0,0,0,0,"Category A",0,0,
-,29,0,512,0,0,0,0,0,0,0,0,"Category B",0,0,
-,30,0,768,0,0,0,0,0,0,0,0,"Category C",0,0,
-,31,0,1024,0,0,0,0,0,0,0,0,"Category A.A",28,0,
+,"uid","pid","sorting","deleted","sys_language_uid","l10n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","title","parent","items","l10n_diffsource","description"
+,28,0,256,0,0,0,0,0,0,0,0,"Category A",0,0,,,
+,29,0,512,0,0,0,0,0,0,0,0,"Category B",0,0,,,
+,30,0,768,0,0,0,0,0,0,0,0,"Category C",0,0,,,
+,31,0,1024,0,0,0,0,0,0,0,0,"Category A.A",28,0,,,
 "tt_content",,,,,,,,,,,,,,,
 ,"uid","pid","sorting","deleted","sys_language_uid","l18n_parent","t3ver_wsid","t3ver_state","t3ver_stage","t3ver_oid","t3ver_move_id","header"
 ,297,89,256,0,0,0,0,0,0,0,0,"Regular Element #1"
 ,298,89,512,0,0,0,0,0,0,0,0,"Regular Element #2"
 ,299,89,768,0,0,0,0,0,0,0,0,"Regular Element #3"
-,300,89,1024,0,1,299,0,0,0,0,0,"[Translate to Dansk:] Regular Element #3"
\ No newline at end of file
+,300,89,1024,0,1,299,0,0,0,0,0,"[Translate to Dansk:] Regular Element #3"
index 0fab844..a5bac61 100644 (file)
@@ -7,8 +7,8 @@ tt_content
 ,297,89,256,0,0,0,0,0,0,0,0,"Regular Element #1","1,2"
 ,298,89,512,0,0,0,0,0,0,0,0,"Regular Element #2","2,3"
 tx_testdatahandler_element
-,uid,pid,sorting,deleted,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title
-,1,89,256,0,0,0,0,0,0,0,0,"Element #1"
-,2,89,512,0,0,0,0,0,0,0,0,"Element #2"
-,3,89,768,0,0,0,0,0,0,0,0,"Element #3"
+,uid,pid,sorting,deleted,sys_language_uid,l10n_parent,t3ver_wsid,t3ver_state,t3ver_stage,t3ver_oid,t3ver_move_id,title,l10n_diffsource
+,1,89,256,0,0,0,0,0,0,0,0,"Element #1",
+,2,89,512,0,0,0,0,0,0,0,0,"Element #2",
+,3,89,768,0,0,0,0,0,0,0,0,"Element #3",