partdml.out

来自「derby database source code.good for you.」· OUT 代码 · 共 658 行 · 第 1/4 页

OUT
658 行
字号
1234
Index Scan ResultSet for BASIC using index B4 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched=All	ij> update basic set ccharForBitData = ccharForBitData where cint = 11;1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B4 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched=All	ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME   |CDEC     |CINT       |CCHAR     ----------------------------------------------11  |11:11:11|1.10     |11         |11        22  |22:22:22|2.20     |22         |22        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1          -----------1          ij> update basic set cint = cint where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 1, 2, 4}ij> update basic set cchar = cchar where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B1 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched={0, 1, 2, 3}ij> update basic set ctime = ctime where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 2, 4}ij> update basic set cdec = cdec where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={3, 4}ij> update basic set ccharForBitData = ccharForBitData where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B1 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched={0, 1, 2, 3}ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME   |CDEC     |CINT       |CCHAR     ----------------------------------------------11  |11:11:11|1.10     |11         |11        22  |22:22:22|2.20     |22         |22        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1          -----------1          ij> autocommit off;ij> update basic set cdec = cint;12 rows inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 3}ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME   |CDEC     |CINT       |CCHAR     ----------------------------------------------11  |11:11:11|11.00    |11         |11        22  |22:22:22|22.00    |22         |22        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        33  |03:33:33|33.00    |33         |33        ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1          -----------1          ij> rollback;ij> update basic set cchar = cchar where cdec = 3.3 and ctime = TIME('03:33:33');10 rows inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 1, 2, 3, 4}ij> update basic set ctime = ctime, cchar = cchar, cint = cint, cdec = cdec, ccharForBitData = ccharForBitData;12 rows inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 1, 2, 3, 4}ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME   |CDEC     |CINT       |CCHAR     ----------------------------------------------11  |11:11:11|1.10     |11         |11        22  |22:22:22|2.20     |22         |22        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        33  |03:33:33|3.30     |33         |33        ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1          -----------1          ij> ---------------------------------------------------------------------------- deletes------------------------------------------------------------------------------ index scans--delete from basic where cchar = '22';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1                                                                                                                                                                                                       --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B1 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched=All	ij> rollback;ij> delete from basic where cint = 22;
1234

partdml.out - 源码说明

本页面展示了「derby database source code.good for you.」中的 partdml.out 源码文件，采用 OUT 编程语言编写，共 658 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与database相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?