[solved] PostgreSQL - Char field filled space at end

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Post Reply
fhaut
Junior Boarder
Junior Boarder
Posts: 29
Joined: 10.04.2009, 15:55

[solved] PostgreSQL - Char field filled space at end

Post 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
Last edited by fhaut on 18.10.2013, 19:49, edited 2 times in total.
Image
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: PostgreSQL - Char field filled space at end

Post 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
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
fhaut
Junior Boarder
Junior Boarder
Posts: 29
Joined: 10.04.2009, 15:55

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

Post 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.
Image
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

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

Post by EgonHugeist »

Testcase "Test_TrailingSpaced" added. This stub doesn't happen again :)

R2855 \testing-7.2
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Post Reply