Comments - Index Condition Pushdown
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
0
CREATE TABLE `t2` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` char(10) DEFAULT NULL, `d` varchar(256) DEFAULT NULL, `e` text, KEY `ii1` (`a`,`b`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
sql1: update t2 set b = 3 where a = 1; sql2: select b from t2 where a = 1;
sql2 will use index condition pushdown, but sql1 doesn't, but why, is that data format between engine and server transformation?