blob: c47a5a1f65a25a04ffe0093e266b488904539fc9 [file] [log] [blame]
-- GPDB used to define Datum as a signed type. That caused below
-- soring issues.
create table mac_tbl (id int, mac macaddr) distributed by (id);
insert into mac_tbl values
(0, '00:00:00:00:00:00'),
(0, 'ff:ff:ff:ff:ff:ff'),
(0, '11:11:11:11:11:11');
select * from mac_tbl order by mac;
create table uuid_tbl (id int, uid uuid) distributed by (id);
insert into uuid_tbl values
(0, '00000000000000000000000000000000'),
(0, 'ffffffffffffffffffffffffffffffff'),
(0, '11111111111111111111111111111111');
select * from uuid_tbl order by uid;