mysql> drop table if exists tb;
Query OK, 0 rows affected (0.00 sec)

mysql> create table tb (s1 int, s2 int) engine=myisam partition by list(s1) (partition p1 values in (1), partition p2 values in (2))
Query OK, 0 rows affected (0.05 sec)

mysql> insert into tb values (1,1);
Query OK, 1 row affected (0.00 sec)

mysql> create index ib on tb (s1);
Query OK, 1 row affected (0.05 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> update tb set s1 = 2 where s1 = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from tb;
+------+------+
| s1   | s2   |
+------+------+
|    2 |    1 |
+------+------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql> drop table if exists tb;
Query OK, 0 rows affected (0.00 sec)

mysql> create table tb (s1 int, s2 int) engine=falcon partition by list(s1) (partition p1 values in (1), partition p2 values in (2))
Query OK, 0 rows affected (0.08 sec)

mysql> insert into tb values (1,1);
Query OK, 1 row affected (0.00 sec)

mysql> create index ib on tb (s1);
Query OK, 1 row affected (0.39 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> update tb set s1 = 2 where s1 = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from tb;
+------+------+
| s1   | s2   |
+------+------+
|    2 | NULL |
+------+------+
1 row in set (0.00 sec)