baseline scripts executed unexpectedly

[tianzhou]

Discussed in #350

^{Originally posted by NickStepanov January 10, 2022}
Hi,

I am trying to test the use of Clickhouse with VCS based workflow.

I am creating a UI based baseline and it works fine.

After that, I am pushing a file to gitlab with my baseline, it get picked up by Bytebase and it even states:

SQL (This is a baseline migration and bytebase won't apply the SQL to the database, it will only record a baseline history)

After that, in the created issue, I try to click run, thinking that it will not touch my db, but I get

execute query ..... Table ...... already exists

It looks like my baseline file is trying to be executed my live db.

Is that an issue? Or am I doing something wrong?

Nik

[tianzhou]

Converted from #350

[tianzhou]

@qsliu2017 please take a look.

To setup a ClickHouse instance, you can follow:

https://bytebase.com/blog/how-to-run-clickhouse-with-docker-and-connect-using-mysql-client

[qsliu2017]

I find that baseline SQL script will always be executed, both UI and Git workflow

In bytebase docs, it says

...This is achieved by using a baseline migration script which includes the entire schema of that live database.
...
Internally, the baseline migration only causes Bytebase to update its migration history table to record the baseline state. It won't apply the SQL statements in that baseline file to the corresponding database since the database is the origin source of the baseline and already has all the schema.

@tianzhou ,I need more info about

1. does the baseline script need statements?
2. should the baseline script be executed?

[tianzhou]

I find that baseline SQL script will always be executed, both UI and Git workflow

In bytebase docs, it says

...This is achieved by using a baseline migration script which includes the entire schema of that live database.
...
Internally, the baseline migration only causes Bytebase to update its migration history table to record the baseline state. It won't apply the SQL statements in that baseline file to the corresponding database since the database is the origin source of the baseline and already has all the schema.

@tianzhou ,I need more info about

1. does the baseline script need statements?
2. should the baseline script be executed?

What baseline means is it tells Bytebase the current state of schema (aka establishing the baseline)

So Baseline statement does has statement, it's the statement tells Bytebase the current schema.

But it should NOT be executed.