We've just started again a few hours ago (because SR5 crashed and we couldn't resurrect it) with the --nightly=stable build as downloaded today 2007-01-21 and we ended up with a different problem. Using "" to represent the empty string doesn't work because MonetDB thinks "" represents NULL and that is not allowed by column constraint. The new workaround is to explicitly rpad the strings to fill the CHAR(2) or CHAR(16) in addition to quoting. e.g. instead of for a CHAR(2) value of all spaces "" we use " ". On Jan 21, 2008 1:24 PM, Bob Ippolito <bob@redivi.com> wrote:
We've had problems with MonetDB SR5 using COPY INTO with data that may be the empty string or all spaces. We've been able to work around this by surrounding all of the values in our copy files with "quotes" (I read tablet.c to try and diagnose the issue and found that as a workaround). I'm not familiar enough with the source and build process yet to submit a patch.
We are using '\t' as the separator and the fields that we've had problem with are CHAR(2) or CHAR(16) if that matters.
-bob