Bug in MSSQLDatabase.getViewDefinition()

Description

MSSQLDatabase.getViewDefinition() is using a regular expression to strip the "create view..." clause from the SQL text. The pattern is wrong and incomplete:

should be

This matches all of the following:

and the same as ALTER clauses and works with block comments before the clause.

Environment

any

Reporter

Jörg Waßmer

Components

Fix versions

Affects versions

Priority

Major
Configure