title: Flyway | MariaDb - Unable to execute conditional block
body: <p>I want to add a not null column to a table with existing data. My toolset includes MariaDb and flyway. Here's what I am doing</p>
  
  <pre><code>IF NOT EXISTS(SELECT 1
                  FROM INFORMATION_SCHEMA.COLUMNS
                  WHERE table_name = 'MY_DATA_TABLE'
                  AND table_schema = '${schemaName}'
                  AND column_name = 'NewColumnName'
                ) THEN
          ALTER TABLE MY_DATA_TABLE ADD COLUMN 'NewColumnName' INT;
          SELECT ID INTO @val FROM MASTER_TABLE WHERE lower(Name) = 'XYZ';
          UPDATE MY_DATA_TABLE SET NewColumnName = @val;
          ALTER TABLE MY_DATA_TABLE MODIFY COLUMN 'NewColumnName' INT NOT NULL;
  END IF;
  </code></pre>
  
  <p>Doing <code>mvn flyway:migrate</code> gives me this error</p>
  
  <pre><code>[ERROR] SQL State  : 42000
  [ERROR] Error Code : 1064
  [ERROR] Message    : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''NewColumnName'
  INT' at line 7
  </code></pre>
  
  <p>I even tried placing some running select statement inside, but the error remains the same. Please suggest some workaround. Please also recommend if there's another way to achieve the objective.
  Thanks!</p>