CREATE TABLE gis_geometrycollection (fid int, g GEOMETRYCOLLECTION NOT NULL) ENGINE=MyISAM;

INSERT INTO gis_geometrycollection (fid,g) VALUES

(120, GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),

(122, GeomFromText('GeometryCollection()'));

SELECT g1.fid as first, g2.fid as second,

Within(g1.g, g2.g) as w, Contains(g1.g, g2.g) as c, Overlaps(g1.g, g2.g) as o,

Equals(g1.g, g2.g) as e, Disjoint(g1.g, g2.g) as d, Touches(g1.g, g2.g) as t,

Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r

FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second;

ALTER TABLE gis_geometrycollection MODIFY g GEOMETRYCOLLECTION NULL;

SELECT g1.fid as first, g2.fid as second,

Within(g1.g, g2.g) as w, Contains(g1.g, g2.g) as c, Overlaps(g1.g, g2.g) as o,

Equals(g1.g, g2.g) as e, Disjoint(g1.g, g2.g) as d, Touches(g1.g, g2.g) as t,

Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r

FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second;

DROP TABLE gis_geometrycollection;

# First SELECT 

+-------+--------+---+---+---+---+---+---+---+---+

| first | second | w | c | o | e | d | t | i | r |

+-------+--------+---+---+---+---+---+---+---+---+

|   120 |    120 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |

|   120 |    122 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |

|   122 |    120 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |

|   122 |    122 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |

+-------+--------+---+---+---+---+---+---+---+---+

# Second SELECT

+-------+--------+------+------+------+------+------+------+------+------+

| first | second | w    | c    | o    | e    | d    | t    | i    | r    |

+-------+--------+------+------+------+------+------+------+------+------+

|   120 |    120 |    1 |    1 |    0 |    1 |    0 |    0 |    1 |    0 |

|   120 |    122 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |

|   122 |    120 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |

|   122 |    122 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |

+-------+--------+------+------+------+------+------+------+------+------+