title: Snowflake using REPEAT/SPACE inside VALUES clasue
body: <p>Simple scenario table with single column:</p>
  
  <pre><code>CREATE OR REPLACE TABLE t1(c VARCHAR(200));
  
  INSERT INTO t1(c) SELECT repeat('a',100); -- works 
  INSERT INTO t1(c) VALUES (repeat('a',100)); -- error
  
  INSERT INTO t1(c) SELECT space(100); -- works
  INSERT INTO t1(c) VALUES (space(100)); -- error
  
  SELECT c, LENGTH(c) FROM t1;
  </code></pre>
  
  <blockquote>
    <p>SQL compilation error: Invalid expression [LPAD('', CAST(100 * (CAST(LENGTH('a') AS NUMBER(18,0))) AS NUMBER(21,0)), 'a')] in VALUES clause</p>
  </blockquote>
  
  <p>Is there a limitation which expressions/function calls could be used with <code>INSERT ... VALUES</code> or is it simply a bug?</p>