Compatibility issues and known problems

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