Xpand (fomerly clustrixdb) unsupported

 

 

Unsupported Functions

ClustrixDB does not support the following functions:

• ANALYSE()
• AREA()
• AsBinary()
• AsText()
• AsWKB()
• AsWKT()
• BENCHMARK() 
• BINLOG_GTID_POS()
• BOUNDARY()
• BUFFER()
• CENTROID()
• CHARSET() 
• CHR()
• COERCIBILITY() 
• COLLATION() 
• COLUMN_ADD()
• COLUMN_CHECK()
• COLUMN_CREATE()
• COLUMN_DELETE()
• COLUMN_EXISTS()
• COLUMN_GET()
• COLUMN_JSON()
• COLUMN_LIST()
• CONVEXHULL()
• CROSSES()
• CUME_DIST()
• CURRENT_USER() 
• DECODE_HISTOGRAM()
• DEFAULT()
• DEGREES()
• DENSE_RANK()
• DES_DECRYPT()
• DES_ENCRYPT()
• DIMENSION()
• DISJOINT() 
• ENDPOINT()
• ENVELOPE()
• ExteriorRing()
• EXTRACT() 
• EXTRACTVALUE()
• GeomCollFromText()
• GeomCollFromWKB()
• GEOMETRYCOLLECTION()
• GeometryCollectionFromText()
• GeometryCollectionFromWKB()
• GeometryFromText()
• GeometryFromWKB()
• GeometryN()
• GeometryType()
• GeomFromText()
• GeomFromWKB()
• GLENGTH()
• GET_FORMAT() 
• INET_ATON(), INET_NTOA(), INET6_ATON(), INET6_NTOA() 
• InteriorRingN() 
• INTERSECTS()
• IS_IPV4, IS_IPV4_COMPAT (), IS_IPV4_MAPPED (), IS_IPV6 ()
• IsClosed()
• IsEmpty()
• IsRing()
• IsSimple() 
• JSON_ARRAY_APPEND()
• JSON_ARRAY_INSERT()
• JSON_COMPACT()
• JSON_CONTAINS()
• JSON_DETAILED()
• JSON_EXISTS()
• JSON_INSERT()
• JSON_LOOSE()
• JSON_MERGE()
• JSON_QUERY()
• JSON_REMOVE()
• JSON_REPLACE()
• JSON_SET()
• JSON_VALUE()
  
• LAST_VAL() 
• LineFromText()
• LineFromWKB()
• LineStringFromText()
• LineStringFromWKB() 
• LOAD_FILE()
• LOCK TABLES()
• LOAD_FILE() 
• MAKEDATE() 
• MASTER_GTID_WAIT()
• MASTER_POS_WAIT()
• MATCH AGAINST()
• MBRContains()
• MBRDisjoint()
• MBREqual()
• MBRIntersects()
• MBROverlaps()
• MBRTouches()
• MBRWithin()
• MEDIAN()
• MLineFromText()
• MLineFromWKB()
• MPointFromText()
• MPointFromWKB()
• MPolyFromText()
• MPolyFromWKB()
• MULTILINESTRING()
• MultiLineStringFromText()
• MultiLineStringFromWKB()
• MULTIPOINT()
• MultiPointFromText()
• MultiPointFromWKB()
• MULTIPOLYGON()
• MultiPolygonFromText()
• MultiPolygonFromWKB()
• NTILE()
• NumGeometries()
• NumInteriorRings()
• NumPoints()
• OCTET_LENGTH()
• OLD_PASSWORD()
• OVERLAPS()
• PERCENT_RANK 
• PERCENTILE_CONT()
• PERCENTILE_DISC()
• POINT()
• PointFromText()
• PointFromWKB()
• PointN()
• PointOnSurface()
• PolyFromText()
• PolyFromWKB()
• POLYGON()
• PolygonFromText()
• PolygonFromWKB()
• POSITION()
• RANK() 
• REGEXP_INSTR()
• REGEXP_REPLACE()
• REGEXP_SUBSTR()
• ROW_NUMBER()
• SESSION_USER()
• SETVAL()
• SOUNDEX()
• SOUNDS LIKE()
• SPACE()
• SPIDER_BG_DIRECT_SQL()
• SPIDER_COPY_TABLES()
• SPIDER_DIRECT_SQL()
• SPIDER_FLUSH_TABLE_MON_CACHE()
• SRID()
• ST_AREA()
• ST_AsBinary()
• ST_AsText()
• ST_AsWKB()
• ST_ASWKT()
• ST_BOUNDARY()
• ST_BUFFER()
• ST_CENTROID()
• ST_CONTAINS()
• ST_CONVEXHULL()
• ST_CROSSES()
• ST_DIFFERENCE()
• ST_DIMENSION()
• ST_DISJOINT()
• ST_DISTANCE()
• ST_ENDPOINT()
• ST_ENVELOPE()
• ST_EQUALS()
• ST_ExteriorRing()
• ST_GeomCollFromText()
• ST_GeomCollFromWKB()
• ST_GeometryCollectionFromText()
• ST_GeometryCollectionFromWKB()
• ST_GeometryFromText()
• ST_GeometryFromWKB()
• ST_GEOMETRYN()
• ST_GEOMETRYTYPE()
• ST_GeomFromText()
• ST_GeomFromWKB()
• ST_InteriorRingN()
• ST_INTERSECTION()
• ST_INTERSECTS()
• ST_ISCLOSED()
• ST_ISEMPTY()
• ST_IsRing()
• ST_IsSimple()
• ST_LENGTH()
• ST_LineFromText()
• ST_LineFromWKB()
• ST_LineStringFromText()
• ST_LineStringFromWKB()
• ST_NUMGEOMETRIES()
• ST_NumInteriorRings()
• ST_NUMPOINTS()
• ST_OVERLAPS()
• ST_PointFromText()
• ST_PointFromWKB()
• ST_POINTN()
• ST_POINTONSURFACE()
• ST_PolyFromText()
• ST_PolyFromWKB()
• ST_PolygonFromText()
• ST_PolygonFromWKB()
• ST_RELATE()
• ST_SRID()
• ST_STARTPOINT()
• ST_SYMDIFFERENCE()
• ST_TOUCHES()
• ST_UNION()
• ST_WITHIN()
• ST_X()
• ST_Y()
• STARTPOINT()
• TO_SECONDS() 
• TOUCHES()
• UPDATEXML()
• WEIGHT_STRING()
• WITHIN()
• X()
• Y()