This is a FB 1.5.6 bug. It does not appear in our testing for the move
to FB 2.5.2.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Friday, November 09, 2012 4:22 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Unique constraint causes insert to fail with
'conversion error from string " "'

I have a table T (PBM_CLAIM BIGINT, CLAIM_SRC SMALLINT, ...) with the
unique constraint:

ALTER TABLE RELAY_CLAIM ADD CONSTRAINT U_RELAY_CLAIM_SRC UNIQUE
(PBM_CLAIM,CLAIM_SRC);

If I try to insert a row with (NULL, NULL, ...) when this constraint
exists, I get the error

ISC ERROR CODE:335544334
ISC ERROR MESSAGE:
conversion error from string " "

I drop the constraint, and the insert works.
I'm at a loss to understand what's going on, as adding the constraint to
an existing table works and there are thousands of rows where the tuple
is (NULL,NULL).
A simple test table with only a few test rows, these two columns, and
the unique constraint works fine.

Does anyone have any ideas or experience anything like this?


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links