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

[Benjamin Mack]

Hi Steffen,

+1 after reading. IMHO a nobrainer. Thanks for taking care of that.

Steffen Kamper wrote:
> "Steffen Kamper" <steffen at sk-typo3.de> schrieb im Newsbeitrag 
> news:mailman.1.1196186741.20054.typo3-team-core at lists.netfielders.de...
>> 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
>>
> the construct is no "nice" so i did the trimming before comparison, looks 
> better and more easy to read.
> 
> vg  Steffen 
> 
> 
> begin 666 20071127_dbcompare2.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.38L-R K-#DV+#@@
> M0$ -"B )"0D)"0EF;W)E86-H*"1K97E4>7!E<R!A<R D=&AE2V5Y*0E["B )
> M"0D)"0D):68@*&ES7V%R<F%Y*"1I;F9O6R1T:&5+97E=*2D)>PH@"0D)"0D)
> M"0EF;W)E86-H*"1I;F9O6R1T:&5+97E=(&%S("1F:65L9$X@/3X@)&9I96QD
> M0RD)>PHM"0D)"0D)"0D))&9I96QD3B ]('-T<E]R97!L86-E*"=@)RPG)RPD
> M9FEE;&1.*3L**PD)"0D)"0D)"21F:65L9$X@/2!T<FEM*'-T<E]R97!L86-E
> M*"=@)RPG)RPD9FEE;&1.*2D["BL)"0D)"0D)"0DD9FEE;&1#(#T@=')I;2 at D
> M9FEE;&1#*3L*( D)"0D)"0D)"6EF("@A:7-S970H)$9$8V]M<%LD=&%B;&5=
> M6R1T:&5+97E=6R1F:65L9$Y=*2D)>PH@"0D)"0D)"0D)"21E>'1R84%R<ELD
> M=&%B;&5=6R1T:&5+97E=6R1F:65L9$Y=(#T@)&9I96QD0SL*( D)"0D)"0D)
> M"7T at 96QS96EF("AS=')C;7 H)$9$8V]M<%LD=&%B;&5=6R1T:&5+97E=6R1F
> M:65L9$Y=+" D:6=N;W)E3F]T3G5L;%=H96Y#;VUP87)I;F<_<W1R7W)E<&QA
> I8V4H)R!.3U0 at 3E5,3"<L("<G+" D9FEE;&1#*3HD9FEE;&1#*2D)>PH`
> `
> end
> 
> _______________________________________________
> Before posting to this list, please have a look to the posting rules
> on the following websites:
> 
> http://typo3.org/teams/core/core-mailinglist-rules/
> http://typo3.org/development/bug-fixing/diff-and-patch/ 
> _______________________________________________
> TYPO3-team-core mailing list
> TYPO3-team-core at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-core

-- 
greetings,
benni.
-SDG-

www.xnos.de // www.xnos.org