Compatibility issues and known problems

When functions or table functions are written in lower cases - no match found error can occur: Example for no match found select aux.asissuekey(i.ID) ID1, i.summary from issues i limit 10 As a workaround - write the function name in upper cases: Workaround select aux.ASISSUEKEY(i.ID) ID1, i.summary from issues i limit 10

If you do a search with a join of a JQL search and a core.issues table or two JQL searches and try to join them (and they have overlapping column names) it will return the first column of that only. For example: Same name, same values presented select jql.ID, CI.ID from table(AUX.JQL('ID,issuekey,', 'type = bug')) jql  join core.issuelinks CIL on CIL.destination = jql.ID join core.issues CI on CI.ID = CIL.source jql.ID and CI.ID will return the same column where CI.ID should be the source ID. As a workaround use aliasing: Same name, same values presented select jql.ID as jqlid, CI.ID from table(AUX.JQL('ID,issuekey,', 'type = bug')) jql  join core.issuelinks CIL on CIL.destination = jql.ID join core.issues CI on CI.ID = CIL.source

Smart QL app does not support H2 databases with driver bundled in Jira. You may want to update the driver in your Jira instance with version at least 1.4.197. See http://www.h2database.com/html/download.html