Hi,
I am encountering something very strange. (Windows - NovSP1 from CVS)
On some machines I encountered crashes in Monet when doing a copy into on tables with a float column. After trying to investigate, I narrowed it down to this:
Run: 1. CREATE TABLE test (f1 int, f2 float); 2. COPY INTO test from 'filename.txt' using delimiters ',','\n','"' null as '';
the text file contains: 1,1 2,2
This sequence exactly caused a server crash (without any message) on some machines, while on others it didn't. The machines it happened on were: 1. 32 bit XP with 3 GB RAM. 2. 32 bit Vista with 4 GB RAM.
In both cases, changing the column type from float to real worked.
Could it be that float, being a 64 bit floating point, might cause crashes on 32 bit machines?
Is there anything I can to help you get a clearer picture of this?
Thanks.