Open ibuiltthis opened 1 year ago
same here. I can confirm this behavior
tf plan to reproduce:
+ resource "mssql_script" "this" {
+ database_id = "1"
+ delete_script = "ALTER DATABASE [lock] SET CHANGE_TRACKING = OFF"
+ id = (known after apply)
+ read_script = "SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id=8"
+ state = {
+ "is_enabled" = "1"
}
+ update_script = <<-EOT
USE MASTER;
DECLARE @database_name VARCHAR(256)
DECLARE @sql_cmd VARCHAR(2000)
SET @database_name = 'TEST'
SET @sql_cmd = '
CREATE DATABASE ' + @database_name + ' COLLATE Latin1_General_CI_AS
'
EXEC (@sql_cmd)
GO
EOT
}
output:
│ 203: resource "mssql_script" "this" {
│
│ mssql: Incorrect syntax near 'GO'.
GO is a batch separator and is not part of T-SQL, and is only interpreted by SSMS or other tools. https://learn.microsoft.com/en-us/sql/t-sql/language-elements/sql-server-utilities-statements-go?view=sql-server-ver16&redirectedfrom=MSDN
When creating a mssql_script resource that uses 'GO' in the script the resource fails to create.
The error is:
Any help?