[CM][BUG]When edit column, default and not null cannot modify together.

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: CM8.4.0.3
  • Fix Version/s: CM8.4.0.3
  • Component/s: CUBRID Manager
  • Labels:
    None
  • Environment:

    OS windows xp
    CM 8.4.0.3004

Description

1 Choose one table, right click, click edit table
2 Add one column aa. Data type =DATE, default value=2011-01-01, choose not null. click ok. save the table.
3 Edit table again.remove the option of not null
4 Modify the column, it will pop
"ALTER TABLE "aa" ADD COLUMN "t" character(1) DEFAULT '3' AFTER date;
Error code: -493
Syntax: syntax error, unexpected Date "

  1. File
    CODE_REVIEW.creview
    18/Oct/11 4:21 AM
    47 kB
    庞启仁
  1. Cancelnotnull.PNG
    45 kB
    24/Oct/11 10:02 PM
  2. datetime.PNG
    57 kB
    28/Oct/11 4:33 AM
  3. null.png
    1.47 MB
    10/Oct/11 10:04 PM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
庞启仁 added a comment -

Add fixed code review file

Show
庞启仁 added a comment - Add fixed code review file
Hide
Permalink
庞启仁 added a comment -

Fix it in version CUBRID Manager 8.4.1.0006 and CUBRID Query Browser 1.2.2.0006

Test scope:
need test the prior version from 8.2.2 to 8.4.1

Show
庞启仁 added a comment - Fix it in version CUBRID Manager 8.4.1.0006 and CUBRID Query Browser 1.2.2.0006 Test scope: need test the prior version from 8.2.2 to 8.4.1
Hide
Permalink
高艳铭 added a comment -

When cancel not null,it will pop error.

Steps:
1 add two column, a char(1) defaut=f
b date default=2011-03-04
2 click ok.

3 click edit, choose the not null of the two column.

4 click ok, it will pop error.Please see the attachment.

Show
高艳铭 added a comment - When cancel not null,it will pop error. Steps: 1 add two column, a char(1) defaut=f b date default=2011-03-04 2 click ok. 3 click edit, choose the not null of the two column. 4 click ok, it will pop error.Please see the attachment.
Hide
Permalink
庞启仁 added a comment -

This is not bug

Show
庞启仁 added a comment - This is not bug
Hide
Permalink
高艳铭 added a comment -

Add one column t DATATIME default='2011-03-04'
Then edit column, click not null, it will be error. pls see the attachment.

Show
高艳铭 added a comment - Add one column t DATATIME default='2011-03-04' Then edit column, click not null, it will be error. pls see the attachment.
Hide
Permalink
庞启仁 added a comment -

Fix it in version 8.4.1.0011

Show
庞启仁 added a comment - Fix it in version 8.4.1.0011
Hide
Permalink
高艳铭 added a comment -

Fixed in version CM8.4.1.0012

But the datetime, datestamp data type has problem.
http://www.jira.cubrid.org/browse/TOOLS-259

Show
高艳铭 added a comment - Fixed in version CM8.4.1.0012 But the datetime, datestamp data type has problem. http://www.jira.cubrid.org/browse/TOOLS-259

People

  • Assignee:
    高艳铭
    Reporter:
    高艳铭
Vote (0)
Watch (0)

Dates

  • Due:
    Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
0m
Original Estimate - 0 minutes
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
3h
Time Spent - 3 hours