column with default char not defaulting when inserting a record

From: Baldwin <ibaldwinjr_at_gmail.com>
Date: Fri, 03 Aug 2007 20:16:03 -0000
Message-ID: <1186172163.286969.83050@r34g2000hsd.googlegroups.com>

Hi,

I got this very interesting issue. I configured a column of a table defaulted to 'A'. Whenever I insert a record into the table without specifying a value in that column, the column is not defaulted to 'A'. I am able to default other char column without any problem. But for this one column, for some reason, it is not defaulting to 'A'. My table got 34 columns. There are foreign keys but not set to the column with the issue. I got a lot of triggers for this table, but i tried disabling them and inserted a record and still didn't work.

Here is the example. the table and column names are not the actual names.

Here are my sql statements.

insert into mytable(id, name)
values(33, 'testme')

select id, name, status
from mytable
where name = 'testme'

Here is the table definition.

create table mytable
(
  id NUMBER(10) not null,
  name VARCHAR2(60) not null,
  status CHAR(1) default 'A'
)

Any help is greatly appreciated. thanks
Baldwin Received on Fri Aug 03 2007 - 15:16:03 CDT