Tested lyx against postgres regression tests
I tried to run postgress regression tests against SPQR, but lyx failed to parse queries to create test-DB "regression":
{"level":"error","client":824638695392,"tx-status":73,"error":"error processing query 'CREATE DATABASE \"regression\" TEMPLATE=template0': syntax error on pos 37","time":"2024-05-13T11:52:22+05:00","message":"client iteration done with error"}
{"level":"error","client":824638695392,"tx-status":73,"error":"error processing query 'ALTER DATABASE \"regression\" SET lc_messages TO 'C';ALTER DATABASE \"regression\" SET lc_monetary TO 'C';ALTER DATABASE \"regression\" SET lc_numeric TO 'C';ALTER DATABASE \"regression\" SET lc_time TO 'C';ALTER DATABASE \"regression\" SET bytea_output TO 'hex';ALTER DATABASE \"regression\" SET timezone_abbreviations TO 'Default';': syntax error on pos 51","time":"2024-05-13T11:52:22+05:00","message":"client iteration done with error"}
So I created "regression" DB manually and run sql scripts from https://github.com/postgres/postgres/tree/master/src/test/regress/sql
I run this scripts from terminal using psql:
psql -U <username> -d regression -h <spqr host> -p <spqr port> -a -f "<filename.sql>"
Here are full logs of SPQR and list of queries that lyx failed to parse: logs.zip
Tested lyx against postgres regression tests
I tried to run postgress regression tests against SPQR, but lyx failed to parse queries to create test-DB "regression":
So I created "regression" DB manually and run sql scripts from https://github.com/postgres/postgres/tree/master/src/test/regress/sql
I run this scripts from terminal using psql:
psql -U <username> -d regression -h <spqr host> -p <spqr port> -a -f "<filename.sql>"Here are full logs of SPQR and list of queries that lyx failed to parse: logs.zip