Ref MDEV-35072.
--source include/have_innodb.inc
|
SET sql_select_limit=1,optimizer_join_limit_pref_ratio=1;
|
CREATE TABLE t (c INT NOT NULL UNIQUE) ENGINE=InnoDB;
|
INSERT INTO t VALUES (0),(1),(2),(3),(4),(5);
|
SELECT * FROM t ORDER BY c;
|
Leads to:
|
CS 11.8.1 33e0796e7a154e02a5e53c55cefc5d6feb4f5e6d (Debug, UBASAN, Clang) Build 15/02/2025
|
mariadbd: /test/11.8_dbg_san/sql/sql_select.cc:11723: double recompute_join_cost_with_limit(const JOIN *, bool, double *, double): Assertion `partial_join_cost >= 0.0' failed.
|
|
CS 11.8.1 33e0796e7a154e02a5e53c55cefc5d6feb4f5e6d (Debug, UBASAN, Clang) Build 15/02/2025
|
Core was generated by `/test/UBASAN_MD150225-mariadb-11.8.1-linux-x86_64-dbg/bin/mariadbd --no-default'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
|
[Current thread is 1 (LWP 2021717)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=6)at ./nptl/pthread_kill.c:89
|
#3 0x000055f8965a2ac5 in handle_fatal_signal (sig=<optimized out>)at /test/11.8_dbg_san/sql/signal_handler.cc:298
|
#4 <signal handler called>
|
#5 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#6 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#7 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#8 0x000014a7d144526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#9 0x000014a7d14288ff in __GI_abort () at ./stdlib/abort.c:79
|
#10 0x000014a7d142881b in __assert_fail_base (fmt=0x14a7d15d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55f898810200 <str> "partial_join_cost >= 0.0", file=file@entry=0x55f898809c54 "/test/11.8_dbg_san/sql/sql_select.cc", line=line@entry=11723, function=function@entry=0x55f898810240 <__PRETTY_FUNCTION__._Z30recompute_join_cost_with_limitPK4JOINbPdd> "double recompute_join_cost_with_limit(const JOIN *, bool, double *, double)") at ./assert/assert.c:94
|
#11 0x000014a7d143b507 in __assert_fail (assertion=0x55f898810200 <str> "partial_join_cost >= 0.0", file=0x55f898809c54 "/test/11.8_dbg_san/sql/sql_select.cc", line=11723, function=0x55f898810240 <__PRETTY_FUNCTION__._Z30recompute_join_cost_with_limitPK4JOINbPdd> "double recompute_join_cost_with_limit(const JOIN *, bool, double *, double)") at ./assert/assert.c:103
|
#12 0x000055f895957c58 in recompute_join_cost_with_limit (join=join@entry=0x52d0003c1e10, skip_sorting=<optimized out>, first_table_cost=first_table_cost@entry=0x14a79ff144b0, fraction=fraction@entry=0.16666666666666666)at /test/11.8_dbg_san/sql/sql_select.cc:11723
|
#13 0x000055f89594f489 in join_limit_shortcut_finalize_plan (join=0x52d0003c1e10, cost=<optimized out>)at /test/11.8_dbg_san/sql/sql_select.cc:11793
|
#14 0x000055f89594c5e6 in choose_plan (join=0x52d0003c1e10, join_tables=<optimized out>, emb_sjm_nest=<optimized out>)at /test/11.8_dbg_san/sql/sql_select.cc:10216
|
#15 0x000055f8958db1a1 in make_join_statistics (join=0x52d0003c1e10, tables_list=<optimized out>, keyuse_array=<optimized out>)at /test/11.8_dbg_san/sql/sql_select.cc:6343
|
#16 0x000055f8958c41c9 in JOIN::optimize_inner (this=0x52d0003c1e10)at /test/11.8_dbg_san/sql/sql_select.cc:2711
|
#17 0x000055f8958b4493 in JOIN::optimize (this=<optimized out>)at /test/11.8_dbg_san/sql/sql_select.cc:1994
|
#18 0x000055f895895de9 in mysql_select (thd=0x52b000165218, tables=tables@entry=0x52d0003c0b58, fields=<optimized out>, conds=<optimized out>, og_num=og_num@entry=1, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x52d0003c1de0, unit=0x52b000169540, select_lex=0x52d0003c04e0)at /test/11.8_dbg_san/sql/sql_select.cc:5361
|
#19 0x000055f895895103 in handle_select (thd=thd@entry=0x52b000165218, lex=lex@entry=0x52b000169460, result=result@entry=0x52d0003c1de0, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/11.8_dbg_san/sql/sql_select.cc:633
|
#20 0x000055f89576a108 in execute_sqlcom_select (thd=0x52b000165218, all_tables=<optimized out>) at /test/11.8_dbg_san/sql/sql_parse.cc:6191
|
#21 0x000055f895755e06 in mysql_execute_command (thd=0x52b000165218, is_called_from_prepared_stmt=<optimized out>)at /test/11.8_dbg_san/sql/sql_parse.cc:3979
|
#22 0x000055f895725629 in mysql_parse (thd=thd@entry=0x52b000165218, rawbuf=rawbuf@entry=0x52d0003c0438 "SELECT * FROM t ORDER BY c", length=<optimized out>, parser_state=parser_state@entry=0x14a7a03458a0)at /test/11.8_dbg_san/sql/sql_parse.cc:7915
|
#23 0x000055f8957196ec in dispatch_command (command=<optimized out>, thd=0x52b000165218, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/11.8_dbg_san/sql/sql_parse.cc:1902
|
#24 0x000055f89572804e in do_command (thd=thd@entry=0x52b000165218, blocking=true) at /test/11.8_dbg_san/sql/sql_parse.cc:1415
|
#25 0x000055f895df0cfd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x508000002fb8, put_in_cache=true)at /test/11.8_dbg_san/sql/sql_connect.cc:1415
|
#26 0x000055f895df05b8 in handle_one_connection (arg=0x508000002fb8)at /test/11.8_dbg_san/sql/sql_connect.cc:1327
|
#27 0x000055f89511cd9d in asan_thread_start(void*) ()
|
#28 0x000014a7d149ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#29 0x000014a7d1529c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Setup:
Compiled with a recent version of Clang (I used Clang 18.1.3) with LLVM 18. Ubuntu instructions:
|
# Note: It is strongly recommended to uninstall all old Clang & LLVM packages (ref dpkg --list | grep -iE 'clang|llvm' and use apt purge and dpkg --purge to remove the packages), before following these steps
|
# Note: llvm-17-linker-tools installs /usr/lib/llvm-17/lib/LLVMgold.so, which is needed for compilation, and LLVMgold.so is no longer included in LLVM 18
|
sudo apt install clang llvm-18 llvm-18-linker-tools llvm-18-runtime llvm-18-tools llvm-18-dev libstdc++-14-dev llvm-dev llvm-17-linker-tools
|
sudo ln -s /usr/lib/llvm-17/lib/LLVMgold.so /usr/lib/llvm-18/lib/LLVMgold.so
|
Compiled with: "-DCMAKE_C_COMPILER=/usr/bin/clang -DCMAKE_CXX_COMPILER=/usr/bin/clang++ -DCMAKE_C{,XX}_FLAGS='-march=native -mtune=native'" and:
|
-DWITH_ASAN=ON -DWITH_ASAN_SCOPE=ON -DWITH_UBSAN=ON -DWSREP_LIB_WITH_ASAN=ON
|
Set before execution:
|
export UBSAN_OPTIONS=print_stacktrace=1:report_error_type=1 # And you may also want to supress UBSAN startup issues using 'suppressions=UBSAN.filter' in UBSAN_OPTIONS. For an example of UBSAN.filter, which includes current startup issues see: https://github.com/mariadb-corporation/mariadb-qa/blob/master/UBSAN.filter
|
Bug confirmed present in:
MariaDB: 11.4.6 (dbg), 11.8.1 (dbg), 12.0.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.5.29 (dbg), 10.5.29 (opt), 10.6.22 (dbg), 10.6.22 (opt), 10.11.12 (dbg), 10.11.12 (opt), 11.4.6 (opt), 11.8.1 (opt), 12.0.0 (opt)
Note that a Clang UBASAN build is required to produce the bug. It does not reproduce on a standard build
- relates to
-
MDEV-35072
Assertion with optimizer_join_limit_pref_ratio and 1-table select
-
-
Closed
There are no comments yet on this issue.
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1743273489566},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1743273489567},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1743273489573},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":true},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":true},{"name":"Component","id":"component","key":"issue.field.components","isShown":true},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Link types","id":"issue_link_type","key":"issue.field.issuelinks","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true,"lastViewed":1743273489576},{"name":"Query","id":"text","key":"text","isShown":true},{"name":"Development","id":"customfield_11700","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true},{"name":"Epic Colour","id":"customfield_10603","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false},{"name":"Epic Link","id":"customfield_10600","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Epic Name","id":"customfield_10601","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Status","id":"customfield_10602","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false},{"name":"Epic/Theme","id":"customfield_10103","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Flagged","id":"customfield_13101","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"Global Rank","id":"customfield_10000","key":"com.pyxis.greenhopper.jira:gh-global-rank","isShown":true},{"name":"PM Planning","id":"customfield_11404","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Python Version","id":"customfield_12404","key":"com.atlassian.jira.plugin.system.customfieldtypes:textfield","isShown":false},{"name":"Rank","id":"customfield_10700","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Rank (Obsolete)","id":"customfield_10104","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Rank (Obsolete)","id":"customfield_10300","key":"com.pyxis.greenhopper.jira:gh-global-rank","isShown":true},{"name":"Roadmap Score","id":"customfield_10106","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Sprint","id":"customfield_10400","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"Story Points","id":"customfield_13100","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Support case ID","id":"customfield_11500","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Zendesk inactive tickets","id":"customfield_13002","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"gitBranch","id":"customfield_12400","key":"com.xiplink.jira.git.jira_git_plugin:gitbranches","isShown":true},{"name":"gitCommitsReferenced","id":"customfield_12401","key":"com.xiplink.jira.git.jira_git_plugin:gitcommitsreferenced","isShown":true},{"name":"jqltField","id":"customfield_11300","key":"com.j-tricks.jql-plugin:jqlt-field","isShown":true}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true},{"name":"Due Date","id":"duedate","key":"issue.field.duedate","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1743273489575},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true},{"name":"Assigned for Review","id":"customfield_12700","key":"com.atlassian.jira.plugin.system.customfieldtypes:userpicker","isShown":true},{"name":"Assigned for Testing","id":"customfield_12701","key":"com.atlassian.jira.plugin.system.customfieldtypes:userpicker","isShown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label> <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-type\" multiple=\"multiple\" name=\"type\"\n data-placeholder-text=\"Find Issue Types...\" size=\"5\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked 12800 10202 12701 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14103&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_1\"\n title=\"Bug\"\n value=\"1\">Bug</option>\n \n <option class=\" imagebacked 12800 10202 12701 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14107&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"Epic\"\n value=\"5\">Epic</option>\n \n <option class=\" imagebacked 12800 10202 12701 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14111&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 12800 10202 12701 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14118&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_3\"\n title=\"Task\"\n value=\"3\">Task</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 12800 12701 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14116&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Sub-Task\"\n value=\"10000\">Sub-Task</option>\n \n <option class=\" imagebacked 10202 12701 \"\n data-icon=\"/images/icons/issuetypes/task_agile.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_7\"\n title=\"Technical task\"\n value=\"7\">Technical task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"project":{"name":"Project","editHtml":"\n <div class=\"field-group aui-field-project\" >\n <label for=\"searcher-pid\">Project</label> \n\n <select class=\"select js-default-checkboxmultiselect\" data-placeholder-text=\"Find Projects...\" id=\"searcher-pid\" multiple=\"multiple\" name=\"pid\" size=\"5\">\n <optgroup label=\"All Projects\">\n \n <option data-icon=\"/secure/projectavatar?pid=10902&size=small\"\n title=\"MariaDB ColumnStore\"\n value=\"10902\">\n MariaDB ColumnStore (MCOL)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10300&size=small\"\n title=\"MariaDB Connector/C\"\n value=\"10300\">\n MariaDB Connector/C (CONC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11801&size=small\"\n title=\"MariaDB Connector/C++\"\n value=\"11801\">\n MariaDB Connector/C++ (CONCPP)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10301&size=small\"\n title=\"MariaDB Connector/J\"\n value=\"10301\">\n MariaDB Connector/J (CONJ)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11300&size=small\"\n title=\"MariaDB Connector/node.js\"\n value=\"11300\">\n MariaDB Connector/node.js (CONJS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10400&size=small\"\n title=\"MariaDB Connector/ODBC\"\n value=\"10400\">\n MariaDB Connector/ODBC (ODBC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11400&size=small\"\n title=\"MariaDB Connector/Python\"\n value=\"11400\">\n MariaDB Connector/Python (CONPY)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11902&size=small\"\n title=\"MariaDB Connector/R2DBC\"\n value=\"11902\">\n MariaDB Connector/R2DBC (R2DBC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11901&size=small\"\n title=\"MariaDB Foundation Development\"\n value=\"11901\">\n MariaDB Foundation Development (MDBF)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10600&size=small\"\n title=\"MariaDB MaxScale\"\n value=\"10600\">\n MariaDB MaxScale (MXS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10000&size=small\"\n title=\"MariaDB Server\"\n value=\"10000\">\n MariaDB Server (MDEV)\n </option>\n </optgroup>\n </select>\n </div>\n \n","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label> <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://jira.mariadb.org/secure/useravatar?size=xsmall&avatarId=10123\" value=\"empty\" title=\"Unassigned\">Unassigned</option>\n </optgroup>\n <optgroup>\n </optgroup>\n </select>\n <input type=\"hidden\" name=\"check_prev_assignee\" value=\"true\">\n </div>\n \n","validSearcher":true,"isShown":true},"status":{"name":"Status","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-status\">Status</label> \n <select class=\"select js-default-checkboxmultiselectstatuslozenge\" data-placeholder-text=\"Find Statuses...\" id=\"searcher-status\" multiple=\"multiple\" name=\"status\" size=\"4\" data-status-lozenge=\"true\">\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{"id":"1","name":"Open","description":"","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/status_generic.gif\" value=\"10101\" title=\"Confirmed\" data-simple-status=\"{"id":"10101","name":"Confirmed","description":"","iconUrl":"/images/icons/status_generic.gif","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Confirmed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/inprogress.png\" value=\"3\" title=\"In Progress\" data-simple-status=\"{"id":"3","name":"In Progress","description":"This issue is being actively worked on at the moment by the assignee.","iconUrl":"/images/icons/statuses/inprogress.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Progress</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/down.png\" value=\"10000\" title=\"Stalled\" data-simple-status=\"{"id":"10000","name":"Stalled","description":"This issue is not being actively worked on at the moment.","iconUrl":"/images/icons/statuses/down.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Stalled</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/information.png\" value=\"10002\" title=\"In Review\" data-simple-status=\"{"id":"10002","name":"In Review","description":"The current assignee is reviewing the work done in this issue.","iconUrl":"/images/icons/statuses/information.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Review</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10301\" title=\"In Testing\" data-simple-status=\"{"id":"10301","name":"In Testing","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Testing</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"10001\" title=\"Done\" data-simple-status=\"{"id":"10001","name":"Done","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Done</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/open.png\" value=\"10003\" title=\"To Do\" data-simple-status=\"{"id":"10003","name":"To Do","description":"","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">To Do</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/status_generic.gif\" value=\"10102\" title=\"Verified\" data-simple-status=\"{"id":"10102","name":"Verified","description":"Issue is tested and confirmed as fixed or done","iconUrl":"/images/icons/status_generic.gif","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Verified</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10408\" title=\"Release done\" data-simple-status=\"{"id":"10408","name":"Release done","description":"-Commit & merges are done\\r\\n-Packages are built & tested\\r\\n-Packages of packages are created\\r\\n-Packages are uploaded live on MariaDB.com","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Release done</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10501\" title=\"Needs Feedback\" data-simple-status=\"{"id":"10501","name":"Needs Feedback","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Needs Feedback</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10701\" title=\"Fixed\" data-simple-status=\"{"id":"10701","name":"Fixed","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Fixed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10702\" title=\"Duplicate\" data-simple-status=\"{"id":"10702","name":"Duplicate","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Duplicate</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10703\" title=\"Retest\" data-simple-status=\"{"id":"10703","name":"Retest","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Retest</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10704\" title=\"Re-opened\" data-simple-status=\"{"id":"10704","name":"Re-opened","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Re-opened</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10801\" title=\"Published on Staging\" data-simple-status=\"{"id":"10801","name":"Published on Staging","description":"For the issue type \\"Release\\" in the poject TODO, when new build are published on staging.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Published on Staging</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10802\" title=\"Won't Fix\" data-simple-status=\"{"id":"10802","name":"Won't Fix","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Won't Fix</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10803\" title=\"Invalid\" data-simple-status=\"{"id":"10803","name":"Invalid","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Invalid</option>\n </select>\n </div>\n \n","validSearcher":true,"isShown":true},"labels":{"name":"Label","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldlabels\">Label:</label><span id=\"fieldlabels\" class=\"fieldValue\">\n \n clang\n</span></div>\n","editHtml":"\n <div class=\"field-group aui-field-labels\" >\n <label for=\"searcher-labels\">Labels</label> <select class=\"js-label-checkboxmultiselect\" multiple=\"multiple\" id=\"searcher-labels\" name=\"labels\" data-placeholder-text=\"Find Labels...\">\n <option value=\"clang\" title=\"clang\" selected=\"selected\">clang</option>\n </select>\n </div>\n \n","jql":"labels = clang","validSearcher":true,"isShown":true}}}
[{"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
Major