Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-8006803

Qbe does not work for number columns with trailing zero's

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not an Issue
    • Icon: P2 P2
    • 7-pool
    • 7u11
    • core-libs
    • None

         
        SHORT SUMMARY:
        This bug is being logged as requested by Oracle JDeveloper group.
        Inconsistent QBE behavior for number columns with trailing zero's.

        Take these examples.

        1. Amount = 100.00

           When user enters 100 (or) 100. [just the decimal point], record is queried
           in the table.

           It does not work when user enters 100.0 (or) 100.00

        2. Amount = 1062.50

           When user enters 1062.5, record is queried.

           It does not work for all other cases, 1062 (or) 1062. (or) 1062.50

        Issue:
        This is the pattern I see. When there are trailing zero's in the decimal
        place, QBE does not work when user enters the exact value.

        INDICATORS:
        COUNTER INDICATORS:
        TRIGGERS:
        KNOWN WORKAROUND:
        As a workaround, user has to enter all numbers until the non-zero value.
        PRESENT SINCE:
        HOW TO VERIFY:
        NOTES FOR SE:
        REGRESSION:
         

              dmeetry Dmeetry Degrave (Inactive)
              webbuggrp Webbug Group
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: