:OLD.ID))\n OR ((:NEW.SOURCE IS NULL AND :OLD.SOURCE IS NOT NULL)\n OR (:NEW.SOURCE IS NOT NULL AND :OLD.SOURCE IS NULL)\n OR (:NEW.SOURCE IS NOT NULL AND :OLD.SOURCE IS NOT NULL AND :NEW.SOURCE <> :OLD.SOURCE))\n OR (NVL(LENGTHB(:NEW.DEVICE_ORDER_NO), -1) <> NVL(LENGTHB(:OLD.DEVICE_ORDER_NO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.DEVICE_ORDER_NO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.DEVICE_ORDER_NO)), '#'))\n OR (NVL(LENGTHB(:NEW.MACHID), -1) <> NVL(LENGTHB(:OLD.MACHID), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.MACHID)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.MACHID)), '#'))\n OR ((:NEW.EQUIPMENT_ID IS NULL AND :OLD.EQUIPMENT_ID IS NOT NULL)\n OR (:NEW.EQUIPMENT_ID IS NOT NULL AND :OLD.EQUIPMENT_ID IS NULL)\n OR (:NEW.EQUIPMENT_ID IS NOT NULL AND :OLD.EQUIPMENT_ID IS NOT NULL AND :NEW.EQUIPMENT_ID <> :OLD.EQUIPMENT_ID))\n OR ((:NEW.RESTAURANT_ID IS NULL AND :OLD.RESTAURANT_ID IS NOT NULL)\n OR (:NEW.RESTAURANT_ID IS NOT NULL AND :OLD.RESTAURANT_ID IS NULL)\n OR (:NEW.RESTAURANT_ID IS NOT NULL AND :OLD.RESTAURANT_ID IS NOT NULL AND :NEW.RESTAURANT_ID <> :OLD.RESTAURANT_ID))\n OR (NVL(LENGTHB(:NEW.TRACKNO), -1) <> NVL(LENGTHB(:OLD.TRACKNO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.TRACKNO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.TRACKNO)), '#'))\n OR (NVL(LENGTHB(:NEW.GOODS_NAME), -1) <> NVL(LENGTHB(:OLD.GOODS_NAME), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.GOODS_NAME)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.GOODS_NAME)), '#'))\n OR ((:NEW.PRICE IS NULL AND :OLD.PRICE IS NOT NULL)\n OR (:NEW.PRICE IS NOT NULL AND :OLD.PRICE IS NULL)\n OR (:NEW.PRICE IS NOT NULL AND :OLD.PRICE IS NOT NULL AND :NEW.PRICE <> :OLD.PRICE))\n OR (NVL(LENGTHB(:NEW.CHANNELID), -1) <> NVL(LENGTHB(:OLD.CHANNELID), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.CHANNELID)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.CHANNELID)), '#'))\n OR ((:NEW.PREPAY_STATUS IS NULL AND :OLD.PREPAY_STATUS IS NOT NULL)\n OR (:NEW.PREPAY_STATUS IS NOT NULL AND :OLD.PREPAY_STATUS IS NULL)\n OR (:NEW.PREPAY_STATUS IS NOT NULL AND :OLD.PREPAY_STATUS IS NOT NULL AND :NEW.PREPAY_STATUS <> :OLD.PREPAY_STATUS))\n OR ((:NEW.MEAL_ORDER_ID IS NULL AND :OLD.MEAL_ORDER_ID IS NOT NULL)\n OR (:NEW.MEAL_ORDER_ID IS NOT NULL AND :OLD.MEAL_ORDER_ID IS NULL)\n OR (:NEW.MEAL_ORDER_ID IS NOT NULL AND :OLD.MEAL_ORDER_ID IS NOT NULL AND :NEW.MEAL_ORDER_ID <> :OLD.MEAL_ORDER_ID))\n OR (NVL(LENGTHB(:NEW.MEAL_ORDER_NO), -1) <> NVL(LENGTHB(:OLD.MEAL_ORDER_NO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.MEAL_ORDER_NO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.MEAL_ORDER_NO)), '#'))\n OR ((:NEW.USER_ID IS NULL AND :OLD.USER_ID IS NOT NULL)\n OR (:NEW.USER_ID IS NOT NULL AND :OLD.USER_ID IS NULL)\n OR (:NEW.USER_ID IS NOT NULL AND :OLD.USER_ID IS NOT NULL AND :NEW.USER_ID <> :OLD.USER_ID))\n OR ((:NEW.SHIP_STATUS IS NULL AND :OLD.SHIP_STATUS IS NOT NULL)\n OR (:NEW.SHIP_STATUS IS NOT NULL AND :OLD.SHIP_STATUS IS NULL)\n OR (:NEW.SHIP_STATUS IS NOT NULL AND :OLD.SHIP_STATUS IS NOT NULL AND :NEW.SHIP_STATUS <> :OLD.SHIP_STATUS))\n OR (NVL(LENGTHB(:NEW.ERRINFO), -1) <> NVL(LENGTHB(:OLD.ERRINFO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.ERRINFO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.ERRINFO)), '#'))\n OR ((:NEW.EXPIRE_TIME IS NULL AND :OLD.EXPIRE_TIME IS NOT NULL)\n OR (:NEW.EXPIRE_TIME IS NOT NULL AND :OLD.EXPIRE_TIME IS NULL)\n OR (:NEW.EXPIRE_TIME IS NOT NULL AND :OLD.EXPIRE_TIME IS NOT NULL AND :NEW.EXPIRE_TIME <> :OLD.EXPIRE_TIME))\n OR ((:NEW.PAY_TIME IS NULL AND :OLD.PAY_TIME IS NOT NULL)\n OR (:NEW.PAY_TIME IS NOT NULL AND :OLD.PAY_TIME IS NULL)\n OR (:NEW.PAY_TIME IS NOT NULL AND :OLD.PAY_TIME IS NOT NULL AND :NEW.PAY_TIME <> :OLD.PAY_TIME))\n OR ((:NEW.SHIP_TIME IS NULL AND :OLD.SHIP_TIME IS NOT NULL)\n OR (:NEW.SHIP_TIME IS NOT NULL AND :OLD.SHIP_TIME IS NULL)\n OR (:NEW.SHIP_TIME IS NOT NULL AND :OLD.SHIP_TIME IS NOT NULL AND :NEW.SHIP_TIME <> :OLD.SHIP_TIME))\n OR ((:NEW.CREATE_TIME IS NULL AND :OLD.CREATE_TIME IS NOT NULL)\n OR (:NEW.CREATE_TIME IS NOT NULL AND :OLD.CREATE_TIME IS NULL)\n OR (:NEW.CREATE_TIME IS NOT NULL AND :OLD.CREATE_TIME IS NOT NULL AND :NEW.CREATE_TIME <> :OLD.CREATE_TIME))\n OR (NVL(LENGTHB(:NEW.CREATE_BY), -1) <> NVL(LENGTHB(:OLD.CREATE_BY), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.CREATE_BY)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.CREATE_BY)), '#'))\n OR (NVL(LENGTHB(:NEW.UPDATE_BY), -1) <> NVL(LENGTHB(:OLD.UPDATE_BY), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.UPDATE_BY)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.UPDATE_BY)), '#')) THEN\n V_CHANGED := 1;\n END IF;\n -- FIELD RAW_REQUEST_A: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_A IS NULL AND :OLD.RAW_REQUEST_A IS NOT NULL)\n OR (:NEW.RAW_REQUEST_A IS NOT NULL AND :OLD.RAW_REQUEST_A IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_A IS NOT NULL AND :OLD.RAW_REQUEST_A IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_A);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_A);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_A,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_A,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_A,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_A,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD RAW_REQUEST_C: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_C IS NULL AND :OLD.RAW_REQUEST_C IS NOT NULL)\n OR (:NEW.RAW_REQUEST_C IS NOT NULL AND :OLD.RAW_REQUEST_C IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_C IS NOT NULL AND :OLD.RAW_REQUEST_C IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_C);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_C);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_C,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_C,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_C,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_C,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD RAW_REQUEST_B: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_B IS NULL AND :OLD.RAW_REQUEST_B IS NOT NULL)\n OR (:NEW.RAW_REQUEST_B IS NOT NULL AND :OLD.RAW_REQUEST_B IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_B IS NOT NULL AND :OLD.RAW_REQUEST_B IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_B);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_B);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_B,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_B,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_B,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_B,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD QRCODE_PAYLOAD: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.QRCODE_PAYLOAD IS NULL AND :OLD.QRCODE_PAYLOAD IS NOT NULL)\n OR (:NEW.QRCODE_PAYLOAD IS NOT NULL AND :OLD.QRCODE_PAYLOAD IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.QRCODE_PAYLOAD IS NOT NULL AND :OLD.QRCODE_PAYLOAD IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.QRCODE_PAYLOAD);\n V_NEW_LEN := LENGTH(:NEW.QRCODE_PAYLOAD);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.QRCODE_PAYLOAD,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.QRCODE_PAYLOAD,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.QRCODE_PAYLOAD,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.QRCODE_PAYLOAD,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n IF V_CHANGED = 1 THEN\n :NEW.UPDATE_TIME := TO_TIMESTAMP(TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS');\n END IF;\n END IF;\nEND;", "source_shadow_plan_sha256": "8733e44344c5e96d57398e2b33b3ea4b66d2c9403ec8a23e51fdc7470eaa1b94", "steps": [ { "ordinal": 1, "kind": "read", "label": "pre.identity", "role": "identity", "SQL": "SELECT VERSION() AS VERSION,DATABASE() AS DB,@@session.sql_mode AS SQL_MODE,@@session.time_zone AS TIME_ZONE,@@session.character_set_connection AS CONNECTION_CHARSET", "binds": [], "PDO_types": [], "read_query": "identity" }, { "ordinal": 2, "kind": "read", "label": "pre.table", "role": "collision", "SQL": "SELECT TABLE_NAME,ENGINE,ROW_FORMAT,TABLE_COLLATION,CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=?", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "table" }, { "ordinal": 3, "kind": "read", "label": "pre.indexes", "role": "collision", "SQL": "SELECT INDEX_NAME,NON_UNIQUE,COLUMN_NAME,SEQ_IN_INDEX,SUB_PART,COLLATION,INDEX_TYPE FROM information_schema.STATISTICS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY INDEX_NAME,SEQ_IN_INDEX", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "indexes" }, { "ordinal": 4, "kind": "read", "label": "pre.constraints", "role": "collision", "SQL": "SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR CONSTRAINT_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME", "binds": [ "cdx_ppfull261011_s2", "PK_cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 5, "kind": "read", "label": "pre.keys", "role": "collision", "SQL": "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR REFERENCED_TABLE_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME,ORDINAL_POSITION", "binds": [ "cdx_ppfull261011_s2", "cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "keys" }, { "ordinal": 6, "kind": "read", "label": "pre.triggers", "role": "collision", "SQL": "SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA=DATABASE() AND (EVENT_OBJECT_TABLE=? OR ACTION_STATEMENT LIKE ?) ORDER BY TRIGGER_NAME", "binds": [ "cdx_ppfull261011_s2", "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 7, "kind": "read", "label": "pre.views", "role": "collision", "SQL": "SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE TABLE_SCHEMA=DATABASE() AND VIEW_DEFINITION LIKE ? ORDER BY TABLE_NAME", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "views" }, { "ordinal": 8, "kind": "read", "label": "pre.routines", "role": "collision", "SQL": "SELECT ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA=DATABASE() AND ROUTINE_DEFINITION LIKE ? ORDER BY ROUTINE_NAME,ROUTINE_TYPE", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "routines" }, { "ordinal": 9, "kind": "DDL", "label": "create", "role": "create", "SQL": "CREATE TABLE cdx_ppfull261011_s2 LIKE ydy_prepay_order", "binds": [], "PDO_types": [] }, { "ordinal": 10, "kind": "read", "label": "create.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 11, "kind": "read", "label": "created.table", "role": "created_schema", "SQL": "SELECT TABLE_NAME,ENGINE,ROW_FORMAT,TABLE_COLLATION,CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=?", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "table" }, { "ordinal": 12, "kind": "read", "label": "created.columns", "role": "created_schema", "SQL": "SELECT COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_DEFAULT,EXTRA,CHARACTER_SET_NAME,COLLATION_NAME,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,DATETIME_PRECISION,ORDINAL_POSITION FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY ORDINAL_POSITION", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "columns" }, { "ordinal": 13, "kind": "read", "label": "created.indexes", "role": "created_schema", "SQL": "SELECT INDEX_NAME,NON_UNIQUE,COLUMN_NAME,SEQ_IN_INDEX,SUB_PART,COLLATION,INDEX_TYPE FROM information_schema.STATISTICS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY INDEX_NAME,SEQ_IN_INDEX", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "indexes" }, { "ordinal": 14, "kind": "read", "label": "created.constraints", "role": "created_schema", "SQL": "SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR CONSTRAINT_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME", "binds": [ "cdx_ppfull261011_s2", "PK_cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 15, "kind": "read", "label": "created.keys", "role": "created_schema", "SQL": "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR REFERENCED_TABLE_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME,ORDINAL_POSITION", "binds": [ "cdx_ppfull261011_s2", "cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "keys" }, { "ordinal": 16, "kind": "read", "label": "created.triggers", "role": "created_schema", "SQL": "SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA=DATABASE() AND (EVENT_OBJECT_TABLE=? OR ACTION_STATEMENT LIKE ?) ORDER BY TRIGGER_NAME", "binds": [ "cdx_ppfull261011_s2", "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 17, "kind": "read", "label": "created.views", "role": "created_schema", "SQL": "SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE TABLE_SCHEMA=DATABASE() AND VIEW_DEFINITION LIKE ? ORDER BY TABLE_NAME", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "views" }, { "ordinal": 18, "kind": "read", "label": "created.routines", "role": "created_schema", "SQL": "SELECT ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA=DATABASE() AND ROUTINE_DEFINITION LIKE ? ORDER BY ROUTINE_NAME,ROUTINE_TYPE", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "routines" }, { "ordinal": 19, "kind": "read", "label": "created.ddl", "role": "created_schema", "SQL": "SHOW CREATE TABLE cdx_ppfull261011_s2", "binds": [], "PDO_types": [], "read_query": "ddl" }, { "ordinal": 20, "kind": "read", "label": "SEED.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "SEED" }, { "ordinal": 21, "kind": "DML", "label": "SEED", "role": "seed", "SQL": "INSERT INTO cdx_ppfull261011_s2 (ID,SOURCE,DEVICE_ORDER_NO,MACHID,EQUIPMENT_ID,RESTAURANT_ID,TRACKNO,GOODS_NAME,PRICE,CHANNELID,PREPAY_STATUS,MEAL_ORDER_ID,MEAL_ORDER_NO,USER_ID,SHIP_STATUS,ERRINFO,RAW_REQUEST_A,RAW_REQUEST_C,RAW_REQUEST_B,QRCODE_PAYLOAD,EXPIRE_TIME,PAY_TIME,SHIP_TIME,CREATE_TIME,CREATE_BY,UPDATE_TIME,UPDATE_BY) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2 ] }, { "ordinal": 22, "kind": "read", "label": "SEED.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 23, "kind": "read", "label": "SEED.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "SEED" }, { "ordinal": 24, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A.RESET" }, { "ordinal": 25, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_A.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 26, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 27, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A.RESET" }, { "ordinal": 28, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A" }, { "ordinal": 29, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_A", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET RAW_REQUEST_A=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_RAW_REQUEST_A", "changed_column": "RAW_REQUEST_A" }, { "ordinal": 30, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 31, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A" }, { "ordinal": 32, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C.RESET" }, { "ordinal": 33, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_C.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 34, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 35, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C.RESET" }, { "ordinal": 36, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C" }, { "ordinal": 37, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_C", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET RAW_REQUEST_C=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_RAW_REQUEST_C", "changed_column": "RAW_REQUEST_C" }, { "ordinal": 38, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 39, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C" }, { "ordinal": 40, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B.RESET" }, { "ordinal": 41, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_B.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 42, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 43, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B.RESET" }, { "ordinal": 44, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B" }, { "ordinal": 45, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_B", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET RAW_REQUEST_B=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_RAW_REQUEST_B", "changed_column": "RAW_REQUEST_B" }, { "ordinal": 46, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 47, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B" }, { "ordinal": 48, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD.RESET" }, { "ordinal": 49, "kind": "DML", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 50, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 51, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD.RESET" }, { "ordinal": 52, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD" }, { "ordinal": 53, "kind": "DML", "label": "BOUNDARY_QRCODE_PAYLOAD", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET QRCODE_PAYLOAD=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_QRCODE_PAYLOAD", "changed_column": "QRCODE_PAYLOAD" }, { "ordinal": 54, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 55, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD" }, { "ordinal": 56, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A.RESET" }, { "ordinal": 57, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 58, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 59, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A.RESET" }, { "ordinal": 60, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A" }, { "ordinal": 61, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_A", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET RAW_REQUEST_A=RAW_REQUEST_A WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_RAW_REQUEST_A", "changed_column": null }, { "ordinal": 62, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 63, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A" }, { "ordinal": 64, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C.RESET" }, { "ordinal": 65, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 66, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 67, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C.RESET" }, { "ordinal": 68, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C" }, { "ordinal": 69, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_C", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET RAW_REQUEST_C=RAW_REQUEST_C WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_RAW_REQUEST_C", "changed_column": null }, { "ordinal": 70, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 71, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C" }, { "ordinal": 72, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B.RESET" }, { "ordinal": 73, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 74, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 75, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B.RESET" }, { "ordinal": 76, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B" }, { "ordinal": 77, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_B", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET RAW_REQUEST_B=RAW_REQUEST_B WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_RAW_REQUEST_B", "changed_column": null }, { "ordinal": 78, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 79, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B" }, { "ordinal": 80, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD.RESET" }, { "ordinal": 81, "kind": "DML", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 82, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 83, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD.RESET" }, { "ordinal": 84, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD" }, { "ordinal": 85, "kind": "DML", "label": "NONNULL_SELF_QRCODE_PAYLOAD", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET QRCODE_PAYLOAD=QRCODE_PAYLOAD WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_QRCODE_PAYLOAD", "changed_column": null }, { "ordinal": 86, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 87, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD" }, { "ordinal": 88, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.RESET.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS.RESET" }, { "ordinal": 89, "kind": "DML", "label": "ALL26_SELF_NONNULL_CLOBS.RESET", "role": "reset", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 90, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.RESET.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 91, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.RESET.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS.RESET" }, { "ordinal": 92, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.before", "role": "before", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS" }, { "ordinal": 93, "kind": "DML", "label": "ALL26_SELF_NONNULL_CLOBS", "role": "mutation", "SQL": "UPDATE cdx_ppfull261011_s2 SET ID=ID,SOURCE=SOURCE,DEVICE_ORDER_NO=DEVICE_ORDER_NO,MACHID=MACHID,EQUIPMENT_ID=EQUIPMENT_ID,RESTAURANT_ID=RESTAURANT_ID,TRACKNO=TRACKNO,GOODS_NAME=GOODS_NAME,PRICE=PRICE,CHANNELID=CHANNELID,PREPAY_STATUS=PREPAY_STATUS,MEAL_ORDER_ID=MEAL_ORDER_ID,MEAL_ORDER_NO=MEAL_ORDER_NO,USER_ID=USER_ID,SHIP_STATUS=SHIP_STATUS,ERRINFO=ERRINFO,RAW_REQUEST_A=RAW_REQUEST_A,RAW_REQUEST_C=RAW_REQUEST_C,RAW_REQUEST_B=RAW_REQUEST_B,QRCODE_PAYLOAD=QRCODE_PAYLOAD,EXPIRE_TIME=EXPIRE_TIME,PAY_TIME=PAY_TIME,SHIP_TIME=SHIP_TIME,CREATE_TIME=CREATE_TIME,CREATE_BY=CREATE_BY,UPDATE_BY=UPDATE_BY WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "ALL26_SELF_NONNULL_CLOBS", "changed_column": null }, { "ordinal": 94, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 95, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.after", "role": "after", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS" }, { "ordinal": 96, "kind": "read", "label": "cleanup.identity", "role": "cleanup_identity", "SQL": "SELECT VERSION() AS VERSION,DATABASE() AS DB,@@session.sql_mode AS SQL_MODE,@@session.time_zone AS TIME_ZONE,@@session.character_set_connection AS CONNECTION_CHARSET", "binds": [], "PDO_types": [], "read_query": "identity" }, { "ordinal": 97, "kind": "read", "label": "cleanup.snapshot", "role": "cleanup_snapshot", "SQL": "SELECT T.*,CURRENT_TIMESTAMP(0) AS CLOCK0,CURRENT_TIMESTAMP(6) AS CLOCK6,DATE_FORMAT(EXPIRE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_EXPIRE_TIME,DATE_FORMAT(PAY_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_PAY_TIME,DATE_FORMAT(SHIP_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_SHIP_TIME,DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_CREATE_TIME,DATE_FORMAT(UPDATE_TIME,'%Y-%m-%d %H:%i:%s.%f') AS F_UPDATE_TIME FROM cdx_ppfull261011_s2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot" }, { "ordinal": 98, "kind": "read", "label": "cleanup.table", "role": "cleanup_schema", "SQL": "SELECT TABLE_NAME,ENGINE,ROW_FORMAT,TABLE_COLLATION,CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=?", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "table" }, { "ordinal": 99, "kind": "read", "label": "cleanup.columns", "role": "cleanup_schema", "SQL": "SELECT COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_DEFAULT,EXTRA,CHARACTER_SET_NAME,COLLATION_NAME,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,DATETIME_PRECISION,ORDINAL_POSITION FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY ORDINAL_POSITION", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "columns" }, { "ordinal": 100, "kind": "read", "label": "cleanup.indexes", "role": "cleanup_schema", "SQL": "SELECT INDEX_NAME,NON_UNIQUE,COLUMN_NAME,SEQ_IN_INDEX,SUB_PART,COLLATION,INDEX_TYPE FROM information_schema.STATISTICS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY INDEX_NAME,SEQ_IN_INDEX", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "indexes" }, { "ordinal": 101, "kind": "read", "label": "cleanup.constraints", "role": "cleanup_schema", "SQL": "SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR CONSTRAINT_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME", "binds": [ "cdx_ppfull261011_s2", "PK_cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 102, "kind": "read", "label": "cleanup.keys", "role": "cleanup_schema", "SQL": "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR REFERENCED_TABLE_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME,ORDINAL_POSITION", "binds": [ "cdx_ppfull261011_s2", "cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "keys" }, { "ordinal": 103, "kind": "read", "label": "cleanup.triggers", "role": "cleanup_schema", "SQL": "SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA=DATABASE() AND (EVENT_OBJECT_TABLE=? OR ACTION_STATEMENT LIKE ?) ORDER BY TRIGGER_NAME", "binds": [ "cdx_ppfull261011_s2", "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 104, "kind": "read", "label": "cleanup.views", "role": "cleanup_schema", "SQL": "SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE TABLE_SCHEMA=DATABASE() AND VIEW_DEFINITION LIKE ? ORDER BY TABLE_NAME", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "views" }, { "ordinal": 105, "kind": "read", "label": "cleanup.routines", "role": "cleanup_schema", "SQL": "SELECT ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA=DATABASE() AND ROUTINE_DEFINITION LIKE ? ORDER BY ROUTINE_NAME,ROUTINE_TYPE", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "routines" }, { "ordinal": 106, "kind": "read", "label": "cleanup.ddl", "role": "cleanup_schema", "SQL": "SHOW CREATE TABLE cdx_ppfull261011_s2", "binds": [], "PDO_types": [], "read_query": "ddl" }, { "ordinal": 107, "kind": "DDL", "label": "drop_table", "role": "drop_table", "SQL": "DROP TABLE cdx_ppfull261011_s2", "binds": [], "PDO_types": [] }, { "ordinal": 108, "kind": "read", "label": "drop_table.warnings", "role": "warnings", "SQL": "SHOW WARNINGS", "binds": [], "PDO_types": [], "read_query": "warnings" }, { "ordinal": 109, "kind": "read", "label": "post.table", "role": "zero", "SQL": "SELECT TABLE_NAME,ENGINE,ROW_FORMAT,TABLE_COLLATION,CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=?", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "table" }, { "ordinal": 110, "kind": "read", "label": "post.indexes", "role": "zero", "SQL": "SELECT INDEX_NAME,NON_UNIQUE,COLUMN_NAME,SEQ_IN_INDEX,SUB_PART,COLLATION,INDEX_TYPE FROM information_schema.STATISTICS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY INDEX_NAME,SEQ_IN_INDEX", "binds": [ "cdx_ppfull261011_s2" ], "PDO_types": [ 2 ], "read_query": "indexes" }, { "ordinal": 111, "kind": "read", "label": "post.constraints", "role": "zero", "SQL": "SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR CONSTRAINT_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME", "binds": [ "cdx_ppfull261011_s2", "PK_cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 112, "kind": "read", "label": "post.keys", "role": "zero", "SQL": "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=DATABASE() AND (TABLE_NAME=? OR REFERENCED_TABLE_NAME=?) ORDER BY TABLE_NAME,CONSTRAINT_NAME,ORDINAL_POSITION", "binds": [ "cdx_ppfull261011_s2", "cdx_ppfull261011_s2" ], "PDO_types": [ 2, 2 ], "read_query": "keys" }, { "ordinal": 113, "kind": "read", "label": "post.triggers", "role": "zero", "SQL": "SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA=DATABASE() AND (EVENT_OBJECT_TABLE=? OR ACTION_STATEMENT LIKE ?) ORDER BY TRIGGER_NAME", "binds": [ "cdx_ppfull261011_s2", "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 114, "kind": "read", "label": "post.views", "role": "zero", "SQL": "SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE TABLE_SCHEMA=DATABASE() AND VIEW_DEFINITION LIKE ? ORDER BY TABLE_NAME", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "views" }, { "ordinal": 115, "kind": "read", "label": "post.routines", "role": "zero", "SQL": "SELECT ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA=DATABASE() AND ROUTINE_DEFINITION LIKE ? ORDER BY ROUTINE_NAME,ROUTINE_TYPE", "binds": [ "%cdx_ppfull261011_s2%" ], "PDO_types": [ 2 ], "read_query": "routines" } ], "budget": { "read": 94, "DML": 19, "DDL": 2, "HTTP": 0, "business_writes": 0, "max_rows": 1 }, "field_contract": [ { "name": "ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": null, "extra": "auto_increment", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": null, "data_length": 8, "data_scale": 0 } }, { "name": "SOURCE", "source": { "type": "tinyint(3) unsigned", "nullable": false, "default": "1", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "SMALLINT", "nullable": false, "default": "1", "data_length": 2, "data_scale": 0 } }, { "name": "DEVICE_ORDER_NO", "source": { "type": "varchar(64)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 64 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 256, "data_scale": 7 } }, { "name": "MACHID", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "EQUIPMENT_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "RESTAURANT_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "1", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "1", "data_length": 8, "data_scale": 0 } }, { "name": "TRACKNO", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "GOODS_NAME", "source": { "type": "varchar(128)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 128 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 512, "data_scale": 7 } }, { "name": "PRICE", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "CHANNELID", "source": { "type": "varchar(16)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 16 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 64, "data_scale": 7 } }, { "name": "PREPAY_STATUS", "source": { "type": "tinyint(3) unsigned", "nullable": false, "default": "2", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "SMALLINT", "nullable": false, "default": "2", "data_length": 2, "data_scale": 0 } }, { "name": "MEAL_ORDER_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "MEAL_ORDER_NO", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "USER_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "SHIP_STATUS", "source": { "type": "tinyint(3) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "SMALLINT", "nullable": false, "default": "0", "data_length": 2, "data_scale": 0 } }, { "name": "ERRINFO", "source": { "type": "varchar(500)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 500 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 2000, "data_scale": 7 } }, { "name": "RAW_REQUEST_A", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "RAW_REQUEST_C", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "RAW_REQUEST_B", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "QRCODE_PAYLOAD", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "EXPIRE_TIME", "source": { "type": "datetime", "nullable": false, "default": "2000-01-01 00:00:00", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "'2000-01-01 00:00:00'", "data_length": 8, "data_scale": 6 } }, { "name": "PAY_TIME", "source": { "type": "datetime", "nullable": false, "default": "2000-01-01 00:00:00", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "'2000-01-01 00:00:00'", "data_length": 8, "data_scale": 6 } }, { "name": "SHIP_TIME", "source": { "type": "datetime", "nullable": false, "default": "2000-01-01 00:00:00", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "'2000-01-01 00:00:00'", "data_length": 8, "data_scale": 6 } }, { "name": "CREATE_TIME", "source": { "type": "datetime", "nullable": false, "default": "CURRENT_TIMESTAMP", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "CURRENT_TIMESTAMP", "data_length": 8, "data_scale": 6 } }, { "name": "CREATE_BY", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "UPDATE_TIME", "source": { "type": "datetime", "nullable": false, "default": "CURRENT_TIMESTAMP", "extra": "on update CURRENT_TIMESTAMP", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "CURRENT_TIMESTAMP", "data_length": 8, "data_scale": 6 } }, { "name": "UPDATE_BY", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } } ] }, "C": { "status": "ROOT_APPROVAL_REQUIRED_NO_SHADOW_EXECUTION", "lane": "C", "marker": "CDXPPFULL11", "table": "ZHCT_APP.CDX_PPFULL261011_S2", "bare": "CDX_PPFULL261011_S2", "trigger": "TRG_CDX_PPFULL261011_S2", "pk": "PK_CDX_PPFULL261011_S2", "columns": [ "ID", "SOURCE", "DEVICE_ORDER_NO", "MACHID", "EQUIPMENT_ID", "RESTAURANT_ID", "TRACKNO", "GOODS_NAME", "PRICE", "CHANNELID", "PREPAY_STATUS", "MEAL_ORDER_ID", "MEAL_ORDER_NO", "USER_ID", "SHIP_STATUS", "ERRINFO", "RAW_REQUEST_A", "RAW_REQUEST_C", "RAW_REQUEST_B", "QRCODE_PAYLOAD", "EXPIRE_TIME", "PAY_TIME", "SHIP_TIME", "CREATE_TIME", "CREATE_BY", "UPDATE_TIME", "UPDATE_BY" ], "dates": [ "EXPIRE_TIME", "PAY_TIME", "SHIP_TIME", "CREATE_TIME", "UPDATE_TIME" ], "lobs": [ "RAW_REQUEST_A", "RAW_REQUEST_C", "RAW_REQUEST_B", "QRCODE_PAYLOAD" ], "connection": { "host": "127.0.0.1", "port": "5237", "schema": "ZHCT_APP", "config_path": "/tmp/zhct-dm-poc-20260928.fcpiiN/store/application/database.php", "expected_version_banners": [ "DM Database Server 64 V8", "8.4", "企业版", "DB Version: 0x7000d", "03134284488-20260212-314192-20200", "Msg Version: 1", "Gsu level(5) cnt: 102" ] }, "runtime_directory": "/tmp/cdx-prepay-full27-C-20261011", "baseline": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11" ], "candidate_trigger": "CREATE TRIGGER ZHCT_APP.TRG_CDX_PPFULL261011_S2\nBEFORE UPDATE ON ZHCT_APP.CDX_PPFULL261011_S2\nFOR EACH ROW\nDECLARE\n V_CHANGED INT := 0;\n V_POS BIGINT;\n V_OLD_LEN BIGINT;\n V_NEW_LEN BIGINT;\nBEGIN\n IF NOT UPDATING('UPDATE_TIME') THEN\n -- All22 non-CLOB fields; do not read long LOBs once a scalar changed.\n IF ((:NEW.ID IS NULL AND :OLD.ID IS NOT NULL)\n OR (:NEW.ID IS NOT NULL AND :OLD.ID IS NULL)\n OR (:NEW.ID IS NOT NULL AND :OLD.ID IS NOT NULL AND :NEW.ID <> :OLD.ID))\n OR ((:NEW.SOURCE IS NULL AND :OLD.SOURCE IS NOT NULL)\n OR (:NEW.SOURCE IS NOT NULL AND :OLD.SOURCE IS NULL)\n OR (:NEW.SOURCE IS NOT NULL AND :OLD.SOURCE IS NOT NULL AND :NEW.SOURCE <> :OLD.SOURCE))\n OR (NVL(LENGTHB(:NEW.DEVICE_ORDER_NO), -1) <> NVL(LENGTHB(:OLD.DEVICE_ORDER_NO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.DEVICE_ORDER_NO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.DEVICE_ORDER_NO)), '#'))\n OR (NVL(LENGTHB(:NEW.MACHID), -1) <> NVL(LENGTHB(:OLD.MACHID), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.MACHID)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.MACHID)), '#'))\n OR ((:NEW.EQUIPMENT_ID IS NULL AND :OLD.EQUIPMENT_ID IS NOT NULL)\n OR (:NEW.EQUIPMENT_ID IS NOT NULL AND :OLD.EQUIPMENT_ID IS NULL)\n OR (:NEW.EQUIPMENT_ID IS NOT NULL AND :OLD.EQUIPMENT_ID IS NOT NULL AND :NEW.EQUIPMENT_ID <> :OLD.EQUIPMENT_ID))\n OR ((:NEW.RESTAURANT_ID IS NULL AND :OLD.RESTAURANT_ID IS NOT NULL)\n OR (:NEW.RESTAURANT_ID IS NOT NULL AND :OLD.RESTAURANT_ID IS NULL)\n OR (:NEW.RESTAURANT_ID IS NOT NULL AND :OLD.RESTAURANT_ID IS NOT NULL AND :NEW.RESTAURANT_ID <> :OLD.RESTAURANT_ID))\n OR (NVL(LENGTHB(:NEW.TRACKNO), -1) <> NVL(LENGTHB(:OLD.TRACKNO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.TRACKNO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.TRACKNO)), '#'))\n OR (NVL(LENGTHB(:NEW.GOODS_NAME), -1) <> NVL(LENGTHB(:OLD.GOODS_NAME), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.GOODS_NAME)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.GOODS_NAME)), '#'))\n OR ((:NEW.PRICE IS NULL AND :OLD.PRICE IS NOT NULL)\n OR (:NEW.PRICE IS NOT NULL AND :OLD.PRICE IS NULL)\n OR (:NEW.PRICE IS NOT NULL AND :OLD.PRICE IS NOT NULL AND :NEW.PRICE <> :OLD.PRICE))\n OR (NVL(LENGTHB(:NEW.CHANNELID), -1) <> NVL(LENGTHB(:OLD.CHANNELID), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.CHANNELID)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.CHANNELID)), '#'))\n OR ((:NEW.PREPAY_STATUS IS NULL AND :OLD.PREPAY_STATUS IS NOT NULL)\n OR (:NEW.PREPAY_STATUS IS NOT NULL AND :OLD.PREPAY_STATUS IS NULL)\n OR (:NEW.PREPAY_STATUS IS NOT NULL AND :OLD.PREPAY_STATUS IS NOT NULL AND :NEW.PREPAY_STATUS <> :OLD.PREPAY_STATUS))\n OR ((:NEW.MEAL_ORDER_ID IS NULL AND :OLD.MEAL_ORDER_ID IS NOT NULL)\n OR (:NEW.MEAL_ORDER_ID IS NOT NULL AND :OLD.MEAL_ORDER_ID IS NULL)\n OR (:NEW.MEAL_ORDER_ID IS NOT NULL AND :OLD.MEAL_ORDER_ID IS NOT NULL AND :NEW.MEAL_ORDER_ID <> :OLD.MEAL_ORDER_ID))\n OR (NVL(LENGTHB(:NEW.MEAL_ORDER_NO), -1) <> NVL(LENGTHB(:OLD.MEAL_ORDER_NO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.MEAL_ORDER_NO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.MEAL_ORDER_NO)), '#'))\n OR ((:NEW.USER_ID IS NULL AND :OLD.USER_ID IS NOT NULL)\n OR (:NEW.USER_ID IS NOT NULL AND :OLD.USER_ID IS NULL)\n OR (:NEW.USER_ID IS NOT NULL AND :OLD.USER_ID IS NOT NULL AND :NEW.USER_ID <> :OLD.USER_ID))\n OR ((:NEW.SHIP_STATUS IS NULL AND :OLD.SHIP_STATUS IS NOT NULL)\n OR (:NEW.SHIP_STATUS IS NOT NULL AND :OLD.SHIP_STATUS IS NULL)\n OR (:NEW.SHIP_STATUS IS NOT NULL AND :OLD.SHIP_STATUS IS NOT NULL AND :NEW.SHIP_STATUS <> :OLD.SHIP_STATUS))\n OR (NVL(LENGTHB(:NEW.ERRINFO), -1) <> NVL(LENGTHB(:OLD.ERRINFO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.ERRINFO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.ERRINFO)), '#'))\n OR ((:NEW.EXPIRE_TIME IS NULL AND :OLD.EXPIRE_TIME IS NOT NULL)\n OR (:NEW.EXPIRE_TIME IS NOT NULL AND :OLD.EXPIRE_TIME IS NULL)\n OR (:NEW.EXPIRE_TIME IS NOT NULL AND :OLD.EXPIRE_TIME IS NOT NULL AND :NEW.EXPIRE_TIME <> :OLD.EXPIRE_TIME))\n OR ((:NEW.PAY_TIME IS NULL AND :OLD.PAY_TIME IS NOT NULL)\n OR (:NEW.PAY_TIME IS NOT NULL AND :OLD.PAY_TIME IS NULL)\n OR (:NEW.PAY_TIME IS NOT NULL AND :OLD.PAY_TIME IS NOT NULL AND :NEW.PAY_TIME <> :OLD.PAY_TIME))\n OR ((:NEW.SHIP_TIME IS NULL AND :OLD.SHIP_TIME IS NOT NULL)\n OR (:NEW.SHIP_TIME IS NOT NULL AND :OLD.SHIP_TIME IS NULL)\n OR (:NEW.SHIP_TIME IS NOT NULL AND :OLD.SHIP_TIME IS NOT NULL AND :NEW.SHIP_TIME <> :OLD.SHIP_TIME))\n OR ((:NEW.CREATE_TIME IS NULL AND :OLD.CREATE_TIME IS NOT NULL)\n OR (:NEW.CREATE_TIME IS NOT NULL AND :OLD.CREATE_TIME IS NULL)\n OR (:NEW.CREATE_TIME IS NOT NULL AND :OLD.CREATE_TIME IS NOT NULL AND :NEW.CREATE_TIME <> :OLD.CREATE_TIME))\n OR (NVL(LENGTHB(:NEW.CREATE_BY), -1) <> NVL(LENGTHB(:OLD.CREATE_BY), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.CREATE_BY)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.CREATE_BY)), '#'))\n OR (NVL(LENGTHB(:NEW.UPDATE_BY), -1) <> NVL(LENGTHB(:OLD.UPDATE_BY), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.UPDATE_BY)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.UPDATE_BY)), '#')) THEN\n V_CHANGED := 1;\n END IF;\n -- FIELD RAW_REQUEST_A: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_A IS NULL AND :OLD.RAW_REQUEST_A IS NOT NULL)\n OR (:NEW.RAW_REQUEST_A IS NOT NULL AND :OLD.RAW_REQUEST_A IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_A IS NOT NULL AND :OLD.RAW_REQUEST_A IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_A);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_A);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_A,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_A,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_A,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_A,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD RAW_REQUEST_C: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_C IS NULL AND :OLD.RAW_REQUEST_C IS NOT NULL)\n OR (:NEW.RAW_REQUEST_C IS NOT NULL AND :OLD.RAW_REQUEST_C IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_C IS NOT NULL AND :OLD.RAW_REQUEST_C IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_C);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_C);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_C,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_C,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_C,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_C,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD RAW_REQUEST_B: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_B IS NULL AND :OLD.RAW_REQUEST_B IS NOT NULL)\n OR (:NEW.RAW_REQUEST_B IS NOT NULL AND :OLD.RAW_REQUEST_B IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_B IS NOT NULL AND :OLD.RAW_REQUEST_B IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_B);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_B);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_B,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_B,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_B,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_B,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD QRCODE_PAYLOAD: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.QRCODE_PAYLOAD IS NULL AND :OLD.QRCODE_PAYLOAD IS NOT NULL)\n OR (:NEW.QRCODE_PAYLOAD IS NOT NULL AND :OLD.QRCODE_PAYLOAD IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.QRCODE_PAYLOAD IS NOT NULL AND :OLD.QRCODE_PAYLOAD IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.QRCODE_PAYLOAD);\n V_NEW_LEN := LENGTH(:NEW.QRCODE_PAYLOAD);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.QRCODE_PAYLOAD,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.QRCODE_PAYLOAD,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.QRCODE_PAYLOAD,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.QRCODE_PAYLOAD,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n IF V_CHANGED = 1 THEN\n :NEW.UPDATE_TIME := TO_TIMESTAMP(TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS');\n END IF;\n END IF;\nEND;", "source_shadow_plan_sha256": "8733e44344c5e96d57398e2b33b3ea4b66d2c9403ec8a23e51fdc7470eaa1b94", "steps": [ { "ordinal": 1, "kind": "read", "label": "pre.identity", "role": "identity", "SQL": "SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') AS SCHEMA_NAME FROM DUAL", "binds": [], "PDO_types": [], "read_query": "identity" }, { "ordinal": 2, "kind": "read", "label": "pre.version", "role": "version", "SQL": "SELECT * FROM V$VERSION", "binds": [], "PDO_types": [], "read_query": "version" }, { "ordinal": 3, "kind": "read", "label": "pre.table", "role": "collision", "SQL": "SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME=?", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "table" }, { "ordinal": 4, "kind": "read", "label": "pre.indexes", "role": "collision", "SQL": "SELECT INDEX_NAME,INDEX_TYPE,UNIQUENESS,TABLE_NAME FROM USER_INDEXES WHERE TABLE_NAME=? OR INDEX_NAME=? ORDER BY INDEX_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "indexes" }, { "ordinal": 5, "kind": "read", "label": "pre.constraints", "role": "collision", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME=? OR CONSTRAINT_NAME=? ORDER BY CONSTRAINT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 6, "kind": "read", "label": "pre.constraint_columns", "role": "collision", "SQL": "SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME=? ORDER BY CONSTRAINT_NAME,POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "constraint_columns" }, { "ordinal": 7, "kind": "read", "label": "pre.triggers", "role": "collision", "SQL": "SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=? OR TRIGGER_NAME=?", "binds": [ "CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 8, "kind": "read", "label": "pre.objects", "role": "collision", "SQL": "SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM USER_OBJECTS WHERE OBJECT_NAME IN (?,?,?) ORDER BY OBJECT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2, 2 ], "read_query": "objects" }, { "ordinal": 9, "kind": "read", "label": "pre.foreign_keys", "role": "collision", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND (TABLE_NAME=? OR R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=?))", "binds": [ "CDX_PPFULL261011_S2", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "foreign_keys" }, { "ordinal": 10, "kind": "read", "label": "pre.dependencies", "role": "collision", "SQL": "SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_OWNER=? AND REFERENCED_NAME=?", "binds": [ "ZHCT_APP", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "dependencies" }, { "ordinal": 11, "kind": "DDL", "label": "create", "role": "create", "SQL": "CREATE TABLE ZHCT_APP.CDX_PPFULL261011_S2 (ID BIGINT NOT NULL,SOURCE SMALLINT DEFAULT 1 NOT NULL,DEVICE_ORDER_NO VARCHAR(64 CHAR) DEFAULT '' NOT NULL,MACHID VARCHAR(32 CHAR) DEFAULT '' NOT NULL,EQUIPMENT_ID BIGINT DEFAULT 0 NOT NULL,RESTAURANT_ID BIGINT DEFAULT 1 NOT NULL,TRACKNO VARCHAR(32 CHAR) DEFAULT '' NOT NULL,GOODS_NAME VARCHAR(128 CHAR) DEFAULT '' NOT NULL,PRICE BIGINT DEFAULT 0 NOT NULL,CHANNELID VARCHAR(16 CHAR) DEFAULT '' NOT NULL,PREPAY_STATUS SMALLINT DEFAULT 2 NOT NULL,MEAL_ORDER_ID BIGINT DEFAULT 0 NOT NULL,MEAL_ORDER_NO VARCHAR(32 CHAR) DEFAULT '' NOT NULL,USER_ID BIGINT DEFAULT 0 NOT NULL,SHIP_STATUS SMALLINT DEFAULT 0 NOT NULL,ERRINFO VARCHAR(500 CHAR) DEFAULT '' NOT NULL,RAW_REQUEST_A CLOB NULL,RAW_REQUEST_C CLOB NULL,RAW_REQUEST_B CLOB NULL,QRCODE_PAYLOAD CLOB NULL,EXPIRE_TIME DATETIME(0) DEFAULT '2000-01-01 00:00:00' NOT NULL,PAY_TIME DATETIME(0) DEFAULT '2000-01-01 00:00:00' NOT NULL,SHIP_TIME DATETIME(0) DEFAULT '2000-01-01 00:00:00' NOT NULL,CREATE_TIME DATETIME(0) DEFAULT CURRENT_TIMESTAMP(0) NOT NULL,CREATE_BY VARCHAR(32 CHAR) DEFAULT '' NOT NULL,UPDATE_TIME DATETIME(0) DEFAULT CURRENT_TIMESTAMP(0) NOT NULL,UPDATE_BY VARCHAR(32 CHAR) DEFAULT '' NOT NULL,CONSTRAINT PK_CDX_PPFULL261011_S2 PRIMARY KEY(ID))", "binds": [], "PDO_types": [] }, { "ordinal": 12, "kind": "read", "label": "created.columns", "role": "created_schema", "SQL": "SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "columns" }, { "ordinal": 13, "kind": "read", "label": "created.indexes", "role": "created_schema", "SQL": "SELECT INDEX_NAME,INDEX_TYPE,UNIQUENESS,TABLE_NAME FROM USER_INDEXES WHERE TABLE_NAME=? OR INDEX_NAME=? ORDER BY INDEX_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "indexes" }, { "ordinal": 14, "kind": "read", "label": "created.index_columns", "role": "created_schema", "SQL": "SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME=? ORDER BY INDEX_NAME,COLUMN_POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "index_columns" }, { "ordinal": 15, "kind": "read", "label": "created.constraints", "role": "created_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME=? OR CONSTRAINT_NAME=? ORDER BY CONSTRAINT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 16, "kind": "read", "label": "created.constraint_columns", "role": "created_schema", "SQL": "SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME=? ORDER BY CONSTRAINT_NAME,POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "constraint_columns" }, { "ordinal": 17, "kind": "read", "label": "created.triggers", "role": "created_schema", "SQL": "SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=? OR TRIGGER_NAME=?", "binds": [ "CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 18, "kind": "read", "label": "created.objects", "role": "created_schema", "SQL": "SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM USER_OBJECTS WHERE OBJECT_NAME IN (?,?,?) ORDER BY OBJECT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2, 2 ], "read_query": "objects" }, { "ordinal": 19, "kind": "read", "label": "created.foreign_keys", "role": "created_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND (TABLE_NAME=? OR R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=?))", "binds": [ "CDX_PPFULL261011_S2", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "foreign_keys" }, { "ordinal": 20, "kind": "read", "label": "created.dependencies", "role": "created_schema", "SQL": "SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_OWNER=? AND REFERENCED_NAME=?", "binds": [ "ZHCT_APP", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "dependencies" }, { "ordinal": 21, "kind": "read", "label": "created.table_ddl", "role": "created_schema", "SQL": "SELECT DBMS_METADATA.GET_DDL('TABLE',?,'ZHCT_APP') AS DDL FROM DUAL", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "table_ddl" }, { "ordinal": 22, "kind": "DDL", "label": "create_trigger", "role": "create_trigger", "SQL": "CREATE TRIGGER ZHCT_APP.TRG_CDX_PPFULL261011_S2\nBEFORE UPDATE ON ZHCT_APP.CDX_PPFULL261011_S2\nFOR EACH ROW\nDECLARE\n V_CHANGED INT := 0;\n V_POS BIGINT;\n V_OLD_LEN BIGINT;\n V_NEW_LEN BIGINT;\nBEGIN\n IF NOT UPDATING('UPDATE_TIME') THEN\n -- All22 non-CLOB fields; do not read long LOBs once a scalar changed.\n IF ((:NEW.ID IS NULL AND :OLD.ID IS NOT NULL)\n OR (:NEW.ID IS NOT NULL AND :OLD.ID IS NULL)\n OR (:NEW.ID IS NOT NULL AND :OLD.ID IS NOT NULL AND :NEW.ID <> :OLD.ID))\n OR ((:NEW.SOURCE IS NULL AND :OLD.SOURCE IS NOT NULL)\n OR (:NEW.SOURCE IS NOT NULL AND :OLD.SOURCE IS NULL)\n OR (:NEW.SOURCE IS NOT NULL AND :OLD.SOURCE IS NOT NULL AND :NEW.SOURCE <> :OLD.SOURCE))\n OR (NVL(LENGTHB(:NEW.DEVICE_ORDER_NO), -1) <> NVL(LENGTHB(:OLD.DEVICE_ORDER_NO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.DEVICE_ORDER_NO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.DEVICE_ORDER_NO)), '#'))\n OR (NVL(LENGTHB(:NEW.MACHID), -1) <> NVL(LENGTHB(:OLD.MACHID), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.MACHID)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.MACHID)), '#'))\n OR ((:NEW.EQUIPMENT_ID IS NULL AND :OLD.EQUIPMENT_ID IS NOT NULL)\n OR (:NEW.EQUIPMENT_ID IS NOT NULL AND :OLD.EQUIPMENT_ID IS NULL)\n OR (:NEW.EQUIPMENT_ID IS NOT NULL AND :OLD.EQUIPMENT_ID IS NOT NULL AND :NEW.EQUIPMENT_ID <> :OLD.EQUIPMENT_ID))\n OR ((:NEW.RESTAURANT_ID IS NULL AND :OLD.RESTAURANT_ID IS NOT NULL)\n OR (:NEW.RESTAURANT_ID IS NOT NULL AND :OLD.RESTAURANT_ID IS NULL)\n OR (:NEW.RESTAURANT_ID IS NOT NULL AND :OLD.RESTAURANT_ID IS NOT NULL AND :NEW.RESTAURANT_ID <> :OLD.RESTAURANT_ID))\n OR (NVL(LENGTHB(:NEW.TRACKNO), -1) <> NVL(LENGTHB(:OLD.TRACKNO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.TRACKNO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.TRACKNO)), '#'))\n OR (NVL(LENGTHB(:NEW.GOODS_NAME), -1) <> NVL(LENGTHB(:OLD.GOODS_NAME), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.GOODS_NAME)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.GOODS_NAME)), '#'))\n OR ((:NEW.PRICE IS NULL AND :OLD.PRICE IS NOT NULL)\n OR (:NEW.PRICE IS NOT NULL AND :OLD.PRICE IS NULL)\n OR (:NEW.PRICE IS NOT NULL AND :OLD.PRICE IS NOT NULL AND :NEW.PRICE <> :OLD.PRICE))\n OR (NVL(LENGTHB(:NEW.CHANNELID), -1) <> NVL(LENGTHB(:OLD.CHANNELID), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.CHANNELID)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.CHANNELID)), '#'))\n OR ((:NEW.PREPAY_STATUS IS NULL AND :OLD.PREPAY_STATUS IS NOT NULL)\n OR (:NEW.PREPAY_STATUS IS NOT NULL AND :OLD.PREPAY_STATUS IS NULL)\n OR (:NEW.PREPAY_STATUS IS NOT NULL AND :OLD.PREPAY_STATUS IS NOT NULL AND :NEW.PREPAY_STATUS <> :OLD.PREPAY_STATUS))\n OR ((:NEW.MEAL_ORDER_ID IS NULL AND :OLD.MEAL_ORDER_ID IS NOT NULL)\n OR (:NEW.MEAL_ORDER_ID IS NOT NULL AND :OLD.MEAL_ORDER_ID IS NULL)\n OR (:NEW.MEAL_ORDER_ID IS NOT NULL AND :OLD.MEAL_ORDER_ID IS NOT NULL AND :NEW.MEAL_ORDER_ID <> :OLD.MEAL_ORDER_ID))\n OR (NVL(LENGTHB(:NEW.MEAL_ORDER_NO), -1) <> NVL(LENGTHB(:OLD.MEAL_ORDER_NO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.MEAL_ORDER_NO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.MEAL_ORDER_NO)), '#'))\n OR ((:NEW.USER_ID IS NULL AND :OLD.USER_ID IS NOT NULL)\n OR (:NEW.USER_ID IS NOT NULL AND :OLD.USER_ID IS NULL)\n OR (:NEW.USER_ID IS NOT NULL AND :OLD.USER_ID IS NOT NULL AND :NEW.USER_ID <> :OLD.USER_ID))\n OR ((:NEW.SHIP_STATUS IS NULL AND :OLD.SHIP_STATUS IS NOT NULL)\n OR (:NEW.SHIP_STATUS IS NOT NULL AND :OLD.SHIP_STATUS IS NULL)\n OR (:NEW.SHIP_STATUS IS NOT NULL AND :OLD.SHIP_STATUS IS NOT NULL AND :NEW.SHIP_STATUS <> :OLD.SHIP_STATUS))\n OR (NVL(LENGTHB(:NEW.ERRINFO), -1) <> NVL(LENGTHB(:OLD.ERRINFO), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.ERRINFO)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.ERRINFO)), '#'))\n OR ((:NEW.EXPIRE_TIME IS NULL AND :OLD.EXPIRE_TIME IS NOT NULL)\n OR (:NEW.EXPIRE_TIME IS NOT NULL AND :OLD.EXPIRE_TIME IS NULL)\n OR (:NEW.EXPIRE_TIME IS NOT NULL AND :OLD.EXPIRE_TIME IS NOT NULL AND :NEW.EXPIRE_TIME <> :OLD.EXPIRE_TIME))\n OR ((:NEW.PAY_TIME IS NULL AND :OLD.PAY_TIME IS NOT NULL)\n OR (:NEW.PAY_TIME IS NOT NULL AND :OLD.PAY_TIME IS NULL)\n OR (:NEW.PAY_TIME IS NOT NULL AND :OLD.PAY_TIME IS NOT NULL AND :NEW.PAY_TIME <> :OLD.PAY_TIME))\n OR ((:NEW.SHIP_TIME IS NULL AND :OLD.SHIP_TIME IS NOT NULL)\n OR (:NEW.SHIP_TIME IS NOT NULL AND :OLD.SHIP_TIME IS NULL)\n OR (:NEW.SHIP_TIME IS NOT NULL AND :OLD.SHIP_TIME IS NOT NULL AND :NEW.SHIP_TIME <> :OLD.SHIP_TIME))\n OR ((:NEW.CREATE_TIME IS NULL AND :OLD.CREATE_TIME IS NOT NULL)\n OR (:NEW.CREATE_TIME IS NOT NULL AND :OLD.CREATE_TIME IS NULL)\n OR (:NEW.CREATE_TIME IS NOT NULL AND :OLD.CREATE_TIME IS NOT NULL AND :NEW.CREATE_TIME <> :OLD.CREATE_TIME))\n OR (NVL(LENGTHB(:NEW.CREATE_BY), -1) <> NVL(LENGTHB(:OLD.CREATE_BY), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.CREATE_BY)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.CREATE_BY)), '#'))\n OR (NVL(LENGTHB(:NEW.UPDATE_BY), -1) <> NVL(LENGTHB(:OLD.UPDATE_BY), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(:NEW.UPDATE_BY)), '#') <> NVL(RAWTOHEX(CHARTOBIN(:OLD.UPDATE_BY)), '#')) THEN\n V_CHANGED := 1;\n END IF;\n -- FIELD RAW_REQUEST_A: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_A IS NULL AND :OLD.RAW_REQUEST_A IS NOT NULL)\n OR (:NEW.RAW_REQUEST_A IS NOT NULL AND :OLD.RAW_REQUEST_A IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_A IS NOT NULL AND :OLD.RAW_REQUEST_A IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_A);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_A);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_A,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_A,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_A,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_A,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD RAW_REQUEST_C: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_C IS NULL AND :OLD.RAW_REQUEST_C IS NOT NULL)\n OR (:NEW.RAW_REQUEST_C IS NOT NULL AND :OLD.RAW_REQUEST_C IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_C IS NOT NULL AND :OLD.RAW_REQUEST_C IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_C);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_C);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_C,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_C,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_C,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_C,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD RAW_REQUEST_B: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.RAW_REQUEST_B IS NULL AND :OLD.RAW_REQUEST_B IS NOT NULL)\n OR (:NEW.RAW_REQUEST_B IS NOT NULL AND :OLD.RAW_REQUEST_B IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.RAW_REQUEST_B IS NOT NULL AND :OLD.RAW_REQUEST_B IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.RAW_REQUEST_B);\n V_NEW_LEN := LENGTH(:NEW.RAW_REQUEST_B);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.RAW_REQUEST_B,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.RAW_REQUEST_B,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.RAW_REQUEST_B,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.RAW_REQUEST_B,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n -- FIELD QRCODE_PAYLOAD: full nullable CLOB, not first-chunk or collation equality.\n IF V_CHANGED = 0 THEN\n IF (:NEW.QRCODE_PAYLOAD IS NULL AND :OLD.QRCODE_PAYLOAD IS NOT NULL)\n OR (:NEW.QRCODE_PAYLOAD IS NOT NULL AND :OLD.QRCODE_PAYLOAD IS NULL) THEN\n V_CHANGED := 1;\n ELSIF :NEW.QRCODE_PAYLOAD IS NOT NULL AND :OLD.QRCODE_PAYLOAD IS NOT NULL THEN\n V_OLD_LEN := LENGTH(:OLD.QRCODE_PAYLOAD);\n V_NEW_LEN := LENGTH(:NEW.QRCODE_PAYLOAD);\n IF V_OLD_LEN <> V_NEW_LEN THEN\n V_CHANGED := 1;\n ELSE\n V_POS := 1;\n WHILE V_CHANGED = 0 AND V_POS <= V_OLD_LEN LOOP\n IF NVL(LENGTHB(SUBSTR(:NEW.QRCODE_PAYLOAD,V_POS,256)), -1) <> NVL(LENGTHB(SUBSTR(:OLD.QRCODE_PAYLOAD,V_POS,256)), -1)\n OR NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:NEW.QRCODE_PAYLOAD,V_POS,256))), '#')\n <> NVL(RAWTOHEX(CHARTOBIN(SUBSTR(:OLD.QRCODE_PAYLOAD,V_POS,256))), '#') THEN\n V_CHANGED := 1;\n END IF;\n V_POS := V_POS + 256;\n END LOOP;\n END IF;\n END IF;\n END IF;\n IF V_CHANGED = 1 THEN\n :NEW.UPDATE_TIME := TO_TIMESTAMP(TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS');\n END IF;\n END IF;\nEND;", "binds": [], "PDO_types": [] }, { "ordinal": 23, "kind": "read", "label": "compiled.columns", "role": "compiled_schema", "SQL": "SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "columns" }, { "ordinal": 24, "kind": "read", "label": "compiled.indexes", "role": "compiled_schema", "SQL": "SELECT INDEX_NAME,INDEX_TYPE,UNIQUENESS,TABLE_NAME FROM USER_INDEXES WHERE TABLE_NAME=? OR INDEX_NAME=? ORDER BY INDEX_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "indexes" }, { "ordinal": 25, "kind": "read", "label": "compiled.index_columns", "role": "compiled_schema", "SQL": "SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME=? ORDER BY INDEX_NAME,COLUMN_POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "index_columns" }, { "ordinal": 26, "kind": "read", "label": "compiled.constraints", "role": "compiled_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME=? OR CONSTRAINT_NAME=? ORDER BY CONSTRAINT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 27, "kind": "read", "label": "compiled.constraint_columns", "role": "compiled_schema", "SQL": "SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME=? ORDER BY CONSTRAINT_NAME,POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "constraint_columns" }, { "ordinal": 28, "kind": "read", "label": "compiled.triggers", "role": "compiled_schema", "SQL": "SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=? OR TRIGGER_NAME=?", "binds": [ "CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 29, "kind": "read", "label": "compiled.objects", "role": "compiled_schema", "SQL": "SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM USER_OBJECTS WHERE OBJECT_NAME IN (?,?,?) ORDER BY OBJECT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2, 2 ], "read_query": "objects" }, { "ordinal": 30, "kind": "read", "label": "compiled.foreign_keys", "role": "compiled_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND (TABLE_NAME=? OR R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=?))", "binds": [ "CDX_PPFULL261011_S2", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "foreign_keys" }, { "ordinal": 31, "kind": "read", "label": "compiled.dependencies", "role": "compiled_schema", "SQL": "SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_OWNER=? AND REFERENCED_NAME=?", "binds": [ "ZHCT_APP", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "dependencies" }, { "ordinal": 32, "kind": "read", "label": "compiled.table_ddl", "role": "compiled_schema", "SQL": "SELECT DBMS_METADATA.GET_DDL('TABLE',?,'ZHCT_APP') AS DDL FROM DUAL", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "table_ddl" }, { "ordinal": 33, "kind": "read", "label": "compiled.trigger_ddl", "role": "compiled_schema", "SQL": "SELECT DBMS_METADATA.GET_DDL('TRIGGER',?,'ZHCT_APP') AS DDL FROM DUAL", "binds": [ "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "trigger_ddl" }, { "ordinal": 34, "kind": "read", "label": "SEED.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "SEED" }, { "ordinal": 35, "kind": "DML", "label": "SEED", "role": "seed", "SQL": "INSERT INTO ZHCT_APP.CDX_PPFULL261011_S2 (ID,SOURCE,DEVICE_ORDER_NO,MACHID,EQUIPMENT_ID,RESTAURANT_ID,TRACKNO,GOODS_NAME,PRICE,CHANNELID,PREPAY_STATUS,MEAL_ORDER_ID,MEAL_ORDER_NO,USER_ID,SHIP_STATUS,ERRINFO,RAW_REQUEST_A,RAW_REQUEST_C,RAW_REQUEST_B,QRCODE_PAYLOAD,EXPIRE_TIME,PAY_TIME,SHIP_TIME,CREATE_TIME,CREATE_BY,UPDATE_TIME,UPDATE_BY) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2 ] }, { "ordinal": 36, "kind": "read", "label": "SEED.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "SEED" }, { "ordinal": 37, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A.RESET" }, { "ordinal": 38, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_A.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 39, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A.RESET" }, { "ordinal": 40, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A" }, { "ordinal": 41, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_A", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET RAW_REQUEST_A=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_RAW_REQUEST_A", "changed_column": "RAW_REQUEST_A" }, { "ordinal": 42, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_A.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_A" }, { "ordinal": 43, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C.RESET" }, { "ordinal": 44, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_C.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 45, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C.RESET" }, { "ordinal": 46, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C" }, { "ordinal": 47, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_C", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET RAW_REQUEST_C=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_RAW_REQUEST_C", "changed_column": "RAW_REQUEST_C" }, { "ordinal": 48, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_C.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_C" }, { "ordinal": 49, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B.RESET" }, { "ordinal": 50, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_B.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 51, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B.RESET" }, { "ordinal": 52, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B" }, { "ordinal": 53, "kind": "DML", "label": "BOUNDARY_RAW_REQUEST_B", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET RAW_REQUEST_B=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_RAW_REQUEST_B", "changed_column": "RAW_REQUEST_B" }, { "ordinal": 54, "kind": "read", "label": "BOUNDARY_RAW_REQUEST_B.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_RAW_REQUEST_B" }, { "ordinal": 55, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD.RESET" }, { "ordinal": 56, "kind": "DML", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 57, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD.RESET" }, { "ordinal": 58, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD" }, { "ordinal": 59, "kind": "DML", "label": "BOUNDARY_QRCODE_PAYLOAD", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET QRCODE_PAYLOAD=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营a", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 2, 1, 2 ], "case_label": "BOUNDARY_QRCODE_PAYLOAD", "changed_column": "QRCODE_PAYLOAD" }, { "ordinal": 60, "kind": "read", "label": "BOUNDARY_QRCODE_PAYLOAD.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "BOUNDARY_QRCODE_PAYLOAD" }, { "ordinal": 61, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A.RESET" }, { "ordinal": 62, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 63, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A.RESET" }, { "ordinal": 64, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A" }, { "ordinal": 65, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_A", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET RAW_REQUEST_A=RAW_REQUEST_A WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_RAW_REQUEST_A", "changed_column": null }, { "ordinal": 66, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_A.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_A" }, { "ordinal": 67, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C.RESET" }, { "ordinal": 68, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 69, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C.RESET" }, { "ordinal": 70, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C" }, { "ordinal": 71, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_C", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET RAW_REQUEST_C=RAW_REQUEST_C WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_RAW_REQUEST_C", "changed_column": null }, { "ordinal": 72, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_C.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_C" }, { "ordinal": 73, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B.RESET" }, { "ordinal": 74, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 75, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B.RESET" }, { "ordinal": 76, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B" }, { "ordinal": 77, "kind": "DML", "label": "NONNULL_SELF_RAW_REQUEST_B", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET RAW_REQUEST_B=RAW_REQUEST_B WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_RAW_REQUEST_B", "changed_column": null }, { "ordinal": 78, "kind": "read", "label": "NONNULL_SELF_RAW_REQUEST_B.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_RAW_REQUEST_B" }, { "ordinal": 79, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD.RESET" }, { "ordinal": 80, "kind": "DML", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 81, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD.RESET" }, { "ordinal": 82, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD" }, { "ordinal": 83, "kind": "DML", "label": "NONNULL_SELF_QRCODE_PAYLOAD", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET QRCODE_PAYLOAD=QRCODE_PAYLOAD WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "NONNULL_SELF_QRCODE_PAYLOAD", "changed_column": null }, { "ordinal": 84, "kind": "read", "label": "NONNULL_SELF_QRCODE_PAYLOAD.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "NONNULL_SELF_QRCODE_PAYLOAD" }, { "ordinal": 85, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.RESET.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS.RESET" }, { "ordinal": 86, "kind": "DML", "label": "ALL26_SELF_NONNULL_CLOBS.RESET", "role": "reset", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=?,SOURCE=?,DEVICE_ORDER_NO=?,MACHID=?,EQUIPMENT_ID=?,RESTAURANT_ID=?,TRACKNO=?,GOODS_NAME=?,PRICE=?,CHANNELID=?,PREPAY_STATUS=?,MEAL_ORDER_ID=?,MEAL_ORDER_NO=?,USER_ID=?,SHIP_STATUS=?,ERRINFO=?,RAW_REQUEST_A=?,RAW_REQUEST_C=?,RAW_REQUEST_B=?,QRCODE_PAYLOAD=?,EXPIRE_TIME=?,PAY_TIME=?,SHIP_TIME=?,CREATE_TIME=?,CREATE_BY=?,UPDATE_TIME=?,UPDATE_BY=? WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, 1, "CDXPPFULL11_ORDER", "CDXPPFULL11_M1", 0, 1, "T1", "CDXPPFULL11", 1, "T", 2, 0, "", 0, 0, "", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营营A", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", "2001-01-01 00:00:00", "CDXPPFULL11", "2001-01-01 00:00:00", "CDXPPFULL11", 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 1, 2, 2, 1, 1, 2, 2, 1, 2, 1, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2 ] }, { "ordinal": 87, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.RESET.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS.RESET" }, { "ordinal": 88, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.before", "role": "before", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS" }, { "ordinal": 89, "kind": "DML", "label": "ALL26_SELF_NONNULL_CLOBS", "role": "mutation", "SQL": "UPDATE ZHCT_APP.CDX_PPFULL261011_S2 SET ID=ID,SOURCE=SOURCE,DEVICE_ORDER_NO=DEVICE_ORDER_NO,MACHID=MACHID,EQUIPMENT_ID=EQUIPMENT_ID,RESTAURANT_ID=RESTAURANT_ID,TRACKNO=TRACKNO,GOODS_NAME=GOODS_NAME,PRICE=PRICE,CHANNELID=CHANNELID,PREPAY_STATUS=PREPAY_STATUS,MEAL_ORDER_ID=MEAL_ORDER_ID,MEAL_ORDER_NO=MEAL_ORDER_NO,USER_ID=USER_ID,SHIP_STATUS=SHIP_STATUS,ERRINFO=ERRINFO,RAW_REQUEST_A=RAW_REQUEST_A,RAW_REQUEST_C=RAW_REQUEST_C,RAW_REQUEST_B=RAW_REQUEST_B,QRCODE_PAYLOAD=QRCODE_PAYLOAD,EXPIRE_TIME=EXPIRE_TIME,PAY_TIME=PAY_TIME,SHIP_TIME=SHIP_TIME,CREATE_TIME=CREATE_TIME,CREATE_BY=CREATE_BY,UPDATE_BY=UPDATE_BY WHERE ID=? AND DEVICE_ORDER_NO=?", "binds": [ 1, "CDXPPFULL11_ORDER" ], "PDO_types": [ 1, 2 ], "case_label": "ALL26_SELF_NONNULL_CLOBS", "changed_column": null }, { "ordinal": 90, "kind": "read", "label": "ALL26_SELF_NONNULL_CLOBS.after", "role": "after", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot", "operation": "ALL26_SELF_NONNULL_CLOBS" }, { "ordinal": 91, "kind": "read", "label": "cleanup.identity", "role": "cleanup_identity", "SQL": "SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') AS SCHEMA_NAME FROM DUAL", "binds": [], "PDO_types": [], "read_query": "identity" }, { "ordinal": 92, "kind": "read", "label": "cleanup.version", "role": "cleanup_version", "SQL": "SELECT * FROM V$VERSION", "binds": [], "PDO_types": [], "read_query": "version" }, { "ordinal": 93, "kind": "read", "label": "cleanup.snapshot", "role": "cleanup_snapshot", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot" }, { "ordinal": 94, "kind": "read", "label": "cleanup.columns", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "columns" }, { "ordinal": 95, "kind": "read", "label": "cleanup.indexes", "role": "cleanup_schema", "SQL": "SELECT INDEX_NAME,INDEX_TYPE,UNIQUENESS,TABLE_NAME FROM USER_INDEXES WHERE TABLE_NAME=? OR INDEX_NAME=? ORDER BY INDEX_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "indexes" }, { "ordinal": 96, "kind": "read", "label": "cleanup.index_columns", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME=? ORDER BY INDEX_NAME,COLUMN_POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "index_columns" }, { "ordinal": 97, "kind": "read", "label": "cleanup.constraints", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME=? OR CONSTRAINT_NAME=? ORDER BY CONSTRAINT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 98, "kind": "read", "label": "cleanup.constraint_columns", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME=? ORDER BY CONSTRAINT_NAME,POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "constraint_columns" }, { "ordinal": 99, "kind": "read", "label": "cleanup.triggers", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=? OR TRIGGER_NAME=?", "binds": [ "CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 100, "kind": "read", "label": "cleanup.objects", "role": "cleanup_schema", "SQL": "SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM USER_OBJECTS WHERE OBJECT_NAME IN (?,?,?) ORDER BY OBJECT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2, 2 ], "read_query": "objects" }, { "ordinal": 101, "kind": "read", "label": "cleanup.foreign_keys", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND (TABLE_NAME=? OR R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=?))", "binds": [ "CDX_PPFULL261011_S2", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "foreign_keys" }, { "ordinal": 102, "kind": "read", "label": "cleanup.dependencies", "role": "cleanup_schema", "SQL": "SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_OWNER=? AND REFERENCED_NAME=?", "binds": [ "ZHCT_APP", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "dependencies" }, { "ordinal": 103, "kind": "read", "label": "cleanup.table_ddl", "role": "cleanup_schema", "SQL": "SELECT DBMS_METADATA.GET_DDL('TABLE',?,'ZHCT_APP') AS DDL FROM DUAL", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "table_ddl" }, { "ordinal": 104, "kind": "read", "label": "cleanup.trigger_ddl", "role": "cleanup_schema", "SQL": "SELECT DBMS_METADATA.GET_DDL('TRIGGER',?,'ZHCT_APP') AS DDL FROM DUAL", "binds": [ "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "trigger_ddl" }, { "ordinal": 105, "kind": "DDL", "label": "drop_trigger", "role": "drop_trigger", "SQL": "DROP TRIGGER ZHCT_APP.TRG_CDX_PPFULL261011_S2", "binds": [], "PDO_types": [] }, { "ordinal": 106, "kind": "read", "label": "after_trigger_drop.columns", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "columns" }, { "ordinal": 107, "kind": "read", "label": "after_trigger_drop.indexes", "role": "after_trigger_schema", "SQL": "SELECT INDEX_NAME,INDEX_TYPE,UNIQUENESS,TABLE_NAME FROM USER_INDEXES WHERE TABLE_NAME=? OR INDEX_NAME=? ORDER BY INDEX_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "indexes" }, { "ordinal": 108, "kind": "read", "label": "after_trigger_drop.index_columns", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME=? ORDER BY INDEX_NAME,COLUMN_POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "index_columns" }, { "ordinal": 109, "kind": "read", "label": "after_trigger_drop.constraints", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME=? OR CONSTRAINT_NAME=? ORDER BY CONSTRAINT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 110, "kind": "read", "label": "after_trigger_drop.constraint_columns", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME=? ORDER BY CONSTRAINT_NAME,POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "constraint_columns" }, { "ordinal": 111, "kind": "read", "label": "after_trigger_drop.triggers", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=? OR TRIGGER_NAME=?", "binds": [ "CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 112, "kind": "read", "label": "after_trigger_drop.objects", "role": "after_trigger_schema", "SQL": "SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM USER_OBJECTS WHERE OBJECT_NAME IN (?,?,?) ORDER BY OBJECT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2, 2 ], "read_query": "objects" }, { "ordinal": 113, "kind": "read", "label": "after_trigger_drop.foreign_keys", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND (TABLE_NAME=? OR R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=?))", "binds": [ "CDX_PPFULL261011_S2", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "foreign_keys" }, { "ordinal": 114, "kind": "read", "label": "after_trigger_drop.dependencies", "role": "after_trigger_schema", "SQL": "SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_OWNER=? AND REFERENCED_NAME=?", "binds": [ "ZHCT_APP", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "dependencies" }, { "ordinal": 115, "kind": "read", "label": "after_trigger_drop.table_ddl", "role": "after_trigger_schema", "SQL": "SELECT DBMS_METADATA.GET_DDL('TABLE',?,'ZHCT_APP') AS DDL FROM DUAL", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "table_ddl" }, { "ordinal": 116, "kind": "read", "label": "after_trigger_drop.snapshot", "role": "table_drop_snapshot", "SQL": "SELECT T.*,CAST(CURRENT_TIMESTAMP(0) AS DATETIME(0)) AS CLOCK0,TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS CLOCK6,CURRENT_TIMESTAMP AS CLOCK_RAW,TO_CHAR(EXPIRE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_EXPIRE_TIME,TO_CHAR(PAY_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_PAY_TIME,TO_CHAR(SHIP_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_SHIP_TIME,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_CREATE_TIME,TO_CHAR(UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS.FF6') AS F_UPDATE_TIME FROM ZHCT_APP.CDX_PPFULL261011_S2 T ORDER BY ID", "binds": [], "PDO_types": [], "read_query": "snapshot" }, { "ordinal": 117, "kind": "DDL", "label": "drop_table", "role": "drop_table", "SQL": "DROP TABLE ZHCT_APP.CDX_PPFULL261011_S2", "binds": [], "PDO_types": [] }, { "ordinal": 118, "kind": "read", "label": "post.table", "role": "zero", "SQL": "SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME=?", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "table" }, { "ordinal": 119, "kind": "read", "label": "post.indexes", "role": "zero", "SQL": "SELECT INDEX_NAME,INDEX_TYPE,UNIQUENESS,TABLE_NAME FROM USER_INDEXES WHERE TABLE_NAME=? OR INDEX_NAME=? ORDER BY INDEX_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "indexes" }, { "ordinal": 120, "kind": "read", "label": "post.constraints", "role": "zero", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME=? OR CONSTRAINT_NAME=? ORDER BY CONSTRAINT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "constraints" }, { "ordinal": 121, "kind": "read", "label": "post.constraint_columns", "role": "zero", "SQL": "SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME=? ORDER BY CONSTRAINT_NAME,POSITION", "binds": [ "CDX_PPFULL261011_S2" ], "PDO_types": [ 2 ], "read_query": "constraint_columns" }, { "ordinal": 122, "kind": "read", "label": "post.triggers", "role": "zero", "SQL": "SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=? OR TRIGGER_NAME=?", "binds": [ "CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "triggers" }, { "ordinal": 123, "kind": "read", "label": "post.objects", "role": "zero", "SQL": "SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM USER_OBJECTS WHERE OBJECT_NAME IN (?,?,?) ORDER BY OBJECT_NAME", "binds": [ "CDX_PPFULL261011_S2", "PK_CDX_PPFULL261011_S2", "TRG_CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2, 2 ], "read_query": "objects" }, { "ordinal": 124, "kind": "read", "label": "post.foreign_keys", "role": "zero", "SQL": "SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND (TABLE_NAME=? OR R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=?))", "binds": [ "CDX_PPFULL261011_S2", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "foreign_keys" }, { "ordinal": 125, "kind": "read", "label": "post.dependencies", "role": "zero", "SQL": "SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_OWNER=? AND REFERENCED_NAME=?", "binds": [ "ZHCT_APP", "CDX_PPFULL261011_S2" ], "PDO_types": [ 2, 2 ], "read_query": "dependencies" } ], "budget": { "read": 102, "DML": 19, "DDL": 4, "HTTP": 0, "business_writes": 0, "max_rows": 1 }, "field_contract": [ { "name": "ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": null, "extra": "auto_increment", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": null, "data_length": 8, "data_scale": 0 } }, { "name": "SOURCE", "source": { "type": "tinyint(3) unsigned", "nullable": false, "default": "1", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "SMALLINT", "nullable": false, "default": "1", "data_length": 2, "data_scale": 0 } }, { "name": "DEVICE_ORDER_NO", "source": { "type": "varchar(64)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 64 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 256, "data_scale": 7 } }, { "name": "MACHID", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "EQUIPMENT_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "RESTAURANT_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "1", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "1", "data_length": 8, "data_scale": 0 } }, { "name": "TRACKNO", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "GOODS_NAME", "source": { "type": "varchar(128)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 128 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 512, "data_scale": 7 } }, { "name": "PRICE", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "CHANNELID", "source": { "type": "varchar(16)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 16 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 64, "data_scale": 7 } }, { "name": "PREPAY_STATUS", "source": { "type": "tinyint(3) unsigned", "nullable": false, "default": "2", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "SMALLINT", "nullable": false, "default": "2", "data_length": 2, "data_scale": 0 } }, { "name": "MEAL_ORDER_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "MEAL_ORDER_NO", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "USER_ID", "source": { "type": "int(11) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "BIGINT", "nullable": false, "default": "0", "data_length": 8, "data_scale": 0 } }, { "name": "SHIP_STATUS", "source": { "type": "tinyint(3) unsigned", "nullable": false, "default": "0", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "SMALLINT", "nullable": false, "default": "0", "data_length": 2, "data_scale": 0 } }, { "name": "ERRINFO", "source": { "type": "varchar(500)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 500 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 2000, "data_scale": 7 } }, { "name": "RAW_REQUEST_A", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "RAW_REQUEST_C", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "RAW_REQUEST_B", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "QRCODE_PAYLOAD", "source": { "type": "text", "nullable": true, "default": null, "extra": "", "character_maximum_length": 65535 }, "target_sealed": { "type": "CLOB", "nullable": true, "default": null, "data_length": 2147483647, "data_scale": 0 } }, { "name": "EXPIRE_TIME", "source": { "type": "datetime", "nullable": false, "default": "2000-01-01 00:00:00", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "'2000-01-01 00:00:00'", "data_length": 8, "data_scale": 6 } }, { "name": "PAY_TIME", "source": { "type": "datetime", "nullable": false, "default": "2000-01-01 00:00:00", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "'2000-01-01 00:00:00'", "data_length": 8, "data_scale": 6 } }, { "name": "SHIP_TIME", "source": { "type": "datetime", "nullable": false, "default": "2000-01-01 00:00:00", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "'2000-01-01 00:00:00'", "data_length": 8, "data_scale": 6 } }, { "name": "CREATE_TIME", "source": { "type": "datetime", "nullable": false, "default": "CURRENT_TIMESTAMP", "extra": "", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "CURRENT_TIMESTAMP", "data_length": 8, "data_scale": 6 } }, { "name": "CREATE_BY", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } }, { "name": "UPDATE_TIME", "source": { "type": "datetime", "nullable": false, "default": "CURRENT_TIMESTAMP", "extra": "on update CURRENT_TIMESTAMP", "character_maximum_length": null }, "target_sealed": { "type": "DATETIME", "nullable": false, "default": "CURRENT_TIMESTAMP", "data_length": 8, "data_scale": 6 } }, { "name": "UPDATE_BY", "source": { "type": "varchar(32)", "nullable": false, "default": "", "extra": "", "character_maximum_length": 32 }, "target_sealed": { "type": "VARCHAR", "nullable": false, "default": "''", "data_length": 128, "data_scale": 7 } } ] } } F27_JSON ,true);} function f27_tokens($sql){preg_match_all('~\x27(?:\x27\x27|[^\x27])*\x27|"(?:""|[^"])*"|--[^\r\n]*|[A-Za-z_][A-Za-z0-9_$]*|(?:<>|:=|<=|>=)|[^\s]~u',$sql,$m);$out=[];foreach($m[0]as $t){if(substr($t,0,2)==='--')continue;$out[]=($t[0]===chr(39)||$t[0]===chr(34))?$t:strtoupper($t);}return $out;} function f27_trigger($ddl,$body,$approved){$extract=static function($s){f27_assert(preg_match('/FOR\s+EACH\s+ROW\b/i',$s,$m,PREG_OFFSET_CAPTURE)===1,'Full original FOR EACH ROW trigger');return trim(substr($s,$m[0][1]+strlen($m[0][0])));};$header=static function($s){f27_assert(preg_match('/FOR\s+EACH\s+ROW\b/i',$s,$m,PREG_OFFSET_CAPTURE)===1,'Complete original trigger header');$tokens=f27_tokens(substr($s,0,$m[0][1]+strlen($m[0][0])));$out=[];foreach($tokens as $t){if($t==='OR'||$t==='REPLACE')continue;$out[]=$t[0]===chr(34)?strtoupper(substr($t,1,-1)):$t;}return $out;};f27_assert($header($approved)===$header($ddl)&&$header($approved)===$header($body),'Full owned owner/name/table/event/row header tokens');$a=$extract($approved);$d=$extract($ddl);$b=$extract($body);f27_assert(f27_tokens($a)===f27_tokens($d)&&f27_tokens($a)===f27_tokens($b),'Complete literal-preserving trigger body token equality');return ['approved_body_sha256'=>hash('sha256',$a),'GET_DDL_body_sha256'=>hash('sha256',$d),'USER_TRIGGERS_body_sha256'=>hash('sha256',$b),'body_byte_exact'=>$a===$d&&$a===$b,'body_token_exact'=>true,'header_token_exact'=>true];} function f27_extra_schema($m,$p,$hasTrigger){$b=$p['lane']==='B';foreach($m['columns']as $i=>$c){$f=$p['field_contract'][$i];$want=$b?$f['source']['default']:$f['target_sealed']['default'];if(!$b&&in_array($f['name'],['CREATE_TIME','UPDATE_TIME'],true))$want='CURRENT_TIMESTAMP(0)';$actual=$c[$b?'column_default':'data_default'];$norm=static function($v){return $v===null?null:preg_replace('/\s+/','',strtoupper($v));};f27_assert($norm($actual)===$norm($want),'Every exact declared default '.$f['name']);if(!$b&&$f['source']['character_maximum_length']!==null)f27_assert((int)$c['data_length']===4*$f['source']['character_maximum_length'],'Full target VARCHAR byte capacity');} if($b){$groups=[];foreach($m['indexes']as $r)$groups[$r['index_name']][]=[strtoupper($r['column_name']),(string)$r['non_unique'],(string)$r['seq_in_index'],$r['sub_part'],$r['index_type']];$got=array_values($groups);usort($got,static function($a,$b){return strcmp(f27_json($a),f27_json($b));});$want=[[['ID','0','1',null,'BTREE']],[['DEVICE_ORDER_NO','1','1',null,'BTREE'],['MACHID','1','2',null,'BTREE']],[['MEAL_ORDER_ID','1','1',null,'BTREE']],[['MEAL_ORDER_NO','1','1',null,'BTREE']],[['USER_ID','1','1',null,'BTREE']]];usort($want,static function($a,$b){return strcmp(f27_json($a),f27_json($b));});f27_assert($got===$want,'Source cloned exact PK/four secondary index columns/type/uniqueness');}else{$objects=[];foreach($m['objects']as $o)$objects[$o['object_name']]=$o['object_type'];f27_assert(($objects[$p['bare']]??'')==='TABLE'&&($hasTrigger?($objects[$p['trigger']]??'')==='TRIGGER':!isset($objects[$p['trigger']])),'Own native TABLE/TRIGGER presence');}} function f27_assert($v,$m){if(!$v)throw new RuntimeException($m);} function f27_json($v){$j=json_encode($v,JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES|JSON_PRESERVE_ZERO_FRACTION);f27_assert($j!==false,'Full native JSON');return $j;} function f27_gate($p){$ref=f27_reference();f27_assert(isset($ref[$p['lane']])&&$p===$ref[$p['lane']],'Immutable literal SQL/binds/types/owner/source/budget');$n=['read'=>0,'DML'=>0,'DDL'=>0];foreach($p['steps']as $i=>$s){f27_assert($s['ordinal']===$i+1&&isset($n[$s['kind']]),'Exact ordered known statement');$n[$s['kind']]++;f27_assert(substr_count($s['SQL'],'?')===count($s['binds'])&&count($s['binds'])===count($s['PDO_types']),'Arity');foreach($s['binds']as $j=>$v)f27_assert((is_int($v)||is_string($v)||$v===null)&&$s['PDO_types'][$j]===($v===null?0:(is_int($v)?1:2)),'Literal PHP/PDO binding types');}foreach($n as $k=>$v)f27_assert($v===$p['budget'][$k],'Exact count '.$k);return $n;} function f27_step_gate($p,$s,$st){f27_assert(isset($p['steps'][$st['cursor']])&&$s===$p['steps'][$st['cursor']],'Unknown/replayed SQL/binds/order');f27_assert($st[$s['kind']]<$p['budget'][$s['kind']],'Attempt budget');if($s['role']==='create')f27_assert($st['collision_zero']&&!$st['created']&&$st['DDL']===0,'Fresh collision0 CREATE once');elseif($s['role']==='create_trigger')f27_assert($st['created']&&!$st['trigger_created']&&$st['DDL']===1,'Only own trigger once');elseif($s['role']==='drop_trigger')f27_assert($st['created']&&$st['trigger_created']&&$st['drop_proof'],'Exact owned trigger proof');elseif($s['role']==='drop_table')f27_assert($st['created']&&$st['drop_proof']&&(!$st['trigger_created'])&&$st['table_drop_proof'],'Unknown table DROP forbidden');elseif($s['kind']!=='read')f27_assert($st['created']&&$st['protected'],'Owned full row/schema protection');} function f27_append($h,$e){$j=f27_json($e)."\n";f27_assert(fwrite($h,$j)===strlen($j)&&fflush($h),'Append-before/result durable');} function f27_materialize($rows){$types=[];$keys=[];$streams=[];$bits=[];foreach($rows as $i=>&$r){$keys[$i]=array_keys($r);foreach($r as $k=>&$v){$key=strtolower($k);$types[$i][$key]=gettype($v);if(is_float($v))$bits[$i][$key]=bin2hex(pack('d',$v));if(is_resource($v)){$v=stream_get_contents($v);f27_assert(is_string($v),'Complete native stream');$streams[$i][$key]=['bytes'=>strlen($v),'sha256'=>hash('sha256',$v)];}}unset($v);$r=array_change_key_case($r,CASE_LOWER);}unset($r);return [$rows,$types,$keys,$streams,$bits];} function f27_native($rows,$types,$p){$v=[];foreach($rows as $i=>$r){$x=[];$t=[];foreach($p['columns']as $c){$k=strtolower($c);f27_assert(array_key_exists($k,$r)&&isset($types[$i][$k]),'Full27 original columns/types');$x[$k]=$r[$k];$t[$k]=$types[$i][$k];}$v[]=['values'=>$x,'types'=>$t];}return $v;} function f27_snapshot($rows,$types,$p,$empty=false){f27_assert(count($rows)===($empty?0:1),'Exact max1 own row');$v=f27_native($rows,$types,$p);if(!$empty){$r=$rows[0];f27_assert((string)$r['id']==='1'&&$r['device_order_no']==='CDXPPFULL11_ORDER'&&$r['machid']==='CDXPPFULL11_M1'&&$r['create_by']==='CDXPPFULL11','Full owner lease');foreach($p['dates']as $c){$k=strtolower($c);f27_assert(is_string($r[$k])&&$r['f_'.$k]===$r[$k].'.000000','Whole-second native/FF6 without raw rewriting');}foreach($p['lobs']as $c)f27_assert(is_string($r[strtolower($c)]),'Every original nonNULL complete CLOB');f27_assert(preg_match('/^\d{4}-\d\d-\d\d \d\d:\d\d:\d\d$/D',$r['clock0'])===1,'Original local whole clock');}return $v;} function f27_baseline($row,$p){foreach($p['columns']as $i=>$c){$v=$p['baseline'][$i];$actual=$row[strtolower($c)];f27_assert(is_int($v)?(string)$v===(string)$actual:$v===$actual,'Independent baseline '.$c);}} function f27_transition($before,$after,$bt,$at,$s,$p){if($s['role']==='seed'||$s['role']==='reset'){f27_baseline($after[0],$p);return;}$allow=['update_time'];if($s['changed_column']!==null)$allow[]=strtolower($s['changed_column']);foreach($p['columns']as $c){$k=strtolower($c);if(!in_array($k,$allow,true))f27_assert($before[0][$k]===$after[0][$k]&&$bt[0][$k]===$at[0][$k],'Independent full27 native value/type conservation '.$k);}if($s['changed_column']!==null)f27_assert($after[0][strtolower($s['changed_column'])]===$s['binds'][0],'Exact last-byte changed CLOB');$ut=$after[0]['update_time'];$old=$before[0]['update_time'];$clock=$ut>=$before[0]['clock0']&&$ut<=$after[0]['clock0'];f27_assert($s['changed_column']!==null?$clock:($ut===$old||$clock),'Observe source self oracle; never pre-impose noop');} function f27_fingerprint($meta,$p){$r=$meta;if(isset($r['columns'])){foreach($r['columns']as &$c){unset($c['num_distinct'],$c['low_value'],$c['high_value'],$c['density'],$c['num_nulls'],$c['num_buckets'],$c['last_analyzed'],$c['sample_size'],$c['global_stats'],$c['user_stats'],$c['avg_col_len'],$c['histogram'],$c['avg_col_len']);}unset($c);}if($p['lane']==='B'&&isset($r['ddl']))foreach($r['ddl']as &$row)foreach($row as &$value)if(is_string($value))$value=preg_replace('/\bAUTO_INCREMENT=\d+\b/','AUTO_INCREMENT=',$value);unset($row,$value);return $r;} function f27_schema($m,$p,$hasTrigger){f27_extra_schema($m,$p,$hasTrigger);$b=$p['lane']==='B';f27_assert(array_map('strtoupper',array_column($m['columns'],'column_name'))===$p['columns'],'Exact27 own column order');foreach($m['columns']as $i=>$c){$f=$p['field_contract'][$i];if($b){f27_assert(strtolower($c['column_type'])===$f['source']['type']&&$c['is_nullable']===($f['source']['nullable']?'YES':'NO'),'Source column type/nullability');if(in_array($f['name'],$p['dates'],true))f27_assert((int)$c['datetime_precision']===0,'Source actual fsp0');if($f['name']==='UPDATE_TIME')f27_assert(stripos($c['extra'],'on update CURRENT_TIMESTAMP')!==false,'Source actual ON UPDATE');}else{f27_assert($c['data_type']===$f['target_sealed']['type']&&$c['nullable']===($f['source']['nullable']?'Y':'N'),'Target exact type/nullability');if(in_array($f['name'],$p['dates'],true))f27_assert((int)$c['data_scale']===0,'Target explicit fsp0');if($f['source']['character_maximum_length']!==null)f27_assert((int)$c['char_length']===$f['source']['character_maximum_length']&&$c['char_used']==='C','Target exact VARCHAR character capacity');}} if($b){f27_assert($m['triggers']===[]&&$m['views']===[]&&$m['routines']===[],'No foreign dependents/triggers');f27_assert(count($m['constraints'])===1&&$m['constraints'][0]['constraint_type']==='PRIMARY KEY'&&count($m['keys'])===1&&strtoupper($m['keys'][0]['column_name'])==='ID'&&$m['keys'][0]['referenced_table_name']===null,'Owned PK only and incomingFK0');f27_assert(count($m['indexes'])===6,'Cloned original5 indexes/6 column entries');} else{f27_assert(count($m['indexes'])===2,'Known DM cluster plus PK NORMAL pair');$by=[];foreach($m['indexes']as $x){f27_assert($x['table_owner']==='ZHCT_APP'&&$x['table_name']===$p['bare']&&$x['status']==='VALID','Only own VALID index');$by[$x['index_name']]=$x;}$c=$m['constraints'];f27_assert(count($c)===1&&$c[0]['constraint_name']===$p['pk']&&$c[0]['constraint_type']==='P'&&$c[0]['status']==='ENABLED'&&$c[0]['validated']==='VALIDATED'&&isset($by[$c[0]['index_name']]),'Exact owned PK pointer');$pk=$by[$c[0]['index_name']];f27_assert($pk['index_type']==='NORMAL'&&$pk['uniqueness']==='UNIQUE','PK NORMAL UNIQUE');unset($by[$c[0]['index_name']]);$cluster=array_values($by)[0];f27_assert($cluster['index_type']==='CLUSTER'&&$cluster['uniqueness']==='NONUNIQUE','Implicit owned CLUSTER NONUNIQUE');f27_assert(count($m['index_columns'])===1&&$m['index_columns'][0]['index_name']===$c[0]['index_name']&&$m['index_columns'][0]['column_name']==='ID'&&count($m['constraint_columns'])===1&&$m['constraint_columns'][0]['column_name']==='ID'&&$m['foreign_keys']===[],'Exact PK columns/incomingFK0');foreach($m['objects']as $o)f27_assert($o['status']==='VALID'&&in_array($o['object_name'],[$p['bare'],$p['trigger']],true),'Native owned valid objects');if($hasTrigger){f27_assert(count($m['triggers'])===1,'Single owned trigger');$t=$m['triggers'][0];f27_assert($t['trigger_name']===$p['trigger']&&$t['table_name']===$p['bare']&&$t['table_owner']==='ZHCT_APP'&&$t['status']==='Y'&&$t['triggering_type']==='BEFORE ROW'&&$t['triggering_event']==='UPDATE','Actual owned trigger Y BEFORE ROW UPDATE');f27_trigger($m['trigger_ddl'][0]['ddl'],$t['trigger_body'],$p['candidate_trigger']);foreach($m['dependencies']as $d)f27_assert(in_array($p['trigger'],array_values($d),true),'Only owned trigger dependency');}else f27_assert($m['triggers']===[]&&$m['dependencies']===[],'No unowned trigger/dependency');}}