Supported SQL - Revision history

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T10:14:04Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

← Older revision		Revision as of 12:14, 28 August 2026
Line 59:		Line 59:
	== Planner inspection ==		== Planner inspection ==

	<~~code~~>EXPLAIN SELECT ...;		<pre>EXPLAIN SELECT ...;
	EXPLAIN IR SELECT ...;		EXPLAIN IR SELECT ...;
	EXPLAIN REORDER SELECT ...;		EXPLAIN REORDER SELECT ...;
	EXPLAIN PHYSICAL SELECT ...;		EXPLAIN PHYSICAL SELECT ...;
	EXPLAIN COMPILE SELECT ...;</~~code~~>		EXPLAIN COMPILE SELECT ...;</pre>

	See [[Query Planner and Physical Lowering]].		See [[Query Planner and Physical Lowering]].

Carli: /* Planner inspection */

2026-08-28T10:03:52Z

Planner inspection

← Older revision		Revision as of 12:03, 28 August 2026
Line 59:		Line 59:
	== Planner inspection ==		== Planner inspection ==

	<~~syntaxhighlight lang="sql"~~>EXPLAIN SELECT ...;		<code>EXPLAIN SELECT ...;
	EXPLAIN IR SELECT ...;		EXPLAIN IR SELECT ...;
	EXPLAIN REORDER SELECT ...;		EXPLAIN REORDER SELECT ...;
	EXPLAIN PHYSICAL SELECT ...;		EXPLAIN PHYSICAL SELECT ...;
	EXPLAIN COMPILE SELECT ...;</~~syntaxhighlight~~>		EXPLAIN COMPILE SELECT ...;</code>
	See [[~~Query_Planner_and_Physical_Lowering\|~~Query Planner and Physical Lowering]].
			See [[Query Planner and Physical Lowering]].

	<span id="known-limitations"></span>		<span id="known-limitations"></span>

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T09:59:39Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

@@ Line 1: / Line 1: @@
-== Statements ==
+<!-- Copyright (C) 2026 Carl-Philip Haensch -->
-* SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET
+<!-- SPDX-License-Identifier: GPL-3.0-or-later -->
 == Expressions ==
-== Aggregates ==
+MemCP implements SQL NULL/three-valued logic, CASE, COALESCE/NULLIF/IFNULL, arithmetic and bitwise operators, comparisons, BETWEEN, IN lists, LIKE/ILIKE, REGEXP/RLIKE, MATCH…AGAINST compatibility, casts, string functions, mathematical functions, hashes, date/time functions, intervals, and timezone conversion.
-The following aggregates are available:
-* COUNT
+<span id="json"></span>
-* SUM
+== JSON ==
-== Modifiers ==
+MemCP stores declared <code>JSON</code>/<code>JSONB</code> values in a native tagged BSON representation. The MySQL dialect implements JSON validation, type inspection, path extraction, constructors, aggregates, mutation functions, containment/search operations, <code>JSON_TABLE</code>, and the <code>-></code>/<code>->></code> operators. The PostgreSQL dialect provides its corresponding <code>json</code>/<code>jsonb</code> operators, constructors, aggregates, path functions, and set-returning expansion forms. Deterministic path expressions can be materialized and indexed through the ordinary computed-column/index machinery. See [[JSON]] for the detailed compatibility contract and deviations.
-* COLLATE
+<span id="planner-inspection"></span>
-== JSON ==
+<syntaxhighlight lang="sql">EXPLAIN SELECT ...;
-JSON support is documented separately in the [[JSON|MemCP MySQL- and Postgres-compatible JSON SQL]]
+EXPLAIN IR SELECT ...;

Carli at 07:31, 26 August 2026

2026-08-26T07:31:35Z

← Older revision		Revision as of 09:31, 26 August 2026
Line 54:		Line 54:

	* COLLATE		* COLLATE

			== JSON ==
			JSON support is documented separately in the [[JSON\|MemCP MySQL- and Postgres-compatible JSON SQL]]

Carli: /* Statements */

2026-01-26T00:06:51Z

Statements

