Re: [MonetDB-users] (some) Numeric columns don't allow NULL?

On Nov 16, 2007 1:33 AM, Niels Nes wrote:

On Thu, Nov 15, 2007 at 09:36:38PM -0700, m h wrote:

...

On Nov 15, 2007 4:58 PM, m h wrote:

...

Confused.....

Sorry, one more message, I should add that this is using the command line client, not python.

Matt

Could you include the statements used (ie both create table and insert statements)? Maybe also report this possible bug via the bugtracker at sourceforge? Many thanks.

Here's the bug: http://sourceforge.net/tracker/index.php?func=detail&aid=1833286&group_id=56967&atid=482468 Here's the SQL to recreate it: DROP TABLE decimal_null; CREATE TABLE decimal_null ( promoid NUMERIC(8, 2) ); ' this will fail INSERT into "decimal_null" values (NULL); ' this will work INSERT into "decimal_null" values (2.3); 'now the one that failed will work INSERT into "decimal_null" values (NULL);