[TASK] Tests: Include all NOT NULL fields in EXT:workspaces fixtures 28/42628/3
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Fri, 14 Aug 2015 13:40:21 +0000 (15:40 +0200)
committerAnja Leichsenring <aleichsenring@ab-softlab.de>
Tue, 18 Aug 2015 14:03:21 +0000 (16:03 +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: #69059
Releases: master
Change-Id: I466cf8fd965918096cc72710a8637e82d26d48c9
Reviewed-on: http://review.typo3.org/42628
Reviewed-by: Frans Saris <franssaris@gmail.com>
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/workspaces/Tests/Functional/DataHandling/FAL/DataSet/LiveDefaultElements.csv
typo3/sysext/workspaces/Tests/Functional/DataHandling/Group/DataSet/LiveDefaultElements.csv
typo3/sysext/workspaces/Tests/Functional/DataHandling/IRRE/CSV/DataSet/LiveDefaultElements.csv
typo3/sysext/workspaces/Tests/Functional/DataHandling/IRRE/ForeignField/DataSet/LiveDefaultElements.csv
typo3/sysext/workspaces/Tests/Functional/DataHandling/ManyToMany/DataSet/LiveDefaultElements.csv
typo3/sysext/workspaces/Tests/Functional/DataHandling/Regular/DataSet/LiveDefaultElements.csv
typo3/sysext/workspaces/Tests/Functional/DataHandling/Select/DataSet/LiveDefaultElements.csv

index e5f3d6a..aa49397 100644 (file)
 ,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 9b468be..e4f6d82 100644 (file)
@@ -14,8 +14,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 ffd165b..1e38109 100644 (file)
@@ -14,22 +14,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 cb8f530..854c7fe 100644 (file)
 ,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 54adcea..3dc9b78 100644 (file)
@@ -10,11 +10,11 @@ sys_workspace_stage
 ,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 e3a2b8d..bb9c5f4 100644 (file)
@@ -10,11 +10,11 @@ sys_workspace_stage
 ,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"
index eadeabd..6bbb10e 100644 (file)
@@ -14,8 +14,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",