[TYPO3-core] RFC: bug #6844: DB compare fails

Steffen Kamper steffen at sk-typo3.de
Tue Nov 27 19:06:34 CET 2007


This is an SVN patch request.


Branches: Trunk , 4.1?

Bugtracker Reference:
http://bugs.typo3.org/view.php?id=6844


Description:
many users noticed that EM gives update warning though field definition is 
equal to existing field. You see it with a "UPDATE NEEDED", eg:

ALTER TABLE fe_groups CHANGE felogin_redirectPid felogin_redirectPid 
tinytext;
Current value: tinytext

The comparison fails because of missing trim


Solution:
add trim to comparison

vg  Steffen 


begin 666 20071127_dbcompare.diff
M26YD97 at Z('0S;&EB+V-L87-S+G0S;&EB7VEN<W1A;&PN<&AP#0H]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]#0HM+2T@=#-L:6(O8VQA<W,N=#-L:6)?:6YS=&%L
M;"YP:' )*')E=FES:6]N(#(W-C8I#0HK*RL@=#-L:6(O8VQA<W,N=#-L:6)?
M:6YS=&%L;"YP:' )*'=O<FMI;F<@8V]P>2D-"D! ("TT.3DL-R K-#DY+#<@
M0$ -"B )"0D)"0D)"0DD9FEE;&1.(#T@<W1R7W)E<&QA8V4H)V G+"<G+"1F
M:65L9$XI.PH@"0D)"0D)"0D):68@*"%I<W-E="@D1D1C;VUP6R1T86)L95U;
M)'1H94ME>5U;)&9I96QD3ETI*0E["B )"0D)"0D)"0D))&5X=')A07)R6R1T
M86)L95U;)'1H94ME>5U;)&9I96QD3ET@/2 D9FEE;&1#.PHM"0D)"0D)"0D)
M?2!E;'-E:68@*'-T<F-M<"@D1D1C;VUP6R1T86)L95U;)'1H94ME>5U;)&9I
M96QD3ETL("1I9VYO<F5.;W1.=6QL5VAE;D-O;7!A<FEN9S]S=')?<F5P;&%C
M92 at G($Y/5"!.54Q,)RP@)R<L("1F:65L9$,I.B1F:65L9$,I*0E["BL)"0D)
M"0D)"0E](&5L<V5I9B H<W1R8VUP*'1R:6TH)$9$8V]M<%LD=&%B;&5=6R1T
M:&5+97E=6R1F:65L9$Y=*2P@)&EG;F]R94YO=$YU;&Q7:&5N0V]M<&%R:6YG
M/W-T<E]R97!L86-E*"<@3D]4($Y53$PG+" G)RP@=')I;2 at D9FEE;&1#*2DZ
M=')I;2 at D9FEE;&1#*2DI"7L*( D)"0D)"0D)"0DD9&EF9D%R<ELD=&%B;&5=
M6R1T:&5+97E=6R1F:65L9$Y=(#T@)&9I96QD0SL*( D)"0D)"0D)"0DD9&EF
M9D%R<E]C=7);)'1A8FQE75LD=&AE2V5Y75LD9FEE;&1.72 ]("1&1&-O;7!;
G)'1A8FQE75LD=&AE2V5Y75LD9FEE;&1.73L*( D)"0D)"0D)"7T*
`
end



More information about the TYPO3-team-core mailing list