MatrixOne 功能列表

本文档列出了 MatrixOne 最新版本所支持的功能。

数据定义语言(Data definition language, DDL)

数据定义语言 (DDL)支持(Y)/不支持(N)
CREATE DATABASEY
DROP DATABASEY
RENAME DATABASEN
CREATE TABLEY
ALTER TABLEN
RENAME TABLEN
DROP TABLEY
CREATE INDEXY
DROP INDEXY
MODIFY COLUMNN
PRIMARY KEYY
CREATE VIEWY
ALTER VIEWY
DROP VIEWY
CREATE OR REPLACE VIEWN
TRUNCATEN
SEQUENCEN
AUTO_INCREMENTY
Temporary tablesY

SQL 语句

SQL 语句支持(Y)/不支持(N)
SELECTY
INSERTY
UPDATEY
DELETEY
REPLACEN
INSERT ON DUPLICATE KEYN
LOAD DATA INFILEY
SELECT INTO OUTFILEY
INNER/LEFT/RIGHT/OUTER JOINY
UNION, UNION ALLY
EXCEPT, INTERSECTY
GROUP BY, ORDER BYY
Common Table Expressions(CTE)Y
START TRANSACTION, COMMIT, ROLLBACKY
EXPLAINY
EXPLAIN ANALYZEY
Stored ProcedureN
TriggerN
Event SchedulerN
PARTITION BYY
LOCK TABLEN

数据类型

数据类型分类数据类型支持(Y)/不支持(N)
整数类型TINYINTY
SMALLINTY
INTY
BIGINTY
TINYINT UNSIGNEDY
SMALLINT UNSIGNEDY
INT UNSIGNEDY
BIGINT UNSIGNEDY
浮点类型FLOATY
DOUBLEY
字符串类型CHARY
VARCHARY
TINYTEXT/TEXT/MEDIUMTEXT/LONGTEXTY
二进制类型TINYBLOB/BLOB/MEDIUMBLOB/LONGBLOBY
时间与日期DateY
TimeY
DateTimeY
TimestampY
BooleanBOOLY
定点类型DECIMALY
JSON 类型JSONY

索引与约束

索引与约束支持(Y)/不支持(N)
主键约束Y
复合主键Y
唯一约束Y
Secondary KEYY,仅语法实现
外键约束Y
无效数据强制约束Y
ENUM 和 SET 约束N
非空约束Y

事务

事务支持(Y)/不支持(N)
1PCY
悲观事务N
乐观事务Y
分布式事务Y
隔离级别Y

函数与操作符

函数与操作符名称
聚合函数AVG()
COUNT()
MAX()
MIN()
Median()
SUM()
ANY_VALUE()
BIT_OR()
BIT_AND()
BIT_XOR()
STD()
VARIANCE()
GROUP_CONCAT()
SLEEP()
数学类ABS()
SIN()
COS()
TAN()
COT()
ACOS()
ATAN()
SINH()
FLOOR()
ROUND()
CEIL()
POWER()
PI()
LOG()
LN()
UUID()
EXP()
日期时间类DATE_FORMAT()
YEAR()
MONTH()
DATE()
WEEKDAY()
TIMESTAMP()
DAYOFYEAR()
EXTRACT()
DATE_ADD()
DATE_SUB()
TO_DATE()
DAY()
UNIX_TIMESTAMP()
FROM_UNIXTIME()
UTC_TIMESTAMP()
NOW()
CURRENT_TIMESTAMP()
DATEDIFF()
TIMEDIFF()
CURDATE()
字符串类BIN()
BIT_LENGTH()
HEX()
CONCAT()
CONCAT_WS()
FIND_IN_SET()
FORMAT()
OCT()
EMPTY()
LENGTH()
BIT_LENGTH()
LENGTHUTF8()
CHAR_LENGTH()
LEFT()
TRIM()
LTRIM()
RTRIM()
LPAD()
RPAD()
STARTSWITH()
ENDSWITH()
SUBSTRING()
SPACE()
REVERSE()
SUBSTRING_INDEX()
FIELD()
操作符%, MOD
*
+
-
/
Div
=
&
>>
<<
^
|
~
CAST()
CONVERT()
>
>=
<
<>, !=
<=
=
LIKE
BETWEEN … AND …
IN()
IS/IS NOT
IS/IS NOT NULL
NOT BETWEEN … AND …
LIKE
NOT LIKE
COALESCE()
CASE…WHEN
IF
AND
OR
XOR
NOT