Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-768

Criteria Builder may insert crieria inside object names if user not careful

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • 7.4
    • 7.1.1
    • Transformations
    • None

      I start with:
      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT * FROM PartsSource.PARTS;
      END

      At this point the Criteria Builder (and Expression Builder) button is disabled. So I click in the SELECT clause to enable the button. Let's say I click between the P and the A of .PARTS. The button enables, I craft my WHERE clause, click OK and wind up with:

      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT * FROM PartsSource.PA WHERE PartsSource.PARTS.PART_COLOR = PartsView.getPartsByColor.colorInRTS;
      END

      Regardless of where in the SELECT I click, the WHERE clause should be inserted in a syntactically correct location.

            dflorian@redhat.com Daniel Florian (Inactive)
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: