Kua tukuna te MariaDB 12.2.2, koinei te tukunga pumau tuatahi o te peka 12.2. Ko te MariaDB 12.2, kua tohua hei tukunga hurihuri, kei te haere tonu te whanaketanga āta o te mahi, ā, kei te whakakapi i te MariaDB 12.1. Ko te MariaDB 12.3.1, he kaitono tukunga mō te peka LTS e haere ake nei, i tukuna i te wā kotahi, me te whakaatu i tētahi whakatinanatanga binlog hou. Ka puritia te MariaDB 12.2 kia tukuna rā anō te tukunga 12.3.2.
Ka whakawhanakehia e te kaupapa MariaDB tētahi marau o MySQL e pupuri ana i te hototahi whakamuri, ā, kei roto hoki te whakaurunga o ngā miihini rokiroki tāpiri me ngā āhuatanga matatau. Ko te MariaDB Foundation motuhake te kaiwhakahaere o te whanaketanga o MariaDB, e whai ana i tētahi tukanga whanaketanga tuwhera, mārama hoki, motuhake mai i ngā kaihoko takitahi. Ka tukuna a MariaDB hei whakakapi mō MySQL i roto i te maha o ngā tohatoha. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ā, kua whakatinanahia i roto i ngā kaupapa nunui pēnei i a Wikipedia, Google Cloud SQL me Nimbuzz.
Ko nga huringa i te peka MariaDB 12.2 ko:
- I roto i te aratau hototahi Oracle DBMS, ka whakatinanahia ngā mahi TO_NUMBER (te huri i tētahi aho ki tētahi tau) me te TRUNC (te tapahi i tētahi rā, hei tauira, ki tētahi hāora, rā, marama, tau rānei).
- I te whakahaere i ngā mahi hanumi ripanga (JOIN), kua whakatinanahia te arotautanga e whai whakaaro ana ki te ahurei o ngā rarangi i roto i ngā uiuinga iti me te kīanga "GROUP BY" hei matapae tika ake i te maha o ngā rarangi ka puta (ngā rarangi_waho) me te whakamahinga tika o ngā taupū.
- Kua tāpirihia ngā kōwhiringa whakahaere arotau hou: ROWID_FILTER/NO_ROWID_FILTER me INDEX_MERGE/NO_INDEX_MERGE, tae atu ki te kaha ki te tohu puku i ngā ingoa poraka i roto i ngā patai (ka taea te whakamahi i ngā kōwhiringa arotau ki ngā wāhanga o ngā patai mā te tohutoro i a rātou mā te ingoa "select#N", ko N te tau poraka). Hei tauira: "select /*+ JOIN_ORDER(@"select#2" twenty,ten) */ …."
- Kua tangohia ngā here i runga i te taumata kōhanga o ngā hanganga i roto i ngā mahi mō te mahi me JSON (kua tangohia te rohenga JSON_DEPTH_LIMIT, i mua ko te uara o 32).
- I tāpirihia he ripanga TRIGGERED_UPDATE_COLUMNS ki te kaupapa INFORMATION_SCHEMA (INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS) hei whakaatu i ngā pou ka whakarerekētia ina mura te keu.
- Ka whakatinanahia e te ripanga PARAMETERS i roto i te kaupapa INFORMATION_SCHEMA tētahi pou PARAMETER_DEFAULT kei roto ngā uara taunoa o ngā tawhā tukanga kua rongoatia.
- Kua whakatinanahia te tautoko whakamātautau mō te tauākī "HANGAIA TE TAPUTAPU WĀTEA AO" mō te waihanga i ngā ripanga rangitahi ā-ao. Ka tangohia ēnei ripanga rangitahi i muri i te mutunga o te wātū, ā, ka kitea e ngā kaiwhakamahi katoa, engari kei roto ngā raraunga e pā ana ki ia kaiwhakamahi.
- Kei te aratau whakamātautau te tautoko pai ake mō te tāruarua i waenga i ngā ripanga me ngā hanganga rerekē.
Source: opennet.ru
