Hello,

Application Teams are experiencing a behavior where few statements are skipped when executed via scripts, They are running multiple scripts concurrently on different tables.

Please let us know if there are any know issues or a fix for the reported behavior.

Database: MonetDB v11.27.13 (Jul2017-SP4)

ü DROP, CREATE, INSERT – New SQL sequence, however looks like SQL statement are not executing as in order in database as per system catalog table log time entries. We need to check on this.

ü First DROP, INSERT started and then after couple of statements, CREATE SQL started executing.

DROP TABLE IF EXISTS "KEYFOOD_IT_S_22_43321_C";^M

CREATE TABLE "KEYFOOD_IT_S_22_43321_C"(ATTR_NAME VARCHAR(500) NOT NULL, COL_NAME VARCHAR(30) NOT NULL, AVP_KEY INTEGER NOT NULL, ATTR_VALUE VARCHAR(3000), ATTR_LONG_VALUE VARCHAR(3000), ATTR_SHORT_VALUE VARCHAR(100), ATTR_MEDIUM_VALUE VARCHAR(100), PARENT_AVP_KEY INTEGER, SORT_ORDER INTEGER);

INSERT INTO "KEYFOOD_IT_S_22_43321_C" (ATTR_NAME, COL_NAME, AVP_KEY, ATTR_VALUE, ATTR_LONG_VALUE, ATTR_SHORT_VALUE, ATTR_MEDIUM_VALUE, PARENT_AVP_KEY, SORT_ORDER) SELECT ATTR_NAME, COL_NAME, AVP_KEY, ATTR_VALUE, ATTR_LONG_VALUE, ATTR_SHORT_VALUE, ATTR_MEDIUM_VALUE, PARENT_AVP_KEY, SORT_ORDER FROM "IT_DSJ_KEYFOOD_43321" WHERE COL_NAME='S_22_KEY' AND SORT_TYPE='CATG';

We were able to  statements being skipped in sys.querylog_catalog and sys.querylog_calls.

Thank You,

Gautham