aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/action/eval_input_output_table.sql
blob: e8bbd374f9d5a734f0b7d93ac3abadc79ed6dec4 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
/* syntax version 1 */
/* postgres can not */
USE plato;

$a = CAST(Unicode::ToUpper("o"u) AS String) || "utput";
$b = CAST(Unicode::ToUpper("i"u) AS String) || "nput";
INSERT INTO $a
SELECT
    key as key,
    "" as subkey,
    "value:" || value as value
FROM $b
WHERE key < "100"
ORDER BY key;