Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CM8.4.0.3
-
Fix Version/s: CM8.4.1.201203
-
Component/s: CUBRID Manager
-
Labels:
-
Environment:
CM8.4.1.0012
-
Fix Build Number:2005
Description
1 Click edit table
2 add one column
3 Choose timestamp, in default value, input 2011-02-01, will see "Invalid valid for the TIMESTAMP data type, valid TIMESTAMP values look like:
"2009/02/23 AM 09:53:08", "2009-02-23 PM 09:53:09", "2009/02/23 09:53:10",
"2009-02-23 09:53:11", "09:53:06 AM 02/23/2009", "09:53:07 02/23/2009""
4 input "2009-02-23 PM 09:53:09"
Actual result
The warning is existed.
Additional result:
When add datatime input default value"2009-02-23 PM 09:53:09",but click ok,it will pop error.
Can't reproduce this problem on
Version:2008 R4.1
Build id:8.4.1.0012
I had tried two ways :
1. create a new table use this dialog and add a new column with timestamp type ,the default value is same as you mentioned.
2. alter a exists table to add a new column with timestamp type , and it also works.
I followed all your steps.
By the way , I found another issues in this dialog , the locale problem.
if the locale is Chinese , there will be a error message to tell you the value is invalid even if you type the example date into the default value field.
for example , if you try "2009/02/23 AM 09:53:23" , it is invalid in Chinese locale such as zh_CN , if you change to "2009/02/23 上午 09:53:23", it pass. This might be happen in all the place which use the Date.