Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1633

Regression: The fields of views are not being calculated properly since 10.1.2.4

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.3.1
    • Fix Version/s: 10.1.3.2, 10.2.1.6, 10.3.1.4
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      2.8 GHZ dual PIV on Windows XP SP2, 2 GB memory
    • Urgency:
      Blocker
    • Issue & fix info:
      Release Note Needed
    • Bug behavior facts:
      Regression

      Description

      Database can be assumed to be same as in Derby - 1205 Jira issue

      SELECT PORT1.PORT_ID FROM T_RES_PORT PORT1, T_VIEW_ENTITY2PORT ENTITY2PORT WHERE ENTITY2PORT.PORT_ID = PORT1.PORT_ID

      This works fine in 10.1.2.1 but fails thereafter complaining that Comparison between INTEGER and CHAR is not supported

      for some reason, it thinks one of the PORT_ID columns is a character, when in reality both are integers.

      SELECT DISTINCT
      ZONE.ZONE_ID ZONE_ID,
      PORT2ZONE.ZONE_MEMBER_ID
      FROM
      T_RES_ZONE ZONE left outer join T_VIEW_PORT2ZONE PORT2ZONE on
      ZONE.ZONE_ID = PORT2ZONE.ZONE_ID , T_RES_FABRIC FABRIC

      In this query, it is complaining that one of the columns is a VARCHAR and cannot be compared to INTEGER, when clearly this is not the case...

      Same issue

        Attachments

        1. DERBY-1633_v3.html
          67 kB
          A B
        2. DERBY-1633_v2.html
          45 kB
          A B
        3. DERBY-1633_v1.html
          45 kB
          A B
        4. d1633_v3_tests.patch
          143 kB
          A B
        5. d1633_v3_code.patch
          46 kB
          A B
        6. d1633_v2.patch
          63 kB
          A B
        7. d1633_v1_reviewOnly.patch
          24 kB
          A B
        8. d1633_repro.sql
          1 kB
          A B
        9. d1633_10_1_merge.patch
          189 kB
          A B

          Activity

            People

            • Assignee:
              army A B
              Reporter:
              psarkar Prasenjit Sarkar
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: