title: How to create column and copy another column into the newly created one
body: <p>I'm trying to achieve a simple task, I create a new column in a table and immediately afterwards try to copy a value of some other column in the same table into the new created column but I got a </p>
  
  <blockquote>
    <p>Invalid column name 'COMMENT_TMP'.
    error</p>
  </blockquote>
  
  <p>The SQL is </p>
  
  <p>Invalid column name 'COMMENT_TMP'.</p>
  
  <pre><code>ALTER TABLE TASK_COMMENT ADD COMMENT_TMP text;
  UPDATE TASK_COMMENT SET TASK_COMMENT.COMMENT_TMP = COMMENT;
  </code></pre>