[20180609]Wrong Results with IOT, Added Column and Secondary Index2.tx...
[20180609]Wrong Results with IOT, Added Column and Secondary Index2.txt --//链接:http://db-oriented.com/2018/06/05/wrong-results-with-iot-added-column-and-secondary-index/ --//我记得ITPUB上也有一位网友遇到类似的问题. --//昨天测试很晚,上午又看一下测试,我发现对方建立的IOT表非常特殊,开始建立的表的字段全是主键.然后再增加 --//字段. create table iot ( x number, y number, constraint iot_pk primary key (x,y) ) organization index; --//全部是主键. alter table iot add z number; row#0[7968] flag: K------, lock: 2, len=14 col 0; len 2; (2): c1 02 col 1; len 2; (2): c1 02 tl:...