Skip to content

Conversation

@robins
Copy link
Collaborator

@robins robins commented Feb 5, 2025

As per discussionsin Issue #912 , SQLancer works fine with Postgres v13.

This commit updates the test harness to run against Postgres v13 (instead of v12 currently).

Also, the documentation links in README & code-comment URLs point to unreleased / outdated postgres documentation versions - For e.g. links were pointing to different postgres version documentations like devel (unreleased) / current / v12 or even v9.5 / v11 (both already EOL).

This commit ensures that all www.postgresql.org documentation links in the comments, point to the supported version of postgres (which as of this commit is v13). As and when we advance support for a more recent version, we should update the doc links accordingly too.

As per discussionsin Issue sqlancer#912 , SQLancer works fine with Postgres v13.

This commit updates the test harness to run against Postgres v13 (instead of v12 currently).

Also, the documentation links in README & code-comment URLs point to unreleased / outdated postgres documentation versions - For e.g. links were pointing to different postgres version documentations like devel (unreleased) / current / v12 or even v9.5 / v11 (both already EOL).

This commit ensures that all www.postgresql.org documentation links in the comments, point to the supported version of postgres (which as of this commit is v13). As and when we advance support for a more recent version, we should update the doc links accordingly too.
@mrigger
Copy link
Contributor

mrigger commented Feb 5, 2025

Thanks for the PR! It seems that an ALTER TABLE currently causes an unexpected error. I guess it can be merged as an expected error, after which we can merge the change.

 ALTER TABLE  ONLY t0 ALTER c0 DROP NOT NULL, ENABLE ROW LEVEL SECURITY, REPLICA IDENTITY NOTHING, ALTER c0  SET(n_distinct=0.1), CLUSTER ON i0, SET WITHOUT CLUSTER, ALTER c0 SET STORAGE MAIN; -- ERROR: column "c0" is in index used as replica identity

@robins
Copy link
Collaborator Author

robins commented Apr 8, 2025

I had let this PR be, so as to be a part of the on-going GSoC, but it seems to create more confusion than I was hoping for.

I'll push a change and submit for another review.

@robins robins added the postgres label Apr 8, 2025
Copy link
Contributor

@mrigger mrigger left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks! Sorry, just saw this now.

@mrigger mrigger merged commit 0cae179 into sqlancer:main Apr 13, 2025
15 of 25 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants