mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
9e1fb104a3
-----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEF39AEP5WyjM2MAMF8WVvJMdM0dgFAmck77AACgkQ8WVvJMdM 0dgccQ/+Lls8fWt4D+gMPP7x+drJSO/IE/gZFt3ugbWF+/p3B2xXAs5AAE83wxEh QSbp4DCkb/9PnuakhLmzg0lFbxMUlh4rsJ1YyiuLB2J+YgKbAc36eQQf+rtYSipd DT5uRk36c9wOcOXo/mMv4APEvpPXBIBdIL4VvpKFbIOE7xT24Sp767zWXdXqrB1f JgOQdM2ct+bvSPC55oZ5p1kqyxwvd6K6+3RB3CIpwW9zrVSLg7enT3maLjj/761s jvlRae+Cv+r+Hit9XpmEH6n2FYVgIJ3o3WhdAHwN0kxKabXYTg7OCB7QxDZiUHI9 C/5goKmKaPB1PCQyuTQyLSyyK9a8nPfgn6tqw/p/ZKDQhKT9sWJv/5bSWecrVndx LLYifSTrFC/eXLzgPvCnNv/U8SjsZaAdMIKS681+qDJ0P5abghUIlGnMYTjYXuX1 1B6Vrr0bdrQ3V1CLB3tpkRjpUvicrsabtuAUAP65QnEG2G9UJXklOer+DE291Gsl f1I0o6C1zVGAOkUUD3QEYaHD8w7hlvyfKme5oXKUm3DOjaAar5UUKLdr6prxRZL4 ebhmGEy42Mf8fBYoeohIxmxgvv6h2Xd9xCukgPp8hFpqJGw8abg7JNZTTKH4h2IY J51RpD10h4eoi6WRn3opEcjexTGvZ+xNR7yYO5WxWw6VIre9IUA= =s+WW -----END PGP SIGNATURE----- Merge tag '11.4' into 11.6 MariaDB 11.4.4 release
106 lines
6.1 KiB
Text
106 lines
6.1 KiB
Text
/*M!999999\- enable the sandbox mode */
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sv_basic` (
|
|
`a` int(11) NOT NULL,
|
|
PRIMARY KEY (`a`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*M!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
|
INSERT INTO `sv_basic` (`a`, row_start, row_end) VALUES (1,'2023-12-19 14:23:22.304434','2038-01-19 03:14:07.999999'),
|
|
(2,'2023-12-19 14:23:22.304434','2023-12-19 14:23:22.305292'),
|
|
(3,'2023-12-19 14:23:22.304434','2038-01-19 03:14:07.999999');
|
|
/*M!101100 SET system_versioning_insert_history=@old_system_versioning_insert_history */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sv_explicit` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`row_foo_start` timestamp(6) GENERATED ALWAYS AS ROW START,
|
|
`row_foo_end` timestamp(6) GENERATED ALWAYS AS ROW END,
|
|
PERIOD FOR SYSTEM_TIME (`row_foo_start`, `row_foo_end`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*M!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
|
INSERT INTO `sv_explicit` VALUES
|
|
(1,'2023-12-19 14:23:22.358302','2038-01-19 03:14:07.999999'),
|
|
(2,'2023-12-19 14:23:22.358302','2023-12-19 14:23:22.359113'),
|
|
(3,'2023-12-19 14:23:22.358302','2038-01-19 03:14:07.999999');
|
|
/*M!101100 SET system_versioning_insert_history=@old_system_versioning_insert_history */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sv_partition` (
|
|
`a` int(11) NOT NULL,
|
|
PRIMARY KEY (`a`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING
|
|
PARTITION BY SYSTEM_TIME
|
|
(PARTITION `p_hist` HISTORY ENGINE = MyISAM,
|
|
PARTITION `p_cur` CURRENT ENGINE = MyISAM);
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*M!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
|
INSERT INTO `sv_partition` (`a`, row_start, row_end) VALUES (2,'2023-12-19 14:23:22.331143','2023-12-19 14:23:22.332359'),
|
|
(1,'2023-12-19 14:23:22.331143','2038-01-19 03:14:07.999999'),
|
|
(3,'2023-12-19 14:23:22.331143','2038-01-19 03:14:07.999999');
|
|
/*M!101100 SET system_versioning_insert_history=@old_system_versioning_insert_history */;
|
|
/*M!999999\- enable the sandbox mode */
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sv_basic` (
|
|
`a` int(11) NOT NULL,
|
|
PRIMARY KEY (`a`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*M!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
|
INSERT INTO `sv_basic` (`a`, row_start, row_end) VALUES (1,'2023-12-19 14:23:22.304434','2106-02-07 06:28:15.999999'),
|
|
(2,'2023-12-19 14:23:22.304434','2023-12-19 14:23:22.305292'),
|
|
(3,'2023-12-19 14:23:22.304434','2106-02-07 06:28:15.999999');
|
|
/*M!101100 SET system_versioning_insert_history=@old_system_versioning_insert_history */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sv_explicit` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`row_foo_start` timestamp(6) GENERATED ALWAYS AS ROW START,
|
|
`row_foo_end` timestamp(6) GENERATED ALWAYS AS ROW END,
|
|
PERIOD FOR SYSTEM_TIME (`row_foo_start`, `row_foo_end`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*M!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
|
INSERT INTO `sv_explicit` VALUES
|
|
(1,'2023-12-19 14:23:22.358302','2106-02-07 06:28:15.999999'),
|
|
(2,'2023-12-19 14:23:22.358302','2023-12-19 14:23:22.359113'),
|
|
(3,'2023-12-19 14:23:22.358302','2106-02-07 06:28:15.999999');
|
|
/*M!101100 SET system_versioning_insert_history=@old_system_versioning_insert_history */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sv_partition` (
|
|
`a` int(11) NOT NULL,
|
|
PRIMARY KEY (`a`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING
|
|
PARTITION BY SYSTEM_TIME
|
|
(PARTITION `p_hist` HISTORY ENGINE = MyISAM,
|
|
PARTITION `p_cur` CURRENT ENGINE = MyISAM);
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*M!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
|
INSERT INTO `sv_partition` (`a`, row_start, row_end) VALUES (2,'2023-12-19 14:23:22.331143','2023-12-19 14:23:22.332359'),
|
|
(1,'2023-12-19 14:23:22.331143','2106-02-07 06:28:15.999999'),
|
|
(3,'2023-12-19 14:23:22.331143','2106-02-07 06:28:15.999999');
|
|
/*M!101100 SET system_versioning_insert_history=@old_system_versioning_insert_history */;
|
|
test.sv_basic Needs upgrade with ALTER TABLE FORCE
|
|
test.sv_explicit Needs upgrade with ALTER TABLE FORCE
|
|
test.sv_partition Needs upgrade with ALTER TABLE FORCE
|
|
set @@time_zone="+00:00";
|
|
select a,row_end from sv_basic for system_time all;
|
|
a row_end
|
|
1 2106-02-07 06:28:15.999999
|
|
2 2023-12-19 14:23:22.305292
|
|
3 2106-02-07 06:28:15.999999
|
|
select a,row_end from sv_partition for system_time all;
|
|
a row_end
|
|
1 2106-02-07 06:28:15.999999
|
|
2 2023-12-19 14:23:22.332359
|
|
3 2106-02-07 06:28:15.999999
|
|
select a,row_foo_end from sv_explicit for system_time all;
|
|
a row_foo_end
|
|
1 2106-02-07 06:28:15.999999
|
|
2 2023-12-19 14:23:22.359113
|
|
3 2106-02-07 06:28:15.999999
|
|
drop table sv_basic,sv_partition,sv_explicit;
|