aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/expr/pickle.sql
blob: 2279d409c0b6f2b2d60588a7d1b041401e401351 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
/* postgres can not */
/* syntax version 1 */
$lst = AsList(AsTuple(13,4),AsTuple(11,2),AsTuple(17,8),AsTuple(5,6));

$p1 = Pickle(ToDict($lst));
$p2 = StablePickle(ToDict($lst));
$p3 = StablePickle(ToSortedDict($lst));
$p4 = Pickle(ToDict(ListReverse($lst)));
$p5 = StablePickle(ToDict(ListReverse($lst)));
select $p1, Ensure($p2, $p1 != $p2), Ensure($p3, $p2 = $p3),
    Ensure($p4, $p4 != $p1), Ensure($p5, $p5 = $p2);
select ListSort(DictItems(Unpickle(TypeOf(ToDict($lst)),$p1))), ListSort(DictItems(Unpickle(TypeOf(ToDict($lst)),$p2)));