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

        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.)
        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).

          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