← Older revision		Revision as of 02:06, 26 January 2026
Line 5:		Line 5:
	* UPDATE SET WHERE		* UPDATE SET WHERE
	* DELETE FROM WHERE		* DELETE FROM WHERE
	* INSERT INTO VALUES ON DUPLICATE KEY UPDATE		* INSERT INTO VALUES ON DUPLICATE KEY UPDATE / INSERT ... ON CONFLICT (PostgreSQL)
			* INSERT IGNORE
	* CREATE TABLE		* CREATE TABLE
	* ALTER TABLE		* ALTER TABLE
Line 38:		Line 39:
	* COALESCE		* COALESCE
	* UNIX_TIMESTAMP		* UNIX_TIMESTAMP
			* LIKE
			* ILIKE

	== Aggregates ==		== Aggregates ==
Line 47:		Line 50:
	* MIN		* MIN
	* MAX		* MAX

			== Modifiers ==

			* COLLATE

Carli: /* Expressions */

2024-05-19T19:27:34Z

Expressions

← Older revision		Revision as of 21:27, 19 May 2024
Line 37:		Line 37:
	* CONCAT		* CONCAT
	* COALESCE		* COALESCE
			* UNIX_TIMESTAMP

	== Aggregates ==		== Aggregates ==

Carli at 15:26, 19 May 2024

2024-05-19T15:26:03Z

← Older revision		Revision as of 17:26, 19 May 2024
Line 1:		Line 1:
			== Statements ==
	The following SQL statements are supported:		The following SQL statements are supported:

Line 4:		Line 5:
	* UPDATE SET WHERE		* UPDATE SET WHERE
	* DELETE FROM WHERE		* DELETE FROM WHERE
	* INSERT INTO VALUES		* INSERT INTO VALUES ON DUPLICATE KEY UPDATE
	* CREATE TABLE		* CREATE TABLE
	* ALTER TABLE		* ALTER TABLE
Line 21:		Line 22:
	* UNLOCK TABLES (no function)		* UNLOCK TABLES (no function)

			== Expressions ==
	The following functions are supported:		The following functions are supported:

	* CASE WHEN THEN ELSE END		* CASE WHEN THEN ELSE END
	* DATABASE		* DATABASE
Line 38:		Line 38:
	* COALESCE		* COALESCE

			== Aggregates ==
	The following aggregates are available:		The following aggregates are available:

Carli: Created page with "The following SQL statements are supported: * SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET * UPDATE SET WHERE * DELETE FROM WHERE * INSERT INTO VALUES * CREATE TABLE * ALTER TABLE * CREATE DATABASE * CREATE USER * ALTER USER * SHOW DATABASES * SHOW TABLES * SHOW TABLE STATUS * SHOW VARIABLES * SET NAMES (no function) * DROP DATABASE * DROP TABLE * SET SESSION * LOCK TABLES (no function) * UNLOCK TABLES (no function) The following functions are supported: * CASE..."

2024-05-19T08:23:12Z

Created page with "The following SQL statements are supported: * SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET * UPDATE SET WHERE * DELETE FROM WHERE * INSERT INTO VALUES * CREATE TABLE * ALTER TABLE * CREATE DATABASE * CREATE USER * ALTER USER * SHOW DATABASES * SHOW TABLES * SHOW TABLE STATUS * SHOW VARIABLES * SET NAMES (no function) * DROP DATABASE * DROP TABLE * SET SESSION * LOCK TABLES (no function) * UNLOCK TABLES (no function) The following functions are supported: * CASE..."

New page

The following SQL statements are supported:

* SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET
* UPDATE SET WHERE
* DELETE FROM WHERE
* INSERT INTO VALUES
* CREATE TABLE
* ALTER TABLE
* CREATE DATABASE
* CREATE USER
* ALTER USER
* SHOW DATABASES
* SHOW TABLES
* SHOW TABLE STATUS
* SHOW VARIABLES
* SET NAMES (no function)
* DROP DATABASE
* DROP TABLE
* SET SESSION
* LOCK TABLES (no function)
* UNLOCK TABLES (no function)

The following functions are supported:

* CASE WHEN THEN ELSE END
* DATABASE
* PASSWORD (hashes a password for user authentication)
* FLOOR
* CEIL
* CEILING
* ROUND
* UPPER
* LOWER
* CAST AS UNSIGNED
* CAST AS CHAR CHARACTER SET utf8
* CONCAT
* COALESCE

The following aggregates are available:

* COUNT
* SUM
* AVG
* MIN
* MAX