DROP table if EXISTS t1;

DROP table if EXISTS t2;

CREATE TABLE t1(geom geometry NOT NULL);

CREATE TABLE t2(geom geometry NOT NULL);

INSERT INTO t1 (geom) VALUES(ST_GeomFromText('POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))'));

INSERT INTO t2 (geom) VALUES(ST_GeomFromText('POLYGON ((1 1, 1 2, 2 2, 2 1, 1 1))'));

SELECT ST_DIMENSION(ST_INTERSECTION(t1.geom, t2.geom)), ST_OVERLAPS(t1.geom, t2.geom) FROM t1, t2;

-- expected:{0, f}

-- actual  :{0, t}