Compatibility issues and known problems

Owned by Piotr Bojko
Last updated: Feb 06, 2019
1 min read
 No match found for functions and table functions

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
 Same named columns return only one set of values

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
 H2 driver bundled in JIRA

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