MDEV-6468
MYSQL_PS1 no longer handles "\n" correctly- MDEV-6294
[5.1-5.3] Wrong result (extra rows) with subquery in HAVING clause - MDEV-6151
Wrong result (missing row) with LEFT JOIN, HAVING and ORDER BY - MDEV-5899
Merge problem in scripts/mysql_system_tables_data.sql disabled recent bugfixes - MDEV-5717
Server crash with insert statement containing DEFAULT into view - MDEV-5655
Server crashes on NAME_CONST containing AND/OR expressions 
MDEV-5609
create new test ssl certificates- MDEV-5543
MyISAM repair unsafe usage of TMD files - MDEV-5410
Server crashes in Bitmap<64u>::intersect on a FROM SQ with UNION, PS protocol - MDEV-5290
MTR cannot find mysql_tzinfo_to_sql on Windows - MDEV-5266
MySQL:57657 - Temporary MERGE table with temporary underlying is broken by ALTER - MDEV-5071
[5.1-5.2 only] Wrong result (missing rows) with group by, multi-part key, equality conditions (MySQL:70359) - MDEV-4978
Server cursor is broken with blobs in the select list, ORDER BY does not work - MDEV-4763
5.5.32 merge - MDEV-4544
update MSI installer to include HeidiSQL 8.0 - MDEV-4462
mysqld gets SIGFPE when mysql.user table is empty - MDEV-4444
Server crashes with "safe_mutex: Trying to destroy a mutex share->mutex that was locked" on attempt to recover an archive table - MDEV-4346
Assertion `0' fails in net_end_statement(THD*) on concurrent DML and KILL with InnoDB and PBXT - MDEV-4326
Server crashes in append_query_string on 2nd execution of a PS with string in LIMIT via API - MDEV-4296
Assertion `n_linear_rings > 0' fails in Gis_polygon::centroid_xy - MDEV-4295
Server crashes in get_point on a query with Area, AsBinary, MultiPoint - MDEV-4289
Assertion `0' fails in make_sortkey with GROUP_CONCAT, MAKE_SET, GROUP BY - MDEV-4280
Assertion `empty_size == empty_size_on_page' failure in ma_blockrec.c or ER_NOT_KEYFILE on query with DISTINCT and GROUP BY - MDEV-4270
crash in fix_semijoin_strategies_for_picked_join_order - MDEV-4269
crash when grouping by values() - MDEV-4252
geometry query crashes server - MDEV-4213
5.5.30 merge - MDEV-4203
Possible bug in maria's repair functions - MDEV-4194
Missing comma breaks mysys error messages - MDEV-4169
mysql-test-run doesn't strip expected warnings - MDEV-4147
Cannot build with include files from binary tarballs (fatal error: mysql/plugin.h: No such file or directory) - MDEV-4103
Wrong result (missing row) with index_merge, multiple indexes, AND and OR conditions - MDEV-3854
Makefiles are incompatible with automake 1.12 - MDEV-765
LP:825075 - Wrong result with multipart key + MIN/MAX loose scan and OR expression in WHERE - MDEV-763
LP:702776 - Deadlock around remove_table_from_cache with HANDLER + DDL - MDEV-752
LP:666250 - Undefined symbol strdup_root - MDEV-750
LP:800035 - intermittent rpl_deadlock_innodb failures - MDEV-716
LP:815198 - problems with overwriting libmysqlclient files when installing mariadb on debian wheezy - MDEV-715
LP:705217 - Some tests fail with BUILD/compile-pentium64 [PATCH] - MDEV-698
LP:814514 - Aria double recovery failure Key tree is empty / Record at: 1:0 Can't find key for index: 1 - MDEV-691
LP:425916 - CREATE TABLE with unsupported table option keeps the option - MDEV-685
LP:662714 - PBXT replication failure with simple transactions - MDEV-677
LP:635691 - OQGraph valgrind warnings when running a Random Query Generator test - MDEV-670
LP:1002402 - mysql_install_db still creates users with case sensitive hostname - MDEV-663
LP:1001092 - Query with GROUP BY returns an extra row - MDEV-648
LP:1002404 - DROP USER can't drop users with legacy upper case host name anymore - MDEV-643
LP:668491 - Wrong result for SELECT COUNT(*) FROM t in pbxt.preload - MDEV-621
LP:693329 - Assertion `!is_interleave_error' failed on low optimizer_search_depth - MDEV-601
LP:576702 - my.cnf missing in MariaDB 5.1 rpm's - MDEV-599
LP:625107 - xtradb crashes on shutdown
[{"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