|
1306228381065 |
1306228381329 |
1306228381549 |
1306228381554 |
1306228381583 |
1306228382491 |
|
RD 1: read final block: 33 bytes RX 1: void:merovingian:8:md5,plain:LIT: RD 1: inserting prompt TD 1: write final block: 48 bytes TX 1: BIG:merovingian:{plain}merovingianvoid:sql:test: RD 2: read final block: 40 bytes RX 2: ^mapi:merovingian://proxy?database=test
RD 2: inserting prompt RD 3: read final block: 56 bytes RX 3: JUC8LkKQ:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512: RD 3: inserting prompt TD 4: write final block: 94 bytes TX 4: BIG:monetdb:{SHA256}b286625fb50a93a4c9418f4fb3f27ce49e1ef068f5331cba841e4b5d4d216954:sql:test: RD 5: read final block: 0 bytes RX 5: RD 5: inserting prompt TD 6: write final block: 48 bytes TX 6: sSET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; RD 6: read final block: 0 bytes RX 6: RD 6: inserting prompt |
|
|
|
|
|
|
|
RD 7: read final block: 33 bytes RX 7: void:merovingian:8:md5,plain:LIT: RD 7: inserting prompt TD 7: write final block: 48 bytes TX 7: BIG:merovingian:{plain}merovingianvoid:sql:test: RD 7: read final block: 40 bytes RX 7: ^mapi:merovingian://proxy?database=test
RD 7: inserting prompt RD 7: read final block: 57 bytes RX 8: gPCZ0DS2x:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512: RD 8: inserting prompt TD 8: write final block: 94 bytes TX 8: BIG:monetdb:{SHA256}f6d84fcd94ae526da7b35cdcc9d41d055e4acea7335fd038ae80b69b355d7a63:sql:test: RD 9: read final block: 0 bytes RX 9: RD 9: inserting prompt TD 9: write final block: 48 bytes TX 9: sSET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; RD 9: read final block: 0 bytes RX 9: RD 9: inserting prompt TD 10: write final block: 15 bytes TX 10: Xreply_size 250 RD 10: read final block: 0 bytes RX 10: RD 10: inserting prompt TD 10: write final block: 50 bytes TX 10: sCREATE TABLE "locked" ( "process" VARCHAR(128) ); RD 11: read final block: 3 bytes RX 11: &3
RD 11: inserting prompt TD 12: write final block: 47 bytes TX 12: sINSERT INTO "locked" VALUES ('26171@hendrix'); RD 13: read final block: 8 bytes RX 13: &2 1 -1
RD 13: inserting prompt |
|
|
|
|
|
|
|
RD 14: read final block: 33 bytes RX 14: void:merovingian:8:md5,plain:LIT: RD 14: inserting prompt TD 14: write final block: 48 bytes TX 14: BIG:merovingian:{plain}merovingianvoid:sql:test: RD 14: read final block: 40 bytes RX 14: ^mapi:merovingian://proxy?database=test
RD 14: inserting prompt RD 14: read final block: 56 bytes RX 14: 03TWsnvH:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512: RD 14: inserting prompt TD 15: write final block: 94 bytes TX 15: BIG:monetdb:{SHA256}b175a92fdfc3eeeb6248a788f9d8cddbf58e88fde9c672b07d2876442e651a22:sql:test: RD 16: read final block: 0 bytes RX 16: RD 16: inserting prompt TD 16: write final block: 48 bytes TX 16: sSET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; RD 17: read final block: 0 bytes RX 17: RD 17: inserting prompt |
|
|
|
|
|
|
|
RD 18: read final block: 33 bytes RX 18: void:merovingian:8:md5,plain:LIT: RD 18: inserting prompt TD 18: write final block: 48 bytes TX 18: BIG:merovingian:{plain}merovingianvoid:sql:test: RD 19: read final block: 40 bytes RX 19: ^mapi:merovingian://proxy?database=test
RD 19: inserting prompt RD 19: read final block: 58 bytes RX 19: sisZ3UWB3v:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512: RD 19: inserting prompt TD 19: write final block: 94 bytes TX 19: BIG:monetdb:{SHA256}db4b977b4702af28ab0e09f6521176a7f8552f34657a03967061ff89aebf841e:sql:test: RD 20: read final block: 0 bytes RX 20: RD 20: inserting prompt TD 20: write final block: 48 bytes TX 20: sSET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; RD 20: read final block: 0 bytes RX 20: RD 20: inserting prompt |
|
|
|
|
|
|
|
RD 21: read final block: 33 bytes RX 21: void:merovingian:8:md5,plain:LIT: RD 21: inserting prompt TD 21: write final block: 48 bytes TX 21: BIG:merovingian:{plain}merovingianvoid:sql:test: RD 21: read final block: 40 bytes RX 21: ^mapi:merovingian://proxy?database=test
RD 21: inserting prompt RD 21: read final block: 58 bytes RX 21: hzTJoSa6Jv:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512: RD 21: inserting prompt TD 22: write final block: 94 bytes TX 22: BIG:monetdb:{SHA256}8d83b52e5f1e84a5f1dc5404109f363b19689fd2a4be739b45672cc90690e857:sql:test: RD 23: read final block: 0 bytes RX 23: RD 23: inserting prompt TD 23: write final block: 48 bytes TX 23: sSET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; RD 23: read final block: 0 bytes RX 23: RD 23: inserting prompt TD 24: write final block: 15 bytes TX 24: Xreply_size 250 RD 24: read final block: 0 bytes RX 24: RD 24: inserting prompt TD 24: write final block: 46 bytes TX 24: sSELECT "name", "value" FROM sys.env() as env; RD 25: read final block: 5038 bytes RX 25: &1 0 52 2 52
RD 25: inserting prompt TD 26: write final block: 1407 bytes TX 26: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'hash_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 27: read final block: 377 bytes RX 27: &1 1 0 10 0
RD 27: inserting prompt TD 27: write final block: 76 bytes TX 27: sCREATE TABLE hash_values ( id INTEGER NOT NULL, value BIGINT NOT NULL ); RD 28: read final block: 3 bytes RX 28: &3
RD 28: inserting prompt TD 29: write final block: 46 bytes TX 29: sALTER TABLE hash_values ADD PRIMARY KEY (id); RD 30: read final block: 3 bytes RX 30: &3
RD 30: inserting prompt TD 30: write final block: 59 bytes TX 30: sCREATE INDEX hash_values_value_idx ON hash_values (value); RD 31: read final block: 3 bytes RX 31: &3
RD 31: inserting prompt TD 32: write final block: 87 bytes TX 32: sPREPARE SELECT MAX(id), MOD((id >> 28) + 16, 16) AS grp FROM hash_values GROUP BY grp; RD 33: read final block: 130 bytes RX 33: &5 0 0 3 0
RD 33: inserting prompt TD 33: write final block: 10 bytes TX 33: sexec 0(); RD 34: read final block: 99 bytes RX 34: &1 2 0 2 0
RD 34: inserting prompt TD 35: write final block: 10 bytes TX 35: Xrelease 0 RD 35: read final block: 0 bytes RX 35: RD 35: inserting prompt |
|
|
|
TD 36: write final block: 46 bytes TX 36: sSELECT "name", "value" FROM sys.env() as env; RD 37: read final block: 5038 bytes RX 37: &1 0 52 2 52
RD 37: inserting prompt TD 38: write final block: 1414 bytes TX 38: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'namespace_prefixes' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 39: read final block: 377 bytes RX 39: &1 1 0 10 0
RD 39: inserting prompt TD 39: write final block: 85 bytes TX 39: sCREATE TABLE namespace_prefixes ( prefix VARCHAR(127), namespace TEXT NOT NULL ); RD 40: read final block: 3 bytes RX 40: &3
RD 40: inserting prompt TD 41: write final block: 50 bytes TX 41: sSELECT prefix, namespace FROM namespace_prefixes; RD 42: read final block: 139 bytes RX 42: &1 2 0 2 0
RD 42: inserting prompt |
|
|
|
|
|
|
|
TD 43: write final block: 15 bytes TX 43: Xreply_size 250 RD 43: read final block: 0 bytes RX 44: RD 44: inserting prompt TD 44: write final block: 46 bytes TX 44: sSELECT "name", "value" FROM sys.env() as env; RD 45: read final block: 5038 bytes RX 45: &1 0 52 2 52
RD 45: inserting prompt TD 46: write final block: 1408 bytes TX 46: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'bnode_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 47: read final block: 377 bytes RX 47: &1 1 0 10 0
RD 47: inserting prompt TD 48: write final block: 83 bytes TX 48: sCREATE TABLE bnode_values ( id INTEGER NOT NULL, value VARCHAR(127) NOT NULL ); RD 49: read final block: 3 bytes RX 49: &3
RD 49: inserting prompt TD 49: write final block: 47 bytes TX 49: sALTER TABLE bnode_values ADD PRIMARY KEY (id); RD 50: read final block: 3 bytes RX 50: &3
RD 50: inserting prompt TD 51: write final block: 1406 bytes TX 51: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'uri_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 52: read final block: 377 bytes RX 52: &1 2 0 10 0
RD 52: inserting prompt TD 52: write final block: 81 bytes TX 52: sCREATE TABLE uri_values ( id INTEGER NOT NULL, value VARCHAR(255) NOT NULL ); RD 53: read final block: 3 bytes RX 53: &3
RD 53: inserting prompt TD 53: write final block: 45 bytes TX 53: sALTER TABLE uri_values ADD PRIMARY KEY (id); RD 54: read final block: 3 bytes RX 54: &3
RD 54: inserting prompt TD 55: write final block: 1411 bytes TX 55: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'long_uri_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 56: read final block: 377 bytes RX 56: &1 3 0 10 0
RD 56: inserting prompt TD 56: write final block: 78 bytes TX 56: sCREATE TABLE long_uri_values ( id INTEGER NOT NULL, value TEXT NOT NULL ); RD 57: read final block: 3 bytes RX 57: &3
RD 57: inserting prompt TD 57: write final block: 50 bytes TX 57: sALTER TABLE long_uri_values ADD PRIMARY KEY (id); RD 58: read final block: 3 bytes RX 58: &3
RD 58: inserting prompt
|
|
|
|
|
|
|
|
TD 59: write final block: 15 bytes TX 59: Xreply_size 250 RD 60: read final block: 0 bytes RX 60: RD 60: inserting prompt TD 60: write final block: 46 bytes TX 60: sSELECT "name", "value" FROM sys.env() as env; RD 61: read final block: 5038 bytes RX 61: &1 0 52 2 52
RD 61: inserting prompt TD 62: write final block: 1408 bytes TX 62: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'label_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 63: read final block: 377 bytes RX 63: &1 1 0 10 0
RD 63: inserting prompt TD 63: write final block: 83 bytes TX 63: sCREATE TABLE label_values ( id INTEGER NOT NULL, value VARCHAR(255) NOT NULL ); RD 64: read final block: 3 bytes RX 64: &3
RD 64: inserting prompt TD 64: write final block: 47 bytes TX 64: sALTER TABLE label_values ADD PRIMARY KEY (id); RD 65: read final block: 3 bytes RX 65: &3
RD 65: inserting prompt TD 65: write final block: 1413 bytes TX 65: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'long_label_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 66: read final block: 377 bytes RX 66: &1 2 0 10 0
RD 66: inserting prompt TD 66: write final block: 80 bytes TX 66: sCREATE TABLE long_label_values ( id INTEGER NOT NULL, value TEXT NOT NULL ); RD 67: read final block: 3 bytes RX 67: &3
RD 67: inserting prompt TD 67: write final block: 52 bytes TX 67: sALTER TABLE long_label_values ADD PRIMARY KEY (id); RD 68: read final block: 3 bytes RX 68: &3
RD 68: inserting prompt TD 68: write final block: 1411 bytes TX 68: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'language_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 69: read final block: 377 bytes RX 69: &1 3 0 10 0
RD 69: inserting prompt TD 69: write final block: 86 bytes TX 69: sCREATE TABLE language_values ( id INTEGER NOT NULL, value VARCHAR(127) NOT NULL ); RD 70: read final block: 3 bytes RX 70: &3
RD 70: inserting prompt TD 70: write final block: 50 bytes TX 70: sALTER TABLE language_values ADD PRIMARY KEY (id); RD 71: read final block: 3 bytes RX 71: &3
RD 71: inserting prompt TD 72: write final block: 1411 bytes TX 72: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'datatype_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 73: read final block: 377 bytes RX 73: &1 4 0 10 0
RD 73: inserting prompt TD 74: write final block: 86 bytes TX 74: sCREATE TABLE datatype_values ( id INTEGER NOT NULL, value VARCHAR(255) NOT NULL ); RD 75: read final block: 3 bytes RX 75: &3
RD 75: inserting prompt TD 75: write final block: 50 bytes TX 75: sALTER TABLE datatype_values ADD PRIMARY KEY (id); RD 76: read final block: 3 bytes RX 76: &3
RD 76: inserting prompt TD 77: write final block: 1410 bytes TX 77: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'numeric_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 78: read final block: 377 bytes RX 78: &1 5 0 10 0
RD 78: inserting prompt TD 78: write final block: 89 bytes TX 78: sCREATE TABLE numeric_values ( id INTEGER NOT NULL, value double precision NOT NULL ); RD 79: read final block: 3 bytes RX 79: &3
RD 79: inserting prompt TD 79: write final block: 49 bytes TX 79: sALTER TABLE numeric_values ADD PRIMARY KEY (id); RD 80: read final block: 3 bytes RX 80: &3
RD 80: inserting prompt TD 81: write final block: 1411 bytes TX 81: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'datetime_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 82: read final block: 377 bytes RX 82: &1 6 0 10 0
RD 82: inserting prompt TD 82: write final block: 80 bytes TX 82: sCREATE TABLE datetime_values ( id INTEGER NOT NULL, value BIGINT NOT NULL ); RD 83: read final block: 3 bytes RX 83: &3
RD 83: inserting prompt TD 83: write final block: 50 bytes TX 83: sALTER TABLE datetime_values ADD PRIMARY KEY (id); RD 84: read final block: 3 bytes RX 84: &3
RD 84: inserting prompt TD 85: write final block: 1406 bytes TX 85: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND LOWER("TABLE_NAME") LIKE 'geo_values' AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 86: read final block: 377 bytes RX 86: &1 7 0 10 0
RD 86: inserting prompt TD 86: write final block: 50 bytes TX 86: sCREATE TABLE geo_values ( id INTEGER NOT NULL ); RD 87: read final block: 3 bytes RX 87: &3
RD 87: inserting prompt TD 87: write final block: 46 bytes TX 87: sALTER TABLE geo_values ADD strdfgeo GEOMETRY; RD 88: read final block: 3 bytes RX 88: &3
RD 88: inserting prompt TD 88: write final block: 48 bytes TX 88: sCREATE INDEX geoindex ON geo_values (strdfgeo); RD 89: read final block: 3 bytes RX 89: &3
RD 89: inserting prompt TD 89: write final block: 45 bytes TX 89: sALTER TABLE geo_values ADD PRIMARY KEY (id); RD 90: read final block: 3 bytes RX 90: &3
RD 90: inserting prompt
|
|
|
|
|
TD 91: write final block: 1364 bytes TX 91: sSELECT * FROM ( SELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", CASE WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'SYSTEM TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'SYSTEM VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 0 THEN 'TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 0 THEN 'VIEW' WHEN "tables"."system" = true AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION TABLE' WHEN "tables"."system" = true AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SYSTEM SESSION VIEW' WHEN "tables"."system" = false AND "tables"."type" = 0 AND "tables"."temporary" = 1 THEN 'SESSION TABLE' WHEN "tables"."system" = false AND "tables"."type" = 1 AND "tables"."temporary" = 1 THEN 'SESSION VIEW' END AS "TABLE_TYPE", "tables"."query" AS "REMARKS", null AS "TYPE_CAT", null AS "TYPE_SCHEM", null AS "TYPE_NAME", 'rowid' AS "SELF_REFERENCING_COL_NAME", 'SYSTEM' AS "REF_GENERATION" FROM "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "tables"."schema_id" = "schemas"."id" ) AS "tables" WHERE 1 = 1 AND (LOWER("TABLE_TYPE") LIKE 'table') ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME" ; RD 92: read final block: 1591 bytes RX 93: &1 3 14 10 14
RD 93: inserting prompt TD 93: write final block: 1702 bytes TX 93: sSELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", "columns"."name" AS "COLUMN_NAME", cast(CASE "columns"."type" WHEN 'timetz' THEN 92 WHEN 'table' THEN 2003 WHEN 'blob' THEN 2004 WHEN 'bigint' THEN -5 WHEN 'varchar' THEN 12 WHEN 'time' THEN 92 WHEN 'clob' THEN 2005 WHEN 'wrd' THEN -5 WHEN 'int' THEN 4 WHEN 'timestamptz' THEN 93 WHEN 'date' THEN 91 WHEN 'sec_interval' THEN -5 WHEN 'boolean' THEN 16 WHEN 'decimal' THEN 3 WHEN 'double' THEN 8 WHEN 'char' THEN 1 WHEN 'month_interval' THEN 4 WHEN 'oid' THEN 1111 WHEN 'smallint' THEN 5 WHEN 'tinyint' THEN -6 WHEN 'timestamp' THEN 93 WHEN 'real' THEN 7 ELSE 1111 END AS smallint) AS "DATA_TYPE", "columns"."type" AS "TYPE_NAME", "columns"."type_digits" AS "COLUMN_SIZE", "columns"."type_scale" AS "DECIMAL_DIGITS", 0 AS "BUFFER_LENGTH", 10 AS "NUM_PREC_RADIX", cast(CASE "null" WHEN true THEN 1 WHEN false THEN 0 END AS int) AS "NULLABLE", cast(null AS varchar(1)) AS "REMARKS", "columns"."default" AS "COLUMN_DEF", 0 AS "SQL_DATA_TYPE", 0 AS "SQL_DATETIME_SUB", 0 AS "CHAR_OCTET_LENGTH", "columns"."number" + 1 AS "ORDINAL_POSITION", cast(null AS varchar(1)) AS "SCOPE_CATALOG", cast(null AS varchar(1)) AS "SCOPE_SCHEMA", cast(null AS varchar(1)) AS "SCOPE_TABLE", cast(1111 AS smallint) AS "SOURCE_DATA_TYPE", CASE "null" WHEN true THEN CAST ('YES' AS varchar(3)) WHEN false THEN CAST ('NO' AS varchar(3)) END AS "IS_NULLABLE" FROM "sys"."columns" AS "columns", "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "columns"."table_id" = "tables"."id" AND "tables"."schema_id" = "schemas"."id" AND LOWER("columns"."name") LIKE 'ctx' ORDER BY "TABLE_SCHEM", "TABLE_NAME", "ORDINAL_POSITION"; RD 94: read final block: 721 bytes RX 94: &1 4 0 22 0
RD 94: inserting prompt TD 94: write final block: 1702 bytes TX 94: sSELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", "columns"."name" AS "COLUMN_NAME", cast(CASE "columns"."type" WHEN 'timetz' THEN 92 WHEN 'table' THEN 2003 WHEN 'blob' THEN 2004 WHEN 'bigint' THEN -5 WHEN 'varchar' THEN 12 WHEN 'time' THEN 92 WHEN 'clob' THEN 2005 WHEN 'wrd' THEN -5 WHEN 'int' THEN 4 WHEN 'timestamptz' THEN 93 WHEN 'date' THEN 91 WHEN 'sec_interval' THEN -5 WHEN 'boolean' THEN 16 WHEN 'decimal' THEN 3 WHEN 'double' THEN 8 WHEN 'char' THEN 1 WHEN 'month_interval' THEN 4 WHEN 'oid' THEN 1111 WHEN 'smallint' THEN 5 WHEN 'tinyint' THEN -6 WHEN 'timestamp' THEN 93 WHEN 'real' THEN 7 ELSE 1111 END AS smallint) AS "DATA_TYPE", "columns"."type" AS "TYPE_NAME", "columns"."type_digits" AS "COLUMN_SIZE", "columns"."type_scale" AS "DECIMAL_DIGITS", 0 AS "BUFFER_LENGTH", 10 AS "NUM_PREC_RADIX", cast(CASE "null" WHEN true THEN 1 WHEN false THEN 0 END AS int) AS "NULLABLE", cast(null AS varchar(1)) AS "REMARKS", "columns"."default" AS "COLUMN_DEF", 0 AS "SQL_DATA_TYPE", 0 AS "SQL_DATETIME_SUB", 0 AS "CHAR_OCTET_LENGTH", "columns"."number" + 1 AS "ORDINAL_POSITION", cast(null AS varchar(1)) AS "SCOPE_CATALOG", cast(null AS varchar(1)) AS "SCOPE_SCHEMA", cast(null AS varchar(1)) AS "SCOPE_TABLE", cast(1111 AS smallint) AS "SOURCE_DATA_TYPE", CASE "null" WHEN true THEN CAST ('YES' AS varchar(3)) WHEN false THEN CAST ('NO' AS varchar(3)) END AS "IS_NULLABLE" FROM "sys"."columns" AS "columns", "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "columns"."table_id" = "tables"."id" AND "tables"."schema_id" = "schemas"."id" AND LOWER("columns"."name") LIKE 'ctx' ORDER BY "TABLE_SCHEM", "TABLE_NAME", "ORDINAL_POSITION"; RD 95: read final block: 721 bytes RX 95: &1 5 0 22 0
RD 95: inserting prompt TD 96: write final block: 1703 bytes TX 96: sSELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", "columns"."name" AS "COLUMN_NAME", cast(CASE "columns"."type" WHEN 'timetz' THEN 92 WHEN 'table' THEN 2003 WHEN 'blob' THEN 2004 WHEN 'bigint' THEN -5 WHEN 'varchar' THEN 12 WHEN 'time' THEN 92 WHEN 'clob' THEN 2005 WHEN 'wrd' THEN -5 WHEN 'int' THEN 4 WHEN 'timestamptz' THEN 93 WHEN 'date' THEN 91 WHEN 'sec_interval' THEN -5 WHEN 'boolean' THEN 16 WHEN 'decimal' THEN 3 WHEN 'double' THEN 8 WHEN 'char' THEN 1 WHEN 'month_interval' THEN 4 WHEN 'oid' THEN 1111 WHEN 'smallint' THEN 5 WHEN 'tinyint' THEN -6 WHEN 'timestamp' THEN 93 WHEN 'real' THEN 7 ELSE 1111 END AS smallint) AS "DATA_TYPE", "columns"."type" AS "TYPE_NAME", "columns"."type_digits" AS "COLUMN_SIZE", "columns"."type_scale" AS "DECIMAL_DIGITS", 0 AS "BUFFER_LENGTH", 10 AS "NUM_PREC_RADIX", cast(CASE "null" WHEN true THEN 1 WHEN false THEN 0 END AS int) AS "NULLABLE", cast(null AS varchar(1)) AS "REMARKS", "columns"."default" AS "COLUMN_DEF", 0 AS "SQL_DATA_TYPE", 0 AS "SQL_DATETIME_SUB", 0 AS "CHAR_OCTET_LENGTH", "columns"."number" + 1 AS "ORDINAL_POSITION", cast(null AS varchar(1)) AS "SCOPE_CATALOG", cast(null AS varchar(1)) AS "SCOPE_SCHEMA", cast(null AS varchar(1)) AS "SCOPE_TABLE", cast(1111 AS smallint) AS "SOURCE_DATA_TYPE", CASE "null" WHEN true THEN CAST ('YES' AS varchar(3)) WHEN false THEN CAST ('NO' AS varchar(3)) END AS "IS_NULLABLE" FROM "sys"."columns" AS "columns", "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "columns"."table_id" = "tables"."id" AND "tables"."schema_id" = "schemas"."id" AND LOWER("columns"."name") LIKE 'subj' ORDER BY "TABLE_SCHEM", "TABLE_NAME", "ORDINAL_POSITION"; RD 97: read final block: 721 bytes RX 97: &1 6 0 22 0
RD 97: inserting prompt TD 98: write final block: 1703 bytes TX 98: sSELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", "columns"."name" AS "COLUMN_NAME", cast(CASE "columns"."type" WHEN 'timetz' THEN 92 WHEN 'table' THEN 2003 WHEN 'blob' THEN 2004 WHEN 'bigint' THEN -5 WHEN 'varchar' THEN 12 WHEN 'time' THEN 92 WHEN 'clob' THEN 2005 WHEN 'wrd' THEN -5 WHEN 'int' THEN 4 WHEN 'timestamptz' THEN 93 WHEN 'date' THEN 91 WHEN 'sec_interval' THEN -5 WHEN 'boolean' THEN 16 WHEN 'decimal' THEN 3 WHEN 'double' THEN 8 WHEN 'char' THEN 1 WHEN 'month_interval' THEN 4 WHEN 'oid' THEN 1111 WHEN 'smallint' THEN 5 WHEN 'tinyint' THEN -6 WHEN 'timestamp' THEN 93 WHEN 'real' THEN 7 ELSE 1111 END AS smallint) AS "DATA_TYPE", "columns"."type" AS "TYPE_NAME", "columns"."type_digits" AS "COLUMN_SIZE", "columns"."type_scale" AS "DECIMAL_DIGITS", 0 AS "BUFFER_LENGTH", 10 AS "NUM_PREC_RADIX", cast(CASE "null" WHEN true THEN 1 WHEN false THEN 0 END AS int) AS "NULLABLE", cast(null AS varchar(1)) AS "REMARKS", "columns"."default" AS "COLUMN_DEF", 0 AS "SQL_DATA_TYPE", 0 AS "SQL_DATETIME_SUB", 0 AS "CHAR_OCTET_LENGTH", "columns"."number" + 1 AS "ORDINAL_POSITION", cast(null AS varchar(1)) AS "SCOPE_CATALOG", cast(null AS varchar(1)) AS "SCOPE_SCHEMA", cast(null AS varchar(1)) AS "SCOPE_TABLE", cast(1111 AS smallint) AS "SOURCE_DATA_TYPE", CASE "null" WHEN true THEN CAST ('YES' AS varchar(3)) WHEN false THEN CAST ('NO' AS varchar(3)) END AS "IS_NULLABLE" FROM "sys"."columns" AS "columns", "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "columns"."table_id" = "tables"."id" AND "tables"."schema_id" = "schemas"."id" AND LOWER("columns"."name") LIKE 'subj' ORDER BY "TABLE_SCHEM", "TABLE_NAME", "ORDINAL_POSITION"; RD 99: read final block: 721 bytes RX 99: &1 7 0 22 0
RD 99: inserting prompt TD 99: write final block: 1702 bytes TX 100: sSELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", "columns"."name" AS "COLUMN_NAME", cast(CASE "columns"."type" WHEN 'timetz' THEN 92 WHEN 'table' THEN 2003 WHEN 'blob' THEN 2004 WHEN 'bigint' THEN -5 WHEN 'varchar' THEN 12 WHEN 'time' THEN 92 WHEN 'clob' THEN 2005 WHEN 'wrd' THEN -5 WHEN 'int' THEN 4 WHEN 'timestamptz' THEN 93 WHEN 'date' THEN 91 WHEN 'sec_interval' THEN -5 WHEN 'boolean' THEN 16 WHEN 'decimal' THEN 3 WHEN 'double' THEN 8 WHEN 'char' THEN 1 WHEN 'month_interval' THEN 4 WHEN 'oid' THEN 1111 WHEN 'smallint' THEN 5 WHEN 'tinyint' THEN -6 WHEN 'timestamp' THEN 93 WHEN 'real' THEN 7 ELSE 1111 END AS smallint) AS "DATA_TYPE", "columns"."type" AS "TYPE_NAME", "columns"."type_digits" AS "COLUMN_SIZE", "columns"."type_scale" AS "DECIMAL_DIGITS", 0 AS "BUFFER_LENGTH", 10 AS "NUM_PREC_RADIX", cast(CASE "null" WHEN true THEN 1 WHEN false THEN 0 END AS int) AS "NULLABLE", cast(null AS varchar(1)) AS "REMARKS", "columns"."default" AS "COLUMN_DEF", 0 AS "SQL_DATA_TYPE", 0 AS "SQL_DATETIME_SUB", 0 AS "CHAR_OCTET_LENGTH", "columns"."number" + 1 AS "ORDINAL_POSITION", cast(null AS varchar(1)) AS "SCOPE_CATALOG", cast(null AS varchar(1)) AS "SCOPE_SCHEMA", cast(null AS varchar(1)) AS "SCOPE_TABLE", cast(1111 AS smallint) AS "SOURCE_DATA_TYPE", CASE "null" WHEN true THEN CAST ('YES' AS varchar(3)) WHEN false THEN CAST ('NO' AS varchar(3)) END AS "IS_NULLABLE" FROM "sys"."columns" AS "columns", "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "columns"."table_id" = "tables"."id" AND "tables"."schema_id" = "schemas"."id" AND LOWER("columns"."name") LIKE 'obj' ORDER BY "TABLE_SCHEM", "TABLE_NAME", "ORDINAL_POSITION"; RD 101: read final block: 721 bytes RX 101: &1 8 0 22 0
RD 101: inserting prompt TD 102: write final block: 1702 bytes TX 102: sSELECT 'test' AS "TABLE_CAT", "schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS "TABLE_NAME", "columns"."name" AS "COLUMN_NAME", cast(CASE "columns"."type" WHEN 'timetz' THEN 92 WHEN 'table' THEN 2003 WHEN 'blob' THEN 2004 WHEN 'bigint' THEN -5 WHEN 'varchar' THEN 12 WHEN 'time' THEN 92 WHEN 'clob' THEN 2005 WHEN 'wrd' THEN -5 WHEN 'int' THEN 4 WHEN 'timestamptz' THEN 93 WHEN 'date' THEN 91 WHEN 'sec_interval' THEN -5 WHEN 'boolean' THEN 16 WHEN 'decimal' THEN 3 WHEN 'double' THEN 8 WHEN 'char' THEN 1 WHEN 'month_interval' THEN 4 WHEN 'oid' THEN 1111 WHEN 'smallint' THEN 5 WHEN 'tinyint' THEN -6 WHEN 'timestamp' THEN 93 WHEN 'real' THEN 7 ELSE 1111 END AS smallint) AS "DATA_TYPE", "columns"."type" AS "TYPE_NAME", "columns"."type_digits" AS "COLUMN_SIZE", "columns"."type_scale" AS "DECIMAL_DIGITS", 0 AS "BUFFER_LENGTH", 10 AS "NUM_PREC_RADIX", cast(CASE "null" WHEN true THEN 1 WHEN false THEN 0 END AS int) AS "NULLABLE", cast(null AS varchar(1)) AS "REMARKS", "columns"."default" AS "COLUMN_DEF", 0 AS "SQL_DATA_TYPE", 0 AS "SQL_DATETIME_SUB", 0 AS "CHAR_OCTET_LENGTH", "columns"."number" + 1 AS "ORDINAL_POSITION", cast(null AS varchar(1)) AS "SCOPE_CATALOG", cast(null AS varchar(1)) AS "SCOPE_SCHEMA", cast(null AS varchar(1)) AS "SCOPE_TABLE", cast(1111 AS smallint) AS "SOURCE_DATA_TYPE", CASE "null" WHEN true THEN CAST ('YES' AS varchar(3)) WHEN false THEN CAST ('NO' AS varchar(3)) END AS "IS_NULLABLE" FROM "sys"."columns" AS "columns", "sys"."tables" AS "tables", "sys"."schemas" AS "schemas" WHERE "columns"."table_id" = "tables"."id" AND "tables"."schema_id" = "schemas"."id" AND LOWER("columns"."name") LIKE 'obj' ORDER BY "TABLE_SCHEM", "TABLE_NAME", "ORDINAL_POSITION"; RD 103: read final block: 721 bytes RX 104: &1 9 0 22 0
RD 104: inserting prompt
|
|
|
|
|
|
|
|
|
|
|
RD 105: read final block: 33 bytes RX 105: void:merovingian:8:md5,plain:LIT: RD 106: inserting prompt TD 106: write final block: 48 bytes TX 106: BIG:merovingian:{plain}merovingianvoid:sql:test: RD 106: read final block: 40 bytes RX 106: ^mapi:merovingian://proxy?database=test
RD 106: inserting prompt RD 106: read final block: 59 bytes RX 106: GmStC7Mai3g:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512: RD 106: inserting prompt TD 107: write final block: 94 bytes TX 107: BIG:monetdb:{SHA256}0f08658f0fc4a40bc51d6f337d13558b3b1797d31e91f93f720ce57375bb8999:sql:test: RD 108: read final block: 0 bytes RX 108: RD 108: inserting prompt TD 109: write final block: 48 bytes TX 109: sSET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; RD 109: read final block: 0 bytes RX 109: RD 109: inserting prompt
|
|
|
|
|
|
TD 110: write final block: 90 bytes TX 110: sPREPARE SELECT id, value FROM hash_values WHERE value IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); RD 111: read final block: 432 bytes RX 111: &5 0 15 3 15
RD 111: inserting prompt TD 111: write final block: 112 bytes TX 111: sexec 0(15829055, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); RD 112: read final block: 115 bytes RX 112: &1 3 0 2 0
RD 112: inserting prompt TD 113: write final block: 59 bytes TX 113: sPREPARE INSERT INTO hash_values (id, value) VALUES (?, ?); RD 113: read final block: 167 bytes RX 113: &5 1 2 3 2
RD 113: inserting prompt
|
|
|
|
|
TD 114: write final block: 58 bytes TX 114: sPREPARE INSERT INTO uri_values (id, value) VALUES (?, ?); RD 115: read final block: 169 bytes RX 115: &5 0 2 3 2
RD 115: inserting prompt |
|
|
|
|
|
|
|
|
TD 116: write final block: 112 bytes TX 116: sexec 0(15654331, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); RD 116: read final block: 115 bytes RX 116: &1 4 0 2 0
RD 116: inserting prompt TD 117: write final block: 59 bytes TX 117: sPREPARE INSERT INTO hash_values (id, value) VALUES (?, ?); RD 117: read final block: 167 bytes RX 117: &5 2 2 3 2
RD 117: inserting prompt |
|
|
|
|
TD 118: write final block: 58 bytes TX 118: sPREPARE INSERT INTO uri_values (id, value) VALUES (?, ?); RD 119: read final block: 169 bytes RX 119: &5 1 2 3 2
RD 119: inserting prompt |
|
|
|
|
|
|
|
|
TD 120: write final block: 113 bytes TX 120: sexec 0(157752235, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); RD 121: read final block: 115 bytes RX 121: &1 5 0 2 0
RD 121: inserting prompt TD 121: write final block: 59 bytes TX 121: sPREPARE INSERT INTO hash_values (id, value) VALUES (?, ?); RD 122: read final block: 167 bytes RX 122: &5 3 2 3 2
RD 122: inserting prompt
|
|
|
|
|
|
TD 123: write final block: 60 bytes TX 123: sPREPARE INSERT INTO label_values (id, value) VALUES (?, ?); RD 124: read final block: 169 bytes RX 124: &5 0 2 3 2
RD 124: inserting prompt
|
|
|
|
|
TD 125: write final block: 74 bytes TX 125: sPREPARE INSERT INTO namespace_prefixes (prefix, namespace) VALUES (?, ?); RD 126: read final block: 169 bytes RX 126: &5 2 2 3 2
RD 126: inserting prompt TD 126: write final block: 45 bytes TX 126: sexec 2(NULL, 'http://www.recshop.fake/cd#'); RD 127: read final block: 8 bytes RX 127: &2 1 -1
RD 127: inserting prompt TD 127: write final block: 10 bytes TX 127: Xrelease 2 RD 127: read final block: 0 bytes RX 127: RD 127: inserting prompt TD 128: write final block: 70 bytes TX 128: sPREPARE UPDATE namespace_prefixes SET prefix = ? WHERE namespace = ?; RD 129: read final block: 169 bytes RX 129: &5 3 2 3 2
RD 129: inserting prompt TD 129: write final block: 45 bytes TX 129: sexec 3('cd', 'http://www.recshop.fake/cd#'); RD 130: read final block: 8 bytes RX 130: &2 1 -1
RD 130: inserting prompt TD 130: write final block: 10 bytes TX 130: Xrelease 3 RD 130: read final block: 0 bytes RX 130: RD 130: inserting prompt TD 130: write final block: 74 bytes TX 130: sPREPARE INSERT INTO namespace_prefixes (prefix, namespace) VALUES (?, ?); RD 131: read final block: 169 bytes RX 131: &5 4 2 3 2
RD 131: inserting prompt TD 131: write final block: 61 bytes TX 131: sexec 4(NULL, 'http://www.w3.org/1999/02/22-rdf-syntax-ns#'); RD 132: read final block: 8 bytes RX 132: &2 1 -1
RD 132: inserting prompt TD 132: write final block: 10 bytes TX 132: Xrelease 4 RD 132: read final block: 0 bytes RX 132: RD 132: inserting prompt TD 133: write final block: 70 bytes TX 133: sPREPARE UPDATE namespace_prefixes SET prefix = ? WHERE namespace = ?; RD 133: read final block: 169 bytes RX 134: &5 5 2 3 2
RD 134: inserting prompt TD 134: write final block: 62 bytes TX 134: sexec 5('rdf', 'http://www.w3.org/1999/02/22-rdf-syntax-ns#'); RD 135: read final block: 8 bytes RX 135: &2 1 -1
RD 136: inserting prompt TD 136: write final block: 10 bytes TX 136: Xrelease 5 RD 136: read final block: 0 bytes RX 136: RD 136: inserting prompt TD 137: write final block: 224 bytes TX 137: sCREATE TABLE triples ( ctx INTEGER NOT NULL, subj INTEGER NOT NULL, pred INTEGER NOT NULL, obj INTEGER NOT NULL, expl BOOL NOT NULL, interval_start TIMESTAMP DEFAULT NULL, interval_end TIMESTAMP DEFAULT NULL ); RD 138: read final block: 3 bytes RX 138: &3
RD 138: inserting prompt TD 139: write final block: 49 bytes TX 139: sCREATE INDEX triples_pred_idx ON triples (pred); RD 140: read final block: 3 bytes RX 140: &3
RD 140: inserting prompt TD 140: write final block: 49 bytes TX 140: sCREATE INDEX triples_subj_idx ON triples (subj); RD 141: read final block: 3 bytes RX 141: &3
RD 141: inserting prompt TD 141: write final block: 47 bytes TX 141: sCREATE INDEX triples_ctx_idx ON triples (ctx); RD 142: read final block: 3 bytes RX 142: &3
RD 142: inserting prompt TD 142: write final block: 49 bytes TX 142: sCREATE INDEX triples_expl_idx ON triples (expl); RD 143: read final block: 3 bytes RX 143: &3
RD 143: inserting prompt |
|
|
|
|
|
|
|
|
|
|
TD 144: write final block: 15 bytes TX 144: Xreply_size 250 RD 145: read final block: 0 bytes RX 145: RD 145: inserting prompt TD 145: write final block: 81 bytes TX 145: sPREPARE INSERT INTO triples (ctx, subj, pred, obj, expl) VALUES (?, ?, ?, ?, ?); RD 146: read final block: 218 bytes RX 146: &5 0 5 3 5
RD 146: inserting prompt TD 146: write final block: 34 bytes TX 147: sexec 0(0, 1, 2, 805306369, true); RD 148: read final block: 8 bytes RX 148: &2 1 -1
RD 148: inserting prompt TD 148: write final block: 10 bytes TX 148: Xrelease 0 RD 148: read final block: 0 bytes RX 148: RD 148: inserting prompt |
|
|
|
|
|
TD 149: write final block: 31 bytes TX 149: sexec 1(1, 15829055); RD 150: read final block: 0 bytes RX 150: RD 150: inserting prompt TD 150: write final block: 10 bytes TX 150: Xrelease 1 RD 150: read final block: 0 bytes RX 150: RD 150: inserting prompt TD 150: write final block: 31 bytes TX 150: sexec 2(2, 15654331); RD 150: read final block: 0 bytes RX 150: RD 150: inserting prompt |
|
|
|
|
TD 151: write final block: 58 bytes TX 151: sexec 0(1, 'http://www.recshop.fake/cd/Empire_Burlesque'); RD 151: read final block: 0 bytes RX 151: RD 151: inserting prompt |
|
TD 151: write final block: 10 bytes TX 151: Xrelease 2 RD 151: read final block: 0 bytes RX 151: RD 151: inserting prompt TD 151: write final block: 40 bytes TX 151: sexec 3(805306369, 157752235); RD 151: read final block: 0 bytes RX 151: RD 151: inserting prompt TD 151: write final block: 10 bytes TX 151: Xrelease 3 RD 151: read final block: 0 bytes RX 151: RD 151: inserting prompt |
|
|
|
|
TD 152: write final block: 10 bytes TX 152: Xrelease 0 RD 152: read final block: 0 bytes RX 152: RD 152: inserting prompt TD 152: write final block: 48 bytes TX 152: sexec 1(2, 'http://www.recshop.fake/cd#artist'); RD 152: read final block: 0 bytes RX 152: RD 152: inserting prompt TD 152: write final block: 10 bytes TX 152: Xrelease 1 RD 152: read final block: 0 bytes RX 152: RD 152: inserting prompt |
TD 152: write final block: 32 bytes TX 152: sexec 0(805306369, 'Bob Dylan'); RD 152: read final block: 0 bytes RX 152: RD 152: inserting prompt TD 152: write final block: 10 bytes
|
|
|
|
|
|
|
TX 153: Xrelease 0 RD 153: read final block: 0 bytes RX 153: RD 153: inserting prompt |
TD 153: write final block: 10 bytes TX 153: Xrelease 0 RD 153: read final block: 0 bytes RX 153:
|
|
|
|
TD 154: write final block: 21 bytes TX 154: sDROP TABLE "locked"; RD 155: read final block: 3 bytes RX 155: &3
RD 155: inserting prompt |
|
|
RD 154: inserting prompt |
|
|
|
|
No inserts have been done into 'uri_values'. Should have been inserted: (1, 'http://www.recshop.fake/cd/Empire_Burlesque') (2, 'http://www.recshop.fake/cd#artist') |
No inserts have been done into 'label_values'. Should have been inserted: (805306369, 'Bob Dylan') |
No inserts have been done into 'hash_values'. Should have been inserted: (1, 15829055) (2, 15654331) (805306369, 157752235) |
|