search

dolthub / doltgresql

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

[auto-bump] [no-release-notes] dependency by fulghum #876

Closed coffeegoddd closed 1 month ago

coffeegoddd commented 1 month ago

:coffee: An Automated Dependency Version Bump PR :crown:

Initial Changes

The changes contained in this PR were produced by `go get`ing the dependency.

```bash go get github.com/dolthub/[dependency]/go@[commit] ```

github-actions[bot] commented 1 month ago
Main PR
Total 42090 42090
Successful 12807 12844
Failures 29283 29246
Partial Successes[^1] 4893 4895
Main PR
Successful 30.4277% 30.5156%
Failures 69.5723% 69.4844%

${\color{lightgreen}Progressions}$

alter_table

QUERY: ALTER TABLE onek ADD CONSTRAINT onek_unique1_constraint UNIQUE (unique1);
QUERY: ALTER TABLE onek ADD CONSTRAINT onek_check_constraint CHECK (unique1 >= 0);
QUERY: ALTER TABLE onek ADD CONSTRAINT onek_unique1_constraint UNIQUE (unique1);
QUERY: alter table atacc1 add constraint atacc_test1 check (test+test2<test3*4);
QUERY: insert into atacc1 (test,test2,test3) values (4,4,2);
QUERY: alter table atacc1 add check (test2>test);
QUERY: insert into atacc1 (test2, test) values (3, 4);
QUERY: alter table atacc2 add constraint foo check (test2>0);
QUERY: insert into atacc2 (test2) values (-3);
QUERY: alter table atacc2 add constraint foo check (test2>0);
QUERY: alter table atacc3 add constraint foo check (test2>0);
QUERY: alter table atacc1 add constraint atacc_test1 unique (test, test2);
QUERY: alter table atacc1 add unique (test2);
QUERY: alter table atacc1 add constraint atacc1_constr_or check(test_a is not null or test_b < 10);
QUERY: alter table atacc1 drop constraint atacc1_constr_or;
QUERY: alter table atacc1 add constraint atacc1_constr_a_valid check(test_a is not null);
QUERY: alter table atacc1 add constraint atacc1_constr_b_valid check(test_b is not null);
QUERY: alter table anothertab
  add unique(f1,f4);
QUERY: ALTER TABLE test_inh_check ADD CONSTRAINT bmerged CHECK (b > 1);
QUERY: ALTER TABLE IF EXISTS tt8 ADD CHECK (f BETWEEN 0 AND 10);
QUERY: ALTER TABLE tt9 ADD CHECK(c > 1);
QUERY: ALTER TABLE tt9 ADD CONSTRAINT foo CHECK(c > 3);
QUERY: ALTER TABLE tt9 ADD UNIQUE(c);
QUERY: ALTER TABLE tt9 ADD UNIQUE(c);
QUERY: ALTER TABLE tt9 ADD CONSTRAINT tt9_c_key2 CHECK(c > 6);
QUERY: ALTER TABLE tt9 ADD UNIQUE(c);
QUERY: alter table defpart_attach_test_d add check (a > 1);

constraints

QUERY: ALTER TABLE unique_tbl ADD CONSTRAINT unique_tbl_i_key
    UNIQUE (i) DEFERRABLE INITIALLY DEFERRED;

create_table

QUERY: alter table defcheck_def add check (b <= 0 and b is not null);

${\color{red}Regressions}$

create_table_like

QUERY:          /* Doesn't copy constraint */
INSERT INTO inhg VALUES ('foo');
RECEIVED ERROR: Check constraint "inhg_chk_702ogqm4" violated (errno 1105) (sqlstate HY000)

create_table_like

QUERY: /* Single entry with value 'text' */
ALTER TABLE inhx add constraint foo CHECK (xx = 'text');

inherit

QUERY: alter table p1 add constraint p2chk check (ff1 > 10);
QUERY: alter table ac add constraint ac_check check (aa is not null);
QUERY: insert into ac (aa) values (NULL);
QUERY: alter table ac drop constraint ac_check;
QUERY: alter table ac add check (aa is not null);
QUERY: insert into ac (aa) values (NULL);
QUERY: alter table ac add constraint ac_check check (aa is not null);
QUERY: alter table ac drop constraint ac_check;
QUERY: alter table p1 add constraint inh_check_constraint1 check (f1 > 0);
QUERY: alter table p1 add constraint inh_check_constraint2 check (f1 < 10);
QUERY: ALTER TABLE errtst_child_fastdef ADD CONSTRAINT errtest_child_fastdef_data_check CHECK (data < 10);

tablespace

QUERY: ALTER TABLE testschema.test_tab ADD CONSTRAINT test_tab_unique UNIQUE (a);

[^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.