search

dolthub / doltgresql

DoltgreSQL - Version Controlled PostgreSQL
Apache License 2.0
1.07k stars 23 forks source link

[auto-bump] [no-release-notes] dependency by zachmu #814

Closed coffeegoddd closed 1 day ago

coffeegoddd commented 1 day 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 day ago
Main PR
Total 42090 42090
Successful 12414 12382
Failures 29676 29708
Partial Successes[^1] 4907 4914
Main PR
Successful 29.4939% 29.4179%
Failures 70.5061% 70.5821%

Regressions

comments

QUERY:          /* and this is the end of the file */
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)

create_table_like

QUERY:          INSERT INTO test_like_gen_1 (a) VALUES (1);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          SELECT * FROM test_like_gen_1;
RECEIVED ERROR: expected row count 1 but received 0
QUERY:          CREATE TABLE test_like_gen_2 (LIKE test_like_gen_1);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO test_like_gen_2 (a) VALUES (1);
RECEIVED ERROR: table not found: test_like_gen_2 (errno 1146) (sqlstate HY000)

generated

QUERY:          UPDATE gtest1 SET a = 3 WHERE b = 4;
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest_normal_child (a) VALUES (2);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest_normal_child2 (a) VALUES (3);
RECEIVED ERROR: Invalid default value for '(`a` * 3)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest3 (a) VALUES (1), (2), (3), (NULL);
RECEIVED ERROR: Invalid default value for '(`a` * 3)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          UPDATE gtest3 SET a = 22 WHERE a = 2;
RECEIVED ERROR: Invalid default value for '(`a` * 3)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest1 (a) VALUES (1), (2);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest3 (a) VALUES (1), (2);
RECEIVED ERROR: Invalid default value for '(`a` * 3)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest_varlena (a) VALUES('01234567890123456789');
RECEIVED ERROR: Invalid default value for '(`a`)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest_varlena (a) VALUES(NULL);
RECEIVED ERROR: Invalid default value for '(`a`)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          ALTER TABLE gtest10a DROP COLUMN b;
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest10a (a) VALUES (1);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest20a (a) VALUES (10);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest20a (a) VALUES (30);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest20b (a) VALUES (10);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest20b (a) VALUES (30);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          CREATE INDEX gtest22c_b_idx ON gtest22c (b);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          ALTER TABLE gtest25 ADD COLUMN d int DEFAULT 101;
RECEIVED ERROR: Invalid default value for '(`a` * 3)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest27 (a, b) VALUES (3, 7), (4, 11);
RECEIVED ERROR: Invalid default value for '(`a` + `b` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest29 (a) VALUES (3), (4);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest29 (a) VALUES (5);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          ALTER TABLE gtest29 DROP COLUMN a;
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest26 (a) VALUES (-2), (0), (3);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          UPDATE gtest26 SET a = a * -2;
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          UPDATE gtest26 SET a = 1 WHERE a = 0;
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          INSERT INTO gtest26 (a) VALUES (1);
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          UPDATE gtest26 SET a = 11 WHERE a = 1;
RECEIVED ERROR: Invalid default value for '(`a` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)
QUERY:          ALTER TABLE gtest28a DROP COLUMN a;
RECEIVED ERROR: Invalid default value for '(`b` * 2)': at or near "`": syntax error (errno 1105) (sqlstate HY000)

Progressions

generated

QUERY: ALTER TABLE gtest10 DROP COLUMN b;
QUERY: ALTER TABLE gtest25 ADD COLUMN x int GENERATED ALWAYS AS (b * 4) STORED;
QUERY: ALTER TABLE gtest27 ALTER COLUMN x DROP DEFAULT;

insert_conflict

QUERY:          ;
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)
QUERY:          ;
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)
QUERY:          ;
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)
QUERY:          ;
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)

psql

QUERY:          ;
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)
QUERY:          ;
RECEIVED ERROR: unsupported syntax: <nil> (errno 1105) (sqlstate HY000)

publication

QUERY: UPDATE testpub_tbl5 SET a = 1;
QUERY: ALTER TABLE testpub_tbl5 DROP COLUMN c;
QUERY: UPDATE testpub_tbl5 SET a = 1;
QUERY: UPDATE testpub_tbl5 SET a = 1;

triggers

QUERY: alter table trigtest add column d integer default 42 not null;
QUERY: alter table trigtest drop column b;

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