{"id":121458,"date":"2025-01-23T15:46:10","date_gmt":"2025-01-23T13:46:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-2-0"},"modified":"2025-01-23T15:46:10","modified_gmt":"2025-01-23T13:46:10","slug":"vypusk-subd-mysql-9-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-mysql-9-2-0","title":{"rendered":"Izdavanje SGBD MySQL 9.2.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle je oblikovao novu granu baze podataka MySQL 9.2.0. Gradnje MySQL Community Server 9.2.0 pripremljene su za sve glavne distribucije Linuxa, FreeBSD, macOS i Windows. U okviru nove strategije objave verzija uvedene 2023. godine, MySQL 9.2 je svrstana u grane &#171;Innovation&#187;, u koje \u0107e tako\u0111e biti svrstana i slede\u0107a zna\u010dajna izdanja MySQL 9.3. Innovation grane su preporu\u010dene za one koji \u017eele raniji pristup novim funkcionalnostima, objavljuju se svaka 3 meseca i podr\u017eavaju se samo do objave slede\u0107e zna\u010dajne verzije (na primer, nakon pojave grane 9.2 prestaje podr\u0161ka za granu 9.1). Tokom leta planiraju formiranje LTS izdanja, preporu\u010denog za implementacije kojima su potrebne predvidljivost i dugoro\u010dno o\u010duvanje nepromenjenog pona\u0161anja. Slede\u0107i LTS granu bi\u0107e formirana nova Innovation grana &#8212; MySQL 10.0.        <\/p>\n<p>Glavne promjene u MySQL 9.2:  <\/p>\n<ul>\n<li class=\"l\"> U MLE (Multilingual Engine Component) motor, koji omogu\u0107ava kori\u0161\u0107enje kodova na jezicima razli\u010ditim od SQL u skladi\u0161tenim procedurama i funkcijama, dodata je podr\u0161ka za ponovo kori\u0161\u0107ene biblioteke na JavaScriptu. Funkcije iz tih biblioteka mogu se pozivati iz skladi\u0161tenih procedura na JavaScriptu, ali moraju biti jasno ozna\u010dene kao uvo\u017eene pomo\u0107u klju\u010dne re\u010di &#171;export&#187;. Za upravljanje vezivanjem JavaScript biblioteka dodani su novi SQL izrazi &#171;CREATE LIBRARY&#187; i &#171;DROP LIBRARY&#187;. Za pregled dostupnih JavaScript biblioteka dodat je izraz &#171;SHOW CREATE LIBRARY&#187;. Informacije o JavaScript bibliotekama odra\u017eene su u sistemskoj tabeli &#171;LIBRARIES&#187;, dok se o skladi\u0161tenim procedurama koje koriste takve biblioteke vode u tabeli &#171;ROUTINE_LIBRARIES&#187;. Povezivanje biblioteke u skladi\u0161tenoj proceduri vr\u0161i se putem navo\u0111enja spiska biblioteka u izrazu &#171;USING&#187;.\n<li class=\"l\"> Dodato je API za pristup skladi\u0161tenim procedurama, funkcijama i sesijskim varijablama iz koda napisanog na JavaScriptu. Za pozivanje funkcija MySQL dodat je metod getFunction(), a za skladi\u0161tene procedure &#8212; metod getProcedure(), koji vra\u0107aju JavaScript objekat Function, koji mo\u017ee biti pokrenut sa argumentima. Pristup varijablama vr\u0161i se direktno kao svojstvima JavaScript objekta Session. Dodatno, omogu\u0107eno je direktno pristupanje ugra\u0111enim funkcijama rand(), sleep(), uuid() i isUUID(), koje su ekvivalentne istoimenim SQL funkcijama.\n<li class=\"l\"> Dodana je API za rad s transakcijama iz JavaScripta, koja omogu\u0107uje izvr\u0161avanje ve\u0107ine SQL izraza za rad s transakcijama, kao \u0161to su &#171;START TRANSACTION&#187;, &#171;COMMIT&#187;, &#171;ROLLBACK&#187; i &#171;SET AUTOCOMMIT&#187;.\n<li class=\"l\"> Dodana je mogu\u0107nost kori\u0161\u0107enja MySQL tipova ENUM i SET u argumentima \u010duvanih procedura, napisanih u JavaScript-u.\n<li class=\"l\"> Dodana je privilegija CREATE_SPATIAL_REFERENCE_SYSTEM, koja omogu\u0107uje upravljanje mogu\u0107no\u0161\u0107u stvaranja i brisanja definicija prostorne vezanosti podataka geoinformacijskih sustava. Posjedovanje ove privilegije ili privilegije SUPER sada je obavezno za izvo\u0111enje izraza &#171;CREATE SPATIAL REFERENCE SYSTEM&#187;, &#171;CREATE OR REPLACE SPATIAL REFERENCE SYSTEM&#187; i &#171;DROP SPATIAL REFERENCE SYSTEM&#187;.\n<li class=\"l\"> U izlazu &#171;EXPLAIN FORMAT=JSON&#187; dodane su informacije o verziji JSON formata. Za postavljanje verzije JSON formata treba koristiti varijablu explain_json_format_version (&#171;SET explain_json_format_version=1|2&#187;).\n<li class=\"l\"> Proklamirane su zastarjelim: izraz &#171;FLUSH PRIVILEGES&#187;, komande &#171;mysqladmin flush-privileges&#187; i &#171;mysqladmin reload&#187;, te dodatak &#171;version_tokens&#187;.\n<li class=\"l\"> Prekida podr\u0161ka za klju\u010dnu re\u010d BINLOG.\n<li class=\"l\"> Ispravljeno je 32 ranjivosti, od kojih 3 mogu biti kori\u0161\u0107ene na daljinu. Dve najozbiljnije probleme imaju nivo opasnosti 9.1 i povezane su sa ranjivostima u komponentama Kerberos i Curl. Manje opasne ranjivosti se odnose na InnoDB, Thread Pooling, DDL, optimizator, parser i sistem autentifikacije.     <\/ul>\n<p>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62603\">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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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 \u0440\u0430\u043c\u043a\u0430\u0445 \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\u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, MySQL 9.2 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0442\u0430\u043a\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 MySQL 9.3. 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 [&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-121458","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - 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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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\/sl\/blog\/news\/vypusk-subd-mysql-9-2-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sl_SI\" \/>\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.2.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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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\/sl\/blog\/news\/vypusk-subd-mysql-9-2-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-01-23T13:46:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-01-23T13:46:10+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\udd47Izdanje DBMS MySQL 9.2.0 | ProHoster","description":"Kompanija Oracle je formirala novu granu DBMS MySQL 9.2.0. Buildovi MySQL Community Server 9.2.0 su pripremljeni za sve glavne distribucije Linuxa, FreeBSD, macOS i Windows.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-mysql-9-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","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.2.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.2.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.2.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\/sl\/blog\/news\/vypusk-subd-mysql-9-2-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-01-23T13:46:10+00:00","article:modified_time":"2025-01-23T13:46:10+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"121458","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 09:56:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 09:56:19","updated":"2026-01-23 09:56:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/121458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=121458"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/121458\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=121458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=121458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=121458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}