{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":19816070,"defaultBranch":"11.6","name":"server","ownerLogin":"MariaDB","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2014-05-15T10:58:50.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/4739304?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1718213677.0","currentOid":""},"activityList":{"items":[{"before":"69420d6a304bc781cedb5712359a9193d8fc65e7","after":"baaa2e03c6a434b0583ec561bbc01552098d66da","ref":"refs/heads/bb-11.6-MDEV-31466","pushedAt":"2024-06-12T21:40:25.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mariadb-RexJohnston","name":"Rex Johnston","path":"/mariadb-RexJohnston","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/117681572?s=80&v=4"},"commit":{"message":"MDEV-31466 Add optional correlation column list for derived tables\n\nExtend derived table syntax to support column name assignment.\n(subquery expression) [as|=] ident [comma separated column name list].\nPrior to this patch, the optional comma separated column name list is\nnot supported.\n\nColumn names are reassigned at the end of unit->prepare of the unit\nrepresenting the above subquery expression. Processing within the\nexpression will therefore use original column names, outside the unit\nwill use the newly assigned names. For example.\n\nselect a1, count(*) from\n (select c1, c2, c3 from t1 where c2 > 0) as d1 (a1, a2, a3)\nwhere a1 > 0;\n\nWithin the subquery expression c2 > 0 is a valid condition, outside it,\nafter being assigned a new name, a1 > 0 now the valid condition.","shortMessageHtmlLink":"MDEV-31466 Add optional correlation column list for derived tables"}},{"before":"71a475d689d20a6f774f72e3cbdc9941f9668867","after":"126c38ee0b743ab9578b4ce9c4025d3afd50f952","ref":"refs/heads/10.5-mdev-33746-mark-override","pushedAt":"2024-06-12T20:43:17.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"DaveGosselin-MariaDB","name":"Dave Gosselin","path":"/DaveGosselin-MariaDB","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/113473632?s=80&v=4"},"commit":{"message":"MDEV-33746 Supply missing override markings\n\nFind and fix missing virtual override markings. Updates CMAKE_CXX_FLAGS\nto include -Wsuggest-override and -Winconsistent-missing-override. In\na few places, redundant virtual markings were removed.","shortMessageHtmlLink":"MDEV-33746 Supply missing override markings"}},{"before":null,"after":"71a475d689d20a6f774f72e3cbdc9941f9668867","ref":"refs/heads/10.5-mdev-33746-mark-override","pushedAt":"2024-06-12T17:34:37.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"DaveGosselin-MariaDB","name":"Dave Gosselin","path":"/DaveGosselin-MariaDB","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/113473632?s=80&v=4"},"commit":{"message":"MDEV-33746 Supply missing override markings\n\nFind and fix missing virtual override markings. Updates CMAKE_CXX_FLAGS\nto include -Wsuggest-override and -Winconsistent-missing-override. In\na few places, redundant virtual markings were removed.","shortMessageHtmlLink":"MDEV-33746 Supply missing override markings"}},{"before":"bf1f2aee07a01f006b33de088cf6ba2562646a0d","after":"03bd72d00750760cabbe4790d32fc3bffc2f433e","ref":"refs/heads/bb-10.5-mdev-30073-8","pushedAt":"2024-06-12T17:23:26.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"igorbabaev","name":"Igor Babaev","path":"/igorbabaev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7783432?s=80&v=4"},"commit":{"message":"MDEV-30073 Wrong result on 2nd execution of PS for query with NOT EXISTS\n\nThis bug is consequence of a serious architectural flaw of the query\nprocessing at the prepare stage. Context analysis of processed queries has\nto be done at this stage. The important part of this analysis is resolution\nof column references also known as name resolution. The items for column\nreferences used in a query are created by the parser. They are allocated\nin the statement memory because their life span is the same as the life\nspan of the executed query. During name resolution some of the items are\nwrapped into objects belonging to classes derived from the Item_ref class.\nIn many cases we can't do without such wrappers. For example, the parser\ndoes not differentiate between references to columns of base tables and\nreferences to columns of views. However for a reference to a view column\nwe need a pointer to the translation item for this column. This pointer\nis stored in a Item_direct_view_ref object that wraps the item for the\ncolumn reference. Before this patch the wrappers were allocated in\nexecution memory good only for one execution. That wasn't a problem when\nthe query was executed only once. Yet for the queries executed as prepared\nstatements or within a stored procedure it could lead to crashes or wrong\nresult sets at the second execution of the query. It could happen when\nthe wrapped item was substituted for something else by permanent\ntransformations during the optimization phase.\n\nThis patch allocates all the wrappers around items created for column\nreferences in the statement memory at the first execution of PS or at the\nfirst call of SP/SF.","shortMessageHtmlLink":"MDEV-30073 Wrong result on 2nd execution of PS for query with NOT EXISTS"}},{"before":"10e6f87ca6d3f0c4f999b789f632dd19a23cea56","after":"da974ac55d1971aaf6ac136897245f7dcbd0962e","ref":"refs/heads/10.11-MDEV-33894","pushedAt":"2024-06-12T16:58:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"},"commit":{"message":"fixup! 10e6f87ca6d3f0c4f999b789f632dd19a23cea56\n\nTry harder to fix innodb.log_file_size_online failures. It still fails.\nAlso, cover invalid startup options.","shortMessageHtmlLink":"fixup! 10e6f87"}},{"before":"fe2bfacb492a86e23a527283678156fe5e66a96e","after":"42b963abb519c3a3d0ee83a358e40cef414c7b19","ref":"refs/heads/10.6-mdev-33971","pushedAt":"2024-06-12T16:32:32.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"DaveGosselin-MariaDB","name":"Dave Gosselin","path":"/DaveGosselin-MariaDB","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/113473632?s=80&v=4"},"commit":{"message":"MDEV-33971 NAME_CONST in WHERE clause replaced by inner item\n\nImprove performance of queries like\n SELECT * FROM t1 WHERE field = NAME_CONST('a', 4);\nby, in this example, replacing the WHERE clause with field = 4\nin the case of ref access.\n\nThe rewrite is done during fix_fields and we disambiguate this\ncase from other cases of NAME_CONST by inspecting where we are\nin parsing. We rely on THD::where to accomplish this. To\nimprove performance there, we change the type of THD::where to\nbe an enumeration, so we can avoid string comparisons during\nItem_name_const::fix_fields. Consequently, this patch also\nchanges all usages of THD::where to conform likewise.","shortMessageHtmlLink":"MDEV-33971 NAME_CONST in WHERE clause replaced by inner item"}},{"before":"9923b3d18ad2e8c80b1b28d425311e5ef6859822","after":"a487d21ac5584d15bb01fa5dc72e549e90f1eea8","ref":"refs/heads/preview-11.6-preview","pushedAt":"2024-06-12T16:31:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"sanja-byelkin","name":"Oleksandr \"Sanja\" Byelkin","path":"/sanja-byelkin","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1267602?s=80&v=4"},"commit":{"message":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS.\n\nRename some threads to workaround this restrictions,\ne.g \"rpl_parallel_thread\"->\"rpl_parallel\",\n\"slave_background\" -> \"slave_bg\" etc.","shortMessageHtmlLink":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS."}},{"before":"0952766881346d39aa53482a68be2341df1d9872","after":"2ff27b8310466496794ad22ab7f75544327ef1e8","ref":"refs/heads/preview-11.6-preview-vlad","pushedAt":"2024-06-12T16:11:28.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"vladbogo","name":"Vlad Bogolin","path":"/vladbogo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5010835?s=80&v=4"},"commit":{"message":"test2 buildbot","shortMessageHtmlLink":"test2 buildbot"}},{"before":"9923b3d18ad2e8c80b1b28d425311e5ef6859822","after":"6fc89edfd7a238c27073a8559506e979d170aac1","ref":"refs/heads/st-11.6-vlad-test","pushedAt":"2024-06-12T16:05:22.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"vladbogo","name":"Vlad Bogolin","path":"/vladbogo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5010835?s=80&v=4"},"commit":{"message":"BB-Test MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS.\n\nRename some threads to workaround this restrictions,\ne.g \"rpl_parallel_thread\"->\"rpl_parallel\",\n\"slave_background\" -> \"slave_bg\" etc.","shortMessageHtmlLink":"BB-Test MDEV-32537 due to Linux, restrict thread name 15 characters, …"}},{"before":"9923b3d18ad2e8c80b1b28d425311e5ef6859822","after":"0952766881346d39aa53482a68be2341df1d9872","ref":"refs/heads/preview-11.6-preview-vlad","pushedAt":"2024-06-12T16:03:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vladbogo","name":"Vlad Bogolin","path":"/vladbogo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5010835?s=80&v=4"},"commit":{"message":"test buildbot","shortMessageHtmlLink":"test buildbot"}},{"before":null,"after":"9923b3d18ad2e8c80b1b28d425311e5ef6859822","ref":"refs/heads/st-11.6-vlad-test","pushedAt":"2024-06-12T16:00:42.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"vladbogo","name":"Vlad Bogolin","path":"/vladbogo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5010835?s=80&v=4"},"commit":{"message":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS.\n\nRename some threads to workaround this restrictions,\ne.g \"rpl_parallel_thread\"->\"rpl_parallel\",\n\"slave_background\" -> \"slave_bg\" etc.","shortMessageHtmlLink":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS."}},{"before":null,"after":"9923b3d18ad2e8c80b1b28d425311e5ef6859822","ref":"refs/heads/preview-11.6-preview-vlad","pushedAt":"2024-06-12T15:59:16.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"vladbogo","name":"Vlad Bogolin","path":"/vladbogo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5010835?s=80&v=4"},"commit":{"message":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS.\n\nRename some threads to workaround this restrictions,\ne.g \"rpl_parallel_thread\"->\"rpl_parallel\",\n\"slave_background\" -> \"slave_bg\" etc.","shortMessageHtmlLink":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS."}},{"before":"d40ef378acbea8c5dd20827c9f45ff22ccbb444b","after":"8a7e8559a49d4d739938515fbf7caf59419b85ae","ref":"refs/heads/bb-11.6-MDEV-32618-auth-plugin","pushedAt":"2024-06-12T15:12:03.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"FooBarrior","name":"Nikita Malyavin","path":"/FooBarrior","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/394249?s=80&v=4"},"commit":{"message":"use random and secure random numbers in release","shortMessageHtmlLink":"use random and secure random numbers in release"}},{"before":"f1d154c2e192ea2aa4a93cdffa48ab9761708601","after":"9923b3d18ad2e8c80b1b28d425311e5ef6859822","ref":"refs/heads/preview-11.6-preview","pushedAt":"2024-06-12T14:11:33.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"sanja-byelkin","name":"Oleksandr \"Sanja\" Byelkin","path":"/sanja-byelkin","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1267602?s=80&v=4"},"commit":{"message":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS.\n\nRename some threads to workaround this restrictions,\ne.g \"rpl_parallel_thread\"->\"rpl_parallel\",\n\"slave_background\" -> \"slave_bg\" etc.","shortMessageHtmlLink":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS."}},{"before":"9e6fac74db01a0c18c83bb55b43e0fff0a35f8b7","after":"d40ef378acbea8c5dd20827c9f45ff22ccbb444b","ref":"refs/heads/bb-11.6-MDEV-32618-auth-plugin","pushedAt":"2024-06-12T13:36:31.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"FooBarrior","name":"Nikita Malyavin","path":"/FooBarrior","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/394249?s=80&v=4"},"commit":{"message":"WOOF LIKE A DOG","shortMessageHtmlLink":"WOOF LIKE A DOG"}},{"before":"3bc148ff5cc918463b9dee474f8d1aeb6fe45181","after":"3d86fd8ffbf1525a041942763638c4f4abd435b8","ref":"refs/heads/bb-11.6-MDEV-32537-thread-names","pushedAt":"2024-06-12T13:32:54.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"vaintroub","name":"Vladislav Vaintroub","path":"/vaintroub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1708204?s=80&v=4"},"commit":{"message":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS.\n\nRename some threads to workaround this restrictions,\ne.g \"rpl_parallel_thread\"->\"rpl_parallel\",\n\"slave_background\" -> \"slave_bg\" etc.","shortMessageHtmlLink":"MDEV-32537 due to Linux, restrict thread name 15 characters, also in PS."}},{"before":"e7e7f67a56f0caba85cf19c313c3ca2c4452cb3e","after":"3a9b15929cec0c88145fa3a09aaf3461112b9951","ref":"refs/heads/bb-11.6-MDEV-32887-vector","pushedAt":"2024-06-12T13:14:35.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"vuvova","name":"Sergei Golubchik","path":"/vuvova","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2737648?s=80&v=4"},"commit":{"message":"mhnsw: SIMD for euclidean distance","shortMessageHtmlLink":"mhnsw: SIMD for euclidean distance"}},{"before":null,"after":"8344348e44a050f398ee68cb8549256052b1a321","ref":"refs/heads/bb-10.5-bar-MDEV-34376","pushedAt":"2024-06-12T12:59:05.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"abarkov","name":"Alexander Barkov","path":"/abarkov","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7777469?s=80&v=4"},"commit":{"message":"MDEV-34376 Wrong data types when mixing an utf8 *TEXT column and a short binary\n\nA mixuture of a multi-byte *TEXT column and a short binary\nproduced a too large column.\nFor example, COALESCE(tinytext_utf8mb4, short_varbinary)\nproduced a BLOB column instead of an expected TINYBLOB.\n\n- Adding a virtual method Type_all_attributes::character_octet_length(),\n returning max_length by default.\n- Overriding Item_field::character_octet_length() to extract\n the octet length from the underlying Field.\n- Overriding Item_ref::character_octet_length() to extract\n the octet length from the references Item (e.g. as VIEW fields).\n- Fixing Type_numeric_attributes::find_max_octet_length() to\n take the octet length using the new method character_octet_length()\n instead of accessing max_length directly.","shortMessageHtmlLink":"MDEV-34376 Wrong data types when mixing an utf8 *TEXT column and a sh…"}},{"before":"801b61b1b6434251fa514536d4805ac9a686ab6c","after":"f1d154c2e192ea2aa4a93cdffa48ab9761708601","ref":"refs/heads/preview-11.6-preview","pushedAt":"2024-06-12T12:25:12.000Z","pushType":"push","commitsCount":5,"pusher":{"login":"sanja-byelkin","name":"Oleksandr \"Sanja\" Byelkin","path":"/sanja-byelkin","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1267602?s=80&v=4"},"commit":{"message":"MDEV-33627 : Implement option --dir in mariadb-import\n\nWith that, it is possible to restore the full \"instance\" from a backup\nmade with mariadb-dump --dir\n\nThe patch implements executing DDL (tables, views, triggers) using\nstatements that are stored in .sql file, created by mariadb-dump\n--dir/--tab.\n\nCare is taken of creating triggers correctly after the data is loaded,\ndisabling foreign keys and unique key checks etc.\n\nThe files are loaded in descending order by datafile size -\nto ensure better work distribution when running with --parallel option.\n\nIn addition to --dir option, following options are implemented for\npartial restore\n\ninclude-only options:\n--database - import one or several databases\n--table - import one or several tables\n\nexclude options:\n--ignore-database -. ignore one or several databases when importing\n--ignore-table - to ignore one or several tables when importing\n\nAll options above are only valid together with --dir option,\nand can be specified multiple times.","shortMessageHtmlLink":"MDEV-33627 : Implement option --dir in mariadb-import"}},{"before":null,"after":"b40f9d3d5c5d671e57c0ececfab3e5f659645711","ref":"refs/heads/11.2-MDEV-34374","pushedAt":"2024-06-12T12:20:27.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Thirunarayanan","name":"Thirunarayanan B","path":"/Thirunarayanan","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4223360?s=80&v=4"},"commit":{"message":"MDEV-34374 Shrinking tablespace logic fails to handle error condition\n\n- InnoDB ignores the error while traversing the used\nextents during shrinking process. Made changes in\nfsp_traverse_extents() to handle error condition\ncorrectly","shortMessageHtmlLink":"MDEV-34374 Shrinking tablespace logic fails to handle error condition"}},{"before":"66094e0ac286244a93de08c3939d0fddb1aa34d6","after":"7f81410ddd6b9a4eff4b96c1ee888685a66fcbf0","ref":"refs/heads/bb-11.6-wlad-MDEV-33627","pushedAt":"2024-06-12T11:33:02.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"vaintroub","name":"Vladislav Vaintroub","path":"/vaintroub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1708204?s=80&v=4"},"commit":{"message":"MDEV-33627 : Implement option --dir in mariadb-import\n\nWith that, it is possible to restore the full \"instance\" from a backup\nmade with mariadb-dump --dir\n\nThe patch implements executing DDL (tables, views, triggers) using\nstatements that are stored in .sql file, created by mariadb-dump\n--dir/--tab.\n\nCare is taken of creating triggers correctly after the data is loaded,\ndisabling foreign keys and unique key checks etc.\n\nThe files are loaded in descending order by datafile size -\nto ensure better work distribution when running with --parallel option.\n\nIn addition to --dir option, following options are implemented for\npartial restore\n\ninclude-only options:\n--database - import one or several databases\n--table - import one or several tables\n\nexclude options:\n--ignore-database -. ignore one or several databases when importing\n--ignore-table - to ignore one or several tables when importing\n\nAll options above are only valid together with --dir option,\nand can be specified multiple times.","shortMessageHtmlLink":"MDEV-33627 : Implement option --dir in mariadb-import"}},{"before":null,"after":"801b61b1b6434251fa514536d4805ac9a686ab6c","ref":"refs/heads/preview-11.6-preview","pushedAt":"2024-06-12T11:13:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"sanja-byelkin","name":"Oleksandr \"Sanja\" Byelkin","path":"/sanja-byelkin","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1267602?s=80&v=4"},"commit":{"message":"MDEV-19123 Change default charset from latin1 to utf8mb4\n\nChanging the default server character set from latin1 to utf8mb4.","shortMessageHtmlLink":"MDEV-19123 Change default charset from latin1 to utf8mb4"}},{"before":"301f18516469ff9c61359cf51c3ef5e7c37a22ff","after":"10e6f87ca6d3f0c4f999b789f632dd19a23cea56","ref":"refs/heads/10.11-MDEV-33894","pushedAt":"2024-06-12T08:15:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"},"commit":{"message":"squash! 301f18516469ff9c61359cf51c3ef5e7c37a22ff\n\nAttempt to fix the innodb.log_file_size_online failure. The log is still\noccasionally being written to the wrong offset.\n\nAlso, enforce the limits on innodb_log_write_ahead_size on startup.\nTODO: cover this with a test.","shortMessageHtmlLink":"squash! 301f185"}},{"before":"fc9005adc454a966dfeaa4fb243f5e3993681cb9","after":null,"ref":"refs/heads/st-10.6-merge","pushedAt":"2024-06-12T08:11:15.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"}},{"before":"d524cb5b3ddf4dfcaf01c989b1d6fc76be854e15","after":null,"ref":"refs/heads/bb-10.5-mdev-34002","pushedAt":"2024-06-12T08:11:15.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"}},{"before":"fcd21d3e40a8739ca6813ac3a098ebf8d5fd5475","after":"fc9005adc454a966dfeaa4fb243f5e3993681cb9","ref":"refs/heads/10.6","pushedAt":"2024-06-12T08:10:46.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"},"commit":{"message":"Merge 10.5 into 10.6","shortMessageHtmlLink":"Merge 10.5 into 10.6"}},{"before":"30aac1d184d34d7f205bce73b29aa96a6ff6f188","after":"bf1f2aee07a01f006b33de088cf6ba2562646a0d","ref":"refs/heads/bb-10.5-mdev-30073-8","pushedAt":"2024-06-12T05:43:18.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"igorbabaev","name":"Igor Babaev","path":"/igorbabaev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7783432?s=80&v=4"},"commit":{"message":"MDEV-30073 Wrong result on 2nd execution of PS for query with NOT EXISTS\n\nThis bug is consequence of a serious architectural flaw of the query\nprocessing at the prepare stage. Context analysis of processed queries has\nto be done at this stage. The important part of this analysis is resolution\nof column references also known as name resolution. The items for column\nreferences used in a query are created by the parser. They are allocated\nin the statement memory because their life span is the same as the life\nspan of the executed query. During name resolution some of the items are\nwrapped into objects belonging to classes derived from the Item_ref class.\nIn many cases we can't do without such wrappers. For example, the parser\ndoes not differentiate between references to columns of base tables and\nreferences to columns of views. However for a reference to a view column\nwe need a pointer to the translation item for this column. This pointer\nis stored in a Item_direct_view_ref object that wraps the item for the\ncolumn reference. Before this patch the wrappers were allocated in\nexecution memory good only for one execution. That wasn't a problem when\nthe query was executed only once. Yet for the queries executed as prepared\nstatements or within a stored procedure it could lead to crashes or wrong\nresult sets at the second execution of the query. It could happen when\nthe wrapped item was substituted for something else by permanent\ntransformations during the optimization phase.\n\nThis patch allocates all the wrappers around items created for column\nreferences in the statement memory at the first execution of PS or at the\nfirst call of SP/SF.","shortMessageHtmlLink":"MDEV-30073 Wrong result on 2nd execution of PS for query with NOT EXISTS"}},{"before":"f898ee3e2a53c6718a91419c64834626ffff3055","after":null,"ref":"refs/heads/10.5-MDEV-34365","pushedAt":"2024-06-12T05:39:48.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"}},{"before":"f2eda615798d6d879a913a44c22d5dd0fc7ed8c9","after":"d3a7e46bb46d1347c6d2738590d177e463376f56","ref":"refs/heads/10.5","pushedAt":"2024-06-12T05:39:41.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dr-m","name":"Marko Mäkelä","path":"/dr-m","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20552695?s=80&v=4"},"commit":{"message":"MDEV-34365: UBSAN runtime error: call to function io_callback(tpool::aiocb*)\n\nOn an UBSAN clang-15 build, if running with UBSAN option\nhalt_on_error=1 (the issue doesn't show up without it),\nMTR fails during mysqld --bootstrap with UBSAN error:\n\ncall to function io_callback(tpool::aiocb*) through pointer to incorrect function type 'void (*)(void *)'\n\nThis patch corrects the parameter type of io_callback\nto match its expected type defined by callback_func,\ni.e. (void*).\n\nReviewed By:\n============\n","shortMessageHtmlLink":"MDEV-34365: UBSAN runtime error: call to function io_callback(tpool::…"}},{"before":null,"after":"30aac1d184d34d7f205bce73b29aa96a6ff6f188","ref":"refs/heads/bb-10.5-mdev-30073-8","pushedAt":"2024-06-12T05:35:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"igorbabaev","name":"Igor Babaev","path":"/igorbabaev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7783432?s=80&v=4"},"commit":{"message":"MDEV-30073 Wrong result on 2nd execution of PS for query with NOT EXISTS\n\nThis bug is consequence of a serious architectural flaw of the query\nprocessing at the prepare stage. Context analysis of processed queries has\nto be done at this stage. The important part of this analysis is resolution\nof column references also known as name resolution. The items for column\nreferences used in a query are created by the parser. They are allocated\nin the statement memory because their life span is the same as the life\nspan of the executed query. During name resolution some of the items are\nwrapped into objects belonging to classes derived from the Item_ref class.\nIn many cases we can't do without such wrappers. For example, the parser\ndoes not differentiate between references to columns of base tables and\nreferences to columns of views. However for a reference to a view column\nwe need a pointer to the translation item for this column. This pointer\nis stored in a Item_direct_view_ref object that wraps the item for the\ncolumn reference. Before this patch the wrappers were allocated in\nexecution memory good only for one execution. That wasn't a problem when\nthe query was executed only once. Yet for the queries executed as prepared\nstatements or within a stored procedure it could lead to crashes or wrong\nresult sets at the second execution of the query. It could happen when\nthe wrapped item was substituted for something else by permanent\ntransformations during the optimization phase.\n\nThis patch allocates all the wrappers around items created for column\nreferences in the statement memory at the first execution of PS or at the\nfirst call of SP/SF.","shortMessageHtmlLink":"MDEV-30073 Wrong result on 2nd execution of PS for query with NOT EXISTS"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEY8aK6wA","startCursor":null,"endCursor":null}},"title":"Activity · MariaDB/server"}