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 |
| DROP DATABASE | Y |
| RENAME DATABASE | N |
| CREATE TABLE | Y |
| ALTER TABLE | N |
| RENAME TABLE | N |
| DROP TABLE | Y |
| CREATE INDEX | Y |
| DROP INDEX | Y |
| MODIFY COLUMN | N |
| PRIMARY KEY | Y |
| CREATE VIEW | Y |
| ALTER VIEW | Y |
| DROP VIEW | Y |
| CREATE OR REPLACE VIEW | N |
| TRUNCATE | Y |
| SEQUENCE | N |
| AUTO_INCREMENT | Y |
| Temporary tables | Y |
SQL statements
| 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 | N |
Data types
| Data type categories | Data types | Supported(Y)/Not supported (N) |
|---|
| Integer Numbers | TINYINT | Y |
| SMALLINT | Y |
| INT | Y |
| BIGINT | Y |
| TINYINT UNSIGNED | Y |
| SMALLINT UNSIGNED | Y |
| INT UNSIGNED | Y |
| BIGINT UNSIGNED | Y |
| Real Numbers | FLOAT | Y |
| DOUBLE | Y |
| String Types | CHAR | Y |
| VARCHAR | Y |
| TINYTEXT | Y |
| TEXT | Y |
| MEDIUMTEXT | Y |
| LONGTEXT | Y |
| Binary Types | TINYBLOB | Y |
| BLOB | Y |
| MEDIUMBLOB | Y |
| LONGBLOB | Y |
| Time and Date Types | Date | Y |
| Time | Y |
| DateTime | Y |
| Timestamp | Y |
| Boolean Type | BOOL | Y |
| Decimal Type | DECIMAL | Y |
| JSON Type | JSON | Y |
Indexing and constraints
| 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 | Y |
| Enforced Constraints on Invalid Data | Y |
| ENUM and SET Constraints | N |
| NOT NULL Constraint | Y |
Transactions
| Transactions | Supported(Y)/Not supported (N) |
|---|
| 1PC | Y |
| Pessimistic transactions | N |
| Optimistic transactions | Y |
| Distributed Transaction | Y |
| Snapshot Isolation | Y |
Functions and Operators
| Functions and Operators Categories | Name |
|---|
| Aggregate functions | AVG() |
| MAX() |
| MIN() |
| Median() |
| SUM() |
| ANY_VALUE() |
| BIT_OR() |
| BIT_AND() |
| BIT_XOR() |
| STD() |
| VARIANCE() |
| GROUP_CONCAT() |
| SLEEP() |
| Mathematical functions | ABS() |
| SIN() |
| COS() |
| TAN() |
| COT() |
| ACOS() |
| ATAN() |
| SINH() |
| FLOOR() |
| ROUND() |
| CEIL() |
| POWER() |
| PI() |
| LOG() |
| LN() |
| UUID() |
| EXP() |
| Datetime functions | 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() |
| String functions | 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() |
| Operators | %, 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 |
我的书签
添加书签
移除书签
