DATE: 2024-05-06 MR#11334: [DBMR3773] [MANTIS1507] crash database after update version from 5.4.4 to 5.4.6 DATE: 2024-04-29 MR#11334: [DBMR3773] [MANTIS1507] crash database after update version from 5.4.4 to 5.4.6 DATE: 2024-04-26 MR#11334: [DBMR3773] [MANTIS1507] crash database after update version from 5.4.4 to 5.4.6 DATE: 2024-04-23 MR#11040: [DBM54] dbmaker support network msg log DATE: 2024-04-15 MR#11244: update statistics add mode option DATE: 2024-04-11 MR#11163: update 5.4.x grammar.sql JTOOL: MANTIS1505 search for ' AS ' instead DATE: 2024-04-09 MR#11310: [MANTIS1459] The system table sysschedule throws a datetime field overflow error DATE: 2024-04-08 MR#11329: [Mantis1502]support like case when syntax DATE: 2024-04-03 MR#11327: [DBM546] Failed to create stored procedure MR#11328: [DBM546]After loading the database, the view is missing DATE: 2024-03-28 MR#11127: cjson support encode_sort_keys DATE: 2024-03-27 MR#11326: [MANTIS1499] support FKCHK=2 to support self-reference FK/PK checking DATE: 2024-03-26 MR#11326: [MANTIS1499] support FKCHK=2 to support self-reference FK/PK checking DATE: 2024-03-25 MR#11326: [MANTIS1499] support FKCHK=2 to support self-reference FK/PK checking DATE: 2024-03-22 MR#10949: [MANTIS1028[ Support option to turn off foreign key check in current connection MR#11326: [MANTIS1499] support FKCHK=2 to support self-reference FK/PK checking DATE: 2024-03-21 MR#11325: did not return unique key violation error when update with sel-reference foriegn key JTOOL: MANTIS 1498 change comment's color DATE: 2024-03-19 MR#11325: did not return unique key violation error when update with sel-reference foriegn key DATE: 2024-03-14 MR#11322: When TDE is closed, view as select udf with encrypted column can select data DATE: 2024-03-13 MR#11322: When TDE is closed, view as select udf with encrypted column can select data JTOOL: MANTIS 1497 add 'static' to keywords DATE: 2024-03-11 MR#11318: [DBMR3747][MANTIS1487] Bug Shared Memory with databases name distincts MR#11323: Cannot show DB name with space character before [XXXXX] in dmconfig.ini DATE: 2024-03-08 MR#11241: support Transparent Data Encryption (TDE) MR#11318: [DBMR3747][MANTIS1487] Bug Shared Memory with databases name distincts MR#11322: When TDE is closed, view as select udf with encrypted column can select data MR#11323: Cannot show DB name with space character before [XXXXX] in dmconfig.ini MR#11324: [DBMR3755][MANTIS1490]0003755: INC5703: performance "count" with join SQL on unused tables (Vitor, Jhonata) DATE: 2024-03-07 MR#11318: [DBMR3747][MANTIS1487] Bug Shared Memory with databases name distincts MR#11324: [DBMR3755][MANTIS1490]0003755: INC5703: performance "count" with join SQL on unused tables (Vitor, Jhonata) JTOOL: TDE new icon image DATE: 2024-03-05 MR#11244: update statistics add mode option JTOOL: tde localization JTOOL: tde localization JTOOL: adjust password button size for jp localization. JTOOL: tde localization JTOOL: tde localization JTOOL: Open and Close localization JTOOL: tde localization close/open JTOOL: tde localization close/open DATE: 2024-03-01 MR#11309: [DBM546]when TDE is closed, execute command can select encrypted data DATE: 2024-02-27 MR#11321: [DBMR3756[[MANTIS1491]SQL performance of the first 100 records with "CASE" in the select using limit JTOOL: isIDCAP, set userName to upper case. JTOOL: enable/disable tde manager in initPrivilege DATE: 2024-02-26 MR#11307: [DBM546]Jsoncols type encryption incorrect JTOOL: [MANTIS 1483] https://dev.dbmaker.com.tw/mantisbt/view.php?id=1483 DATE: 2024-02-23 MR#11254: [Mantis1400]Support csvexport MR#11317: [DBM546]After data decryption, the view is unavailable MR#11318: [DBMR3747][MANTIS1487] Bug Shared Memory with databases name distincts MR#11319: [[DBMR3750] [MANTIS1486] use DCI_ENCRYPT in $XFD COMMENT to define encrypt column DATE: 2024-02-21 MR#11319: [[DBMR3750] [MANTIS1486] use DCI_ENCRYPT in $XFD COMMENT to define encrypt column DATE: 2024-02-19 MR#11319: [[DBMR3750] [MANTIS1486] use DCI_ENCRYPT in $XFD COMMENT to define encrypt column DATE: 2024-02-06 MR#11302: [DBM54] DBMaker support SQLUDF function DATE: 2024-01-26 MR#11241: support transparent data encryption MR#11311: [DBM54] add latch for SQLSP building MR#11315: select TABLE_NAME FROM SYSTABLEr eturn error 6104 DATE: 2024-01-22 MR#11312: Error(6576):invalid stored procedure,the error message is incomplete DATE: 2024-01-19 MR#11312: Error(6576):invalid stored procedure,the error message is incomplete MR#11313: execute select count(*) from union query may crash DATE: 2024-01-18 MR#11311: [DBM54] add latch for SQLSP building MR#11312: Error(6576):invalid stored procedure,the error message is incomplete JTOOL: display remarks (procedure type, esql/java/sql) DATE: 2024-01-17 MR#11241: support transparent data encryption MR#11310: The system table sysschedule throws a datetime field overflow error MR#11311: [DBM54] add latch for SQLSP building DATE: 2024-01-17 MR#11241: support transparent data encryption DATE: 2024-01-17 MR#11241: support transparent data encryption DATE: 2024-01-16 MR#11241: support transparent data encryption JTOOL: MANTIS 1470, check if create time = 1970, if so, set warning (different color cell) and suggest user to rebuild DATE: 2024-01-04 MR#11241: support transparent data encryption MR#11306: provide interface to get the total file size for some config keyword (ex: DBDIR) DATE: 2024-01-02 MR#11241: support transparent data encryption DATE: 2023-12-27 MR#11241: support transparent data encryption DATE: 2023-12-26 MR#11241: support transparent data encryption MR#11266: [DBMR3688][MANTIS1432] Add info for suggest rebuild index after update statistics DATE: 2023-12-25 MR#11305: [DBM54]The encrypted data associated with foreign keys can be displayed normally DATE: 2023-12-21 MR#11241: support transparent data encryption MR#11266: [DBMR3688][MANTIS1432] Add info for suggest rebuild index after update statistics DATE: 2023-12-20 MR#11302: [DBM54] DBMaker support SQLUDF function DATE: 2023-12-19 MR#11241: support transparent data encryption MR#11303: [MATIS 0001469] rollover get error "cannot start database : shared memory in use "/opt/dbmaker/backup/SP/dmSpBk.his" DATE: 2023-12-18 MR#11302: [DBM54] DBMaker support SQLUDF function DATE: 2023-12-14 MR#11241: support transparent data encryption DATE: 2023-12-13 MR#11241: support transparent data encryption DATE: 2023-12-07 MR#11241: support transparent data encryption DATE: 2023-12-06 MR#11241: support transparent data encryption DATE: 2023-12-05 MR#11241: support transparent data encryption MR#11301: PreparedStatement support batch DATE: 2023-12-04 MR#11241: support transparent data encryption DATE: 2023-11-29 MR#11241: support transparent data encryption DATE: 2023-11-24 MR#11241: support transparent data encryption MR#11299: [MANTIS1432]Modify the contents of dmevent.log to dmerror.log MR#11300: [DBMR3731][Mantis1468] Error when using the DCI_BLOB_GET directive DATE: 2023-11-23 MR#11241: support transparent data encryption DATE: 2023-11-22 MR#11286: [DBMR3707][MANTIS1449] Support extendts() stored procedure to extend tablespace MR#11297: type 4, sql command longer than 64k caused dmserver hang or crash MR#11299: [MANTIS1432]Modify the contents of dmevent.log to dmerror.log DATE: 2023-11-21 MR#11297: type 4, sql command longer than 64k caused dmserver hang or crash MR#11298: unload table will have problem when table constraint > 1024 bytes DATE: 2023-11-17 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2023-11-16 MR#11241: support transparent data encryption DATE: 2023-11-15 MR#11296: When importing data through ODBC,SQLGetData will increase by '00' DATE: 2023-11-14 MR#11295: [DBMR3729][Mantis1465] support DCI_COLUMNS_MAPPING for OPEN I-O or OPEN OUTPUT DATE: 2023-11-10 MR#11241: support transparent data encryption DATE: 2023-11-09 MR#11241: support transparent data encryption DATE: 2023-11-07 MR#11241: support transparent data encryption DATE: 2023-11-02 MR#11241: support transparent data encryption DATE: 2023-10-31 MR#11241: support transparent data encryption MR#11294: update subquery with trigger may get error ERR_RECORD_TOO_BIG (6137) DATE: 2023-10-25 MR#11293: [DBMR3641][MANTIS13292] check db need check bigserial DATE: 2023-10-24 MR#11279: [DBMR3696][mantis1439] Task Schedule - forces the execution of that task DATE: 2023-10-23 MR#11292: [DBM546]select tb1 except select tb2 with order by ,returned eresult is incorrect DATE: 2023-10-20 MR#11279: [DBMR3696][mantis1439] Task Schedule - forces the execution of that task DATE: 2023-10-19 MR#11279: [DBMR3696][mantis1439] Task Schedule - forces the execution of that task JTOOL: MANTIS 1462 clear output panel (close rs, release lock) DATE: 2023-10-17 MR#11241: support transparent data encryption JTOOL: mantis 1461, add PRODUCT_INFO and BUILD_VERSION JTOOL: add PRODUCT_INFO and BUILD_VERSION JTOOL: add PRODUCT_INFO and BUILD_VERSION DATE: 2023-10-16 MR#11291: [DBM546select blob type from tb1 except select blbo type from tb2,returned error messager is incorrect ] JTOOL: add db_sqlen,PRODUCT_INFO,BUILD_VERSION JTOOL: add db_sqlen,PRODUCT_INFO,BUILD_VERSION DATE: 2023-10-12 MR#11290: [DBMR3721][MANTIS1461] Add 0722 PRODUCT_INFO and 0723 BUILD_VERSION at SYSINFO DATE: 2023-10-11 MR#11244: update statistics add mode option MR#11290: [DBMR3721][MANTIS1461] Add 0722 BUILD_INFO and 0723 BUILD_VERSION at SYSINFO DATE: 2023-10-06 MR#11289: [DBMR3718][MANTIS1458] crash with left join and projection has subquery DATE: 2023-10-03 MR#11202: [MANTIS1345][DBMR3603] iscobol dci_set_where_constraint not removing filter - READ DATE: 2023-10-02 MR#11241: support transparent data encryption DATE: 2023-09-28 MR#11241: support transparent data encryption DATE: 2023-09-27 MR#11265: [Mantis1428]Support Except option in select statement MR#11280: [DBM546]EXPORT INTO data-file FROM (select jsoncols),causes dmsql32 crash DATE: 2023-09-26 MR#11279: [DBMR3696][mantis1439] Task Schedule - forces the execution of that task DATE: 2023-09-20 MR#11284: [MANTIS0001431]How to calculate journal consumption in a shrink process MR#11286: [DBMR3707][MANTIS1449] Support extendts() stored procedure to extend tablespace DATE: 2023-09-19 MR#11241: support transparent data encryption DATE: 2023-09-18 MR#11241: support transparent data encryption DATE: 2023-09-13 MR#11285: Support create/alter tablespace with logical_file='physical_file' syntax for setting at server's site's dmconfig.ini DATE: 2023-09-12 MR#11241: support transparent data encryption MR#11284: [MANTIS0001431]How to calculate journal consumption in a shrink process DATE: 2023-09-12 MR#11284: [MANTIS0001431]How to calculate journal consumption in a shrink process DATE: 2023-09-11 MR#11285: Support create/alter tablespace with logical_file='physical_file' syntax for setting at server's site's dmconfig.ini DATE: 2023-09-05 MR#11285: Support create/alter tablespace with logical_file='physical_file' syntax for setting at server's site's dmconfig.ini DATE: 2023-08-31 MR#11285: Support create/alter tablespace with logical_file='physical_file' syntax for setting at server's site's dmconfig.ini DATE: 2023-08-30 MR#11285: Support create/alter tablespace with logical_file='physical_file' syntax for setting at server's site's dmconfig.ini DATE: 2023-08-30 MR#11285: Support create/alter tablespace with logical_file='physical_file' syntax for setting at server's site's dmconfig.ini DATE: 2023-08-29 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2023-08-25 MR#11284: [MANTIS0001431]How to calculate journal consumption in a shrink process DATE: 2023-08-23 MR#11283: system internal error: syswait DATE: 2023-08-22 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11266: [DBMR3688][MANTIS1432] Add info for suggest rebuild index after update statistics MR#11278: [Mantis1442] support where (col1,col2) in ((val1,val2),(?,?)...) DATE: 2023-08-22 MR#11266: [DBMR3688][MANTIS1432] Add info for suggest rebuild index after update statistics MR#11278: [Mantis1442] support where (col1,col2) in ((val1,val2),(?,?)...) DATE: 2023-08-18 MR#11282: add log for progress info of check db in DMCHECK.LOG DATE: 2023-08-17 MR#11282: add log for progress info of check db in DMCHECK.LOG DATE: 2023-08-17 MR#11282: add log for progress info of check db in DMCHECK.LOG DATE: 2023-08-16 MR#11278: [Mantis1442] support where (col1,col2) in ((val1,val2),(?,?)...) DATE: 2023-08-16 MR#11278: [Mantis1442] support where (col1,col2) in ((val1,val2),(?,?)...) DATE: 2023-08-16 MR#11278: [Mantis1442] support where (col1,col2) in ((val1,val2),(?,?)...) DATE: 2023-08-16 MR#11278: [Mantis1442] support where (col1,col2) in ((val1,val2),(?,?)...) DATE: 2023-08-15 MR#11280: [DBM546]EXPORT INTO data-file FROM (select jsoncols),causes dmsql32 crash DATE: 2023-08-11 MR#11279: [DBMR3696][mantis1439] Task Schedule - forces the execution of that task MR#11280: [DBM546]EXPORT INTO data-file FROM (select jsoncols),causes dmsql32 crash DATE: 2023-08-10 MR#11072: JDBC driver exception using commons-configuration2-2.7 DATE: 2023-08-09 MR#11277: It may crash when alter table add constraint on delete cascade DATE: 2023-08-07 MR#11277: It may crash when alter table add constraint on delete cascade DATE: 2023-08-02 MR#11274: The casewhen query caused an internal error(error6104) DATE: 2023-08-01 MR#11275: jdbc type does not define in java.sql.Types :16 DATE: 2023-08-01 MR#11275: jdbc type does not define in java.sql.Types :16 DATE: 2023-07-31 MR#11265: [Mantis1428]Support Except option in select statement DATE: 2023-07-28 MR#11265: [Mantis1428]Support Except option in select statement DATE: 2023-07-28 MR#11265: [Mantis1428]Support Except option in select statement DATE: 2023-07-26 MR#11265: [Mantis1428]Support Except option in select statement DATE: 2023-07-26 MR#11265: [Mantis1428]Support Except option in select statement DATE: 2023-07-20 MR#11271: check db may get 3804 error when DB_INSPGCMP=-1 MR#11272: [DBM546] change DB_INSPGCMP default from -1 to 1 JTOOL: MR11143 add db_sqlen DATE: 2023-07-19 MR#11241: support transparent data encryption MR#11271: check db may get 3804 error when DB_INSPGCMP=-1 DATE: 2023-07-14 MR#11270: [DBMR3697] [MANTIS1438] Problems with dci_where_constraint DATE: 2023-07-13 MR#11241: support transparent data encryption DATE: 2023-07-10 MR#11244: update statistics add mode option MR#11268: [MANTIS1437] refine ERR_NO_AVAILABLE_DCB error message MR#11269: [MANTIS1436] fix unload view behavior when view contain -- comment DATE: 2023-07-10 MR#11244: update statistics add mode option DATE: 2023-07-04 MR#11267: [MANTIS1435] disable mantis1421 [DBMR3676]'s request for auto rebuild all invalid view DATE: 2023-06-30 MR#11241: support transparent data encryption MR#11256: [DBMR3676][MANTIS1421]create table cause alter view comile inite loop when view has variable DATE: 2023-06-28 MR#11228: [DBMR3644] [MANTIS1397] DCI support insert/rewrite system default MR#11241: support transparent data encryption DATE: 2023-06-26 MR#11266: [DBMR3688][MANTIS1432] Add info for suggest rebuild index after update statistics DATE: 2023-06-20 MR#11264: [Mantis1428] Support null=null is true DATE: 2023-06-15 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2023-06-14 MR#11086: unsupport operation -- prepareStatement(String sql, int autoGeneratedKeys) - manits1222 DATE: 2023-06-08 MR#11263: display IO_SERVER status at SYSUSER DATE: 2023-06-01 MR#11241: support transparent data encryption DATE: 2023-06-01 MR#11241: support transparent data encryption DATE: 2023-06-01 MR#11241: support transparent data encryption DATE: 2023-05-31 MR#11241: support transparent data encryption DATE: 2023-05-30 MR#11259: [DBM545]aggregation function last() reduce dmsql32 core dump DATE: 2023-05-26 MR#11258: [Mantis1416]Allow ORDER BY and LIMIT within UNION (Vitor) DATE: 2023-05-26 MR#11258: [Mantis1416]Allow ORDER BY and LIMIT within UNION (Vitor) DATE: 2023-05-25 MR#11241: support transparent data encryption DATE: 2023-05-24 MR#11142: Add new aggregation function DATE: 2023-05-23 MR#11241: support transparent data encryption MR#11258: [Mantis1416]Allow ORDER BY and LIMIT within UNION (Vitor) DATE: 2023-05-23 MR#11241: support transparent data encryption MR#11258: [Mantis1416]Allow ORDER BY and LIMIT within UNION (Vitor) DATE: 2023-05-22 MR#11259: [DBM545]aggregation function last() reduce dmsql32 core dump MR#11262: SETSYSTEMOPTIONW writes to dmconfig and should be saved as ANSI DATE: 2023-05-18 MR#11260: Chinese characters are garbled in jdbatool JTOOL: simplify parse bkdir string JTOOL: add comment DATE: 2023-05-17 MR#11260: Chinese characters are garbled in jdbatool MR#11261: [DBMR3682][MANTIS1425] [DCI] support XFD COMMENT DCI BIGINT DATE: 2023-05-04 MR#11257: [OMFLOW] reduce page IX lock when DB_INSPGCMP<=0 DATE: 2023-05-02 MR#11241: support transparent data encryption MR#11256: [DBMR3676][MANTIS1421]create table cause alter view comile inite loop when view has variable DATE: 2023-04-28 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11254: [Mantis1400]Support csvexport DATE: 2023-04-27 MR#11254: [Mantis1400]Support csvexport DATE: 2023-04-26 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11241: support transparent data encryption MR#11254: [Mantis1400]Support csvexport DATE: 2023-04-26 MR#11241: support transparent data encryption DATE: 2023-04-25 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11254: [Mantis1400]Support csvexport MR#11255: Host variable support negative value DATE: 2023-04-25 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11254: [Mantis1400]Support csvexport MR#11255: Host variable support negative value DATE: 2023-04-25 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11254: [Mantis1400]Support csvexport MR#11255: Host variable support negative value DATE: 2023-04-25 MR#11255: Host variable support negative value DATE: 2023-04-20 MR#11252: [DBMR3673][MANTIS1417] compresss SYSTABLESPACE when continuous space not enough when DB_INSPGCMP<=0 MR#11253: [DBMR3674] [MANTIS1419] do not compress page at slave site when DB_INSPGCMP=-1 DATE: 2023-04-14 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2023-04-12 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2023-04-11 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2023-04-10 MR#11249: [DBM545] "select ...case when..." return sql internal error DATE: 2023-04-07 MR#11241: support transparent data encryption DATE: 2023-04-07 MR#11241: support transparent data encryption DATE: 2023-03-31 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2023-03-30 MR#11244: update statistics add mode option DATE: 2023-03-29 MR#11242: [QA REGRESSION] create async replicate get internal error MR#11244: update statistics add mode option DATE: 2023-03-28 MR#11243: [QA REGRESSION] select case when may get internal error DATE: 2023-03-27 MR#11244: update statistics add mode option MR#11245: [QA REGRESSION] DB_DIFCO=0 and dmsqlc connect should not return error MR#11246: [DBMR3657]:[MANTIS1413] Problems with DCI when using columns of type serial DATE: 2023-03-27 MR#11244: update statistics add mode option MR#11245: [QA REGRESSION] DB_DIFCO=0 and dmsqlc connect should not return error MR#11246: [DBMR3657]:[MANTIS1413] Problems with DCI when using columns of type serial DATE: 2023-03-21 MR#11240: [MANTIS1411]udf parameter with in list cause internal error DATE: 2023-03-15 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2023-03-14 MR#11090: Support new system UDF and JSONMERGE function and ... JTOOL: refine journal status - seperate journal user panel JTOOL: refine journal status DATE: 2023-02-23 MR#11239: Add SERNO as first field of server log file DATE: 2023-02-22 MR#11229: rollback error when set invalid option DATE: 2023-02-18 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2023-02-17 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data MR#11238: [DBM545]select string_agg distinct reduce dmserver crash DATE: 2023-02-06 MR#11237: [MANTIS1405] DCI start/read/delete/rewrite should return error ERR_DISABLE_INDEX when index is disabled DATE: 2023-02-03 MR#11200: [MANTIS1312] support DBMaker DB replication with file object and stored procedure DATE: 2023-01-31 MR#11173: show incorrect code when set DB_CLILCODE to utf-8 in config file DATE: 2023-01-30 MR#11234: [MANTIS1400] dmSQL support EXPORT INTO data-file FROM (select statement) DATE: 2023-01-19 MR#11234: [MANTIS1400] dmSQL support EXPORT INTO data-file FROM (select statement) MR#11235: [DBMR3651] Error XFD COMMENT DCI_NULL_ON_SPACE_CHAR - Mantis1403 MR#11236: [DBMR3646] support EXPORT description_file option DISPLAY_NAME DATE: 2023-01-17 MR#11234: [MANTIS1400] dmSQL support EXPORT INTO data-file FROM (select statement) DATE: 2023-01-13 JTOOL: [MANTIS1400] only append .txt if there is no extension DATE: 2023-01-12 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11233: [dmjdbc] vc 2005 debug mode java.exe Accumulated damage DATE: 2023-01-06 MR#11231: [DBMR3647][MANTIS1401] delete/update record get 6104 error DATE: 2023-01-05 MR#11230: merge join then group by get wrong result DATE: 2022-12-27 MR#11226: [Manits1394] add CMD_DOCTOTEXT CMD_PPTTOTEXT AND CMD_XLSTOTEXT for replace doctotext DATE: 2022-12-21 MR#11226: [Manits1394] add CMD_DOCTOTEXT CMD_PPTTOTEXT AND CMD_XLSTOTEXT for replace doctotext DATE: 2022-12-20 MR#11228: [DBMR3644] [MANTIS1397] DCI support insert default DATE: 2022-12-16 MR#11228: [DBMR3644] [MANTIS1397] DCI support insert default DATE: 2022-12-15 MR#11228: [DBMR3644] [MANTIS1397] DCI support insert default DATE: 2022-12-13 MR#11226: [Manits1394] add CMD_DOCTOTEXT CMD_PPTTOTEXT AND CMD_XLSTOTEXT for replace doctotext MR#11227: [DBMR3643] Error with application COBOL using DCI after of task alter table to other tablespace-Mantis1395 DATE: 2022-12-02 MR#11225: left outer join with order by limit may get wrong result DATE: 2022-12-01 MR#11221: [DBMR3640] Is there DCI_TABLESPACE_IDX directive MR#11222: [Mantis1393]Problem when executing a group by with subselect in query DATE: 2022-12-01 MR#11221: [DBMR3640] Is there DCI_TABLESPACE_IDX directive MR#11222: [Mantis1393]Problem when executing a group by with subselect in query DATE: 2022-11-30 MR#11200: [MANTIS1312] support DBMaker DB replication with file object and stored procedure DATE: 2022-11-24 MR#11200: [MANTIS1312] support DBMaker DB replication with file object and stored procedure DATE: 2022-11-21 MR#11220: [DBMR3628] Include syntax to subselect with order by in SQL Analyze - mantis1378 DATE: 2022-11-21 MR#11220: [DBMR3628] Include syntax to subselect with order by in SQL Analyze - mantis1378 DATE: 2022-11-18 MR#11219: Mantis[1385]select row_number on view which has order by alias will cause ERROR (6523) DATE: 2022-11-17 MR#11219: Mantis[1385]select row_number on view which has order by alias will cause ERROR (6523) DATE: 2022-11-16 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11200: [MANTIS1312] support DBMaker DB replication with file object and stored procedure DATE: 2022-11-10 MR#11218: [Mantis1288] support case when subquery DATE: 2022-11-09 MR#11217: subquery has limit 1 offset 1 does not work DATE: 2022-11-07 MR#11216: dmserver show lock time-out message when shutdown db DATE: 2022-11-02 MR#11168: [MANTIS880] Change DB_INSPGCMP keyword default from 1 to -1 DATE: 2022-10-20 MR#11215: projection with subquery that has outer reference in subquery's projection will get invalid column error DATE: 2022-10-19 MR#11215: projection with subquery that has outer reference in subquery's projection will get invalid column error DATE: 2022-10-11 MR#11214: [MANTIS1375]Excute SQL cause ERROR(5002): data conversion overflow DATE: 2022-09-30 MR#11214: [MANTIS1375]Excute SQL cause ERROR(5002): data conversion overflow DATE: 2022-09-27 MR#11156: not exists subquery with outer reference may get wrong result DATE: 2022-09-07 MR#11194: [MANTIS1333] only allow dmsql and jtool for extra connection to dmserver by SYSADM when exceed user license DATE: 2022-09-02 MR#11213: show error msg "Warm start error 604 -> SQL internal error" when start db with DB_SMODE = 2 DATE: 2022-08-25 MR#11212: Doubts regarding Jetty HTTP Server from JDBC Type 3 (T.S08) DATE: 2022-08-17 MR#11204: [MANTIS1353]Migrate DB from 5.2 to 5.4, xxxJNL.tmp is over 10Gbyte when start DB with smode=1 MR#11211: [Mantis1361] call deftable() returns 0 tuple on Win2019 sever DATE: 2022-08-17 MR#11211: Mantis[1361] call deftable() returns 0 tuple on Win2019 sever DATE: 2022-08-16 MR#11211: Mantis[1361] call deftable() returns 0 tuple on Win2019 sever DATE: 2022-08-15 MR#11211: Mantis[1361] call deftable() returns 0 tuple on Win2019 sever DATE: 2022-08-15 MR#11211: Mantis[1361] call deftable() returns 0 tuple on Win2019 sever DATE: 2022-08-12 MR#11210: The Type 2 driver pstmt.clearparameters () throws an exception DATE: 2022-08-11 MR#10562: [mantis642] support limit in select projection with subquery DATE: 2022-08-10 MR#11204: Migrate DB from 5.2 to 5.4, xxxJNL.tmp is over 10Gbyte when start DB with smode=1 DATE: 2022-08-09 MR#11209: [MANTIS1353] migrate DB from 52 to 53 or 54 will lost SETSYSETMOPTIONW() procedure DATE: 2022-08-02 MR#11205: [DBMR3612] unexpected FS=46 (no current record) reading a multi-record FD-mantis1359 DATE: 2022-07-28 MR#11208: [mantis1352] Lock Graph repeatedly turned on and off, causing JDBA Tool to shut down DATE: 2022-07-27 MR#11204: Migrate DB from 5.2 to 5.4, xxxJNL.tmp is over 10Gbyte when start DB with smode=1 MR#11206: DBMR3609: INC5173 - BUG in jdba with TIMESTAMP data (TS07,TS08) MR#11207: mantis 1358:Add trace table problem JTOOL: No Json, JSon, json. Only JSON DATE: 2022-07-26 MR#11205: [DBMR3612] unexpected FS=46 (no current record) reading a multi-record FD-mantis1359 DATE: 2022-07-25 DATE: 2022-07-14 MR#11200: support DBMaker DB replication with file object and stored procedure DATE: 2022-07-13 MR#11200: support DBMaker DB replication with file object and stored procedure DATE: 2022-07-05 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2022-07-04 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2022-07-01 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2022-06-30 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2022-06-24 MR#11199: [MANTIS1337] Warm start error 11213 when start db DATE: 2022-06-21 MR#11202: [MANTIS1345][DBMR3603] iscobol dci_set_where_constraint not removing filter - READ DATE: 2022-06-20 MR#11202: [MANTIS1345][DBMR3603] iscobol dci_set_where_constraint not removing filter - READ DATE: 2022-06-16 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2022-06-10 MR#11063: [DBMR3434]SCHEDULE_SERVER START MR#11200: support DBMaker DB replication with file object and stored procedure DATE: 2022-06-09 MR#11194: [MANTIS1333] only allow dmsql and jtool for extra connection to dmserver by SYSADM when exceed user license MR#11199: [MANTIS1337] Warm start error 11213 when start db DATE: 2022-06-06 MR#11197: insert or replace into and create trigger may get random result DATE: 2022-06-02 MR#11197: insert or replace into and create trigger may get random result MR#11198: [MANTIS1341] refine error argument for DB_JNLSZ if specify wrong value DATE: 2022-06-01 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11196: it is no effect to set bkdir size when first run backup MR#11197: insert or replace into and create trigger may get random result DATE: 2022-05-30 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 MR#11194: only allow dmsql and jtool for extra connection to dmserver by SYSADM when exceed user license MR#11195: fix SHOWINDEX procedure for typo ORDINAL_POSITION JTOOL: MR11194 add SQL_DMTOOL_CONNECT_DB DATE: 2022-05-27 MR#11194: only allow dmsql and jtool for extra connection to dmserver by SYSADM when exceed user license DATE: 2022-05-26 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2022-05-19 DATE: 2022-05-17 MR#11189: [DBM545]select first()/last() function for date type ,return exception results DATE: 2022-05-16 MR#11189: [DBM545]select first()/last() function for date type ,return exception results DATE: 2022-05-11 MR#11192: [DBMR3593] [MANTIS1327] update statistics may get wrong statistics of index DATE: 2022-05-10 JTOOL: mantis 1325 remove extra space in the tab labels JTOOL: MANTIS 1328 close AsQueryPane's statement when dropping/removing AsQueryPane DATE: 2022-05-06 MR#11190: mantis 1325 jdba open jsvrmgr create db failed DATE: 2022-04-19 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11182: [DBM544]when insert into table,dmsql32 disappeared for no reason DATE: 2022-04-15 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2022-04-13 MR#11186: [MANTIS1322] import get 6006 error when import with many columns DATE: 2022-04-11 MR#11185: [DBMR3587] Documentation: HIDDEN directive not mentioned -Mantis1319 DATE: 2022-04-07 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11184: JDBC type 4 driver connection url parameters support lowercase format DATE: 2022-03-30 MR#11183: Create domain support system/on update/hidden column attribute DATE: 2022-03-29 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2022-03-25 MR#10989: [DBMR3329] [MANTIS1100] do not set null for not-null column when setting DCI_NULL_ON_ZERO_NUMBER=1 DATE: 2022-03-22 MR#11118: [DBMR3491][MANTIS1245] Fix autoClrProcInfo and restart function from service server DATE: 2022-03-21 MR#11181: [DB544]create async replication occur dmserver dump DATE: 2022-03-18 MR#11157: [DBMR3535] WHEN DIRECTIVE USING KEY FIELD - mantis1283 MR#11179: async table replication not allow different user/password DATE: 2022-03-14 MR#11168: [MANTIS880] Change DB_INSPGCMP keyword default from 1 to -1 DATE: 2022-03-10 MR#11168: [MANTIS880] Change DB_INSPGCMP keyword default from 1 to -1 DATE: 2022-03-07 MR#11179: async table replication not allow different user/password MR#11180: Mantis(1310):ERROR(6329): cannot use window function with aggregate/group by or subquery clause DATE: 2022-03-03 MR#11168: [MANTIS880] Change DB_INSPGCMP keyword default from 1 to -1 MR#11173: show incorrect code when set DB_CLILCODE to utf-8 in config file DATE: 2022-03-02 MR#11173: show incorrect code when set DB_CLILCODE to utf-8 in config file MR#11176: [DBM544]select changelog.txt chglist.txt gv makefile.log order by blob return 25350 DATE: 2022-03-01 MR#11178: set password to 16 byte in dmconfig.ini then dmsql32 will crash DATE: 2022-02-28 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11177: [DBM544]create trigger sql block(special trigger name) return error DATE: 2022-02-24 MR#11173: show incorrect code when set DB_CLILCODE to utf-8 in config file MR#11175: [MANTIS 1204] change create table fillfactor from 100 to 80 DATE: 2022-02-23 MR#11174: [DBM544] ANONYMOUS PROC : FOR , Return Error DATE: 2022-02-22 MR#11173: show incorrect code when set DB_CLILCODE to utf-8 in config file JTOOL: MANTIS1307 jsql, if sql command is not valid, throw error DATE: 2022-02-18 MR#11146: Refine treemap code MR#11172: dmserver may get out of memory when many connection connect/disconnect to U8 DB DATE: 2022-02-15 MR#11146: Refine treemap code DATE: 2022-02-10 MR#11168: [MANTIS880] Change DB_INSPGCMP keyword default from 1 to -1 MR#11169: show system internal error after run shrink command DATE: 2022-02-07 MR#11146: Refine treemap code MR#11167: [DBMR3567] creating a directive in DCI for Not Null in a certain column and this column not is a PK - mantis1303 DATE: 2022-01-28 MR#11164: select into with many long varchar column may get error "record size too big to store" MR#11166: Set var = select no exists table then get error6521 in sp DATE: 2022-01-26 MR#10789: [DBMR3080] NUM_ROW_LOCK_UPG changed even when setting DB_LETRP a big value DATE: 2022-01-25 MR#11161: [DBMR3559][MANTIS1299]INC4982: Errors occurs in stored procedure with data type INTEGER and SMALLINT. (T.S07, T.S08) DATE: 2022-01-24 MR#11146: Refine treemap code DATE: 2022-01-21 MR#11165: Compile msgpack error in Win32 DATE: 2022-01-19 MR#11164: select into with many long varchar column may get error "record size too big to store" DATE: 2022-01-13 MR#11163: update 5.4.3 grammar.sql DATE: 2022-01-12 MR#11111: DB_LCDEC=1 Error behavior MR#11131: [INTERNAL} add dump param info for odbc log DATE: 2022-01-10 MR#11162: Add grammar.sql for schedule daemon DATE: 2022-01-05 JTOOL: remove not utf8 characters in source code DATE: 2021-12-29 MR#11161: [DBMR3559][MANTIS1299]INC4982: Errors occurs in stored procedure with data type INTEGER and SMALLINT. (T.S07, T.S08) DATE: 2021-12-21 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-12-08 MR#11141: support full outer join DATE: 2021-12-02 MR#11160: dmsql32 dont show char in win11 DATE: 2021-11-30 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11102: Cannot know which column when get 'cannot insert NULL value on NON-NULL column' DATE: 2021-11-24 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-11-23 MR#11158: [DBM544]create table return error 5320 in single-user mode MR#11159: [DBMR3550] DCI interpret the FILL FACTOR IS 50% in SELECT of COBOL - mantis1294 DATE: 2021-11-22 MR#11142: Add new aggregation function DATE: 2021-11-19 MR#11157: [DBMR3535] WHEN DIRECTIVE USING KEY FIELD - mantis1283 DATE: 2021-11-17 MR#11141: support full outer join DATE: 2021-11-12 MR#11155: [DBMR3539] How to reference data type BIGSERIAL in FD - mantis1286 DATE: 2021-11-05 MR#11156: not exists subquery with outer reference may get wrong result DATE: 2021-11-02 MR#11155: [DBMR3539] How to reference data type BIGSERIAL in FD - mantis1286 DATE: 2021-10-29 MR#11154: Incorrect resultsert for timestamp DATE: 2021-10-27 MR#11153: DCI support CALL DCI_SETENV with DCI_COMMIT_COUNT DATE: 2021-10-26 MR#11151: [DBM544]select full join return internal error DATE: 2021-10-25 MR#11148: bigserial and alter table DATE: 2021-10-22 MR#11148: bigserial and alter table MR#11152: [DBMR3536] Service of task schedule (DMSCHSVR) is consuming license - mantis1284 DATE: 2021-10-20 MR#11149: rollover add param, dont copy file DATE: 2021-10-19 MR#11150: distributor daemon abonormal exit when cannot open ATRP.LOG DATE: 2021-10-18 MR#11149: rollover add param, dont copy file DATE: 2021-10-13 MR#11148: bigserial and alter table DATE: 2021-10-12 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-10-08 MR#11147: support outer join with subquery DATE: 2021-10-07 MR#11146: Refine treemap code DATE: 2021-09-30 MR#11142: Add new aggregation function MR#11144: disable PK ODBC SQLPrimaryKeys not return MR#11145: autoindex error for SECOND(timestamp) DATE: 2021-09-29 MR#11142: Add new aggregation function MR#11143: support config to set max sql statement length DATE: 2021-09-29 MR#11142: Add new aggregation function MR#11143: support config to set max sql statement length DATE: 2021-09-28 MR#11142: Add new aggregation function DATE: 2021-09-27 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11141: support full outer join DATE: 2021-09-27 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11141: support full outer join DATE: 2021-09-24 MR#11140: If lua mode in stored procedure contains odd quotes, set block delimiter will get error DATE: 2021-09-23 MR#11123: Add lua module luadbi and regression DATE: 2021-09-22 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2021-09-16 MR#11137: [DBMR3519] dmrestoretb tool not work when table name include schema -mantis1269 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2021-09-08 MR#11135: set bkful dont work JTOOL: ja_JP po DATE: 2021-09-06 MR#11134: use force index on multi-table view's error message MR#11137: [DBMR3519] dmrestoretb tool not work when table name include schema -mantis1269 JTOOL: lulu checkin ja_JP/zh_CN po DATE: 2021-09-02 MR#11123: Add lua module luadbi and regression DATE: 2021-09-01 JTOOL: fix and refine jp po DATE: 2021-08-31 MR#11123: Add lua module luadbi and regression MR#11133: [MANTIS1262] Support more limit in subquery MR#11136: [DBMR3518] Error with instruction insert by exec sql JDBC - mantis1268 DATE: 2021-08-30 MR#11123: Add lua module luadbi and regression JTOOL: MANTIS1102 remove space after column name+comma DATE: 2021-08-27 JTOOL: ququ suggests that disable button setEnable(false) if index is already in disable status DATE: 2021-08-27 MR#11133: [MANTIS1262] Support more limit in subquery JTOOL: ququ suggests that disable button setEnable(false) if index is already in disable status DATE: 2021-08-26 MR#11133: [MANTIS1262] Support more limit in subquery MR#11135: set bkful dont work JTOOL: disable/rebuild index all for table JTOOL: disable index all DATE: 2021-08-25 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11108: [DBMR3493][MANTIS1247] DCI get wrong result when open same table with different XFD and table schema DATE: 2021-08-24 MR#11133: [MANTIS1262] Support more limit in subquery JTOOL: lulu found sysinfo should be SYSINFO. Otherwise, it failed when IDCAP=1. JTOOL: lulu found refresh/delete connection buttons have no button border JTOOL: lulu found column name ID should be capital also DATE: 2021-08-20 MR#11124: [DBM544]disable primarykey causes an error statement for def table JTOOL: disable-->disabled, enable-->enabled (Tablespace->index panel) JTOOL: table header "Disable" --> "Disable_Status" DATE: 2021-08-19 MR#11123: Add lua module luadbi and regression MR#11128: [DBMR3510] This error occurs with trigger executing insert in column with data type CLOB and Long Varchar JTOOL: disable index message refined JTOOL: disable index message refined DATE: 2021-08-18 MR#11121: create table define clob column with default udf will get wrong default value MR#11123: Add lua module luadbi and regression DATE: 2021-08-17 MR#11123: Add lua module luadbi and regression JTOOL: refine disable index (according to lulu's email) 1{U+3001}{U+7D22}{U+5F15}{U+9700}{U+8981}100%{U+6574}{U+4E2A}panel {U+5305}{U+62EC}:Index > Index List Tables > Table > Index List {U+6240}{U+6709}treenode,{U+53EA}{U+6709}index {U+6CA1}{U+6709}100% {U+6574}{U+4E2A}panel 2{U+3001}Index > Index List Enabled {U+6CA1}{U+6709}{U+672C}{U+5730}{U+5316}({U+7B80}{U+4E2D},{U+7E41}{U+4E2D}{U+548C}{U+65E5}{U+6587}) {U+82F1}{U+6587}{U+663E}{U+793A}Enabled{U+662F}{U+6B63}{U+786E}{U+7684} DbFrame.frame.res.getString("Enable") {U+770B}{U+4E0A}{U+53BB}{U+662F}{U+6B63}{U+786E}{U+7684},{U+662F}{U+4E0D}{U+662F}{U+4E0E}{U+5176}{U+5B83}Enable{U+51B2}{U+7A81} 3{U+3001}rebuild index{U+540E},{U+6CA1}{U+6709}refresh list JTOOL: enabled/disabled localization DATE: 2021-08-16 JTOOL: import/export json, disable index DATE: 2021-08-13 MR#11132: Add lpeg and cjson module to utluainit JTOOL: [MANTIS 1148] disable index DATE: 2021-08-12 MR#11123: Add lua module luadbi and regression DATE: 2021-08-11 MR#11101: disable/rebuild index on table MR#11123: Add lua module luadbi and regression MR#11129: [DBMR3504] Errors occurs using multiple threads in JAVA Program with DBMaker DATE: 2021-08-10 MR#11128: [DBMR3510] This error occurs with trigger executing insert in column with data type CLOB and Long Varchar MR#11129: [DBMR3504] Errors occurs using multiple threads in JAVA Program with DBMaker MR#11132: Add lpeg and cjson module to utluainit DATE: 2021-08-10 MR#11128: [DBMR3510] This error occurs with trigger executing insert in column with data type CLOB and Long Varchar MR#11129: [DBMR3504] Errors occurs using multiple threads in JAVA Program with DBMaker MR#11132: Add lpeg and cjson module to utluainit DATE: 2021-08-09 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11101: disable/rebuild index on table MR#11121: create table define clob column with default udf will get wrong default value MR#11131: [INTERNAL} add dump param info for odbc log DATE: 2021-08-06 MR#11101: disable/rebuild index on table MR#11127: cjson support encode_sort_keys MR#11130: [MANTIS1263] Fix compile warning 9 and 11 DATE: 2021-08-05 MR#11127: cjson support encode_sort_keys MR#11129: [DBMR3504] Errors occurs using multiple threads in JAVA Program with DBMaker DATE: 2021-08-04 MR#11123: Add lua module luadbi and regression MR#11127: cjson support encode_sort_keys DATE: 2021-07-26 MR#11124: [DBM544]disable primarykey causes an error statement for def table DATE: 2021-07-23 MR#11103: [MANTIS1204] support order/group by blob column by only compare the first 256 bytes blob data DATE: 2021-07-16 MR#10542: [mantis688] ppc64le get ERR_BUF_INV_ECP when NBUFS > 4G MR#11101: disable/rebuild index on table MR#11123: Add lua module luadbi and regression DATE: 2021-07-15 MR#10542: [mantis688] ppc64le get ERR_BUF_INV_ECP when NBUFS > 4G DATE: 2021-07-05 MR#11118: [DBMR3491][1245] Fix autoClrProcInfo and restart function from service server DATE: 2021-07-02 MR#11122: alter table add nclob column give string, the nclob's data is wrong DATE: 2021-06-30 MR#11121: create table define clob column with default udf will get wrong default value DATE: 2021-06-28 MR#11118: [DBMR3491][1245] Fix autoClrProcInfo and restart function from service server DATE: 2021-06-25 MR#11103: [MANTIS1204] support order by blob column by only compare the first 256 bytes blob data DATE: 2021-06-24 MR#11120: [MANTIS1204] [DJANGO] modify PK column's type get 6257 error DATE: 2021-06-23 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-06-07 MR#11118: [DBMR3491][1245] Fix autoClrProcInfo and restart function from service server DATE: 2021-05-27 MR#11115: [django-dbmaker]Error6150 bulk_update set null DATE: 2021-05-25 MR#11114: Mark autoClrProcInfo temporarily DATE: 2021-05-21 MR#11113: [DBMR3491] dmservic.exe crash - Application Error 1000 - mantis1245 DATE: 2021-05-19 MR#11113: [DBMR3491] dmservic.exe crash - Application Error 1000 - mantis1245 DATE: 2021-05-12 MR#11112: ERROR (6515) add column default not null if not empty table DATE: 2021-05-10 MR#11101: disable/rebuild index on table MR#11109: [DBM544]run JAVA program get ERROR (6005) MR#11110: [DBM544]rebuild index reduce "core dump" or "internal error" MR#11111: DB_LCDEC=1 Error behavior DATE: 2021-05-06 MR#11108: [DBMR3493][MANTIS1247] DCI get wrong result when open same table with different XFD and table schema DATE: 2021-05-05 MR#11108: [DBMR3493][MANTIS1247] open same table with same table in two program should return error DATE: 2021-05-04 MR#11101: disable/rebuild index on table DATE: 2021-04-29 MR#11101: disable/rebuild index on table MR#11107: [DBMR3492] INC4672 - "connection already broken ou SQL internal error" DATE: 2021-04-27 MR#11099: [DBMR3469] SQL Server Linked Server can't update DBMaker tables - mantis1221 DATE: 2021-04-20 JTOOL: [MANTIS 1243] add header sorting to permission JTOOL: [MANTIS1228] JTools_lookfeel_2_new.docx DATE: 2021-04-19 MR#11101: disable/rebuild index on table MR#11106: SQLSVR2019 linked server with insert/update crash with oledb JTOOL: [MANTIS 1243] add header sorting to permission DATE: 2021-04-16 MR#11101: disable/rebuild index on table DATE: 2021-04-13 MR#11105: [DBMR3487] How to reduce the load of deleteing Record in 5.4.2 DATE: 2021-04-12 MR#11103: [MANTIS1204] support order by blob column by only compare the first 256 bytes blob data DATE: 2021-04-09 MR#11101: disable/rebuild index on table DATE: 2021-04-07 MR#11103: [MANTIS1204] support order by blob column by only compare the first 256 bytes blob data DATE: 2021-04-01 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11099: [DBMR3469] SQL Server Linked Server can't update DBMaker tables - mantis1221 JTOOL: MANTIS 1236 if there are spaces or newline before statement, parser error DATE: 2021-03-31 MR#11100: [Manis1240]Alias not work when use group by and order by DATE: 2021-03-30 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11098: [DBMR3481] [MANTIS1237] Error When condition "TRIGGER" with 1=1 MR#11099: [DBMR3469] SQL Server Linked Server can't update DBMaker tables - mantis1221 JTOOL: MANTIS1236 save all writes column names at first line JTOOL: code merge from v54rel DATE: 2021-03-25 MR#11097: cast as timestamp + union all cause error DATE: 2021-03-23 JTOOL: init look and feel DATE: 2021-03-22 MR#11095: clob and nclob support like DATE: 2021-03-17 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-03-15 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11094: dci for visual cobol2019 execute program failed by xfd wrong version number. JTOOL: [MANTIS 1228] Jconfiguration Tools adjustments for look and feel DATE: 2021-03-12 MR#11075: [DBM544] DBMaker SQL Procedure support exceed file limit and code refine. DATE: 2021-03-10 MR#11093: [DBM543]migration test,execute SC return"SQL internal error " DATE: 2021-03-09 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11092: auto index SCANLOG to large cause core dump DATE: 2021-03-05 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-03-04 MR#11090: Support new system UDF and JSONMERGE function and ... DATE: 2021-03-03 MR#11090: Support new system UDF and JSONMERGE function and ... MR#11091: schedule end time to unlimit DATE: 2021-02-26 MR#10919: Error(6104) Update set jsoncols or dynamic column = subquery MR#11035: [DBMR3393[[MANTIS1156] Error 6104 DDL in python odbc DATE: 2021-02-23 MR#11083: [DBM543]SQLSP return error JTOOL: MANTIS1125 properly display sql error DATE: 2021-02-19 MR#11083: [DBM543]SQLSP return error MR#11084: [DBM543]call XMLEXPORT cause dmserver core dump DATE: 2021-02-18 MR#11086: unsupport operation -- prepareStatement(String sql, int autoGeneratedKeys) - manits1222 MR#11087: [DBM54] new aggregate function FIRST/LAST. DATE: 2021-02-10 MR#11073: [DBM543]declare decimal variable,return error 5002 MR#11083: [DBM543]SQLSP return error DATE: 2021-02-08 MR#10987: [DBMR3323] [MANTIS1094] ISDCI get Runtime connection ID DATE: 2021-01-28 MR#11068: SQLNumResultCols returns -1 when SQLExecDirect rollback stmt MR#11073: [DBM543]declare decimal variable,return error 5002 MR#11081: [DBMR3462] DCI error passwd with last version - manits1215 DATE: 2021-01-27 MR#11073: [DBM543]declare decimal variable,return error 5002 MR#11075: [DBM544] DBMaker SQL Procedure support exceed file limit and code refine. DATE: 2021-01-26 MR#11073: [DBM543]declare decimal variable,return error 5002 MR#11080: Schedule Task cause core dump DATE: 2021-01-25 MR#11075: [DBM544] DBMaker SQL Procedure support exceed file limit and code refine. MR#11079: update table that has inline blob may return 20904 error DATE: 2021-01-20 MR#11078: [DBM543]import result is wrong DATE: 2021-01-19 MR#11078: [DBM543]import result is wrong DATE: 2021-01-15 MR#11075: [DBM544] DBMaker SQL Procedure support exceed file limit and code refine. DATE: 2021-01-08 MR#11071: execute sql with "select case when not" will crash JTOOL: properties file update (byte vs bit) DATE: 2021-01-06 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2021-01-05 MR#11069: clear sysinfo after start db DATE: 2020-12-28 MR#11063: [DBMR3434]SCHEDULE_SERVER START DATE: 2020-12-23 MR#11063: [DBMR3434]SCHEDULE_SERVER START DATE: 2020-12-17 MR#10949: [MANTIS1028[ Support option to turn off foreign key check in current connection DATE: 2020-12-14 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-12-10 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-12-03 MR#11044: enhance nested join cost DATE: 2020-12-02 MR#11044: enhance nested join cost DATE: 2020-12-01 MR#10978: [mantis1066] support SHOWDMLOG stored procedure MR#11060: [DBMR3405] remove space padding for varchar when alter table modify type CHAR to VARCHAR- mantis1197 DATE: 2020-11-30 MR#11062: Error Store Procedure,dmserver crash JTOOL: [mantis 1199] make it consistent with dmsql utudtbdef.c(check for bin_def_len first) DATE: 2020-11-27 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion MR#11060: [DBMR3405] remove space padding for varchar - mantis1197 MR#11061: fix db tool can not work DATE: 2020-11-24 MR#11060: [DBMR3405] remove space padding for varchar - mantis1197 DATE: 2020-11-18 MR#10987: [DBMR3323] [MANTIS1094] ISDCI get Runtime connection ID MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-11-13 MR#11056: [DBM543]sqlsp recursive error DATE: 2020-11-11 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion MR#11059: alter table with file column may cause unload or get file name with file column get error DATE: 2020-11-05 MR#11055: [DBMR3433] rollover show 'invalid datetime format' when set DB_RTIME - mantis1185 DATE: 2020-11-02 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-10-30 MR#11051: SSIS 0x80040E0C SQL Server 2016 import/export tools MR#11055: [DBMR3433] rollover show 'invalid datetime format' when set DB_RTIME - mantis1185 DATE: 2020-10-29 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-10-28 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion MR#11051: SSIS 0x80040E0C SQL Server 2016 import/export tools DATE: 2020-10-27 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-10-26 MR#11054: 全文檢索執行沒有回應 DATE: 2020-10-22 MR#11052: If DB_SvAdr length exceeds 32, Error 11206 will occur MR#11053: [DBMR3429]: Upgrade 32bit 5.3 to 6.4bit 5.4 for Microfocus and Visual Cobol JTOOL: MANTIS 1183 cstmt for call GETSYSTEMOPTION('lic_expiredate',?) should be properly closed DATE: 2020-10-21 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion MR#11051: SSIS 0x80040E0C SQL Server 2016 import/export tools DATE: 2020-10-20 MR#11044: enhance nested join cost DATE: 2020-10-13 MR#11035: [DBMR3393[[MANTIS1156] Error 6104 DDL in python odbc DATE: 2020-10-12 MR#11042: [DBMR3408]PROGRESS BAR / STATUS BAR MR#11044: enhance nested join cost MR#11049: [DBMR3423] export command doesn't find temporary tables - mantis1178 MR#11050: [MANTIS1177]Create windows service with custom service and display name DATE: 2020-10-12 MR#11042: [DBMR3408]PROGRESS BAR / STATUS BAR DATE: 2020-09-30 MR#10978: [mantis1066] support SHOWDMLOG stored procedure MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-09-29 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-09-28 MR#11044: enhance nested join cost DATE: 2020-09-25 MR#11044: enhance nested join cost DATE: 2020-09-24 MR#10978: [mantis1066] support SHOWDMLOG stored procedure DATE: 2020-09-23 MR#11017: [DBMR3350] [MANTIS1123] rename DMERROR/DMEVENT.LOG to OLD when file size exceed 100MB MR#11042: [DBMR3408]PROGRESS BAR / STATUS BAR DATE: 2020-09-21 MR#11040: [DBM54] dbmaker support network msg log DATE: 2020-09-18 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion MR#11048: Query cause ERROR (6104): SQL internal error -mantis1175 DATE: 2020-09-17 MR#11042: [DBMR3408]PROGRESS BAR / STATUS BAR MR#11047: [DBMR3418] Input Decimal value SQLSP JTOOL: [mantis 1173] 'select 44,44' would change 44,44 to 44 as integer JTOOL: [mantis 1173] make fix similar with mantis 1133 [MANTIS 1133] setObject need to specify type, otherwise type would be CHAR for String. It would be mismatched if real parameter type is date. DATE: 2020-09-15 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion MR#11046: [DBMR3412] function SOUNDEX(character_e xprtession) - mantis1167 DATE: 2020-09-14 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate functiion DATE: 2020-09-09 MR#11043: [DBMR3413] error 6104 on SQL QUERY - mantis1169 MR#11044: enhance nested join cost MR#11045: [DBMR3415] ERROR output parameter using iscobol/jdbc DATE: 2020-09-07 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate function DATE: 2020-09-04 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate function DATE: 2020-08-26 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate function JTOOL: mantis 1166, if yes to overwrite file, delete file first DATE: 2020-08-21 MR#11041: [DBM54] support lua script/UDF aggregate solution and new aggregate function DATE: 2020-08-14 MR#11040: [DBM54] dbmaker support network msg log DATE: 2020-08-12 MR#11040: [DBM54] dbmaker support network msg log DATE: 2020-08-06 MR#10945: auto index need more detail log DATE: 2020-08-05 MR#11038: [MANTIS1158] when crash in in shrink tablespace truncateonly may cause check db error DATE: 2020-07-30 MR#11037: BMODE setting DATE: 2020-07-29 MR#11036: force index support on one table view DATE: 2020-07-24 MR#11034: trigger support dynamic column MR#11036: force index support on one table view DATE: 2020-07-17 MR#11035: [DBMR3393[[MANTIS1156] Error 6104 DDL in python odbc DATE: 2020-07-10 MR#11034: trigger support dynamic column DATE: 2020-07-09 MR#10945: auto index need more detail log DATE: 2020-07-08 MR#11032: [DBMR3391][MANTIS1154] support LTIMO in odbc and jdbc connection string DATE: 2020-06-29 MR#10571: [DBM542?]stored procedure trigger action support edit NEW reference. MR#11029: [DBMR3388] wrong result reading blob value from java list MR#11030: [DBMR3386] COBOL DCI DELETE/START PROBLEM -Mantis1151 DATE: 2020-06-24 MR#10571: [DBM542?]stored procedure trigger action support edit NEW reference. MR#11021: [DBMR3377][MANTIS1142] dci returns wrong record when start is made on an PARTIAL date (just YEAR ) MR#11028: using Variable on INDEX sintax DATE: 2020-06-22 MR#11028: using Variable on INDEX sintax DATE: 2020-06-18 MR#10737: code review for jsoncols in sql layer MR#11027: [UBUS] select into with offset, limit will return wrong number of records DATE: 2020-06-17 MR#11024: if dynamic column default type length > DB_MAXTUPLEN, select dynamic into temtb will cause error DATE: 2020-06-16 MR#11021: [DBMR3377][MANTIS1142] dci returns wrong record when start is made on an PARTIAL date (just YEAR ) DATE: 2020-06-15 MR#10945: auto index need more detail log MR#11026: create view as select jsoncols union select jsoncols can not get dynamic column DATE: 2020-06-10 MR#11021: [DBMR3377][MANTIS1142] dci returns wrong record when start is made on an PARTIAL date (just YEAR ) MR#11025: select null union vartype type cause error(5328) DATE: 2020-06-05 MR#11022: [DBMR3363][MANTIS1130] itt tmp file cannot reuse DATE: 2020-06-04 MR#10976: [JSONCOLS] dynamic columns and JSONPath support rename object name MR#11020: differ backup crash MR#11023: [DBMR3368][MANTIS1135] DCI REWRITE may crash with ATR JTOOL: MANTIS 1138 add filter table DATE: 2020-06-03 MR#11021: [DBMR3377][MANTIS1142] dci returns wrong record when start is made on an PARTIAL date (just YEAR ) MR#11022: [DBMR3363][MANTIS1130] itt tmp file cannot reuse JTOOL: [MANTIS 1139] stay in the same tab panel when switching between 2 table info DATE: 2020-06-01 MR#10612: Cannot get SQL script of SCHEDULE for REPLICATION MR#11020: differ backup crash DATE: 2020-05-28 MR#11019: unload db schema or unload schema can not print definition of replication JTOOL: [MANTIS 1138] disable filter table menuitem if no filter set add clear button in FilterTableDlg DATE: 2020-05-27 JTOOL: [MANTIS 1138] add filter table DATE: 2020-05-22 MR#10737: code review for jsoncols in sql layer DATE: 2020-05-21 MR#11018: [DBMR3367][MANTIS1134] select return 0 rows when using BIGINT as variable DATE: 2020-05-20 MR#11017: [DBMR3350] [MANTIS1123] rename DMERROR/DMEVENT.LOG to OLD when file size exceed 100MB DATE: 2020-05-19 MR#10902: [DBMR3202] ERROR (6187) in slave side of DB replication env - mantis978 MR#10945: auto index need more detail log MR#11016: [MANTIS 1132] jdk 13/14 require newer hessian JTOOL: [mantis 1133] select 2020-01-01 will change date string to integer type (ParameterObject). so, for date/time/timestamp, if ParameterObject is integer, use setString widh inParameter instead. DATE: 2020-05-18 MR#10993: change default max hard connection to 4800 DATE: 2020-05-15 MR#11014: 5.4.3 get wrong query result and 5.4.2 is correct MR#11015: [MANTIS1135] out of memory problem DATE: 2020-05-14 MR#10902: [DBMR3202] ERROR (6187) in slave side of DB replication env - mantis978 MR#10972: [NET] refine net connection code and modify error msg MR#11014: 5.4.3 get wrong query result and 5.4.2 is correct MR#11015: [MANTIS1135] out of memory problem JTOOL: [MANTIS 1133] setObject need to specify type, otherwise type would be CHAR for String. It would be mismatched if real parameter type is date. DATE: 2020-05-13 MR#10945: auto index need more detail log MR#11014: 5.4.3 get wrong query result and 5.4.2 is correct DATE: 2020-05-09 MR#11004: [dbm543]dmSQL>call sqlsp return error(use circle cursor to recursive _sqlsp) DATE: 2020-05-08 MR#11013: [mantis1132[ add debug print if dmjdbct3.properties debug=true DATE: 2020-05-07 MR#11012: alter table move tablespace can not load hidden column's data DATE: 2020-04-30 MR#10945: auto index need more detail log MR#11007: Insert varchar with string including ' ' will be incorrectly. MR#11009: Install both 32bit and 64bit OleDb DATE: 2020-04-29 MR#11009: Install both 32bit and 64bit OleDb DATE: 2020-04-23 MR#10953: [DBMR3261] DCI - file status 46 not returned, read next after invalid start is successful - mantis1033 DATE: 2020-04-22 MR#11004: [dbm543]dmSQL>call sqlsp return error(use circle cursor to recursive _sqlsp) MR#11008: [DBM543]delete from table return error 8073( lua api function error ) DATE: 2020-04-20 MR#11006: JDBC returned null when using QueryRunner to get tablename.column in select projection. DATE: 2020-04-17 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#10945: auto index need more detail log DATE: 2020-04-15 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#11003: [DBMR3353][MANTIS1125] support DCI_USER_TABLESPACE to specify tablespace for create table for user/schema DATE: 2020-04-14 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#10945: auto index need more detail log DATE: 2020-04-09 MR#11002: [DBMR3349][MANTIS1122] isdci DCI_SET_WHERE_CONSTRAINT does not remove filter for READ statement DATE: 2020-04-03 MR#11001: [Mantis1112]sql server 2017 import with oledb provider DATE: 2020-03-31 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#10999: [Mantis1112] sql server 2017 import data from DBMaker, char/varchar can not transfered correctly MR#11000: [DBM543]call sqlsp, cause DB crash somtimes DATE: 2020-03-30 MR#10998: JDBC Driver Error: [DBMaker] this data type does not define in java.sql.Types :99 DATE: 2020-03-24 MR#10996: export from xml causes java crash DATE: 2020-03-20 JTOOL: [MANTIS1111] newer version of xerces and xalan org.apache.xalan.xsltc.runtime.DefaultSAXOutputHandle no longer exists DATE: 2020-03-19 MR#10994: [MANTIS1111] migrate to java 9 JTOOL: [MANTIS1111] newer version of xerces and xalan org.apache.xalan.xsltc.runtime.DefaultSAXOutputHandle no longer exists DATE: 2020-03-13 MR#10945: auto index need more detail log DATE: 2020-03-12 MR#10993: change default max hard connection to 4800 DATE: 2020-03-10 JTOOL: [mantis1102] db_lcdec + default locale decimal point is comma. use comma as decimal point use semicolon as column delimeter DATE: 2020-03-09 MR#10992: [DBMR3337][MANTIS1106] DCI_NULL_ON_ZERO_NUMBER decimal values DATE: 2020-03-06 JTOOL: [mantis 1098] the original jj file was lost. So, rewrite it from scratch. DATE: 2020-03-05 MR#10923: [DBMR3153] can't connect to DBMaker via OLEDB using Microsoft SQL Server's Linked Server MR#10960: [DBM543]If the table name contains a special symbol, the DMRestoreTB command is not executed successfully MR#10991: [DBM543]nest calling sql sp return error 6575 DATE: 2020-03-03 MR#10945: auto index need more detail log MR#10988: [DBMR3330][MANTIS1101] Veryant - internal error during query MR#10989: [DBMR3329] [MANTIS1100] do not set null for not-null column when setting DCI_NULL_ON_ZERO_NUMBER=1 MR#10990: [DBMR3321][MANTIS1093] support temporary table for ISCOBOL DCI DATE: 2020-02-27 MR#10987: [DBMR3323] [MANTIS1094] ISDCI get Runtime connection ID DATE: 2020-02-24 MR#10953: [DBMR3261] DCI - file status 46 not returned, read next after invalid start is successful - mantis1033 DATE: 2020-02-20 MR#10986: [DBMR3316][MANTIS1087] create or replace view for other user get unique key violation DATE: 2020-02-19 MR#10970: [DBMR3284] Users not registered - mantis1057 DATE: 2020-02-18 MR#10847: global table support create auto async index MR#10945: auto index need more detail log DATE: 2020-02-17 MR#10975: [Mantis1074] duplicated data when get clob data with toString in C# AP DATE: 2020-02-07 MR#10982: [mantis1086] PreparedStatement didn't use tuned code DATE: 2020-01-30 MR#10978: [mantis1066] support SHOWDMLOG stored procedure DATE: 2020-01-23 MR#10955: Refine code for oledb source DATE: 2020-01-22 MR#10981: [DBMR3306] UNLOAD process speed - mantis1082 DATE: 2020-01-21 MR#10955: Refine code for oledb source JTOOL: MANTIS1078 backup shows all db (not only local host), rollback previously update #006 DATE: 2020-01-20 MR#10976: [JSONCOLS] dynamic columns and JSONPath support rename object name JTOOL: MANTIS1078 only show local host dbname or bksvr=1 DATE: 2020-01-19 MR#10976: [JSONCOLS] dynamic columns and JSONPath support rename object name DATE: 2020-01-17 MR#10955: Refine code for oledb source MR#10962: support add or remove slave addr runtime MR#10976: [JSONCOLS] dynamic columns and JSONPath support rename object name DATE: 2020-01-16 MR#10955: Refine code for oledb source DATE: 2020-01-14 JTOOL: [MANTIS1078] only show local host dbname DATE: 2020-01-13 MR#10980: contain column at different table cause internal error JTOOL: [MANTIS 1080]In jtools sql query, insert and update are executed twice DATE: 2020-01-10 MR#10979: [mantis1066] refine mail content when DMERROR.LOG have new message MR#10980: contain column at different table cause internal error DATE: 2020-01-09 MR#10976: [JSONCOLS] dynamic columns and JSONPath support rename object name MR#10978: [mantis1066] support SHOWDMLOG stored procedure DATE: 2020-01-08 MR#10976: [JSONCOLS] dynamic columns and JSONPath support rename object name DATE: 2020-01-07 JTOOL: [mantis 1076] conn.rollback would cause rs.close exception (object closed) DATE: 2020-01-03 MR#10945: auto index need more detail log MR#10975: [Mantis1074] duplicated data when get clob data with toString in C# AP DATE: 2019-12-30 MR#10958: enhance rollover DATE: 2019-12-27 JTOOL: [MANTIS1064] disable modify, drop if owner is SYSTEM DATE: 2019-12-25 MR#10972: [NET] refine net connection code and modify error msg DATE: 2019-12-23 MR#10974: [DBMR3304] XML COLUMNS in COBOL READ -mantis1072 DATE: 2019-12-20 MR#10972: [NET] refine net connection code and modify error msg DATE: 2019-12-19 MR#10974: [DBMR3304] XML COLUMNS in COBOL READ -mantis1072 DATE: 2019-12-18 MR#10945: auto index need more detail log DATE: 2019-12-10 MR#10953: [DBMR3261] DCI - file status 46 not returned, read next after invalid start is successful - mantis1033 MR#10958: enhance rollover DATE: 2019-12-09 MR#10955: Refine code for oledb source MR#10958: enhance rollover DATE: 2019-12-06 MR#10888: [DBM54] dynamic column JSONPATH phase II DATE: 2019-12-05 MR#10945: auto index need more detail log JTOOL: [mantis 1065]set "" to precision if jsoncols selected DATE: 2019-12-04 MR#10973: [DBMR3295] Query Getting into a infinite looping - mantis1062 DATE: 2019-12-03 JTOOL: [mantis 1059] keep multiple database/user/pwd in xml DATE: 2019-12-02 JTOOL: [mantis1066] set test button enable/disable after init all components DATE: 2019-11-29 MR#10938: [MANTIS938] create view that has CV should not check whether CV exist MR#10955: Refine code for oledb source JTOOL: [mantis 1068] public Class getColumnClass(int c) cannot be omitted. otherwise, JTable would fail to find proper cell editor DATE: 2019-11-28 MR#10938: [MANTIS938] create view that has CV should not check whether CV exist MR#10972: [NET] refine net connection code and modify error msg JTOOL: [mantis 1066] db_ermrv need use MSTR_TYP retrieve from dmconfig.ini, but it shows as char field DATE: 2019-11-27 JTOOL: [mantis1064] since a new page (dependency graph) was added to tableinfo, index order was different DATE: 2019-11-26 MR#10960: [DBM543]If the table name contains a special symbol, the DMRestoreTB command is not executed successfully MR#10970: [DBMR3284] Users not registered - mantis1057 MR#10971: [MANTIS1062] support insert/load date string '****-**-**' DATE: 2019-11-22 MR#10969: [DBMR3289][MANTIS844] ERROR (6539) when ALTER VIEW DATE: 2019-11-21 MR#10969: [DBMR3289][MANTIS844] ERROR (6539) when ALTER VIEW DATE: 2019-11-20 MR#10968: [dbm543]unload table with no index as newtb,.s0 filename is wrong DATE: 2019-11-19 MR#10967: [dbm543]load table with dynamic column failed DATE: 2019-11-18 MR#10958: enhance rollover JTOOL: lulu found QueryFrame.java line 239 asOneSqlCheckbox.setToolTipText() {U+6CA1}{U+6709}localization JTOOL: lulu found AsShowPlanPane.java LIne69 ToolBarButton saveAsImage = new ToolBarButton("/images/save.png", "save as img"); need localization JTOOL: mantis991 import/export localization JTOOL: lulu updated po JTOOL: [MANTIS991] checkin popupmenuitem for import/export table JTOOL: miss localizing a few text DATE: 2019-11-15 MR#10965: [DBMR3287] Error 6105 on query - mantis1056 MR#10966: in list values is UDF cause core dump JTOOL: [MANTIS991] jdba export table JTOOL: [MANTIS991] jsql show plan requires localization DATE: 2019-11-14 MR#10888: [DBM54] dynamic column JSONPATH phase II DATE: 2019-11-12 MR#10964: [DBMR3282] Return status code Iscobol - mantis1052 DATE: 2019-11-08 JTOOL: [mantis991] export import table DATE: 2019-11-05 MR#10962: support add or remove slave addr runtime JTOOL: [MANTIS991] export table JTOOL: [MANTIS991] export table is not ready yet DATE: 2019-11-01 MR#10963: [DBMR3281] UPPER fuction not working for accented letters - mantis1051 DATE: 2019-10-31 MR#10962: support add or remove slave addr runtime JTOOL: lulu said QA{U+5728}{U+6D4B}{U+8BD5}JTOOLS,{U+89C9}{U+5F97}right-click{U+7684}{U+529F}{U+80FD}{U+4E0D}{U+5B8C}{U+6574},{U+662F}{U+5426}{U+53EF}{U+4EE5}{U+6682}{U+4E14}{U+4E0D}{U+663E}{U+793A}{U+65B0}{U+589E}{U+53F3}{U+952E}{U+529F}{U+80FD} {U+53EA}{U+662F}{U+53F3}{U+952E}{U+4E0D}{U+663E}{U+793A}{U+65B0}{U+7684}{U+529F}{U+80FD}{U+5373}{U+53EF},{U+4E0D}{U+9700}{U+8981}roolback DATE: 2019-10-30 MR#10961: [Laravel] fail to test with default DATE: 2019-10-28 JTOOL: DBAB2184 read user/password from jsyscom_dbmaker.xml, if not exists, read from dmconfig.ini DATE: 2019-10-24 MR#10957: [Lua UDF] refine error exception and show detail error infomation for users. DATE: 2019-10-23 JTOOL: [MANTIS991] delete from table, duplicate table, copy table, def table, rename table DATE: 2019-10-22 JTOOL: [MANTIS972] nimbus requires jdk 1.7, saturn has no jdk 1.7, debian jdk 1.3 is broken. therefore, stop building dmjdbc20.jar and dmjdbc20xa.jar. mkdmjar on debian DATE: 2019-10-21 MR#10959: [DBMR3279] TRIM NOT WORKING IN TRIGGER - mantis1048 DATE: 2019-10-18 MR#10945: auto index need more detail log JTOOL: [mantis1046] replace ok.gif DATE: 2019-10-17 MR#10945: auto index need more detail log JTOOL: [MANTIS969] http://172.16.220.116/mantisbt/view.php?id=969#c12227 no \n, but jeditorpane has line wrapped. comment line should be continued. DATE: 2019-10-12 MR#10957: [Lua UDF] refine error exception and show detail error infomation for users. DATE: 2019-10-02 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 DATE: 2019-10-01 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 DATE: 2019-09-27 MR#10957: [Lua UDF] refine error exception and show detail error infomation for users. DATE: 2019-09-26 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 MR#10958: enhance rollover DATE: 2019-09-25 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 DATE: 2019-09-20 MR#10804: [mantis 892] support runtime setting bmode MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 MR#10916: refeine auto index name when expression columns MR#10955: Refine code for oledb source DATE: 2019-09-19 MR#10947: check RP_PRIMY's ip with getsockname DATE: 2019-09-18 MR#10923: [DBMR3153] can't connect to DBMaker via OLEDB using Microsoft SQL Server's Linked Server DATE: 2019-09-17 MR#10109: support Filtered Indexes MR#10942: call sqlsp cause hang up DATE: 2019-09-16 MR#10923: [DBMR3153] can't connect to DBMaker via OLEDB using Microsoft SQL Server's Linked Server MR#10945: auto index need more detail log MR#10953: [DBMR3261] DCI - file status 46 not returned, read next after invalid start is successful - mantis1033 JTOOL: MR10952 in case, user tried to input 2 G, gui would update to 200 G JTOOL: MR10952 lulu suggested {U+628A}{U+8FD9}{U+4E2A}{U+4E5F}{U+53BB}{U+6389}{U+5427}, result = JNLSZ_DEFAULT_INT * dbPageSize / 1024; {U+4FEE}{U+6539}{U+4E3A}result = 1; DATE: 2019-09-09 MR#10949: [MANTIS1028[ Support option to turn off foreign key check in current connection DATE: 2019-09-06 MR#10950: LingAn MIS DB Crash caused by a query SQL MR#10951: Don't show NO FULL BK warnning when restoring db DATE: 2019-09-05 MR#10926: sql server 2016 can not fetch data from odbc MR#10945: auto index need more detail log MR#10949: [MANTIS1028[ Support option to turn off foreign key check in current connection DATE: 2019-09-04 MR#10949: [MANTIS1028[ Support option to turn off foreign key check in current connection DATE: 2019-09-02 MR#10945: auto index need more detail log MR#10949: [MANTIS1028[ Support option to turn off foreign key check in current connection DATE: 2019-08-30 MR#10945: auto index need more detail log MR#10947: check RP_PRIMY's ip with getsockname DATE: 2019-08-29 MR#10919: Error(6104) Update set jsoncols or dynamic column = subquery DATE: 2019-08-28 MR#10919: Error(6104) Update set jsoncols or dynamic column = subquery MR#10944: SELECT INTO make inline blob to indirect blob MR#10948: support caching user data DATE: 2019-08-27 MR#10944: SELECT INTO make inline blob to indirect blob MR#10945: auto index need more detail log MR#10946: PreparedStatement redirect setString(1,null) to setNull(1, Types.XX); MR#10947: check RP_PRIMY's ip with getsockname DATE: 2019-08-26 MR#10944: SELECT INTO make inline blob to indirect blob DATE: 2019-08-23 MR#10944: SELECT INTO make inline blob to indirect blob DATE: 2019-08-22 MR#10944: SELECT INTO make inline blob to indirect blob MR#10945: auto index need more detail log DATE: 2019-08-21 MR#10864: [UBUS] return 1502 error when setting RP_SLADR and next line is comment MR#10943: lcode utf-8 db + clob column + getAsciiStream should convert u8 to locale encoding DATE: 2019-08-20 JTOOL: [MANTIS941] http://172.16.220.116/mantisbt/view.php?id=941#c12080 it works, but when we choose Schema we need click two times to show schema names besides this the option "import from odbc" on linux the name is cut ``` JTOOL: [MANTIS941] {U+80FD}{U+5426}{U+4FEE}{U+6539}{U+4E3A} click{U+540E}{U+81EA}{U+52A8}{U+5C55}{U+5F00}schema list,{U+7136}{U+540E}{U+624D}{U+9009}{U+62E9}{U+9700}{U+8981}{U+7684}schema JTOOL: [MANTIS941]lulu said destination database{U+662F}{U+5426}{U+80FD}{U+4FEE}{U+6B63}{U+4E3A}{U+4E00}{U+81F4}{U+7684}{U+884C}{U+4E3A}{U+3002} JTOOL: [MANTIS941] add schema: DATE: 2019-08-15 MR#10900: [MANTIS964] dmrestoretb tool support restore table to target_table DATE: 2019-08-14 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#10900: [MANTIS964] dmrestoretb tool support restore table to target_table DATE: 2019-08-13 MR#10888: [DBM54] dynamic column JSONPATH phase II DATE: 2019-08-12 JTOOL: [MANTIS941] linux not just get datasource name, but also need driver description. otherwise, there is no way to know the db brand JTOOL: [MANTIS941] try not to use anonymous class (compile error) DATE: 2019-08-09 MR#10858: [DBM60] lua module scope with C api JTOOL: [MANTIS941] linux+mysql neither getCatalogs nor getSchemas could get schema information http://172.16.220.116/mantisbt/view.php?id=941#c12075 lulu suggested use String schemaStr = "SELECT " + "SCHEMA_NAME AS TABLE_SCHEM," + "CATALOG_NAME AS TABLE_CATALOG " + "FROM INFORMATION_SCHEMA.SCHEMATA " + "WHERE SCHEMA_NAME NOT IN('mysql','information_schema','performance_schema')"; DATE: 2019-08-08 JTOOL: [MANTIS941] match dest schema with dtio.owner JTOOL: [MANTIS941]lulu suggested {U+53EF}{U+4EE5}{U+589E}{U+52A0}{U+652F}{U+6301}MariaDB DATE: 2019-08-07 MR#10941: [Mantis1004]SQL internal error [cgutil.c 207] JTOOL: [MANTIS941] after create fk, dlg should dispose() instead of setVisible(false) JTOOL: [MANTIS941] lulu said {U+7B2C}{U+4E00}{U+6B21}{U+7528}sysadm import OK {U+7B2C}{U+4E8C}{U+6B21}{U+7528}new schema import ,{U+8FD9}{U+6837}destination {U+9875}{U+65F6}{U+603B}{U+662F}{U+7B2C}{U+4E00}{U+6B21}{U+5B58}{U+5728}{U+7684}table,{U+4E0D}{U+80FD}{U+4FEE}{U+6539}schema,{U+4E0D}{U+5408}{U+7406} {U+6240}{U+4EE5}match {U+8981}{U+540C}{U+6642} new schema+tbname,{U+5176}{U+4ED6}{U+4E0D}{U+5E6B}{U+5FD9} DATE: 2019-08-06 JTOOL: [MANTIS941] create fk, needs to use destination schema for pk schema, which has been just created in previous step. if no schema selected in DestinationDB page, use login user as selected destination schema. JTOOL: [MANTIS941] if source = MySQL, getSchemas empty then getCatalogs JTOOL: [MANTIS941] mouse click to reload schemaCombo only if datasource or username has been changed. JTOOL: [MANTIS941] mouse click to reload schemaCombo only if datasource or username has been changed. (DestinationDB) DATE: 2019-08-05 MR#10940: [DBMR3240] DCI_CACHE_NEXT - mantis1015 JTOOL: [MANTIS941] fix - schemaCombo should get schema from destination db JTOOL: [MANTIS941] add mouse listener to all components of schemaCombo DATE: 2019-08-02 MR#10938: [MANTIS938] create view that has CV should not check whether CV exist JTOOL: [MANTIS941] for both source and destination db, user needs to specify schema/user. DATE: 2019-08-01 MR#10939: [DBMR3248] Select view in SQL Query cause ACCESS VIOLATION - mantis1026 DATE: 2019-07-31 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 MR#10927: [DBM54]jsoncols support user alter max jsonb size. MR#10934: ITC error when converting nchar to int MR#10935: [DBM543]unload table to target table with no index syntax,return error MR#10936: [DBMR3247] unload table error ( foreign keys) MR#10937: select distinct with systable get errof if execute by connect user JTOOL: [MANTIS941] http://172.16.220.116/mantisbt/view.php?id=941#c12050 duplicate foreign key names JTOOL: [MANTIS941] ququ suggested tablename{U+589E}{U+52A0}columnName{U+4FE1}{U+606F} JTOOL: [MANTIS941] sql server metadata resultset must be retrieved in order. rs.getString(1) rs.getString(2) rs.getString(3) ... DATE: 2019-07-30 MR#10927: [DBM54]jsoncols support user alter max jsonb size. MR#10935: [DBM543]unload table to target table with no index syntax,return error DATE: 2019-07-29 JTOOL: [MANTIS 941] sql server would throw exception if more than one statement is created. unless set connection option MARS_CONNECTION=YES. in ColumnMapTransfer, getColumns getAutoIncrement caused this problem. So, switch order and make sure only one statement opened at a time JTOOL: [MANTIS941] lulu suggested create foreign key header |Table Name | Foreign Key | Referenced Table | Referenced Column | On Update | On Delete DATE: 2019-07-26 MR#10436: [DBM54] load external database fail when there's many sysfile obj MR#10933: pdftotxt can not handle utpipe error correctly MR#10934: ITC error when converting nchar to int JTOOL: [MANTIS941] getIndexInfo for primary key MySQL "PRIMARY" Oracle tablename_PK sql server PK_tablename DATE: 2019-07-25 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 JTOOL: [MANTIS941] create index DATE: 2019-07-24 MR#10916: refeine auto index name when expression columns JTOOL: [MANTIS941] create index DATE: 2019-07-23 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 MR#10920: Invalid dynamic blob when update blob with expression where exists subquery MR#10927: [DBM54]jsoncols support user alter max jsonb size. JTOOL: [MANTIS895] lulu{U+63D0} {U+9700}{U+8981}{U+6539}{U+8FDB}{U+7684}{U+529F}{U+80FD}{U+70B9} http://172.16.220.116/mantisbt/view.php?id=895#c11914 DATE: 2019-07-22 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 JTOOL: MANTIS 1012 after loop through tablemodel, call table1_valueChanged JTOOL: [MANTIS941] create foreign key (fixed bug, should use dtio.owner, dtio.name instead) DATE: 2019-07-19 MR#10928: missing bbhdr when bind host variable to blob MR#10929: core dump when call sp with udf parameter multi times DATE: 2019-07-18 MR#10931: [MANTIS1020] support new method for setting VC with ESQL/C procedure JTOOL: MANTIS 1012 performance tuning use table join instead of getTableSize to get tb.NUM_PAGE DATE: 2019-07-17 JTOOL: MANTIS 1012 new Thread update column names in background DATE: 2019-07-16 MR#10920: Invalid dynamic blob when update blob with expression where exists subquery DATE: 2019-07-15 MR#10773: support dump plan using json format MR#10927: [DBM54]jsoncols support user alter max jsonb size. JTOOL: MANTIS 814 add SQL_DUMP_PLAN_JSON2 DATE: 2019-07-12 MR#10900: [MANTIS964] dmrestoretb tool support restore table to target_table DATE: 2019-07-11 MR#10914: [DBMR3230] DCI_MAPPING length limit - mantis1002 DATE: 2019-07-10 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 MR#10926: sql server 2016 can not fetch data from odbc DATE: 2019-07-09 MR#10924: dmrestoretb report ERROR 10851 because of incorrect jnl size MR#10925: file type column is damaged by updating with another file type column DATE: 2019-07-05 MR#10923: [DBMR3153] can't connect to DBMaker via OLEDB using Microsoft SQL Server's Linked Server DATE: 2019-07-04 MR#10773: support dump plan using json format DATE: 2019-07-03 MR#10858: [DBM60] lua module scope with C api DATE: 2019-07-02 MR#10921: huge blob can not be replicated to slave MR#10922: dump json plan bug DATE: 2019-06-27 MR#10918: SELECT INTO with dynamic wrong result DATE: 2019-06-26 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 DATE: 2019-06-25 MR#10917: [UBUS] delete from temp table get 20904 error JTOOL: JTOOL: add progress dialog JTOOL: dialog dispose needs to connection.disconnect() file < 10M, no need to have progress dialog (lulu suggested <100M, but 100M actually would take a few seconds already) DATE: 2019-06-24 MR#10858: [DBM60] lua module scope with C api DATE: 2019-06-21 MR#10915: [DBMR3231] Slow Query JOIN - mantis1003 MR#10916: refeine auto index name when expression columns JTOOL: for json file size > 1M, do not load to json tree. instead take token one by one DATE: 2019-06-19 MR#10911: ERROR (6523) dynamic column FROM sub-select MR#10913: Internal error occurred when select from table contained expression join call ESQLSP DATE: 2019-06-18 MR#10908: Error(6145) SELECT alias.dynamic when GROUP BY alias.dynamic MR#10914: [DBMR3230] DCI_MAPPING length limit - mantis1002 JTOOL: make sure one properties file only be loaded once use getDBAResourceBundle() instead of new DBAResourceBundle JTOOL: lulu reported db_lcode=5, jsql dump plan had error. java.io.UnsupportedEncodingException: ISO_8859_2 proper charset is ISO-8859-2 and charset for lcode 3 should be GB2312 JTOOL: lulu reported get "Save_All" resource from resource.jsqltool zh_CN file : Can't find resource for bundle resource.jsqltool_zh_CN, key Save_All Error getResource /images/saveAll.png get "Undo" resource from resource.jsqltool en_US file : Can't find resource for bundle resource.jsqltool_en_US, key Undo get "Redo" resource from resource.jsqltool en_US file : Can't find resource for bundle resource.jsqltool_en_US, key Redo DATE: 2019-06-17 JTOOL: remove obsolete po item JTOOL: remove obsolete po item JTOOL: mkpo add search duplicate text DATE: 2019-06-14 JTOOL: remove obsolete po item DATE: 2019-06-13 MR#10912: temp table support jsoncols JTOOL: mantis 895 a few messages DATE: 2019-06-12 JTOOL: fix mkpo dir scan problem JTOOL: mantis 895 JTOOL: mantis 895 JTOOL: mantis 895 and 983 JTOOL: mantis 895 and 983 JTOOL: mantis 895 make Import_xml_file general usage DATE: 2019-06-10 MR#10911: ERROR (6523) dynamic column FROM sub-select JTOOL: NULL Data,import failed JTOOL: MAINTIS 895 SAMPLE_UNICODETYPE review data failed DATE: 2019-06-06 MR#10909: [DBMR3226] ERROR (1045) when replicate to MySQL without uppercase username JTOOL: jackie said {U+884C}{U+70BA}{U+4E0D}{U+4E00}{U+81F4},{U+6709}{U+6642}{U+8981} click {U+624D}{U+6703}{U+6D88}{U+5931},{U+6709}{U+6642}{U+96E2}{U+958B}{U+65B9}{U+584A}{U+5C31}{U+6703}{U+81EA}{U+52D5}{U+6D88}{U+5931} JTOOL: mantis 814, 4, {U+82E5}{U+76F8}{U+9130}{U+7684}ON Block{U+548C}PL Block{U+6709}{U+76F8}{U+540C}{U+7684}Method, {U+5247}{U+5716}{U+5F62}{U+62FF}{U+6389}ON Block --> {U+9084}{U+8981}{U+52A0}{U+4E0A}{U+6C92}{U+6709}{U+5176}{U+4ED6} ON Block child DATE: 2019-06-05 MR#10905: [DBM543]select showindex report lock time-out sometimes DATE: 2019-06-03 MR#10905: [DBM543]select showindex report lock time-out sometimes JTOOL: MANTIS 983 1.update po file 2.update properties file 3.code add comment 4.fix Hotkey DATE: 2019-05-31 MR#10862: outer join with order by may cause core dump MR#10908: Error(6145) SELECT alias.dynamic when GROUP BY alias.dynamic MR#10910: dump plan of dynmaic column DATE: 2019-05-30 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#10907: [DBMR3207] show create table via SP- mantis986 JTOOL: jackie said copy {U+67D0}{U+4E00}{U+683C} to {U+526A}{U+8CBC}{U+7C3F}{U+5C31}{U+597D} jsql clob {U+7684}size {U+9650}{U+5236}{U+62FF}{U+6389} JTOOL: MANTIS992 set max 5000 for history commands JTOOL: MANTIS993 add save all button JTOOL: MANTIS 994 lock page add kill connection button session page allow multiple selection DATE: 2019-05-27 JTOOL: MANTIS983: add journal status DATE: 2019-05-24 MR#10907: [DBMR3207] show create table via SP- mantis986 DATE: 2019-05-23 JTOOL: MANTIS 895--add export to json and import from json JTOOL: code should be compatible with jdk 1.6 style JTOOL: code should be compatible with jdk 1.6 style DATE: 2019-05-21 MR#10906: [DBM54]block delimtrer support # as comments DATE: 2019-05-17 MR#10907: [DBMR3207] show create table via SP- mantis986 DATE: 2019-05-16 MR#10904: [DBM543]no dbdir is written to the ini file after create db MR#10905: [DBM543]select showindex report lock time-out sometimes DATE: 2019-05-13 MR#10893: [MANTIS975] update table through index with expression index cause crash DATE: 2019-05-09 MR#10893: [MANTIS975] update table through index with expression index cause crash DATE: 2019-05-08 JTOOL: sqlsp in file if the content is not ended with ';', it would return error. so add ';' if last character is not ';'. {U+9519}{U+8BEF}{U+4FE1}{U+606F}{U+662F}: "SP112345SYSADM.sp", line 4: ERROR(6002): syntax error near or at ";" {U+6216}{U+8005} "SP11234SYSADM.sp", line 4: ERROR(6002): syntax error near or at "" DATE: 2019-05-07 MR#10893: [MANTIS975] update table through index with expression index cause crash DATE: 2019-05-06 JTOOL: MANTIS963 save sqlsp script into tempfile + create procedure from tempfile JTOOL: MANTIS980 \t had extra \t added, remove checking \t DATE: 2019-05-03 MR#10867: [Support 0000943]: [DBMR3167] set parameter reused buffer DATE: 2019-04-30 MR#10899: [DBM54]dynamic column get timstamp twice cause result mismatch DATE: 2019-04-29 MR#10891: [MANTIS964] support unload table to target table syntax MR#10893: [MANTIS975] update table through index with expression index cause crash DATE: 2019-04-26 MR#10897: [DBMR3196][MANTIS977] support SHOWINDEX stored procedure MR#10899: [DBM54]dynamic column get timstamp twice cause result mismatch DATE: 2019-04-25 MR#10899: [DBM54]dynamic column get timstamp twice cause result mismatch DATE: 2019-04-24 MR#10900: [MANTIS964] dmrestoretb tool support restore table to target_table DATE: 2019-04-23 MR#10900: [MANTIS964] dmrestoretb tool support restore table to target_table MR#10902: [DBMR3202] ERROR (6187) in slave side of DB replication env - mantis978 DATE: 2019-04-22 MR#10900: [MANTIS964] dmrestoretb tool support restore table to target_table DATE: 2019-04-19 MR#10893: [MANTIS975] update table through index with expression index cause crash DATE: 2019-04-18 MR#10901: cannot install 32bit sp patch on 64bit OS DATE: 2019-04-17 MR#10899: [DBM54]dynamic column get timstamp twice cause result mismatch DATE: 2019-04-16 MR#10897: [DBMR3196][MANTIS977] support SHOWINDEX stored procedure MR#10898: [DBMR3200] DB Crash Error on Windows - mantis976 DATE: 2019-04-15 MR#10893: [MANTIS975] update table through index with expression index cause crash MR#10897: [DBMR3196][MANTIS977] support SHOWINDEX stored procedure DATE: 2019-04-12 MR#10893: [MANTIS975] update table through index with expression index cause crash MR#10894: SQLStatistics() support return FILTER_CONDITION MR#10895: dynamic column support outref for subquery MR#10896: join between int and bigint get wrong result DATE: 2019-04-08 MR#10891: [MANTIS964] support unload table to target table syntax DATE: 2019-04-03 MR#10888: [DBM54] dynamic column JSONPATH phase II DATE: 2019-04-02 JTOOL: jackie said input file for jsoncols, always read it as utf8 encoding jsoncols use setCharacterStream to put data JTOOL: lulu suggested disable undo/redo buttons if not undoable/redoable. it seems variables declared in interface UndoRedoText are static?? so remove UndoRedoText. those related inner classes moved to each text component classes. DATE: 2019-03-29 MR#10890: support update dynamic where current of cursor DATE: 2019-03-28 MR#10888: [DBM54] dynamic column JSONPATH phase II MR#10889: optimize evaluate udf output is null DATE: 2019-03-27 MR#10879: create auto index may fail when column is DYNAMIC COLUMN or UDF DATE: 2019-03-22 MR#10887: auto index daemon does not log update and delete use index scan DATE: 2019-03-21 MR#10886: auto index may cause foreign key not work JTOOL: Mantis 967 login dialog add a checkbox to save user/password. Share with jdba (user/password) JTOOL: mantis 969 text after -- mark in gray mantis 966 add undo/redo buttons DATE: 2019-03-20 JTOOL: Mantis 967 login dialog add a checkbox to save user/password. Need to encrypt/decrypt password when saving into jsyscom_dbmaker.xml. If user chooses not to save user/password, then remove relative content from jsyscom_dbmaker.xml. Since jsql move in jdba, no need for separate login dialog for itself. JTOOL: mantis 967 refine CorePreferences JTOOL: mantis 966 Allow use CTRL+Z / CTRL+Y(undo/redo) on text component (JTextField, JTextArea, JPasswordField, JEditorPane) DATE: 2019-03-19 MR#10880: [DBM54] check the SQLSP error handle procedure and code refine JTOOL: [mantis 968] multi-selections and ctrl-c will put only column names to clipboard DATE: 2019-03-18 MR#10880: [DBM54] check the SQLSP error handle procedure and code refine JTOOL: since we lost original javacc jj file, we can only do ignore by the complete statement, not by line started with -- DATE: 2019-03-15 MR#10881: [DBM54] fix the line comment and block comment include quotes in SQL Procedure JTOOL: MANTIS965 \n right after keyword would make keyword black, so add \n as delimiter for StringTokenizer JTOOL: MANTIS965 Allow execute only highlight sql, remain high light even focus lost DATE: 2019-03-14 MR#10885: [DBMR3185] dmrestoretb issues (DB_IDCAP=0) JTOOL: Jackie suggests add execute as one sql for sqlps... MANTIS965 Allow execute only highlight sql JTOOL: jdk 1.6 error local variable pop is accessed from within inner class; needs to be declared final JTOOL: MANTIS 965 add hotkey F12 on popupMenu DATE: 2019-03-13 MR#10748: [DBMR3046][MANTIS845] DCI_DB_MAP for ISCOBOL MR#10873: [Mantis953] sync auto index can not set correct default dynamic column type MR#10884: create index use index may get wrong result DATE: 2019-03-08 MR#10880: [DBM54] check the SQLSP error handle procedure and code refine DATE: 2019-03-07 MR#10878: subquery use DYNAMIC COLUMN cause core dump MR#10879: create auto index may fail when column is DYNAMIC COLUMN or UDF JTOOL: [mantis913][DBMR3128] change OIDTOSTR(a.TABLE_ID,1)=OIDTOSTR(b.TABLE_OID,1) back to a.TABLE_ID=b.TABLE_OID DATE: 2019-03-05 MR#10876: where is null using index scan get wrong result MR#10877: [DBMR3184] dmacu90.lib not comaptible with VS2017 - mantis962: JTOOL: [mantis913][DBMR3128] change OIDTOSTR(a.TABLE_ID,1)=OIDTOSTR(b.TABLE_OID,1) back to a.TABLE_ID=b.TABLE_OID DATE: 2019-03-04 MR#10748: [DBMR3046][MANTIS845] DCI_DB_MAP for ISCOBOL DATE: 2019-02-27 MR#10876: where is null using index scan get wrong result DATE: 2019-02-25 MR#10875: [DBMR3180] performance issue on INSERT...SELECT - mantis960 DATE: 2019-02-20 MR#10748: [DBMR3046][MANTIS845] DCI_DB_MAP for ISCOBOL DATE: 2019-02-15 MR#10748: [DBMR3046][MANTIS845] DCI_DB_MAP for ISCOBOL DATE: 2019-02-13 MR#10795: allow connect user to call SQLPrimaryKeys() JTOOL: MANTIS946 enable modify button on schema panel, if connect user with alter privilege JTOOL: [mantis 946] connect user with alter privilege, confirm -> check if tsName is null DATE: 2019-02-12 MR#10874: [DBMR3178] Clob Data ERROR when Insert in U8 DB - mantis958 DATE: 2019-01-31 MR#10873: [Mantis953] sync auto index can not set correct default dynamic column type DATE: 2019-01-30 MR#10855: [Mantis910]two connections can not connect to DBs with diff LCODE DATE: 2019-01-29 JTOOL: [MANTIS941] create foreign key JTOOL: remove compile error/warning. do not use ComboBoxModel.... it is not 1.6 DATE: 2019-01-28 MR#10872: [DBMR3171][MANTIS949] DBMaker 5.x: value list syntax error DATE: 2019-01-25 MR#10855: [Mantis910]two connections can not connect to DBs with diff LCODE MR#10871: [DBMR3170] missing quotes in SET SERIAL in s0 unload script - mantis947 DATE: 2019-01-24 JTOOL: [mantis 946] no idea why kris changed SYSAUTHGROUP to SYSAUTHMEMBER, so add distinct to remove duplicate records [mantis 946] do not popup error message when user fails to read SYSTABLESPACE DATE: 2019-01-22 MR#10870: [DBMR3169] [MANTIS 945] support iscobol 2018r1's new WHEN OTHER syntax JTOOL: [MANTIS941] create primary key DATE: 2019-01-14 JTOOL: [MANTIS941] smallint/int + isAutoIncrement set type serial, bigint+ isAutoIncrement set type bigserial DATE: 2019-01-04 MR#10867: [Support 0000943]: [DBMR3167] set parameter reused buffer DATE: 2019-01-02 MR#10867: [Support 0000943]: [DBMR3167] set parameter reused buffer DATE: 2018-12-28 MR#10865: Fix execute other's procedure.causes wrong results. DATE: 2018-12-21 MR#10748: [DBMR3046][MANTIS845] DCI_DB_MAP for ISCOBOL DATE: 2018-12-18 JTOOL: [MANTIS771] centos import from postgresql failed after first table imported. DATE: 2018-12-11 MR#10748: [DBMR3046][MANTIS845] DCI_DB_MAP for ISCOBOL JTOOL: include Prop_SQL in setPropertiesEditable JTOOL: missing several SQL keywords like LANGUAGE... DATE: 2018-12-10 MR#10857: After rebuilding ivf index with increment,the query result is incorrect. MR#10860: [MANTIS923] setDbNameFile check if db start MR#10864: [UBUS] return 1502 error when setting RP_SLADR and next line is comment JTOOL: fastCombineSqlString code refined (do not repeat sign/!sign, the only difference is one ',' when i=0) DATE: 2018-12-07 MR#10825: [DBMR3122] DCI_USER_PATH CREATE TABLES MR#10862: outer join with order by may cause core dump DATE: 2018-12-06 MR#10860: [MANTIS923] setDbNameFile check if db start MR#10861: sql server 2008 linked server can not fetch table catalog info with oledb provider for dbmaker DATE: 2018-12-05 MR#10854: Error(6150) update dynamic cause error after alter table add jsoncols column JTOOL: [mantis923] no need to get user/password, do not connect/terminate db DATE: 2018-12-04 MR#10858: [DBM60] lua module scope with C api DATE: 2018-11-28 MR#10793: [DBMR3094] dci_blob behavior on isCOBOL -mantis884 JTOOL: [mantis913][DBMR3128] The Monitor of lock for JDBA Tool in version 5.4.x it is very slow JTOOL: [mantis913][DBMR3128] The Monitor of lock for JDBA Tool in version 5.4.x it is very slow JTOOL: if view_name is quoted, search for "view_name" JTOOL: [mantis913][DBMR3128] The Monitor of lock for JDBA Tool in version 5.4.x it is very slow DATE: 2018-11-23 MR#10858: [DBM60] lua module scope with C api DATE: 2018-11-21 JTOOL: [MANTIS926] checkbox should use ItemListener instead of ChangeListener. ChangeListener is including move over event which is not needed. JTOOL: [MANTIS926] in jsyscom_dbmaker.xml if dmType is defined, not only create table use it, but also in select sql. cast(colname as dmType) JTOOL: [MANTIS926] remove DTTERROR.LOG before import odbc DATE: 2018-11-19 JTOOL: [MANTIS926] display source is table or view JTOOL: correct mistype JTOOL: [MANTIS926] specify quote id character ` for mysql JTOOL: [MANTIS926] if table name is empty, then setIcon(null) DATE: 2018-11-16 MR#10855: [Mantis910]two connections can not connect to DBs with diff LCODE DATE: 2018-11-15 MR#10346: function extenction for itt temp file MR#10855: [Mantis910]two connections can not connect to DBs with diff LCODE MR#10856: JDBC ODBC cannot get MySQL JSON and enum as typename JTOOL: [MANTIS926] get 3rd db type mapping from PreferencesXml DATE: 2018-11-12 MR#10854: Error(6150) update dynamic cause error after alter table add jsoncols column JTOOL: NAME is not keyword but NAMES is (according to dmSQL> help reserved-word DATE: 2018-11-08 MR#10790: [mantis827] dmsqlc set autocommit off/on ok even after dmserver socket close MR#10852: [UBUS] select constant string with group by into date column will get 6150 error MR#10853: Java VM crash in import text process with Data Transfer Tool DATE: 2018-11-07 JTOOL: [MANTIS913] do not new LockGraphScrollPane until user check lock graphic checkbox DATE: 2018-11-06 JTOOL: [MANTIS913] select CONNECTION_ID from SYSTEM.SYSCONINFO // only need to query once DATE: 2018-11-02 JTOOL: [MANTIS771][MR10596] support DB2 MYSQL POSTGRESQL ODBCX JTOOL: MYSQL select country_id from country vs select "country_id" from country are different. select "country_id" from country --> column type would be SQL_WCHAR? not small int. Therefore, try not to add double quote when id with '_'. DATE: 2018-11-01 MR#10834: call javasp causes DB dump DATE: 2018-10-31 MR#10834: call javasp causes DB dump DATE: 2018-10-30 JTOOL: [MANTIS771][MR10596] support DB2 MYSQL POSTGRESQL ODBCX DATE: 2018-10-29 MR#10834: call javasp causes DB dump DATE: 2018-10-25 MR#10850: enhance filter index optimizer DATE: 2018-10-24 MR#10849: [MANTIS910] use GetModuleHandleExA to get current dll's path DATE: 2018-10-23 JTOOL: MANTIS 771 replace sun.jdbc.odbc.JdbcOdbcDriver with dbmaker.sql.JdbcOdbdDriver + jdbc:dbmaker-odbc:datasource DATE: 2018-10-19 MR#10848: unload user hidden schema and data default MR#10849: [MANTIS910] use GetModuleHandleExA to get current dll's path DATE: 2018-10-16 MR#10846: Support DB_CPFEXT for user to use different code page map JTOOL: MANTIS 917 key :{U+4FDD}{U+7559}{U+53CC}{U+5F15}{U+53F7},{U+4F7F}{U+7528}{U+9ED1}{U+8272}{U+5B57}{U+4F53} value:string{U+90E8}{U+5206}{U+4F7F}{U+7528}{U+7EFF}{U+8272}{U+5B57}{U+4F53},number{U+4F7F}{U+7528}{U+84DD}{U+8272}{U+5B57}{U+4F53} DATE: 2018-10-15 MR#10834: call javasp causes DB dump JTOOL: MANTIS 917 format json source DATE: 2018-10-11 MR#10836: select alias.dynamicColumn will cause invalid column DATE: 2018-10-09 MR#10846: Support DB_CPFEXT for user to use different code page map JTOOL: MANTIS 917 {U+5EFA}{U+8BAE}{U+4E09}{U+89E3}{U+91CA}{U+8BF4}{U+660E}: 1.{U+7528}{U+56FE}{U+6807}{U+66FF}{U+6362}{U+73B0}{U+5728}{U+7684}checkbox 2.{U+53F3}{U+4E0B}{U+65B9}{U+7684}datagrid{U+90E8}{U+5206}{U+9700}{U+8981}{U+589E}{U+52A0}{U+56FE}{U+6807},{U+5982}{U+4E0B}{U+56FE}{U+6240}{U+793A} DATE: 2018-10-08 MR#10810: [DMLua] upgrade to version 534 DATE: 2018-10-05 JTOOL: [MANTIS917] {U+5EFA}{U+8BAE}{U+4E00}: Node{U+4E2D},cost{U+660E}{U+6587}{U+663E}{U+793A}3{U+4E2A}{U+4E3B}{U+8981}{U+6570}{U+636E}{U+5373}{U+53EF},{U+5206}{U+522B}{U+4EE3}{U+8868}:I/O Cost/CPU Cost : 12.6/Sub Cost {U+7C7B}{U+4F3C}cost[15.0 12.6 0] {U+5176}{U+5B83}database{U+4E5F}{U+662F}{U+8FD9}{U+6837}{U+5904}{U+7406}{U+7684}{U+3002} {U+5EFA}{U+8BAE}{U+4E8C}: {U+63D0}{U+4F9B}user{U+9009}{U+9879},{U+9009}{U+62E9}{U+663E}{U+793A}{U+56FE}{U+5F62}{U+683C}{U+5F0F}{U+6216}json{U+683C}{U+5F0F},{U+76F4}{U+63A5}{U+663E}{U+793A}{U+5728}panel{U+9762}{U+677F}{U+4E2D},{U+4E0D}{U+662F}{U+6253}{U+5F00}{U+65B0}{U+7684}window JTOOL: [MANTIS917] DATE: 2018-10-03 MR#10795: allow connect user to call SQLPrimaryKeys() MR#10843: [DBMR3044] DCIC ( FILE CONNECTOR ) FOR WINDOWS ERROR DATE: 2018-10-02 MR#10843: [DBMR3044] DCIC ( FILE CONNECTOR ) FOR WINDOWS ERROR DATE: 2018-09-28 MR#10845: auto index need handle is null JTOOL: MANTIS916 num_history_cmd and save_history are assigned to each dbname/user. if save_history = false, remove history element from xml. (history command would be removed if save_history = false) DATE: 2018-09-27 JTOOL: MANTIS916 keep jsql history command JTOOL: MANTIS916 replace getTextContent with getFirstChild.getNodeValue because java.lang.NoSuchMethodError: org.w3c.dom.Node.getTextContent()Ljava/lang/String; it seems some jar has different org.w3c.dom.Node implementation. https://blog.csdn.net/cl1107056481/article/details/46516459 JTOOL: MANTIS916 replace setTextContent with doc.createTextNode JTOOL: MANTIS 916 if IDCAP = true, ignore case. sysadm should be equal to SYSADM DATE: 2018-09-26 MR#10842: [ERROR(6536)]update set jsoncols to jsoncols MR#10843: [DBMR3044] DCIC ( FILE CONNECTOR ) FOR WINDOWS ERROR MR#10844: add/modiry/drop column make the dynamic default type to varchar(256) if the table has jsoncols DATE: 2018-09-25 MR#10838: [DBM54]trigger action need resync stmt handle DATE: 2018-09-21 MR#10839: [DBM54]SQL Procedure decalre cur cause column name mismatch MR#10842: [ERROR(6536)]update set jsoncols to jsoncols DATE: 2018-09-20 MR#10833: trigger should not show definition if trigger action's column list has hidden column JTOOL: [mantis917] simplify json dump plan DATE: 2018-09-19 MR#10836: select alias.dynamicColumn will cause invalid column MR#10837: Call getsystemoption ('blockcon') returns an error MR#10838: [DBM54]trigger action need resync stmt handle DATE: 2018-09-18 MR#10810: [DMLua] upgrade to version 534 MR#10833: trigger should not show definition if trigger action's column list has hidden column DATE: 2018-09-17 MR#10810: [DMLua] upgrade to version 534 DATE: 2018-09-14 MR#10810: [DMLua] upgrade to version 534 DATE: 2018-09-13 JTOOL: MANTIS914 still need getColumnClass for something like default renderer for Boolean... DATE: 2018-09-12 MR#10832: hidden column's data will be reseted when alter table drop column JTOOL: [mantis913][DBMR3128] The Monitor of sessions for JDBA Tool in version 5.4.x it is very slow DATE: 2018-09-11 MR#10831: set showhidden off/schema/schema_data DATE: 2018-09-10 MR#10830: Dynamic column can not selected when order by in select stmt DATE: 2018-09-07 MR#10829: After rename to tablename, the description of dynamic columns is disappeared DATE: 2018-09-04 JTOOL: MANTIS814 dump plan in json format DATE: 2018-08-31 JTOOL: MANTIS778 - search tree node, current node --> search down --> start over from the first DATE: 2018-08-29 JTOOL: [DBMR2828]: Better graphical JTOOLS - Mantis 778 quick search by ONLY children/sibling JTOOL: [DBMR2828]: Better graphical JTOOLS - Mantis 778 quick search by ONLY table name // search start at current node, unless it is repeating search // then search next sibling // for example, 'bo' 'bo' to search the second BO starting word DATE: 2018-08-21 JTOOL: [DBMR2828]: Better graphical JTOOLS - Mantis 778 quick search by table name DATE: 2018-08-15 MR#10826: [DBMR3126] ISDCI GET ACTIVE CONNECTION MR#10827: view support hidden column DATE: 2018-08-13 MR#10825: [DBMR3122] DCI_USER_PATH CREATE TABLES DATE: 2018-08-10 MR#10809: [SQLSP]internal recurcive call with local function DATE: 2018-08-09 MR#10824: user define no parameter UDF always evaluate DATE: 2018-08-08 MR#10823: [DBMR3121] [MANTIS907]webservice(ISCOBOL)using jdbc type 3 it not works DATE: 2018-08-07 JTOOL: [mantis863][mr10820]jtools set SQL_CLIENT_DECIMAL_DOT 1 DATE: 2018-08-06 MR#10817: Is there a way to automatically elevate permissions for import from odbcˋ JTOOL: [MANTIS906] getString(6) must be before getInt(7) DATE: 2018-08-03 MR#10773: support dump plan using json format JTOOL: [MANTIS902] jtools show null value as (NULL) in light yellow background DATE: 2018-08-02 JTOOL: [MANTIS902] jtools show null value as (NULL) in light yellow background DATE: 2018-08-01 JTOOL: [MANTIS902] jtools show null value as (NULL) in light yellow background DATE: 2018-07-27 MR#10808: Fix internal call procedure check close env DATE: 2018-07-26 MR#10813: [DBM543]call sqlsp,the error returned is not expected. MR#10814: [DBM543]anonymous sp execution results have problems DATE: 2018-07-24 MR#10812: [DBMR3117] ALTERNATE KEYS DCI -- manits903 DATE: 2018-07-19 MR#10808: Fix internal call procedure check close env DATE: 2018-07-18 MR#10808: Fix internal call procedure check close env DATE: 2018-07-17 JTOOL: [DBAB2181] :Executing a Stored Procedure, Input Parameter Problems DATE: 2018-07-16 MR#10808: Fix internal call procedure check close env DATE: 2018-07-11 JTOOL: Display_Mode_of_SQL_Command_Monitor shows incorrect characters in Japanese language. Modeify po/ja_JP.po JTOOL: Sql query Panel has a newline on the Linux platform. DATE: 2018-07-06 MR#10784: [global table] alter global table have some different with local table MR#10807: [INTERON-ppc64le] database upgrade with database replication DATE: 2018-07-03 MR#10805: [DBMR3108] update index(PK) column cause deadlock DATE: 2018-06-26 MR#10804: [mantis 892] support runtime setting bmode DATE: 2018-06-19 MR#10803: insert dynamic column data > 4K will core dump DATE: 2018-06-14 MR#10213: load external db from 'select DCI-5.4.2.zip chkjtool diff.0 diff.txt getmrdate.000 getmrhist getmrhist.000 from xxxx' into xxxx; MR#10802: select normal columns into dynamic columns DATE: 2018-06-13 MR#10213: load external db from 'select DCI-5.4.2.zip chkjtool diff.0 diff.txt getmrdate.000 getmrhist getmrhist.000 from xxxx' into xxxx; MR#10802: select normal columns into dynamic columns DATE: 2018-06-12 JTOOL: [mantis 892] cut clean between bksvr and bmode DATE: 2018-06-07 MR#10801: [DBMR3107] ISCOBOL Exec SQL error 6104 with JDBC driver type 2 - mantis891 DATE: 2018-06-06 MR#10799: [DBMR3104] incremental Backup format ( DB_BkFrm ) DATE: 2018-05-29 MR#10798: [DBMR3103] DCI_GET_TABLE_NAME crash - mantis887 DATE: 2018-05-24 MR#10785: SQL procedure support local function and refine module DATE: 2018-05-23 MR#10797: [jsoncols] can not use text index on jsoncols DATE: 2018-05-22 MR#10792: subquery when outer table use index scan get wrong result MR#10796: subquery and like cause bad performance MR#10797: [jsoncols] can not use text index on jsoncols DATE: 2018-05-11 MR#10785: SQL procedure support local function and refine module DATE: 2018-05-08 MR#10794: [DBMR3095]DCI_DB_MAP OPEN TABLE ON DEFAULT DATABASE-mantis885 DATE: 2018-05-03 MR#10794: [DBMR3095]DCI_DB_MAP OPEN TABLE ON DEFAULT DATABASE-mantis885