MDEV-5012
Server crashes in Item_ref::real_item on EXPLAIN with select subqueries or views, constant table, derived_merge+derived_with_keys- MDEV-5011
ERROR Plugin 'MEMORY' has ref_count=1 after shutdown for SJM queries. - MDEV-4978
Server cursor is broken with blobs in the select list, ORDER BY does not work - MDEV-4971
Server crashes in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field from Item_equal::contains - MDEV-4967
Host field is empty in the audit log. - MDEV-4962
Wrong result (missing rows) on LEFT JOINs and <non-nullable datetime field> IS NULL - MDEV-4959
Join with const table produces incorrect query result - MDEV-4952
Assertion `((Item_cond *) cond)->functype() == ((Item_cond *) new_item)->functype()' fails on a query with LEFT JOIN and IS NULL conditions - MDEV-4951
drop user leaves privileges - MDEV-4944
Server crashes in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field from get_full_func_mm_tree - MDEV-4942
Assertion `((Item_cond *) cond)->functype() == ((Item_cond *) new_item)->functype()' fails on a query with LEFT JOIN and <date> IS NULL - MDEV-4926
[PATCH] Remove division-using-subtraction implementation from semi-sync plugin - MDEV-4923
Incorrect merge on XtraDB os0file.c - MDEV-4915
Valgrind warnings (Conditional jump or move depends on uninitialised value) in my_strtoll10 
MDEV-4909
5.5.33 merge- MDEV-4908
Assertion `((Item_cond *) cond)->functype() == ((Item_cond *) new_item)->functype()' fails on a query with IN and equal conditions, AND/OR, materialization+semijoin - MDEV-4902
sql_yacc.yy incompatible with bison 3 - MDEV-4895
Valgrind warnings (Conditional jump or move depends on uninitialised value) in Field_datetime::get_date on GREATEST(..) IS NULL - MDEV-4889
Race condition on shutdown when threadpool is used - MDEV-4870
Wrong values of CASE, COALESCE, IFNULL on a combination of different temporal types - MDEV-4869
Wrong result of MAKETIME(0, 0, -0.1) - MDEV-4863
COALESCE(time_or_datetime) returns wrong results in numeric context - MDEV-4861
TIME/DATETIME arithmetics does not preserve INTERVAL precision - MDEV-4852
Too inefficient query plan for more complex JOIN/SUBQUERY conditions - MDEV-4849
Out of memory error and valgrind warnings on COLUMN_ADD - MDEV-4843
Wrong data type for TIMESTAMP('2001-01-01','10:10:10') - MDEV-4840
Wrong result (missing rows) on LEFT JOIN with InnoDB tables - MDEV-4836
Wrong result on <not null date column> IS NULL (old documented hack stopped working) - MDEV-4818
Extend CREATE TEMPORARY TABLES privilege to allow temp table operations - MDEV-4817
Optimizer fails to optimize expression of the form 'FOO' IS NULL - MDEV-4815
Calling mysql_library_init twice in same process SEGFAULTs - MDEV-4812
Valgrind warnings (Invalid write) in dynamic_column_update_many on COLUMN_ADD - MDEV-4811
Assertion `offset < 0x1f' fails in type_and_offset_store on COLUMN_ADD - MDEV-4804
Date comparing false result - MDEV-4724
Some temporal functions do not preserve microseconds - MDEV-4687
impossible where with < operation, but =-5 return one row, same problem occur with UPDATE/SELECT/DELETE - MDEV-4653
Wrong result for CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') - MDEV-4652
Wrong result for CONCAT(GREATEST(TIME('00:00:01'),TIME('00:00:00'))) - MDEV-4570
[PATCH] Sys_query_cache_limit initialization depends on initialization in other source files - MDEV-4512
Valgrind warnings in my_long10_to_str_8bit on INTERVAL and DATE_ADD with incorrect types - MDEV-4507
Include TokuDB storage engine - MDEV-4420
Assertion `item->type() == Item::FIELD_ITEM' fails with outer_join_with_cache+join_cache_hashed, join_cache_level > 2 - MDEV-4418
Valgrind warnings or server crash in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field, from Item_equal::contains - MDEV-4355
Wrong result (extra row) with AND and OR conditions - MDEV-4165
[PATCH] RFE: make tmpdir a build-time configurable option - MDEV-3922
UNIX_TIMESTAMP() reports decimal when date specified as string
[{"value":"affectedVersion","displayName":"affectedVersion","auto":"true","orderable":"true","searchable":"true","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["changed","was","was not in","in","is not","was in","!=","is","=","not in","was not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"\"Business Value\"","displayName":"Business Value - cf[10106]","orderable":"true","searchable":"true","cfid":"cf[10106]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"comment","displayName":"comment","searchable":"true","operators":["~","!~"],"types":["java.lang.String"]},{"value":"component","displayName":"component","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"created","displayName":"created","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"createdDate","displayName":"createdDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"creator","displayName":"creator","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Development","displayName":"Development - cf[11700]","orderable":"true","searchable":"true","cfid":"cf[11700]","operators":[">",">=","=","<","<=","in","!~","not in","is","is not"],"types":["java.lang.Number","java.lang.String"]},{"value":"due","displayName":"due","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"duedate","displayName":"duedate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic/Theme\"","displayName":"Epic/Theme - cf[10103]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10103]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Colour\"","displayName":"Epic Colour - cf[10603]","orderable":"true","searchable":"true","cfid":"cf[10603]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10600]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10600]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10601]","orderable":"true","searchable":"true","cfid":"cf[10601]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10602]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10602]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":[">","was","was not in","in","is not","!~","is","~","=","not in","<=",">=","changed","was in","!=","was not","<"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"Flagged","displayName":"Flagged - cf[10102]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10102]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"gitBranch","displayName":"gitBranch - cf[12400]","orderable":"true","searchable":"true","cfid":"cf[12400]","operators":["=","in"],"types":["java.lang.String"]},{"value":"gitCommitsReferenced","displayName":"gitCommitsReferenced - cf[12401]","orderable":"true","searchable":"true","cfid":"cf[12401]","operators":["is","is not"],"types":["java.lang.String"]},{"value":"\"Global Rank\"","displayName":"Global Rank - cf[10000]","orderable":"true","searchable":"true","cfid":"cf[10000]","operators":["is","is not"],"types":["java.lang.Number"]},{"value":"id","displayName":"id","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue","displayName":"issue","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue.property","displayName":"issue.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.Number","java.lang.String","java.util.Date"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLinkType","displayName":"issueLinkType","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"value":"issuetype","displayName":"issuetype","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"jqltField","displayName":"jqltField - cf[11300]","orderable":"true","searchable":"true","cfid":"cf[11300]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"key","displayName":"key","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"labels","displayName":"labels","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"lastViewed","displayName":"lastViewed","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"level","displayName":"level","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.security.IssueSecurityLevel"]},{"value":"originalEstimate","displayName":"originalEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"\"Original story points\"","displayName":"Original story points - cf[11602]","orderable":"true","searchable":"true","cfid":"cf[11602]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"Other-Reporter","displayName":"Other-Reporter - cf[11402]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11402]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Parent Link\"","displayName":"Parent Link - cf[11301]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11301]","operators":["=","in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"PM Planning 2\"","displayName":"PM Planning 2 - cf[12500]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12500]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"PM Planning\"","displayName":"PM Planning - cf[11404]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11404]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":[">","was","was not in","in","is not","is","=","not in","<=",">=","changed","was in","!=","was not","<"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"\"Productboard URL\"","displayName":"Productboard URL - cf[12403]","orderable":"true","cfid":"cf[12403]","operators":[],"types":["java.lang.Object"]},{"value":"progress","displayName":"progress","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"\"Python Version\"","displayName":"Python Version - cf[12404]","orderable":"true","searchable":"true","cfid":"cf[12404]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Rank (Obsolete)\"","displayName":"Rank (Obsolete) - cf[10300]","orderable":"true","searchable":"true","cfid":"cf[10300]","operators":["is","is not"],"types":["java.lang.Number"]},{"value":"Rank","displayName":"Rank - cf[10700]","orderable":"true","searchable":"true","cfid":"cf[10700]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"\"Release Version History\"","displayName":"Release Version History - cf[10109]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10109]","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"remainingEstimate","displayName":"remainingEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["changed","was","was not in","in","is not","was in","!=","is","=","not in","was not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":[">","was","was not in","in","is not","is","=","not in","<=",">=","changed","was in","!=","was not","<"],"types":["com.atlassian.jira.issue.resolution.Resolution"]},{"value":"resolutiondate","displayName":"resolutiondate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"resolved","displayName":"resolved","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"Sprint","displayName":"Sprint - cf[10400]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10400]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["changed","was","was not in","in","is not","was in","!=","is","=","not in","was not"],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"\"Structure Index Monitor\"","displayName":"Structure Index Monitor - cf[12402]","orderable":"true","searchable":"true","cfid":"cf[12402]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Support case ID\"","displayName":"Support case ID - cf[11500]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11500]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Target end\"","displayName":"Target end - cf[11601]","orderable":"true","searchable":"true","cfid":"cf[11601]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Target start\"","displayName":"Target start - cf[11600]","orderable":"true","searchable":"true","cfid":"cf[11600]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"Team","displayName":"Team - cf[11403]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11403]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"timeestimate","displayName":"timeestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timeoriginalestimate","displayName":"timeoriginalestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timespent","displayName":"timespent","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"type","displayName":"type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"updated","displayName":"updated","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"updatedDate","displayName":"updatedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"voter","displayName":"voter","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"worklogAuthor","displayName":"worklogAuthor","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"worklogComment","displayName":"worklogComment","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"worklogDate","displayName":"worklogDate","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"workratio","displayName":"workratio","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]}]
[{"value":"archivedVersions()","displayName":"archivedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"assigneesList(\"\")","displayName":"assigneesList(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachedByUser()","displayName":"attachedByUser()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"value":"childIssuesOf(\"\")","displayName":"childIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"closedSprints()","displayName":"closedSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"commentedAfterDate(\"\")","displayName":"commentedAfterDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedBeforeDate(\"\")","displayName":"commentedBeforeDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedByUser()","displayName":"commentedByUser()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedOnDate(\"\")","displayName":"commentedOnDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"componentLeads()","displayName":"componentLeads()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"componentMatches(\"\")","displayName":"componentMatches(\"\")","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"componentsFromProject(\"\")","displayName":"componentsFromProject(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"componentsList(\"\")","displayName":"componentsList(\"\")","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"coveredBy(\"\")","displayName":"coveredBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"coveredByTestCasesHavingField(\"\", \"\")","displayName":"coveredByTestCasesHavingField(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"currentVersionsByDate()","displayName":"currentVersionsByDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"currentVersionsBySeq()","displayName":"currentVersionsBySeq()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"dueVersions()","displayName":"dueVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"endOfDay()","displayName":"endOfDay()","types":["java.util.Date"]},{"value":"endOfMonth()","displayName":"endOfMonth()","types":["java.util.Date"]},{"value":"endOfWeek()","displayName":"endOfWeek()","types":["java.util.Date"]},{"value":"endOfYear()","displayName":"endOfYear()","types":["java.util.Date"]},{"value":"epicsWhereIssueIn(\"\")","displayName":"epicsWhereIssueIn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"epicsWithIssues()","displayName":"epicsWithIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"groupMatches(\"\")","displayName":"groupMatches(\"\")","isList":"true","types":["com.atlassian.crowd.embedded.api.Group"]},{"value":"groupsOfUser()","displayName":"groupsOfUser()","isList":"true","types":["com.atlassian.crowd.embedded.api.Group"]},{"value":"hasAllLastTestResults(\"\")","displayName":"hasAllLastTestResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAllLinkedTestCyclesWithAllLastTestExecutionResults(\"\")","displayName":"hasAllLinkedTestCyclesWithAllLastTestExecutionResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAllLinkedTestRunsWithAllLastTestResults(\"\")","displayName":"hasAllLinkedTestRunsWithAllLastTestResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAnyLastTestResults(\"\")","displayName":"hasAnyLastTestResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAnyLinkedTestCycleWithAnyLastTestExecutionResult(\"\")","displayName":"hasAnyLinkedTestCycleWithAnyLastTestExecutionResult(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAnyLinkedTestRunWithAnyLastTestResult(\"\")","displayName":"hasAnyLinkedTestRunWithAnyLastTestResult(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAttachments()","displayName":"hasAttachments()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasCommits()","displayName":"hasCommits()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasComponents()","displayName":"hasComponents()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasFailingBuilds()","displayName":"hasFailingBuilds()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasLinkedTestCycle()","displayName":"hasLinkedTestCycle()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasLinkedTestRun()","displayName":"hasLinkedTestRun()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasLinks()","displayName":"hasLinks()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasOpenPRs()","displayName":"hasOpenPRs()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasOpenReviews()","displayName":"hasOpenReviews()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasPRs()","displayName":"hasPRs()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasRemoteLinks()","displayName":"hasRemoteLinks()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasReviews()","displayName":"hasReviews()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasSameValues(\"\", \"\")","displayName":"hasSameValues(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasSameVersions()","displayName":"hasSameVersions()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasSubtasks()","displayName":"hasSubtasks()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasTestCoverage()","displayName":"hasTestCoverage()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasTestResult()","displayName":"hasTestResult()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasVersions()","displayName":"hasVersions()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"impactsTestResult()","displayName":"impactsTestResult()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"inactiveUsers()","displayName":"inactiveUsers()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesInPlan(\"\")","displayName":"issuesInPlan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesInProgram(\"\")","displayName":"issuesInProgram(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWhereEpicIn(\"\")","displayName":"issuesWhereEpicIn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminder()","displayName":"issuesWithReminder()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderDueWithin(\"\", \"\")","displayName":"issuesWithReminderDueWithin(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForEmail(\"\")","displayName":"issuesWithReminderForEmail(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForGroup(\"\")","displayName":"issuesWithReminderForGroup(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForRole(\"\")","displayName":"issuesWithReminderForRole(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForUser(\"\")","displayName":"issuesWithReminderForUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderOwnedBy(\"\")","displayName":"issuesWithReminderOwnedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"labelsList(\"\")","displayName":"labelsList(\"\")","isList":"true","types":["com.atlassian.jira.issue.label.Label"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"lastLoginOf(\"\")","displayName":"lastLoginOf(\"\")","types":["java.util.Date"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedAllIssues(\"\")","displayName":"linkedAllIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesByDepth(\"\", \"\")","displayName":"linkedIssuesByDepth(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesHasStatus(\"\")","displayName":"linkedIssuesHasStatus(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInComponent(\"\")","displayName":"linkedIssuesInComponent(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInComponentByName(\"\", \"\")","displayName":"linkedIssuesInComponentByName(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInFilter(\"\")","displayName":"linkedIssuesInFilter(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInProject(\"\")","displayName":"linkedIssuesInProject(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInQuery(\"\")","displayName":"linkedIssuesInQuery(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInVersion(\"\")","displayName":"linkedIssuesInVersion(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInVersionByName(\"\")","displayName":"linkedIssuesInVersionByName(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"membersOfGroups(\"\")","displayName":"membersOfGroups(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"movedIssues()","displayName":"movedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"openVersions()","displayName":"openVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"overDueVersions()","displayName":"overDueVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"parent(\"\")","displayName":"parent(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"parentIssuesOf(\"\")","displayName":"parentIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"projectLead(\"\")","displayName":"projectLead(\"\")","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"projectLeads()","displayName":"projectLeads()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"projectMatches(\"\")","displayName":"projectMatches(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsList(\"\")","displayName":"projectsList(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasPermission(\"\")","displayName":"projectsWhereUserHasPermission(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasRole(\"\")","displayName":"projectsWhereUserHasRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectWithUserInRole(\"\")","displayName":"projectWithUserInRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"recentProjects()","displayName":"recentProjects()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releasedOn(\"\")","displayName":"releasedOn(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"sprintEndDateOf(\"\")","displayName":"sprintEndDateOf(\"\")","types":["java.util.Date"]},{"value":"sprintStartDateOf(\"\")","displayName":"sprintStartDateOf(\"\")","types":["java.util.Date"]},{"value":"standardIssueTypes()","displayName":"standardIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"startOfDay()","displayName":"startOfDay()","types":["java.util.Date"]},{"value":"startOfMonth()","displayName":"startOfMonth()","types":["java.util.Date"]},{"value":"startOfWeek()","displayName":"startOfWeek()","types":["java.util.Date"]},{"value":"startOfYear()","displayName":"startOfYear()","types":["java.util.Date"]},{"value":"structure()","displayName":"structure()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subtask(\"\")","displayName":"subtask(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"updatedBy(\"\")","displayName":"updatedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"userMatches(\"\")","displayName":"userMatches(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"usersInRole(\"\")","displayName":"usersInRole(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"usersInTimezone(\"\")","displayName":"usersInTimezone(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"versionEndDateOf(\"\")","displayName":"versionEndDateOf(\"\")","types":["java.util.Date"]},{"value":"versionMatches(\"\")","displayName":"versionMatches(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsAfter(\"\")","displayName":"versionsAfter(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsAfterDate(\"\")","displayName":"versionsAfterDate(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsBefore(\"\")","displayName":"versionsBefore(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionStartDateOf(\"\")","displayName":"versionStartDateOf(\"\")","types":["java.util.Date"]},{"value":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workedIssues(\"\", \"\", \"\")","displayName":"workedIssues(\"\", \"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedAfter(\"\")","displayName":"workLoggedAfter(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedBetween(\"\", \"\")","displayName":"workLoggedBetween(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedBy()","displayName":"workLoggedBy()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedOn(\"\")","displayName":"workLoggedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workStartedOn(\"\")","displayName":"workStartedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workUpdatedOn(\"\")","displayName":"workUpdatedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]}]
["explain","select","isnull","commit","isempty","when","rowid","output","number","character","identified","sqrt","delimiter","else","exclusive","lock","catch","join","strict","greater","if","between","order","having","in","byte","double","subtract","outer","index","raw","is","then","execute","input","as","defaults","field","size","left","unique","difference","returns","begin","modulo","object","trans","minus","access","increment","sum","long","into","uid","current","default","file","goto","min","audit","by","share","where","after","power","escape","connect","noaudit","table","validate","cf","set","break","initial","max","more","column","right","trigger","union","asc","rename","decrement","equals","fetch","char","exists","notin","to","first","return","transaction","checkpoint","date","privileges","declare","before","do","integer","float","while","empty","mode","view","whenever","prior","continue","function","intersection","limit","raise","create","from","collation","alter","group","add","all","last","like","resource","count","check","less","encoding","inner","rownum","collate","null","abort","immediate","true","decimal","exec","nowait","changed","desc","option","drop","next","string","session","values","for","distinct","insert","revoke","update","delete","not","synonym","avg","public","and","of","define","alias","divide","end","row","multiply","on","or","intersect","previous","false","go","start","was","rows","any","int","modify","with","inout","boolean","grant","remainder","user"]
{"errorMessages":["jqlTooComplex"],"errors":{}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
0.3
0