2022.2

set @a=null,@c=null,@b=concat("show tables where",ifnull(concat(" `Tables_in_
",database(),"` like '",@c,"' and"),'')," (@a:=concat_ws(',',@a,`Tables_in_
",database(),"`))");
Prepare `bd` from @b;
EXECUTE `bd`;
DEALLOCATE PREPARE `bd`;
set @a:=concat('optimize table ',@a);
PREPARE `sql` FROM @a;
EXECUTE `sql`;
DEALLOCATE PREPARE `sql`;
set @a=null,@b=null,@c=null;
IfusingMicrosoft SQL Serverrunthefollowingcommandinaquerywindow:
sp_updatestats
Windows 10 Search service impacting Connect
TheWindows10Searchservicerunsasabackgroundtask,indexingfilesandfolders.Ithasbeen
notedthatthisbackgroundtaskissometimespreventingfilesbeingaddedtotheConnecttemporary
filesfolderwhenlargeamountsoffilesarebeingoutputandcopied.
Ifthisisanissueforyou,wesuggestdisablingSearchIndexingontheC:\Users\<username>\Connect
folder.
Thisissuewillbefixedinalaterrelease.
Job Creation Presets: External Sorting change introduced in 2018.2
Versionspriorto2018.2didnotcorrectlysavethelineendcharactersforexternalsortconfigurationsin
JobCreationPresets,whichmeantthejobcouldnotbeexternallysorted.Thisissuehasbeenfixedin
version2018.2.However,JobCreationPresetscreatedwithanearlierversionmaystillhavethewrong
lineendcharacterforexternalsorting.Tofixthis,opentheJobCreationPresetinthenewversion,
resetthelineendsettinginthesortingoptionsandthensavethepreset.
Business Graphics: Backward Compatibility Issues introduced in 2018.1
Asaconsequenceofchangesinboththeuserinterfaceandtheunderlyingtechnology,Business
GraphicsmadewithaversionpriortoPrintShopMailConnect2018.1maynotdisplaycorrectlywhen
openedinversion2022.2.
Thecurrentlyknownbackwardcompatibilityissuesarelistedhere:
Page 85