| 澶辨晥閾炬帴澶勭悊 |
|
GBase 8a MPP Cluster瀛樺偍榪囩▼寮傚父澶勭悊鍙傝€冩墜鍐?PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1ARQFNM2oYhAXTD0246IZlw
鎻愬彇鐮侊細(xì)weit
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
鍓嶈█
鎵嬪唽綆€浠?nbsp;
瀛樺偍榪囩▼寮傚父澶勭悊鍙傝€冩墜鍐屼富瑕佺敤浜庢寚瀵肩敤鎴峰湪 GBase 8a MPP Cluster
涓嬌鐢ㄥ瓨鍌ㄨ繃紼嬩腑鏃訛紝濡備綍鑾峰彇鍑虹幇閿欒 SQL 鐨勫紓甯鎬俊鎭€?/div>
鏈墜鍐屼富瑕佷粙緇嶅紓甯鎬俊鎭殑鍒嗙被錛孏ET DIAGNOSTICS 鐨勮娉曟牸寮忋€傚湪紺轟緥
璇存槑閮ㄥ垎閫氳繃瀹炰緥璇存槑濡備綍鍦ㄥ瓨鍌ㄨ繃紼嬩腑閫氳繃浣跨敤 GET DIAGNOSTICS 鍛戒護(hù)鑾峰彇
寮傚父淇℃伅銆?/div>
鍏害
涓嬮潰鐨勬枃鏈害瀹氱敤浜庢湰鏂囨。錛?/div>
綰?瀹?璇?鏄?/div>
鍔犵矖瀛椾綋 琛ㄧず鏂囨。鏍囬
澶у啓鑻辨枃錛圫ELECT錛?琛ㄧず GBase 8a MPP Cluster 鍏抽敭瀛?/div>
絳夊瀛椾綋 琛ㄧず浠ｇ爜紺轟緥
… 鐪佺暐鍙鋒寚鏄庤鐪佺暐鐨勫唴瀹廣€?/div>
瀛樺偍榪囩▼寮傚父澶勭悊鍙傝€冩墜鍐?/div>
- 2 - 鍗楀ぇ閫氱敤鏁版嵁鎶€鏈偂浠芥湁闄愬叕鍙?/div>
1 瀛樺偍榪囩▼寮傚父澶勭悊
1.1 綆€浠?nbsp;
GBase 8a MPP Cluster 鏀寔淇濆瓨瀛樺偍榪囩▼鐨勫紓甯鎬俊鎭姛鑳斤紝鍚屾椂涔熻兘鑾峰緱
DML 鎿嶄綔鐨勫獎鍝嶈鏁般€?/div>
璇婃柇淇℃伅涓昏鍒嗕袱綾伙細(xì)
1) 鎶ラ敊淇℃伅錛屼富瑕佸寘鎷敊璇暟銆侀敊璇彿銆侀敊璇姸鎬併€侀敊璇俊鎭€?/div>
2) DML 鎿嶄綔褰卞搷鐨勮鏁般€?/div>
1.2 瀹夎鏂囦歡
GBase 8a MPP Cluster 鍦ㄥ畨瑁呭悗榛樿鏀寔姝ゅ姛鑳姐€?/div>
1.3 璇硶鏍煎紡
鐢ㄦ埛鍙互鍦ㄥ瓨鍌ㄨ繃紼嬨€佽嚜瀹氫箟鍑芥暟涓垨鐩存帴鍦ㄥ鎴風(fēng)閫氳繃 GET DIAGNOSTICS
璇硶鑾峰緱鎶ラ敊淇℃伅銆丏ML 鎿嶄綔褰卞搷緇撴灉鏁般€?/div>
飪?鑾峰彇閿欒鏁板懡浠ゆ牸寮忓涓嬶細(xì)
GET DIAGNOSTICS @a=number; 飪?鑾峰彇 DML 鎿嶄綔褰卞搷鐨勮鏁板懡浠ゆ牸寮忓涓嬶細(xì)
GET DIAGNOSTICS @a=row_count;
飪?鑾峰彇閿欒鍙峰懡浠ゆ牸寮忓涓嬶細(xì)
GET DIAGNOSTICS CONDITION no @a=gbase_errno;
飪?鑾峰彇閿欒鐘舵€佸懡浠ゆ牸寮忓涓嬶細(xì)
瀛樺偍榪囩▼寮傚父澶勭悊鍙傝€冩墜鍐?/div>
鍗楀ぇ閫氱敤鏁版嵁鎶€鏈偂浠芥湁闄愬叕鍙?- 3 -
GET DIAGNOSTICS CONDITION no @a=returned_sqlstate; 飪?鑾峰彇閿欒淇℃伅鍛戒護(hù)鏍煎紡濡備笅錛?/div>
GET DIAGNOSTICS CONDITION no @a=message_text;
璇硶瀹氫箟涓殑
number/row_count/gbase_errno/returned_sqlstate/message_text 鍙互鐞嗚В
涓虹郴緇熷彉閲忥細(xì)
no 琛ㄧず閿欒鎴?WARNINGS 鐨勫簭鍙楓€?number 涓寘鍚?WARNING 鍜岄敊璇殑鏁伴噺銆?row_count 鍙褰?GET DIAGNOSTICS 鍛戒護(hù)涔嬪墠鏈€鍚庝竴鏉?DML 鎿嶄綔鐨勫獎鍝嶈
鏁幫紝涓嶈兘绱姞錛屽鏋滄兂鑾峰彇澶氭潯 DML 璇彞鐨勫獎鍝嶈鏁幫紝闇€瑕佸湪姣忔潯 DML 璇彞鍚?/div>
鎵ц GET DIAGNOSTICS 鍛戒護(hù)銆?/div>
gbase_errno 璁板綍閿欒鍙楓€?/div>
returned_sqlstate 璁板綍閿欒鐘舵€併€?/div>
message_text 璁板綍閿欒淇℃伅銆?/div>
GET DIAGNOSTICS 鍛戒護(hù)鍙互鐢ㄥ湪瀛樺偍榪囩▼澶栭儴錛屼絾涓昏鐢ㄤ簬瀛樺偍榪囩▼鍐呴儴銆?/div>
1.4 紺轟緥璇存槑
1.4.1鑾峰彇閿欒鏁?nbsp;
SQL 璇彞濡備笅錛?/div>
DROP TABLE IF EXISTS t;
DROP TABLE IF EXISTS tt;
DROP PROCEDURE IF EXISTS p1;
DELIMITER //
CREATE PROCEDURE p1()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
瀛樺偍榪囩▼寮傚父澶勭悊鍙傝€冩墜鍐?/div>
- 4 - 鍗楀ぇ閫氱敤鏁版嵁鎶€鏈偂浠芥湁闄愬叕鍙?/div>
BEGIN
GET DIAGNOSTICS @num1 = NUMBER;
SELECT @num1;
END;
DELETE FROM tt ;
DROP TABLE IF EXISTS t;
GET DIAGNOSTICS @num2 = NUMBER;
SELECT @num2;
END//
DELIMITER ;
CALL p1;
鎵ц緇撴灉濡備笅錛?/div>
gbase> CALL p1; +-------+
| @num1 |
+-------+
| 1 |
+-------+
1 row in set
+-------+
| @num2 | +-------+
| 1 |
+-------+
1 row in set
Query OK, 0 rows affected, 8 warnings
gbase> SHOW WARNINGS; +-------+------+-----------------------------------------+
| Level | Code | Message |
+-------+------+-----------------------------------------+
| Note | 1051 | 192.168.103.77:5050 - Unknown table 't' |
瀛樺偍榪囩▼寮傚父澶勭悊鍙傝€冩墜鍐?/div>
鍗楀ぇ閫氱敤鏁版嵁鎶€鏈偂浠芥湁闄愬叕鍙?- 5 -
| Note | 1051 | 192.168.103.75:5050 - Unknown table 't' |
| Note | 1051 | 192.168.103.74:5050 - Unknown table 't' |
| Note | 1051 | 192.168.103.76:5050 - Unknown table 't' |
| Note | 1051 | 192.168.103.77:5258 - Unknown table 't' |
| Note | 1051 | 192.168.103.75:5258 - Unknown table 't' |
| Note | 1051 | 192.168.103.76:5258 - Unknown table 't' |
| Note | 1051 | 192.168.103.74:5258 - Unknown table 't' |
+-------+------+-----------------------------------------+
8 rows in set
1.4.2鑾峰彇 DML 鎿嶄綔褰卞搷鐨勮鏁幫紙1錛?闈?DML 鎿嶄綔鎵ц瀹屾垚鍚庯紝濡傛灉鐢?GET DIAGNOSTICS 璇硶鑾峰緱 DML 鎿嶄綔褰卞搷
琛屾暟錛屽緱鍒扮殑緇撴灉鏄?1銆?/div>
SQL 璇彞濡備笅錛?/div>
DROP PROCEDURE IF EXISTS p1;
DELIMITER |
CREATE PROCEDURE p1()
BEGIN
DECLARE row_count INT;
GET DIAGNOSTICS row_count = ROW_COUNT;
SELECT row_count;
END|
DELIMITER ;
CALL p1();
鎵ц緇撴灉濡備笅錛?/div>
gbase> CALL p1();
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
