Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostgreSQL regression tests results #20

Open
SergeyBirukov opened this issue May 15, 2024 · 0 comments
Open

PostgreSQL regression tests results #20

SergeyBirukov opened this issue May 15, 2024 · 0 comments

Comments

@SergeyBirukov
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant