[Firebird-devel] [FB-Tracker] Created: (CORE-2218) Unique indexes do not recognise trailing space

[Roddi W. (JIRA) <tr...@fi...>]

Unique indexes do not recognise trailing space
----------------------------------------------

                 Key: CORE-2218
                 URL: http://tracker.firebirdsql.org/browse/CORE-2218
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.1.1
         Environment: Win XP SP2
            Reporter: Roddi Walker


I have the following table:

CREATE TABLE FOO (
    ID  VARCHAR(20),
    VAL VARCHAR(20)
);
CREATE UNIQUE INDEX I_FOO_UNQ ON FOO (ID, VAL);

I then insert a single record with no problem:
insert into foo values ('id1', 'bar');

I then insert a second record with a different VAL field (there is a space after "bar"):
insert into foo values ('id1', 'bar ');

This should be OK but I get this error (in IBExpert):
Invalid insert or update value(s): object columns are
constrained - no 2 table rows can have duplicate column values.
attempt to store duplicate value (visible to active transactions) in unique index "I_FOO_UNQ".







-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira