Page 1 of 1

[solved] PostgreSQL - Char field filled space at end

Posted: 18.10.2013, 00:06
by fhaut
@EgonHugeist

trying to convert my aplication from 7.0.6 to 7.1.2 in thread ( http://zeoslib.sourceforge.net/viewtopi ... 942#p19285 ) i decide to do a test with 7.2 and i got the issue with postgresql 8.4 with Delphi 2009 with CHAR field.

Sample definition

Code: Select all

table s010usu.corpan = CHAR(20)
select corpan from s010usu
in Zeos 7.0.6 and 7.1.2

Code: Select all

Value returned = 'clWhite'  
in Zeos 7.2

Code: Select all

Value returned = 'clWhite             '
there is space char filled at the end

Re: PostgreSQL - Char field filled space at end

Posted: 18.10.2013, 07:40
by EgonHugeist
Fixed. Patch done R2844 \testing-7.2 (SVN)

I'm affraid there is again NO test to see behavior changes! I'll write one tonight.

Welcome to the high performance testers group :D

Re: [solved] PostgreSQL - Char field filled space at end

Posted: 18.10.2013, 19:53
by fhaut
@EgonHugeist

well done!

a testcase will be a good idea, a long time ago when i move from zeos 6.6 to 7.0 was the same issue.

Re: [solved] PostgreSQL - Char field filled space at end

Posted: 20.10.2013, 18:21
by EgonHugeist
Testcase "Test_TrailingSpaced" added. This stub doesn't happen again :)

R2855 \testing-7.2