You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
DROPTABLE IF EXISTS test_delta;
CREATETABLEtest_delta (
id integer,
first varchar,
second varchar
)
WITH (
type ='DELTA',
partitioned_by = ARRAY['second', 'first'] -- NOTE: different than table column order
);
INSERT INTO test_delta (first, id, second)
VALUES ('A', 1, 'B');
-- also broken when inserting with default column orderINSERT INTO test_delta
VALUES (2, 'X', 'Y');
select*from test_delta;
Here is the output. Notice first and second are swapped:
id
first
second
1
B
A
2
Y
X
Some example test queries
-- test casesSELECT if (first <>'A', fail('delta partitioning is broken')) FROM test_delta WHERE id =1;
SELECT if (first <>'X', fail('delta partitioning is broken')) FROM test_delta WHERE id =2;
The text was updated successfully, but these errors were encountered:
Here is the output. Notice first and second are swapped:
Some example test queries
The text was updated successfully, but these errors were encountered: