Looks like there is a huge disparity between Jira 5 and Jira 6 database schemas.
When I run the below statement on Jira 5.2.11, I get the desired results, no null values in pkey column. However when I run the same query on a clone instance running Jira 6.3.6, the values in this column are null. Where the table relationships get switched around? What do I have to do to have the same behavior or results in jira 5.
*********************
SELECT
A.pkey
FROM
jiraissue A,
nodeassociation C
WHERE
A.ID=C.SOURCE_NODE_ID;
*********************
Backk at 6.1 time, the pkey column was made obsolete. It was replaced by issuenum
Depending on what you need, you can join jiraissue.PROJECT field with the PROJECT_KEY.PROJECT_ID to get the PROJECT_KEY field. You can concatenate the PROJECT_KEY and issuenum to recreate the pkey field.
I don't really understand what the question is.
The structure of the data has changed because it needs to for whatever reason. I understand that this has broken a query you are running, but I do not see why it's a problem, because you don't explain what you are trying to get out of the query. "What do I have to do to have the same behaviour" can only be answered by "understand the data properly and adjust your query"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.