Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0 RC1
    • Component/s: Core - SqlServer
    • Labels:
      None

      Description

      Numeric values does not have to be surrounded by quotes in SQL commands, doing so can generate errors when MS SQL Server parses a scientific format number (with quotes surrounding) to DECIMAL o NUMERIC column.

      1. MSSqlBuilder.java
        11 kB
        JuanFran Adame Lorite

        Activity

        JuanFran Adame Lorite created issue -
        Hide
        JuanFran Adame Lorite added a comment -

        getValueAsString method in MSSQLBuilder overrides the SQLBuilder behaviour for REAL, DOUBLE, FLOAT, DECIMAL and NUMERIC types. (It does too for DATE, TIME and TIMESTAMP due to other corrections made before.)

        Show
        JuanFran Adame Lorite added a comment - getValueAsString method in MSSQLBuilder overrides the SQLBuilder behaviour for REAL, DOUBLE, FLOAT, DECIMAL and NUMERIC types. (It does too for DATE, TIME and TIMESTAMP due to other corrections made before.)
        JuanFran Adame Lorite made changes -
        Field Original Value New Value
        Attachment MSSqlBuilder.java [ 12320457 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.0 [ 12310891 ]
        Thomas Dudziak made changes -
        Component/s Core - SqlServer [ 12311219 ]
        Hide
        Thomas Dudziak added a comment -

        Is applied, though I used the CAST function instead for the dates/times because this should also work with other JDBC drivers (as the driver does not evaluate the expression).

        Show
        Thomas Dudziak added a comment - Is applied, though I used the CAST function instead for the dates/times because this should also work with other JDBC drivers (as the driver does not evaluate the expression).
        Thomas Dudziak made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.0 [ 12310891 ]
        Fix Version/s 1.0 RC1 [ 12312482 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        342d 2h 38m 1 Thomas Dudziak 11/Oct/06 20:52

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            JuanFran Adame Lorite
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development