ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where A.id in (select A.id from table_b B) 


Ϊɶ´íÎóµÄд·¨£¬oralce±àÒë²»±¨´íÄØ£¿
¶øÇÒ Ö»ÒªB±íÖÐÓÐÊý¾Ý£¬A¾ÍÈ«±í¸üÐÂÁË
  B±íûÊý¾Ý£¬A±í¾ÍupdateÁË0Ìõ¼Ç¼£¬
Ë­ÄܽâÊÍÏ£¿ÊÇoracleµÄbugô£¿

---

(select A.id from table_b B)Õâ¾äÊÇ¿ÉÒÔÖ´ÐеÄ
Äã˵µÄ´íÎóµÄд·¨Ö»ÊǺÍÄãµÄ±¾Òâ²»Ò»Ö£¬Óï·¨ÉÏû´í

---

UP~

---

select A.id from table_b B

µ¥¶ÀµÄÓï¾äÔËÐÐ:
Ìáʾ:ora-00904µÄ´íÎó!

---

ÒýÓÃ

UP~

select * from test a
where name in(
select a.name from test b)

Õâ¸ö¾Í²»Ìáʾ,Ö±½ÓÏÔʾ
select * from test a

---

±íAºÍB×ö½»²æ£¬Ö»ÒªBÖÐÓÐÊý¾Ý£¬¾Í¸üÐÂAµÄËùÓÐÊý¾Ý£»(Ò²¿ÉÒÔ°ÑB»»³ÉdualÒ»Ñù)
BÖÐûÓÐÊý¾Ý£¬¾Í¸üÐÂ0ÐУ»

---

µ¥¶ÀÓï¾ä¿Ï¶¨²»ÐУ¬

ËûÉÏÃæÓï¾äÀïÃæÒѾ­¶¨ÒåÁ˱íAÁË£¬²»ÖªµÀÕâô˵ÊÇ·ñ׼ȷ

---

ÒýÓÃ

select A.id from table_b B

µ¥¶ÀµÄÓï¾äÔËÐÐ:
Ìáʾ:ora-00904µÄ´íÎó!

ÎÒ˵µÄÊǵڶþ¾ä»°¡£¡£¡£²»Êǵ¥¶ÀµÄ×Ó²éѯ

---

ÒýÓÃ

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
      set A.flag=1
      where A.id in (select B.id from table_b B)
½á¹ûÎóд³É<