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.
Engine Preferences: Backward Compatibility Issues introduced in 2018.2
l
Priortoversion2018.2Connectallowedamixtureofinternalandexternalengines.AsofPlan-
etPressConnect2018.2thisisnolongerallowed.
WhenupgradingtoPlanetPressConnect2018.2fromsuchinstallations,thepre-existingsettings
Page 106