gpdb-except-bug.md

GPDB Version

$ git log --all --graph --decorate
* commit ce261a87769335185480b4b0c7f251669018938f (HEAD -> dev, origin/6X_STABLE)
| Author: Lisa Owen <lowen@pivotal.io>
| Date:   Wed Aug 19 10:32:32 2020 -0700
|
|     docs - clarify gpcopy supported greenplum versions (#10621)
|
|     * docs - clarify gpcopy supported greenplum versions
|
|     * use or later rather than +
|
* commit c3b4f767c3866ba2e835f3f732a03f6a747c55c9
| Author: Hubert Zhang <hzhang@pivotal.io>
| Date:   Tue Aug 18 09:05:39 2020 +0800
|
|     Enable external_table test case in ic-proxy mode
|
|     ic-proxy supports to handle cancel signal during
|     backend connection setup now, so external_table test case
|     could be enabled.
|
|     Reviewed-by: Ning Yu <nyu@pivotal.io>
|     (cherry picked from commit 1789e4371b3450d7081c598127c3dac083d3b78c)
...

Test SQL

CREATE TABLE IF NOT EXISTS t1 (
    id integer NOT NULL
);

CREATE TABLE IF NOT EXISTS t2 (
    id integer NOT NULL
);


INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
INSERT INTO t1 VALUES (3);

INSERT INTO t2 VALUES (2);
INSERT INTO t2 VALUES (3);
INSERT INTO t2 VALUES (4);


SELECT * FROM t1 EXCEPT SELECT * FROM t2;

Test Result

postgres=# SELECT * FROM t1 EXCEPT SELECT * FROM t2;
 id
----
  1
(1 row)