Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.10.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      DERBY-118 started out as a request to allow date-time functions values to be assigned to character columns. This is not standard SQL, but it turns out the Derby allows such conversions at DML time, e.g. in an INSERT statement. Investigating this we found that there a re several instances in which Derby is more restrictive in type conversion at DDL time that at DML time. These instances can be classifies as

      a) legacy restrictions that are DB2 specific, but would be legal SQL if lifted
      b) restrictions that are not legal SQL per the standard

      This subtask addresses a). The original request falls into category b) and we decided not to fix those since this would allow users to write non-standard SQL, notwithstanding that fact the Derby also extends on the standard at DML time. Ideally, we would restrict those cases to follow the standard as well, but that woudl cause compatibility concerns.

      Furthermore, a related issue is that type checks at DDL time, e.g. that a character literal is not too long for its column, are performed at DML time. This is not as per the standard, and we track an improvement in this area as

      c) Catch type mismatch of DEFAULT values at DDL time (DERBY-5825)

      1. derby-5829.diff
        8 kB
        Dag H. Wanvik
      2. derby-5829.status
        0.7 kB
        Dag H. Wanvik

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        3d 16h 4m 1 Dag H. Wanvik 26/Jun/12 15:08
        Resolved Resolved Closed Closed
        20s 1 Dag H. Wanvik 26/Jun/12 15:09
        Gavin made changes -
        Workflow jira [ 12708361 ] Default workflow, editable Closed status [ 12797055 ]
        Dag H. Wanvik made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Dag H. Wanvik made changes -
        Assignee Dag H. Wanvik [ dagw ]
        Dag H. Wanvik made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info Patch Available [ 10102 ]
        Fix Version/s 10.10.0.0 [ 12321550 ]
        Resolution Fixed [ 1 ]
        Hide
        Dag H. Wanvik added a comment -

        Committed as svn 1354024.

        Show
        Dag H. Wanvik added a comment - Committed as svn 1354024.
        Dag H. Wanvik made changes -
        Summary Lift DB2 restrictions on the DEFAULT clause Lift DB2 restriction on the DEFAULT clause
        Dag H. Wanvik made changes -
        Issue & fix info Patch Available [ 10102 ]
        Dag H. Wanvik made changes -
        Field Original Value New Value
        Attachment derby-5829.diff [ 12533131 ]
        Attachment derby-5829.status [ 12533132 ]
        Hide
        Dag H. Wanvik added a comment -

        Attaching a patch originally first attached to DERBY-118 as derby-118-limited-even-more-b, here called derby-5829, for addressing a).

        It removes the restriction on VARCHAR defaults length to maximally 254 characters.

        Show
        Dag H. Wanvik added a comment - Attaching a patch originally first attached to DERBY-118 as derby-118-limited-even-more-b, here called derby-5829, for addressing a). It removes the restriction on VARCHAR defaults length to maximally 254 characters.
        Dag H. Wanvik created issue -

          People

          • Assignee:
            Dag H. Wanvik
            Reporter:
            Dag H. Wanvik
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development