sudr / dbdeploy

Automatically exported from code.google.com/p/dbdeploy
0 stars 0 forks source link

Sybase dialect generates invalid SQL for DDL #24

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
(This looks like the same issues as r22, but for another database dialect.)

What steps will reproduce the problem?

1. Create DDL delta
2. Generate output SQL for SyBase (dbms=syb-ase)
3. See "BEGIN TRANSACTION" and "GO" in output.sql

What is the expected output? What do you see instead?

Sybase DDL statements should not run within explicit transactions.

What version of the product are you using? On what operating system?

DbDeploy 3.0 on Ubuntu Linux.

Please provide any additional information below.

DbDeploy 2.x didn't include the "BEGIN TRANSACTION" and "GO" in output.sql,
and it worked fine.

Original issue reported on code.google.com by simon.br...@gmail.com on 4 Sep 2009 at 9:40

GoogleCodeExporter commented 9 years ago
Patch attached.

Original comment by simon.br...@gmail.com on 4 Sep 2009 at 9:52

Attachments:

GoogleCodeExporter commented 9 years ago
Thanks for the patch simon.

Applied at 
http://github.com/tackley/dbdeploy/commit/e697a84b45dcbfca617c96ca2a59543f24ec7f
4f

Original comment by gtack...@googlemail.com on 14 Sep 2009 at 2:53

GoogleCodeExporter commented 9 years ago
Commited to svn r108

Original comment by gtack...@googlemail.com on 14 Sep 2009 at 2:54