feat: add support for TimescaleDB - #748

That's great! I'd suggest that we merge the first PR as soon as some of the basic things work (e.g., creating tables and inserting data).

By the way, TimescaleDB seems to be an extension of PostgeSQL, so it might make sense to take a look at the Citus implementation, which re-used the basic Postgres SQLancer implementation.

Yes, I found out that both TimescaleDB and Citus are extensions of PostgreSQL; I will check out Citus first.

Hi, @mrigger I referenced the implementation of Citus and refactored my commit.

Now we have already established the basic structure of GlobalState, Options, Error, Bug, Provider, and Schema.

Am I on the right track? If so, I will continue.

But before that, may I ask a question? What is these fields and why do we add them in Citus?

Hi, @mrigger I referenced the implementation of Citus and refactored my commit.

Now we have already established the basic structure of GlobalState, Options, Error, Bug, Provider, and Schema.

Am I on the right track? If so, I will continue.

But before that, may I ask a question? What is these fields and why do we add them in Citus?

I am not very sure - the Citus implementation was contributed by @nukoyluoglu.

LGTM! Could you have a look at why the compilation/tests fail? You can execute mvn verify -DskipTests=true locally. I'd suggest that we already merge this skeleton.

when I try to run mvn verify -DskipTests=true, I got the following error:

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.10.1:compile (default-compile) on project sqlancer: Fatal error compiling: Failed to run the ecj compiler: Unrecognized option : D:\Documents\Projects\Open_Source\sqlancer\.settings\org.eclipse.jdt.core.prefs -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

Do our community get this error before? I am trying to fix this.

---- UPDATE ----

It seems that this error occurs occasionally; it's odd. Let's leave this, because now there is no such error anyway.

@mrigger hi, I have fixed the CI errors. Could you please help with the merge?

@mrigger hi, I have fixed the CI errors. Could you please help with the merge?

I think we can merge as soon as you remove the expected errors as described in my latest comment above. It seems you also need to resolve one merge conflict due to the name check change that we just merged.

@mrigger hi, I have fixed the CI errors. Could you please help with the merge?

I think we can merge as soon as you remove the expected errors as described in my latest comment above. It seems you also need to resolve one merge conflict due to the name check change that we just merged.

@mrigger Done! Thanks for review too.

Great, thanks a lot!