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