CREATE TABLE tab (
  col1_0 NAME,
  col1_1 INT8,
  col1_3 INT8,
  col1_5 VARCHAR,
  PRIMARY KEY (col1_0 ASC),
  UNIQUE (col1_1 ASC, col1_3 ASC)
    PARTITION BY LIST (col1_1,col1_3) (
      PARTITION table1_part_0 VALUES IN (
                                (
                                  1,
                                  NULL
                                )
                              ),
      PARTITION table1_part_1 VALUES IN (
                                (
                                  1000000000,
                                  NULL
                                )
                              ),
      PARTITION table1_part_2 VALUES IN (
                                (
                                  2000000000,
                                  NULL
                                )
                              )
      )
);

INSERT
INTO
	tab
VALUES
	('a', 1, NULL, 'foo1'),
	('b', 1000000000, NULL, 'foo2'),
	('c', 2000000000, NULL, 'foo3'),
	('d', 0, NULL, 'foo4'),
	('aa', 1, 1, 'foo1'),
	('bb', 1000000000, 1, 'foo2'),
	('cc', 2000000000, 1, 'foo3'),
	('dd', 0, 1, 'foo4');

UPDATE tab
     SET col1_5 = 'bar'
   WHERE col1_0 ILIKE col1_0
ORDER BY col1_3
   LIMIT 84;

UPDATE tab@{NO_FULL_SCAN}
     SET col1_5 = 'bar'
   WHERE col1_0 ILIKE col1_0
ORDER BY col1_3
   LIMIT 84;