This repository has been archived by the owner on Aug 21, 2023. It is now read-only.
Improve handling of START TRANSACTION with MySQL-like databases
#309
Comments
|
I suggest we should do a full test for memsql/singlestore. |
|
https://docs.singlestore.com/db/v7.3/en/reference/sql-reference/data-manipulation-language-dml/begin.html indeed doesn't show the |
Yes and maybe Vitess. But as Vitess has a set of MySQL servers as backend and dumping directly from those and combining the data should work. However that could complicate table names and might copy Vitess specific metadata that should have been excluded. |
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Jul 14, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL. - `SHOW CREATE DATABASE` is not supported by MemSQL.
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Jul 14, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Jul 19, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Jul 19, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Jul 23, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Aug 2, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
dveeden
added a commit
to dveeden/dumpling
that referenced
this issue
Aug 2, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
ti-chi-bot
pushed a commit
to ti-chi-bot/dumpling
that referenced
this issue
Aug 3, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
ti-chi-bot
pushed a commit
to ti-chi-bot/dumpling
that referenced
this issue
Aug 3, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
ti-chi-bot
pushed a commit
to ti-chi-bot/dumpling
that referenced
this issue
Aug 3, 2021
Issue: pingcap#309 - `WITH CONSISTENT SNAPSHOT` is not supported by MemSQL (same for Vitess). - `SHOW CREATE DATABASE` is not supported by MemSQL.
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Bug Report
The SQL query from sql.go has a version specific comment to only execute on MySQL 4.1.8.
However with Vitess and MemSQL/SingleStore seems to have the same issue.
I would suggest to run a
START TRANSACTIONwithout the version-specific comment if the original statement fails.Also with
--consistency nonethis still fails.The text was updated successfully, but these errors were encountered: