← Back to team overview

maria-developers team mailing list archive

Re: Feature request: Add support for a syntax check for SQL scripts


On Thu, 13 Oct 2011 23:20:24 +0200, Raphael Vullriede <lists.raphael@xxxxxxxxxxxx> wrote:
> we have a lot of developers writing a lot of SQL scripts against a lot
> of different databases. These scripts usually consists of mixed DDL
> (e.g. change a column definition) and DML (e.g. adding new master data).
> Since our applications are constantly under development we'd like to add
> these scripts to our continuous integration environment.
> For that it would be great to have a feature that checks the script
> against a given database without actually executing it. It should not
> only check the SQL syntax but also if all mentioned tables, columns etc.
> exists in the given database.

This (of course) won't always work. ALTER TABLE ADD COLUMN and then
mention that column.

As an alternative, maybe start up a local server and load data in it to
test the scripts on.

Stewart Smith

Follow ups