[TYPO3-core] RFC: #8399: field tablename in sys_refindex too short

[Steffen Kamper]

"Oliver Hader" <oliver at typo3.org> schrieb im Newsbeitrag 
news:mailman.1.1210762640.2584.typo3-team-core at lists.netfielders.de...
> Hi Steffen,
>
> Steffen Kamper schrieb:
>> Type: Bugfix
>>
>> Bugtracker references:
>> http://bugs.typo3.org/view.php?id=8399
>>
>> Branches: 4.2
>>
>> Problem:
>> In some cases 40 characters for tablename is too less, especially when 
>> using
>> IRRE-relation.
>>
>> Solution:
>> I increased the fields tablename and ref_table to varchar(64) which 
>> should
>> be fit.
>
> Thanks for your patch. As discussed via Skype there are some more tables
> which store table names and are limited to 40 chars. Additionally I fear
> that this change won't go to the 4.2 branch since it contains DB
> changes, but of course it's fine for 4.3.
>

I examined the tables containing tablenames and fixed them too avoiding any 
conflicts, these tables are modified as well:

sys_action
sys_history
sys_lockedrecords
sys_log
sys_refindexes_res (which had varchar(100))

So attached patch change all fields containing tablenames to the same value 
of 64
There was no need to change any TCA because most of these tables doesn't 
have a TCA or doesn't use any limit.

vg Steffen 


