{"id":123615,"date":"2025-04-20T09:05:07","date_gmt":"2025-04-20T07:05:07","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-3-0"},"modified":"2025-04-20T09:05:07","modified_gmt":"2025-04-20T07:05:07","slug":"vypusk-subd-mysql-9-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-subd-mysql-9-3-0","title":{"rendered":"Izlazak DBMS-a MySQL 9.3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Tvrtka Oracle je formirala novu granu sustava baza podataka MySQL 9.3.0. Izgradnje MySQL Community Server 9.3.0 pripremljene su za sve glavne distribucije Linuxa, FreeBSD, macOS i Windows. U skladu s novom modelom izdavanja koji je uveden 2023. godine, MySQL 9.3 je svrstan u 'Innovation' grane. Innovation grane su preporu\u010dene za one koji \u017eele raniji pristup novim funkcionalnostima, objavljuju se svaka 3 mjeseca i podr\u017eavaju se samo do objave sljede\u0107e zna\u010dajne verzije (na primjer, nakon pojave grane 9.3 prestaje podr\u0161ka za granu 9.2). Ljeti planiraju formirati LTS verziju 9.4, preporu\u010denu za implementacije kojima su potrebna predvidljivost i dugotrajno o\u010duvanje nepromijenjenog pona\u0161anja. Nakon LTS grane formirat \u0107e se nova Innovation grana \u2014 MySQL 10.0.        <\/p>\n<p>Glavne promjene u MySQL 9.3:  <\/p>\n<ul>\n<li class=\"l\"> U alat mysqldump dodana je opcija '--users' za stvaranje logi\u010dkih dumpova s informacijama o svim korisni\u010dkim ra\u010dunima, prikazanih putem SQL izraza 'CREATE USER' i 'GRANT'. Za umetanje izraza 'DROP USER' ispred 'CREATE USER' predvi\u0111ena je opcija '--add-drop-user', a za selektivno odra\u017eavanje odre\u0111enih korisnika u dumpu \u2014 opcije '--include-user=user@host' i '--exclude-user=user@host', koje se mogu navesti vi\u0161e puta.\n<li class=\"l\"> U motoru MLE (Multilingual Engine Component), koji omogu\u0107ava kori\u0161tenje jezika osim SQL-a u pohranjenim procedurama i funkcijama, pobolj\u0161ana je podr\u0161ka za JavaScript. Za pohranjene procedure na jeziku JavaScript implementiran je tip 'DECIMAL', koji se mo\u017ee koristiti za ulazne i povratne argumente. Zadano, radi sigurnosti, MySQL tip DECIMAL pretvara se u JavaScript tip 'String', ali se ovo pona\u0161anje mo\u017ee nadja\u010dati naredbom \u2018SELECT mle_set_session_state(\u2018{'decimal_type':'Number'}\u2019)\u2019, nakon \u010dega \u0107e se koristiti JavaScript tip 'Number'. Podr\u017eava se pretvaranje u tip DECIMAL vrijednosti s JavaScript tipovima Boolean, Number, String i BigInt.\n<li class=\"l\"> U pohranjene procedure na JavaScript dodana je podr\u0161ka za postavljanje parametara lokalizacije, koriste\u0107i JavaScript API Intl. Na primjer, za odre\u0111ivanje trenuta\u010dne lokalne postavke mo\u017ee se koristiti svojstvo 'Intl.DateTimeFormat().resolvedOptions().locale', a za preure\u0111ivanje lokalne postavke \u2014 metoda 'toLocaleString()'.\n<li class=\"l\"> Pro\u0161irene su mogu\u0107nosti za upravljanje JavaScript knji\u017enicama: za promjenu popisa uvezenih knji\u017enica sada se mogu koristiti izrazi \u201eALTER PROCEDURE\u201c i \u201eALTER FUNCTION\u201c. Dodana je mogu\u0107nost kori\u0161tenja izraza \u201eALTER LIBRARY\u201c za dodavanje, brisanje ili izmjenu SQL komentara na knji\u017enicu. Za dobivanje informacija o knji\u017enici implementiran je izraz \u201eSHOW LIBRARY STATUS\u201c.\n<li class=\"l\"> Dodana je podr\u0161ka za dinami\u010dko u\u010ditavanje JavaScript knji\u017enica. Za dinami\u010dki uvoz knji\u017enice treba koristiti klju\u010dnu rije\u010d \u201eawait\u201c, na primjer \u201elet module = await import(\u2018\/db1\/lib_${object_type}\u2019)\u201c.\n<li class=\"l\"> Pro\u0161irene su optimizacije upita koji koriste kvantificirane usporedne operatore. Osim podr\u0161ke za operatore \u201e=ANY\u201c i \u201eALL\u201c pri optimizaciji podupitima, u novoj verziji dodana je podr\u0161ka za operatore \u201e&gt;ANY\u201c, \u201e&gt;=ANY\u201c, \u201e&lt;ANY\u201c, \u201eALL\u201c, \u201e&gt;=ALL\u201c, \u201e&lt;ALL\u201c i \u201e&lt;=ALL\u201c.\n<li class=\"l\"> Uklonjen je plugin \u201eversion_tokens\u201c, prethodno ozna\u010den kao zastario.\n<li class=\"l\"> Zabranjeno je postavljanje vrijednosti 0 u sistemsku varijablu replica_parallel_workers.\n<li class=\"l\"> Ispravljeno je 28 ranjivosti, od kojih se 26 mo\u017ee iskoristiti daljinski uz pristup za slanje upita bazi podataka. \u0160est najozbiljnijih problema ima razinu opasnosti 6.5 i povezana su s ranjivostima u InnoDB engineu, parseru i optimizatoru. Manje opasne ranjivosti zahva\u0107aju mysqldump, InnoDB, optimizator, DDL, UDF, parser i sustav replikacije.   <\/ul>\n<p>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=63106\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows. \u0412 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 \u0441 \u0432\u043d\u0435\u0434\u0440\u0451\u043d\u043d\u043e\u0439 \u0432 2023 \u0433\u043e\u0434\u0443 \u043d\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u044c\u044e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, MySQL 9.3 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;. Innovation-\u0432\u0435\u0442\u043a\u0438 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043d\u044b \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0445\u043e\u0447\u0435\u0442 \u0440\u0430\u043d\u044c\u0448\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u043d\u043e\u0432\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u043f\u0443\u0431\u043b\u0438\u043a\u0443\u044e\u0442\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0435 3 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-123615","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-subd-mysql-9-3-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"hr_HR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.3.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-subd-mysql-9-3-0\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2025-04-20T07:05:07+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-04-20T07:05:07+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Izlazak sustava baze podataka MySQL 9.3.0 | ProHoster","description":"Tvrtka Oracle je formirala novu granu sustava baze podataka MySQL 9.3.0. Kompajlacije MySQL Community Server 9.3.0 su pripremljene za sve glavne distribucije Linuxa, FreeBSDa, macOS-a i Windows-a.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-subd-mysql-9-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hr_HR","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.3.0 | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 9.3.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.3.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows.","og:url":"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-subd-mysql-9-3-0","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2025-04-20T07:05:07+00:00","article:modified_time":"2025-04-20T07:05:07+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"123615","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-23 12:19:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 12:19:20","updated":"2026-01-23 12:19:20","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/123615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/comments?post=123615"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/123615\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=123615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=123615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=123615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}