MDEV-4903
slow query using IN () on primary key with 5 columnsMDEV-4901
Drop temporary table generating warning messageMDEV-4900
Bad value inserted into a TIME field on truncationMDEV-4898
Too many warnings when inserting a bad value into a TIMESTAMP columnMDEV-4895
Valgrind warnings (Conditional jump or move depends on uninitialised value) in Field_datetime::get_date on GREATEST(..) IS NULLMDEV-4889
Race condition on shutdown when threadpool is usedMDEV-4887
Sequence plugin is always busy?MDEV-4881
Pivot throws an errorMDEV-4880
Attempt to create a table without columns produces ER_ILLEGAL_HA instead of ER_TABLE_MUST_HAVE_COLUMNSMDEV-4878
LOCK TABLE is not working with ConnectSEMDEV-4877
mysqldump dumps all data from a connect tableMDEV-4872
Inserting a huge number into a TIME column produces a wrong resultMDEV-4870
Wrong values of CASE, COALESCE, IFNULL on a combination of different temporal typesMDEV-4869
Wrong result of MAKETIME(0, 0, -0.1)MDEV-4867
Incomplete Binlog writes on disk-full error, also breaking slave replicationMDEV-4863
COALESCE(time_or_datetime) returns wrong results in numeric contextMDEV-4862
Wrong result of MAKETIME(0, 0, 59.9)MDEV-4861
TIME/DATETIME arithmetics does not preserve INTERVAL precisionMDEV-4859
Wrong value and data type of "SELECT MAX(time_column) + 1 FROM t1"MDEV-4858
Wrong results for a huge unsigned value inserted into a TIME columnMDEV-4857
Wrong result of HOUR('1 00:00:00')MDEV-4856
SQL_ERROR_LOG shows 1146 errors which didnt appear in mysql clientMDEV-4855
No servid special column in ConnectSEMDEV-4854
ConnectSE: table_type=mysql does not send the WHERE part -> full table scanMDEV-4853
DML on table_type=INI gives no error even MySQLd has not the privilege to change the fileMDEV-4849
Out of memory error and valgrind warnings on COLUMN_ADDMDEV-4848
Wrong metadata or column type for LEAST(1.0,'10')MDEV-4846
SQL_ERROR_LOG plugin doesn't log errors produced with SIGNALMDEV-4844
Redundant warning in SELECT TIME('00:00:00.');MDEV-4843
Wrong data type for TIMESTAMP('2001-01-01','10:10:10')MDEV-4840
Wrong result (missing rows) on LEFT JOIN with InnoDB tablesMDEV-4837
Comparing a TIME value with an illegal time representation returns TRUEMDEV-4826
UPDATE in Stored Function is not rolled backMDEV-4825
Valgrind warnings (blocks are still reachable in loss record) on parsing CREATE TABLE with virtual columnMDEV-4823
Server crashes in Item_func_not::fix_fields on creating a table with a virtual column using NOTMDEV-4822
Wrong result (missing row) with index scan over Aria tableMDEV-4820
GTID strict mode is full of bugs and doesn't serve its purposeMDEV-4814
my_create don't handle errorsMDEV-4813
Replication fails on updating a MEMORY table with an index using btreeMDEV-4812
Valgrind warnings (Invalid write) in dynamic_column_update_many on COLUMN_ADDMDEV-4797
Spider crash on show create table spider table and replication multi source to one of the partitionsMDEV-4790
Order by with loose index scan input results in a failed assert during the join cleanup phaseMDEV-4782
Valgrind warnings (Conditional jump or move depends on uninitialised value) with InnoDB, semijoinMDEV-4780
Crash while running SET GLOBAL key_cache_segments = 64MDEV-4779
Spider sort can produce null fieldMDEV-4778
Incorrect results from Aria/MyISAM SELECT using index with prefix length on TEXT columnMDEV-4774
Strangeness with max_binlog_stmt_cache_size SettingsMDEV-4771
Connect SE: Connection dies using table_type=pivorMDEV-4755
ER_FT_MATCHING_KEY_NOT_FOUND on query from table with fulltext indexMDEV-4752
Segfault during parsing of illegal query
[{"value":"\"[CHART] Date of First Response\"","displayName":"[CHART] Date of First Response - cf[10101]","orderable":"true","searchable":"true","cfid":"cf[10101]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"[CHART] Time in Status\"","displayName":"[CHART] Time in Status - cf[10100]","orderable":"true","searchable":"true","cfid":"cf[10100]","operators":["~","!~","is","is not"],"types":["java.lang.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":"Approvals","displayName":"Approvals - cf[11200]","orderable":"true","searchable":"true","cfid":"cf[11200]","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["in","is","not in","was","was not","!=","=","was not in","was in","is not","changed"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"assignee.property","displayName":"assignee.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"buildName","displayName":"buildName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"buildState","displayName":"buildState","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":"captureBrowser","displayName":"captureBrowser","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"captureDocumentMode","displayName":"captureDocumentMode","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"captureJIRAURL","displayName":"captureJIRAURL","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"captureJQueryVersion","displayName":"captureJQueryVersion","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"captureOS","displayName":"captureOS","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"captureScreenResolution","displayName":"captureScreenResolution","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"captureUserAgent","displayName":"captureUserAgent","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":"creator.property","displayName":"creator.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"deploymentEnvironmentName","displayName":"deploymentEnvironmentName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentEnvironmentType","displayName":"deploymentEnvironmentType","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentName","displayName":"deploymentName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentState","displayName":"deploymentState","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"development","displayName":"development - cf[11400]","orderable":"true","searchable":"true","cfid":"cf[11400]","operators":["<","<=",">",">="],"types":["java.lang.Number"]},{"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":[">","in","is","not in",">=","was","was not","was in","<","<=","!=","=","was not in","is not","changed"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"flagDisabledRollout","displayName":"flagDisabledRollout","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagEnabled","displayName":"flagEnabled","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagEnabledRollout","displayName":"flagEnabledRollout","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":"flagKey","displayName":"flagKey","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagName","displayName":"flagName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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.String","java.util.Date","java.lang.Number"]},{"value":"issueBlocks","displayName":"issueBlocks","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueCauses","displayName":"issueCauses","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Issue color\"","displayName":"Issue color - cf[11704]","orderable":"true","searchable":"true","cfid":"cf[11704]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"issueDuplicates","displayName":"issueDuplicates","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIncludes","displayName":"issueIncludes","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsBlockedBy","displayName":"issueIsBlockedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsCausedBy","displayName":"issueIsCausedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsDuplicatedBy","displayName":"issueIsDuplicatedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsPartOf","displayName":"issueIsPartOf","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLink","displayName":"issueLink","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","is","is not"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"value":"issueRelatesTo","displayName":"issueRelatesTo","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"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":"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":"linkedIssue","displayName":"linkedIssue","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"Organizations","displayName":"Organizations - cf[11600]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11600]","operators":["=","!=","not in","in"],"types":["com.atlassian.servicedesk.api.organization.CustomerOrganization"]},{"value":"originalEstimate","displayName":"originalEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"parentEpic","displayName":"parentEpic","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Parent Link\"","displayName":"Parent Link - cf[11300]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11300]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"postmortem status\"","displayName":"postmortem status","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":[">","in","is","not in",">=","was","was not","was in","<","<=","!=","=","was not in","is not","changed"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"progress","displayName":"progress","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"project.property","displayName":"project.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"raisedInSession","displayName":"raisedInSession","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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":["in","is","not in","was","was not","!=","=","was not in","was in","is not","changed"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"reporter.property","displayName":"reporter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"request-channel-type","displayName":"request-channel-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"request-last-activity-time","displayName":"request-last-activity-time","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Request participants\"","displayName":"Request participants - cf[11702]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11702]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"\"Request Type\"","displayName":"Request Type - cf[11701]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11701]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.servicedesk.internal.api.origin.VpOrigin"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":[">","in","is","not in",">=","was","was not","was in","<","<=","!=","=","was not in","is not","changed"],"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":"Satisfaction","displayName":"Satisfaction - cf[11705]","orderable":"true","searchable":"true","cfid":"cf[11705]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"sd-kb-shared","displayName":"sd-kb-shared","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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":"\"Start date\"","displayName":"Start date - cf[11700]","orderable":"true","searchable":"true","cfid":"cf[11700]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["in","is","not in","was","was not","!=","=","was not in","was in","is not","changed"],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"statusCategoryChangedDate","displayName":"statusCategoryChangedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Story point estimate\"","displayName":"Story point estimate - cf[11703]","orderable":"true","searchable":"true","cfid":"cf[11703]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Points\"","displayName":"Story Points - cf[10105]","orderable":"true","searchable":"true","cfid":"cf[10105]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Team","displayName":"Team - cf[11500]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11500]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"testingstatus","displayName":"testingstatus","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"testsessions","displayName":"testsessions","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"voter.property","displayName":"voter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watcher.property","displayName":"watcher.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"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":"approved()","displayName":"approved()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"approver(\"\")","displayName":"approver(\"\")","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"breached()","displayName":"breached()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"value":"closedSprints()","displayName":"closedSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"completed()","displayName":"completed()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"elapsed(\"\")","displayName":"elapsed(\"\")","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"everBreached()","displayName":"everBreached()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"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":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"myApproval()","displayName":"myApproval()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"myPending()","displayName":"myPending()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"organizationMembers(\"\")","displayName":"organizationMembers(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"paused()","displayName":"paused()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"pending()","displayName":"pending()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"pendingBy(\"\")","displayName":"pendingBy(\"\")","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"portfolioChildIssuesOf(\"\")","displayName":"portfolioChildIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","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":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"remaining(\"\")","displayName":"remaining(\"\")","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"running()","displayName":"running()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"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":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"withinCalendarHours()","displayName":"withinCalendarHours()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]}]
["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","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,"favourite":false},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true,"favourite":false},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true,"favourite":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false}]