title: Vertica query returns empty result set at SSRS
body: <p>We are creating SSRS reports using Vertica Data Source.  Vertica query does not return any result set when we using Temp tables on it. Pleas find below sample query,</p>
  
  <pre><code>DROP TABLE IF EXISTS Employee;
  CREATE LOCAL TEMPORARY TABLE IF NOT EXISTS Employee(EmpNo INTEGER, EmpName VARCHAR) ON COMMIT preserve rows unsegmented ALL nodes;
  INSERT INTO Employee (EmpNo, EmpName) VALUES (1000, 'AAA');
  INSERT INTO Employee (EmpNo, EmpName) VALUES (1001, 'BBB');
  SELECT EmpNo, EmpName FROM Employee;
  </code></pre>
  
  <p>Please advise how to resolve this issue.</p>