Bugs item #2075268, was opened at 2008-08-26 07:38
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075268&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: MonetDB5 5.6
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Jane Chen (cjnn)
Assigned to: Niels Nes (nielsnes)
Summary: About CHAR
Initial Comment:
OS: RedHat Linux AS 4
GCC: 3.4.6
1.setup:
CREATE TABLE TMP (T1 CHAR (10));
INSERT INTO TMP (T1)
VALUES ( 'xxxx');
2.execute:
SELECT * FROM TMP
WHERE T1 = 'xxxx ';
3.result:
0 row selected.
4.question:
The result should be 1 row selected.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-09-09 12:59
Message:
we consider this a feature ;-). The old fixed size char semantics stem from
the times where fixed sizes charaters strings really were stored in a fixed
length array. With current unicode encodings this can hardly be true. The
filling with spaces was more a result of the old storage structure then
logical semantics. We think our current approach (ie not adding spaces) is
much more logical semantics. We keep wat the user inserted.
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2008-08-26 08:10
Message:
Logged In: YES
user_id=572415
Originator: NO
See also
[ 2075085 ] The char and varchar compared wrong
http://sourceforge.net/tracker/index.php?func=detail&aid=2075085&group_id=56967&atid=482468
As Fabian already commented there, (trailing) spaces do matter unless
explicitly trimmed-off.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075268&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
