[海量数据：兼容M*]支持DIAGNOSTICS

支持DIAGNOSTICS，获取诊断信息。语法树参照：
CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS 
      errno = NUMBER, msg = ROW_COUNT;
    SELECT 'current DA before mapped insert' AS  errno, msg;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
   GET DIAGNOSTICS    errno = NUMBER, msg = ROW_COUNT;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1 msg = CLASS_ORIGIN;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1  msg = SUBCLASS_ORIGIN;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1   msg = RETURNED_SQLSTATE;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1    msg = MESSAGE_TEXT;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1  msg = MYSQL_ERRNO;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1    msg = CONSTRAINT_CATALOG;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1    msg = CONSTRAINT_SCHEMA;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1   msg = CONSTRAINT_NAME;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1   msg = CATALOG_NAME;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1  msg = SCHEMA_NAME;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1   msg = TABLE_NAME;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1   msg = COLUMN_NAME;
  END;
END;

CREATE PROCEDURE p ()
BEGIN
  DECLARE errcount INT;
  DECLARE errno INT;
  DECLARE msg TEXT;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  BEGIN
    GET DIAGNOSTICS CONDITION 1   msg = CURSOR_NAME;
  END;
END;

openGauss/openGauss-server

内容风险标识

评论 (0)

openGauss/openGauss-server .gitee-modal { width: 500px !important; }

内容风险标识