SingleStoreDB (MemSQL) Procedural SQL (MPSQL) Types

Two data types are only supported in SingleStoreDB (MemSQL) Procedural SQL (MPSQL) scalar-valued functions and stored procedures: ARRAY and RECORD. The QUERY data type is only supported in stored procedures. For more information about these types, see the ARRAY, RECORD, and QUERY topics.