begin 666 8399_v2.diff
M26YD97 at Z('0S;&EB+W-T9&1B+W1A8FQE<RYS<6P-"CT]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T-"BTM+2!T,VQI8B]S=&1D8B]T86)L97,N<W%L"2AR979I<VEO
M;B S-C0V*0T**RLK('0S;&EB+W-T9&1B+W1A8FQE<RYS<6P)*'=O<FMI;F<@
M8V]P>2D-"D! ("TR-C4L-R K,C8U+#<@0$ -"B @(&AI<W1O<GE?9&%T82!M
M961I=6UT97AT($Y/5"!.54Q,+ H@("!F:65L9&QI<W0@=&5X="!.3U0 at 3E5,
M3"P*(" @<F5C=6ED(&EN="@Q,2D at 1$5&055,5" G,"<@3D]4($Y53$PL"BT@
M('1A8FQE;F%M92!V87)C:&%R*#0P*2!$149!54Q4("<G($Y/5"!.54Q,+ HK
M("!T86)L96YA;64@=F%R8VAA<B at V-"D at 1$5&055,5" G)R!.3U0 at 3E5,3"P*
M(" @='-T86UP(&EN="@Q,2D at 1$5&055,5" G,"<@3D]4($Y53$PL"B @(&AI
M<W1O<GE?9FEL97,@;65D:75M=&5X="!.3U0 at 3E5,3"P*(" @<VYA<'-H;W0@
M=&EN>6EN="@T*2!$149!54Q4("<P)R!.3U0 at 3E5,3"P*0$ @+3(X,2PW("LR
M.#$L-R! 0 T*(" @=6ED(&EN="@Q,2D@=6YS:6=N960 at 3D]4($Y53$P at 875T
M;U]I;F-R96UE;G0L"B @('5S97)I9"!I;G0H,3$I('5N<VEG;F5D($1%1D%5
M3%0@)S G($Y/5"!.54Q,+ H@("!T<W1A;7 @:6YT*#$Q*2!U;G-I9VYE9"!$
M149!54Q4("<P)R!.3U0 at 3E5,3"P*+2 @<F5C;W)D7W1A8FQE('9A<F-H87(H
M-# I($1%1D%53%0@)R<@3D]4($Y53$PL"BL@(')E8V]R9%]T86)L92!V87)C
M:&%R*#8T*2!$149!54Q4("<G($Y/5"!.54Q,+ H@("!R96-O<F1?=6ED(&EN
M="@Q,2D at 1$5&055,5" G,"<@3D]4($Y53$PL"B @(')E8V]R9%]P:60@:6YT
M*#$Q*2!$149!54Q4("<P)R!.3U0 at 3E5,3"P*(" @=7-E<FYA;64@=F%R8VAA
M<B at R,"D at 1$5&055,5" G)R!.3U0 at 3E5,3"P*0$ @+3(Y-"PW("LR.30L-R! 
M0 T*(",*($-214%412!404),12!S>7-?<F5F:6YD97@@* H@("!H87-H('9A
M<F-H87(H,S(I($1%1D%53%0@)R<@3D]4($Y53$PL"BT@('1A8FQE;F%M92!V
M87)C:&%R*#0P*2!$149!54Q4("<G($Y/5"!.54Q,+ HK("!T86)L96YA;64@
M=F%R8VAA<B at V-"D at 1$5&055,5" G)R!.3U0 at 3E5,3"P*(" @<F5C=6ED(&EN
M="@Q,2D at 1$5&055,5" G,"<@3D]4($Y53$PL"B @(&9I96QD('9A<F-H87(H
M-# I($1%1D%53%0@)R<@3D]4($Y53$PL"B @(&9L97AP;VEN=&5R('9A<F-H
M87(H,C4U*2!$149!54Q4("<G($Y/5"!.54Q,+ I 0" M,S R+#<@*S,P,BPW
M($! #0H@("!S;V9T<F5F7VED('9A<F-H87(H-# I($1%1D%53%0@)R<@3D]4
M($Y53$PL"B @('-O<G1I;F<@:6YT*#$Q*2!$149!54Q4("<P)R!.3U0 at 3E5,
M3"P*(" @9&5L971E9"!T:6YY:6YT*#$I($1%1D%53%0@)S G($Y/5"!.54Q,
M+ HM("!R969?=&%B;&4@=F%R8VAA<B at T,"D at 1$5&055,5" G)R!.3U0 at 3E5,
M3"P**R @<F5F7W1A8FQE('9A<F-H87(H-C0I($1%1D%53%0@)R<@3D]4($Y5
M3$PL"B @(')E9E]U:60@:6YT*#$Q*2!$149!54Q4("<P)R!.3U0 at 3E5,3"P*
M(" @<F5F7W-T<FEN9R!V87)C:&%R*#(P,"D at 1$5&055,5" G)R!.3U0 at 3E5,
M3"P*( I 0" M,S,V+#<@*S,S-BPW($! #0H@(PH at 0U)%051%(%1!0DQ%('-Y
M<U]R969I;F1E>%]R97,@* H@("!R:60@:6YT*#$Q*2!$149!54Q4("<P)R!.
M3U0 at 3E5,3"P*+2 @=&%B;&5N86UE('9A<F-H87(H,3 P*2!$149!54Q4("<G
M($Y/5"!.54Q,+ HK("!T86)L96YA;64@=F%R8VAA<B at V-"D at 1$5&055,5" G
M)R!.3U0 at 3E5,3"P*(" @<F5C=6ED(&EN="@Q,2D at 1$5&055,5" G,"<@3D]4
M($Y53$PL"B @(%!224U!4ED at 2T59("AR:60I"B I.PI 0" M,S0Y+#<@*S,T
M.2PW($! #0H@("!U<V5R:60@:6YT*#$Q*2!U;G-I9VYE9"!$149!54Q4("<P
M)R!.3U0 at 3E5,3"P*(" @86-T:6]N('1I;GEI;G0H-"D@=6YS:6=N960 at 1$5&
M055,5" G,"<@3D]4($Y53$PL"B @(')E8W5I9"!I;G0H,3$I('5N<VEG;F5D
M($1%1D%53%0@)S G($Y/5"!.54Q,+ HM("!T86)L96YA;64@=F%R8VAA<B at T
M,"D at 1$5&055,5" G)R!.3U0 at 3E5,3"P**R @=&%B;&5N86UE('9A<F-H87(H
M-C0I($1%1D%53%0@)R<@3D]4($Y53$PL"B @(')E8W!I9"!I;G0H,3$I($1%
M1D%53%0@)S G($Y/5"!.54Q,+ H@("!E<G)O<B!T:6YY:6YT*#0I('5N<VEG
M;F5D($1%1D%53%0@)S G($Y/5"!.54Q,+ H@("!D971A:6QS('9A<F-H87(H
M,C4U*2!$149!54Q4("<G($Y/5"!.54Q,+ I);F1E>#H@='EP;S,O<WES97AT
M+W-Y<U]A8W1I;VXO97AT7W1A8FQE<RYS<6P-"CT]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T-"BTM+2!T>7!O,R]S>7-E>'0O<WES7V%C=&EO;B]E>'1?=&%B;&5S
M+G-Q; DH<F5V:7-I;VX@,S8T-BD-"BLK*R!T>7!O,R]S>7-E>'0O<WES7V%C
M=&EO;B]E>'1?=&%B;&5S+G-Q; DH=V]R:VEN9R!C;W!Y*0T*0$ @+3$Y+#<@
M*S$Y+#<@0$ -"B @(&AI9&1E;B!T:6YY:6YT*#0I($1%1D%53%0@)S G($Y/
M5"!.54Q,+ H@("!T,5]C<F5A=&5?=7-E<E]D:7(@=&EN>6EN="@T*2!$149!
M54Q4("<P)R!.3U0 at 3E5,3"P*(" @=#-?;&ES=%!I9"!I;G0H,3$I($1%1D%5
M3%0@)S G($Y/5"!.54Q,+ HM("!T,U]T86)L97,@=F%R8VAA<B at T,"D at 1$5&
M055,5" G)R!.3U0 at 3E5,3"P**R @=#-?=&%B;&5S('9A<F-H87(H-C0I($1%
M1D%53%0@)R<@3D]4($Y53$PL"B @('0T7W)E8V]R9'-4;T5D:70@=&5X="!.
A3U0 at 3E5,3"P*( H@("!04DE-05)9($M%62 H=6ED*2P*
`
end