{"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\/sq\/blog\/news\/vypusk-subd-mysql-9-3-0","title":{"rendered":"L\u00ebshimi i DBMS MySQL 9.3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb DBMS MySQL 9.3.0. Nd\u00ebrtimet MySQL Community Server 9.3.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha shp\u00ebrndarjet kryesore t\u00eb Linux, FreeBSD, macOS dhe Windows. N\u00eb p\u00ebrputhje me modelin e ri t\u00eb formimit t\u00eb l\u00ebshimeve t\u00eb implementuar n\u00eb vitin 2023, MySQL 9.3 \u00ebsht\u00eb renditur n\u00eb deg\u00ebt \"Innovation\". Deg\u00ebt Innovation rekomandohen p\u00ebr ata q\u00eb d\u00ebshirojn\u00eb t\u00eb ken\u00eb akses m\u00eb her\u00ebt n\u00eb funksionalitete t\u00eb reja, publikohen \u00e7do 3 muaj dhe mbahen vet\u00ebm deri n\u00eb publikimin e l\u00ebshimit t\u00eb ardhsh\u00ebm t\u00eb r\u00ebnd\u00ebsish\u00ebm (p.sh., pas shfaqjes s\u00eb deg\u00ebs 9.3, mb\u00ebshtetja p\u00ebr deg\u00ebn 9.2 do t\u00eb ndalet). N\u00eb ver\u00eb planifikohet t\u00eb formohet l\u00ebshimi LTS 9.4, i rekomanduar p\u00ebr implementime q\u00eb k\u00ebrkojn\u00eb parashikueshm\u00ebri dhe ruajtje t\u00eb zbatimit t\u00eb pandryshuar p\u00ebr nj\u00eb periudh\u00eb t\u00eb gjat\u00eb. Pas deg\u00ebs LTS do t\u00eb formohet nj\u00eb deg\u00eb e re Innovation \u2014 MySQL 10.0. <\/p>\n
Ndryshimet kryesore n\u00eb MySQL 9.3: <\/p>\n
\n
N\u00eb utilitarin mysqldump \u00ebsht\u00eb shtuar opsioni \"--users\" p\u00ebr t\u00eb krijuar kopje t\u00eb logjike me informacion mbi t\u00eb gjitha llogarit\u00eb, q\u00eb jepet p\u00ebrmes shprehjeve SQL \"CREATE USER\" dhe \"GRANT\". P\u00ebr t\u00eb futur shprehjen \"DROP USER\" para \"CREATE USER\" \u00ebsht\u00eb parashikuar opsioni \"--add-drop-user\", nd\u00ebrsa p\u00ebr reflektimin selektiv n\u00eb kopje t\u00eb p\u00ebrdoruesve t\u00eb ve\u00e7ant\u00eb \u2014 opsionet \"--include-user=user@host\" dhe \"--exclude-user=user@host\", t\u00eb cilat mund t\u00eb specifikohen disa her\u00eb.\n
N\u00eb motorin MLE (Komponenti Multilingual Engine), q\u00eb lejon p\u00ebrdorimin e kodeve n\u00eb gjuh\u00eb t\u00eb tjera nga SQL n\u00eb procedurat dhe funksionet e ruajtura, \u00ebsht\u00eb p\u00ebrmir\u00ebsuar mb\u00ebshtetja p\u00ebr JavaScript. P\u00ebr procedurat e ruajtur n\u00eb gjuh\u00ebn JavaScript \u00ebsht\u00eb realizuar lloji \"DECIMAL\", i cili mund t\u00eb p\u00ebrdoret p\u00ebr argumentet hyr\u00ebse dhe kthyese. N\u00eb m\u00ebnyr\u00eb t\u00eb paracaktuar, p\u00ebr siguri, lloji MySQL DECIMAL konvertohet n\u00eb llojin JavaScript \"String\", por ky q\u00ebndrim mund t\u00eb tejkalohet nga komanda 'SELECT mle_set_session_state('{\"decimal_type\":\"Number\"}')', pas s\u00eb cil\u00ebs do t\u00eb p\u00ebrdoret lloji JavaScript \"Number\". Mb\u00ebshtetet konvertimi n\u00eb llojin DECIMAL t\u00eb vlerave me llojet JavaScript Boolean, Number, String dhe BigInt.\n
N\u00eb procedurat e ruajtura n\u00eb JavaScript \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr caktimin e paramet\u00ebrve t\u00eb lokalizimit, duke p\u00ebrdorur API-n\u00eb JavaScript Intl. P\u00ebr shembull, p\u00ebr t\u00eb p\u00ebrcaktuar lokalitetin aktual mund t\u00eb p\u00ebrdoren pron\u00ebsit\u00eb \"Intl.DateTimeFormat().resolvedOptions().locale\", nd\u00ebrsa p\u00ebr t\u00eb tejkaluar lokalitetin \u2014 metoda \"toLocaleString()\".\n
Jan\u00eb zgjeruar mund\u00ebsit\u00eb p\u00ebr administrimin e bibliotekave JavaScript: p\u00ebr t\u00eb ndryshuar list\u00ebn e bibliotekave t\u00eb importuara tani mund t\u00eb p\u00ebrdoren shprehjet \u00abALTER PROCEDURE\u00bb dhe \u00abALTER FUNCTION\u00bb. \u00cbsht\u00eb shtuar mund\u00ebsia e p\u00ebrdorimit t\u00eb shprehjes \u00abALTER LIBRARY\u00bb p\u00ebr t\u00eb shtuar, hequr ose ndryshuar komentin SQL p\u00ebr bibliotek\u00ebn. P\u00ebr t\u00eb marr\u00eb informacion mbi bibliotek\u00ebn, \u00ebsht\u00eb realizuar shprehja \u00abSHOW LIBRARY STATUS\u00bb.\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr ngarkimin dinamik t\u00eb bibliotekave JavaScript. P\u00ebr importimin dinamik t\u00eb bibliotek\u00ebs duhet t\u00eb p\u00ebrdoret fjala ky\u00e7e \u00abawait\u00bb, p\u00ebr shembull \u00ablet module = await import(\u2018\/db1\/lib_${object_type}\u2019)\u00bb.\n
Jan\u00eb zgjeruar optimizimet e pyetjes q\u00eb p\u00ebrdorin operator\u00eb t\u00eb kualifikuar krahasimi. P\u00ebrve\u00e7 mb\u00ebshtetjes p\u00ebr operator\u00ebt \u00ab=ANY\u00bb dhe \u00abALL\u00bb gjat\u00eb optimizimit t\u00eb n\u00ebnpyetjeve, n\u00eb versionin e ri \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr operator\u00ebt \u00ab>ANY\u00bb, \u00ab>=ANY\u00bb, \u00ab<ANY\u00bb, \u00abALL\u00bb, \u00ab>=ALL\u00bb, \u00ab<ALL\u00bb dhe \u00ab<=ALL\u00bb.\n
\u00cbsht\u00eb hequr plugini \u00abversion_tokens\u00bb, i cili m\u00eb par\u00eb ishte shpallur i skaduar.\n
Jan\u00eb eliminuar 28 vulnerabilitete, nga t\u00eb cilat 26 mund t\u00eb shfryt\u00ebzohen n\u00eb distanc\u00eb n\u00ebse ka akses p\u00ebr t\u00eb d\u00ebrguar k\u00ebrkesa n\u00eb DBMS. Gjasht\u00eb problemet m\u00eb serioze kan\u00eb nj\u00eb nivel rreziku 6.5 dhe lidhen me vulnerabilitetet n\u00eb motorin InnoDB, parserin dhe optimizuesin. Vulnerabilitetet m\u00eb pak t\u00eb rrezikshme prekin mysqldump, InnoDB, optimizuesin, DDL, UDF, parserin dhe sistemin e replikimit. <\/ul>\n