Skip to content

Mark support for v13, update test / comment URLs accordingly.#1072

Merged
mrigger merged 4 commits into
sqlancer:mainfrom
robins:v13_mark_as_supported
Apr 13, 2025
Merged

Mark support for v13, update test / comment URLs accordingly.#1072
mrigger merged 4 commits into
sqlancer:mainfrom
robins:v13_mark_as_supported

Conversation

@robins

@robins robins commented Feb 5, 2025

Copy link
Copy Markdown
Collaborator

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

mrigger commented Feb 5, 2025

Copy link
Copy Markdown
Contributor

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

robins commented Apr 8, 2025

Copy link
Copy Markdown
Collaborator Author

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

@mrigger mrigger left a comment

Copy link
Copy Markdown
Contributor

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.

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