Skip to content

PostgreSQL regression tests results #20

@SergeyBirukov

Description

@SergeyBirukov

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions