yql/essentials/tests/sql/suites/select/multi_source_issue.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

/* postgres can not */
USE plato;

$i = (SELECT * FROM Input2);
$ii = (SELECT * FROM Input4);

$count_a=(SELECT count(*) FROM $i WHERE substring(value, 0, 1) = 'a');

--INSERT INTO Output
SELECT
  count(*), count(*)/$count_a
FROM $i;

--INSERT INTO Output
SELECT
  count(*), count(*)/$count_a
FROM $ii;