equi_join_by_expr.sql « join « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/join/equi_join_by_expr.sql

blob: d2cad734691eef7dc94775fc8ffe241fb96d0b47 (plain) (blame)

1
2
3

PRAGMA DisableSimpleColumns;
/* postgres can not */
SELECT * FROM plato.Input2 as A JOIN plato.Input3 as B ON CAST(A.key AS INT) + 1 == CAST(B.key AS INT);