VaibhaveS

[SQLite 5] database is locked

3

Migration fails due to contention between the **stream** & **apply** processes. It retries for a while & make some progress however it fails and stops retrying when there is no-progress...

Refresh materialized views fails during post data pg_restore phase

3

REFRESH MATERIALIZED VIEWS fail when there is a reference to a object which is not fully qualified and the query is enclosed in a string. **Query to reproduce** ``` CREATE...

Add support for multi-deletes.

3

Continuation of #465

``` 2024-07-16 20:55:09.167 249 ERROR pgsql.c:2331 [SOURCE 351740] ERROR: relation "ora.xyz" does not exist 2024-07-16 20:55:09.168 249 ERROR pgsql.c:2331 [SOURCE 351740] ERROR: relation "ora.xyz" does not exist 2024-07-16 20:55:09.168 249...

pgcopydb assumes that the data is in UTF-8. With a setup like below `pgcopydb clone` would fail while COPYing. ``` 1. CREATE DATABASE source with encoding 'SQL_ASCII' WITH template0; 2....

Incorrect query is parsed without any errors

4

Query ``` query = """ CREATE OR REPLACE FUNCTION update_customer_total_sales(customer_id INT) RETURNS VOID AS $$ DECLARE total NUMERIC; BEGIN -- Calculate the total sales for the specified customer SELECT COALESCE(SUM(amount),...

Incorrect query is parsed without any errors

3

Query The query is incorrect, because there is no `=` between `WHERE customer_id $1` however `pg_query_free_plpgsql_parse_result(query)` returns correctly. ``` #include #include #include int main() { PgQueryPlpgsqlParseResult result; result = pg_query_parse_plpgsql("...