search

dolthub / doltgresql

DoltgreSQL - Version Controlled PostgreSQL
Apache License 2.0
1.12k stars 25 forks source link

fix dropped error #971

Closed jennifersp closed 1 week ago

jennifersp commented 1 week ago

This causes regression as the error was getting dropped.

github-actions[bot] commented 1 week ago
Main PR
Total 42090 42090
Successful 14426 14385
Failures 27664 27705
Partial Successes[^1] 4690 4679
Main PR
Successful 34.2742% 34.1768%
Failures 65.7258% 65.8232%

${\color{red}Regressions}$

alter_table

QUERY:          create table anothertab (atcol1 serial8, atcol2 boolean,
    constraint anothertab_chk check (atcol1 <= 3));
RECEIVED ERROR: function internal_binary_operator_func_<=(bigserial, integer) does not exist (errno 1105) (sqlstate HY000)
QUERY:          insert into anothertab (atcol1, atcol2) values (default, true);
RECEIVED ERROR: table not found: anothertab (errno 1146) (sqlstate HY000)
QUERY:          insert into anothertab (atcol1, atcol2) values (default, false);
RECEIVED ERROR: table not found: anothertab (errno 1146) (sqlstate HY000)
QUERY:          insert into anothertab (atcol1, atcol2) values (default, null);
RECEIVED ERROR: table not found: anothertab (errno 1146) (sqlstate HY000)
QUERY:          alter table anothertab alter column atcol1 drop default;
RECEIVED ERROR: table not found: anothertab (errno 1146) (sqlstate HY000)
QUERY:          drop table anothertab;
RECEIVED ERROR: table not found: anothertab (errno 1146) (sqlstate HY000)

create_operator

QUERY:          SELECT true<>-1 BETWEEN 1 AND 1;
RECEIVED ERROR: function internal_binary_operator_func_<>(boolean, smallint) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT false<>/**/1 BETWEEN 1 AND 1;
RECEIVED ERROR: function internal_binary_operator_func_<>(boolean, smallint) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT false<=-1 BETWEEN 1 AND 1;
RECEIVED ERROR: function internal_binary_operator_func_<=(boolean, smallint) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT false>=-1 BETWEEN 1 AND 1;
RECEIVED ERROR: function internal_binary_operator_func_>=(boolean, smallint) does not exist (errno 1105) (sqlstate HY000)

json

QUERY:          select '{"a": {"b":{"c": "foo"}}}'::json #>> array['a', null];
RECEIVED ERROR: function internal_binary_operator_func_unknown operator(json, anyarray) does not exist (errno 1105) (sqlstate HY000)

jsonb

QUERY:          select '{"a": {"b":{"c": "foo"}}}'::jsonb #> array['a', null];
RECEIVED ERROR: function internal_binary_operator_func_unknown operator(jsonb, anyarray) does not exist (errno 1105) (sqlstate HY000)
QUERY:          select '{"a": {"b":{"c": "foo"}}}'::jsonb #>> array['a', null];
RECEIVED ERROR: function internal_binary_operator_func_unknown operator(jsonb, anyarray) does not exist (errno 1105) (sqlstate HY000)

object_address

QUERY:          CREATE TABLE addr_nsp.gentable (
    a serial primary key CONSTRAINT a_chk CHECK (a > 0),
    b text DEFAULT 'hello');
RECEIVED ERROR: function internal_binary_operator_func_>(serial, integer) does not exist (errno 1105) (sqlstate HY000)
QUERY:          CREATE VIEW addr_nsp.genview AS SELECT * from addr_nsp.gentable;
RECEIVED ERROR: table not found: gentable (errno 1146) (sqlstate HY000)

opr_sanity

QUERY:          SELECT p1.oid, p1.proname
FROM pg_proc AS p1
WHERE (pronargdefaults <> 0) != (proargdefaults IS NOT NULL);
RECEIVED ERROR: function internal_binary_operator_func_<>(boolean, smallint) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT p1.oid, p1.proname, p2.oid, p2.proname
FROM pg_proc AS p1, pg_proc AS p2
WHERE p1.oid != p2.oid AND
    p1.proname = p2.proname AND
    p1.pronargs = p2.pronargs AND
    p1.proargtypes = p2.proargtypes;
RECEIVED ERROR: function internal_binary_operator_func_=(oid[], oid[]) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT c.oid, c.conname
FROM pg_conversion as c
WHERE c.conproc = 0 OR
    pg_encoding_to_char(conforencoding) = '' OR
    pg_encoding_to_char(contoencoding) = '';
