Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-15717

Fix proto schema and cache configurtion in SQL query store configuration section

    XMLWordPrintable

Description

    Attempt to create cache distributed cache from SQL query store configuration section will fail with: 

    CacheConfigurationException: ISPN008053: Delete and select queries do not have matching arguments. Delete was [name, name] and select was [name]

    Using SQL bellow in select-single instead of the existing one seems to fix the issue.

    SELECT t1.name, t1.picture, t1.sex, t1.birthdate, t1.accepted_tos, t2.street, t2.city, t2.zip FROM Person t1 JOIN Address t2 WHERE t1.name = :name AND t2.name = :name

    Issues with proto schema examples:

    • The section is showing two proto schemas where first (person) refers the second one. Attempt to create the schemas in this order will fail.
    • Address proto schema is missing ; at the end of package line
    • Person proto schema needs to import ${address_proto_file_name} in order so it can be successfully created.

    Attachments

      Issue Links

        is documented by

        Bug - A problem that impairs or prevents the functions of the product. JDG-6686 [DOCS] Proto schemas in SQL query store configuration section are broken

        • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
        • Verified

        Bug - A problem that impairs or prevents the functions of the product. JDG-6687 [DOCS] SQL query store configuration section uses invalid cache configuration

        • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
        • Verified

        Bug - A problem that impairs or prevents the functions of the product. JDG-6865 [Doc]: ISPN-15717 Fix proto schema and cache configurtion in SQL query store configuration section

        • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
        • Closed

        Activity

          People

            amehenda@redhat.com Ashwin Mehendale
            amehenda@redhat.com Ashwin Mehendale
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: