手工执行存储过程，报1364错误

[akira82]

手工依次执行：
call rundim();
call runfact('2012-12-20 15:00:00','2012-12-20 15:59:59');
call runsum('2012-12-20');

在runsum处，报：

SQL 错误 [1364] [HY000]: Field 'segment_sk' doesn't have a default value

Field 'segment_sk' doesn't have a default value

我已经将mysql的sql_mode改为：NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[cobub]

Did you restart the mysql service?

[akira82]

Yep. MySql service has been restarted.

Now, I found some possible way to resolve it: alter the column "not null" TO "null". It seems OK, but I don't know the risk

[cobub]

Your method is OK. Another way is to set a default value for this "not null" column. Now we are checking all tables' structure to fix this problem.

[akira82]

by the way:

I have check out the sp"runsum()" , finding some thing hard to understand, please see below:

line 6 ~ 11:
insert into razor_fact_usinglog_daily
(product_sk,
date_sk,
session_id,
duration)
, not including the column segment_sk, and the column segment_sk is NOT-NULL, so I think this is the problem.

[cobub]

Yes, it depends on mysql is set STRICT_MODE or not. Now we are working to define table structure strictly.

[akira82]

Nice!

Really expect the updating!!!!!