RECEIVED ERROR: function internal_binary_operator_func_=(text, integer) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a.aggfnoid::oid, p.proname
FROM pg_aggregate as a, pg_proc as p
WHERE a.aggfnoid = p.oid AND
    (p.prokind != 'a' OR p.proretset OR p.pronargs < a.aggnumdirectargs);
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a.aggfnoid::oid, p.proname
FROM pg_aggregate as a, pg_proc as p
WHERE a.aggfnoid = p.oid AND
    a.aggfinalfn = 0 AND p.prorettype != a.aggtranstype;
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a.aggfnoid::oid, p.proname
FROM pg_aggregate as a, pg_proc as p
WHERE a.aggfnoid = p.oid AND
    a.aggmtransfn != 0 AND
    a.aggmfinalfn = 0 AND p.prorettype != a.aggmtranstype;
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a.aggfnoid::oid, p.proname, ptr.oid, ptr.proname, iptr.oid, iptr.proname
FROM pg_aggregate AS a, pg_proc AS p, pg_proc AS ptr, pg_proc AS iptr
WHERE a.aggfnoid = p.oid AND
    a.aggmtransfn = ptr.oid AND
    a.aggminvtransfn = iptr.oid AND
    ptr.proisstrict != iptr.proisstrict;
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT p.oid, proname
FROM pg_proc AS p JOIN pg_aggregate AS a ON a.aggfnoid = p.oid
WHERE prokind = 'a' AND provariadic != 0 AND a.aggkind = 'n';
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a1.amprocfamily, a1.amprocnum
FROM pg_amproc as a1
WHERE a1.amprocfamily = 0 OR a1.amproclefttype = 0 OR a1.amprocrighttype = 0
    OR a1.amprocnum < 0 OR a1.amproc = 0;
RECEIVED ERROR: function internal_binary_operator_func_=(text, integer) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a1.amprocfamily, a1.amproc, p1.prosrc
FROM pg_amproc AS a1, pg_proc AS p1
WHERE a1.amproc = p1.oid AND
    a1.amproclefttype = a1.amprocrighttype AND
    p1.provolatile != 'i';
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT a1.amprocfamily, a1.amproc, p1.prosrc
FROM pg_amproc AS a1, pg_proc AS p1
WHERE a1.amproc = p1.oid AND
    a1.amproclefttype != a1.amprocrighttype AND
    p1.provolatile = 'v';
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)

tsearch

QUERY:          SELECT oid, prsname
FROM pg_ts_parser
WHERE prsnamespace = 0 OR prsstart = 0 OR prstoken = 0 OR prsend = 0 OR
      -- prsheadline is optional
      prslextype = 0;
RECEIVED ERROR: function internal_binary_operator_func_=(text, integer) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT oid, tmplname
FROM pg_ts_template
WHERE tmplnamespace = 0 OR tmpllexize = 0;
RECEIVED ERROR: function internal_binary_operator_func_=(text, integer) does not exist (errno 1105) (sqlstate HY000)

type_sanity

QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typinput = p1.oid AND p1.provolatile NOT IN ('i', 's');
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typoutput = p1.oid AND p1.provolatile NOT IN ('i', 's');
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname, p2.oid, p2.proname
FROM pg_type AS t1, pg_proc AS p1, pg_proc AS p2
WHERE t1.typinput = p1.oid AND t1.typreceive = p2.oid AND
    p1.pronargs != p2.pronargs;
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typreceive = p1.oid AND p1.provolatile NOT IN ('i', 's');
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typsend = p1.oid AND NOT
    (p1.prorettype = 'bytea'::regtype AND NOT p1.proretset);
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typsend = p1.oid AND p1.provolatile NOT IN ('i', 's');
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typmodin = p1.oid AND p1.provolatile NOT IN ('i', 's');
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, p1.oid, p1.proname
FROM pg_type AS t1, pg_proc AS p1
WHERE t1.typmodout = p1.oid AND p1.provolatile NOT IN ('i', 's');
RECEIVED ERROR: function internal_binary_operator_func_=(text, oid) does not exist (errno 1105) (sqlstate HY000)
QUERY:          SELECT t1.oid, t1.typname, t1.typelem
FROM pg_type AS t1
WHERE t1.typelem != 0 AND t1.typsubscript = 0;
RECEIVED ERROR: function internal_binary_operator_func_=(text, integer) does not exist (errno 1105) (sqlstate HY000)

[^1]: These are tests that we're marking as Successful, however they do not match the expected output in some way. This is due to small differences, such as different wording on the error messages, or the column names being incorrect while the data itself is correct.

jennifersp commented 1 week ago

Stashed error is returned only during evaluation step, so this error is intentionally ignored.