Page Comparison

...

Expand

title	No match found for functions and table functions

When functions or table functions are written in lower cases - no match found error can occur:

Code Block

language	sql
title	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:

Code Block

language	sql
title	Workaround

select aux.ASISSUEKEY(i.ID) ID1, i.summary
from issues i
limit 10

Expand

title	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:

Code Block

language	sql
title	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:

Code Block

language	sql
title	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

Versions Compared

Old Version 5

New Version 6

Key