blob: 45fb1781a5eac7577f8dde9cf543a663fb65581d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
/* custom error:column name: value conflicted without correlation name it may be one of: Input.value, d.value*/
PRAGMA DisableSimpleColumns;
USE plato;
$data = (SELECT key as kk, subkey as sk, value || value as value FROM Input WHERE cast(key as uint32)/100 > 3);
--INSERT INTO Output
SELECT
value, key -- value is conflicted between Input and d sources
FROM Input JOIN $data as d ON Input.subkey = d.kk
;
|
