Derby
  1. Derby
  2. DERBY-34

Setting default value for a char(1) for bit data column does not work

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.0.2.1
    • Component/s: SQL
    • Labels:
      None

      Description

      create table t2 (i1 char(1) for bit data default x'02');

      throws the following error:
      ERROR 42894: DEFAULT value or IDENTITY attribute value is not valid for column 'I1'.

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        48d 30m 1 Satheesh Bandaram 24/Nov/04 00:34
        Closed Closed Reopened Reopened
        444d 16h 53m 1 Sunitha Kambhampati 11/Apr/06 00:36
        Reopened Reopened Resolved Resolved
        1m 17s 1 Sunitha Kambhampati 11/Apr/06 00:37
        Resolved Resolved Closed Closed
        58d 7h 8m 2 Sunitha Kambhampati 11/Apr/06 00:38
        Gavin made changes -
        Workflow jira [ 37662 ] Default workflow, editable Closed status [ 12797279 ]
        Sunitha Kambhampati made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Sunitha Kambhampati made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Fix Version/s 10.0.2.1 [ 10991 ]
        Resolution Fixed [ 1 ]
        Hide
        Sunitha Kambhampati added a comment -
        Show
        Sunitha Kambhampati added a comment - Updating the fixin. http://svn.apache.org/viewcvs.cgi?view=rev&rev=53974
        Sunitha Kambhampati made changes -
        Status Closed [ 6 ] Reopened [ 4 ]
        Resolution Fixed [ 1 ]
        Assignee Satheesh Bandaram [ bandaram ]
        Sunitha Kambhampati made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Hide
        Sunitha Kambhampati added a comment -

        I have tested it and it works ok; so closing the bug.

        Show
        Sunitha Kambhampati added a comment - I have tested it and it works ok; so closing the bug.
        Satheesh Bandaram made changes -
        Field Original Value New Value
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Hide
        Satheesh Bandaram added a comment -

        Submitted fix for satheesh@Sourcery.org.

        SVN LOG: 53974

        Show
        Satheesh Bandaram added a comment - Submitted fix for satheesh@Sourcery.org. SVN LOG: 53974
        Sunitha Kambhampati created issue -

          People

          • Assignee:
            Satheesh Bandaram
            Reporter:
            Sunitha Kambhampati
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development