MatrixOne Features

This document lists the features supported by MatrixOne for the latest version.

Data definition language (DDL)

Data definition Language(DDL)	Supported(Y)/Not supported (N)
CREATE DATABASE	Y
RENAME DATABASE	N
DROP DATABASE	Y
CREATE TABLE	Y
ALTER TABLE	N
MODIFY COLUMN	N
RENAME TABLE	N
PRIMARY KEY	Y
CREATE VIEW	Y
ALTER VIEW	N
CREATE OR REPLACE VIEW	N
DROP VIEW	Y
TRUNCATE	Y
SEQUENCE	N
AUTO_INCREMENT	Y
Temporary tables	Y

SQL Statement	Supported(Y)/Not supported (N)
SELECT	Y
INSERT	Y
UPDATE	Y
DELETE	Y
REPLACE	N
INSERT ON DUPLICATE KEY	N
LOAD DATA INFILE	Y
SELECT INTO OUTFILE	Y
INNER/LEFT/RIGHT/OUTER JOIN	Y
UNION, UNION ALL	Y
EXCEPT, INTERSECT	Y
GROUP BY, ORDER BY	Y
Common Table Expressions(CTE)	Y
START TRANSACTION, COMMIT, ROLLBACK	Y
EXPLAIN	Y
EXPLAIN ANALYZE	Y
Stored Procedure	N
Trigger	N
Event Scheduler	N
PARTITION BY	Y
LOCK TABLE	Y

Indexing and constraints	Supported(Y)/Not supported (N)
PRIMARY KEY	Y
Composite PRIMARY KEY	Y
UNIQUE KEY	Y
Secondary KEY	Y, Syntax only implementation
FOREIGN KEY	N
Enforced Constraints on Invalid Data	Y
ENUM and SET Constraints	N
NOT NULL Constraint	Y

Functions and Operators Categories	Name
Aggregate functions	SUM()
	COUNT()
	MAX()
	MIN()
	AVG()
	STD()
	VARIANCE()
	BIT_OR()
	BIT_AND()
	BIT_XOR()
Mathematical functions	ABS()
	SIN()
	COS()
	TAN()
	COT()
	ACOS()
	ATAN()
	SINH()
	FLOOR()
	ROUND()
	CEIL()
	POWER()
	PI()
	LOG()
	LN()
	EXP()
Datetime functions	DATE_FORMAT()
	YEAR()
	MONTH()
	DATE()
	WEEKDAY()
	DAYOFYEAR()
	EXTRACT()
	DATE_ADD()
	DATE_SUB()
	TO_DATE()
	DAY()
	UNIX_TIMESTAMP()
	FROM_UNIXTIME()
	UTC_TIMESTAMP()
	NOW()
	CURRENT_TIMESTAMP()
	DATEDIFF()
	TIMEDIFF()
String functions	BIN()
	CONCAT()
	CONCAT_WS()
	FIND_IN_SET()
	OCT()
	EMPTY()
	LENGTH()
	CHAR_LENGTH()
	LEFT()
	LTRIM()
	RTRIM()
	LPAD()
	RPAD()
	STARTSWITH()
	ENDSWITH()
	SUBSTRING()
	SPACE()
	TRIM
	REVERSE()
	UUID()
Other functions	COALESCE()
	ANY_VALUE()
	CAST()
Operators	=
	<>
	>
	>=
	<
	<=
	LIKE
	+
	-
	*
	/
	Div
	%
	AND
	OR
	XOR
	NOT
	CASE…WHEN
	IF
	IS/IS NOT
	IS/IS NOT NULL