mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
93 lines
3 KiB
Text
93 lines
3 KiB
Text
set sql_mode=ansi_quotes;
|
|
create table t1 ("select" int) partition by range ("select") (partition "select" values less than maxvalue);
|
|
create table t2 (f1 int) partition by range (f1) (partition p1 values less than maxvalue);
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE "t1" (
|
|
"select" int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE ("select")
|
|
(PARTITION "select" VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
show create table t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE "t2" (
|
|
"f1" int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE ("f1")
|
|
(PARTITION "p1" VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
set sql_quote_show_create=0;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE t1 (
|
|
"select" int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE ("select")
|
|
(PARTITION "select" VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
show create table t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE t2 (
|
|
f1 int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (f1)
|
|
(PARTITION p1 VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
set sql_mode=default;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE t1 (
|
|
`select` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (`select`)
|
|
(PARTITION `select` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
show create table t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE t2 (
|
|
f1 int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (f1)
|
|
(PARTITION p1 VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
set sql_quote_show_create=1;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`select` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (`select`)
|
|
(PARTITION `select` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
show create table t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE `t2` (
|
|
`f1` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (`f1`)
|
|
(PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
flush tables;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`select` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (`select`)
|
|
(PARTITION `select` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
show create table t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE `t2` (
|
|
`f1` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE (`f1`)
|
|
(PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
set sql_mode=ansi_quotes;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE "t1" (
|
|
"select" int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE ("select")
|
|
(PARTITION "select" VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
show create table t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE "t2" (
|
|
"f1" int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
PARTITION BY RANGE ("f1")
|
|
(PARTITION "p1" VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
|
drop table t1, t2;
|