DATE: 2023-05-23 MR#11259: [DBM545]aggregation function last() reduce dmsql32 core dump DATE: 2023-05-22 MR#11259: [DBM545]aggregation function last() reduce dmsql32 core dump DATE: 2023-05-04 MR#11257: [OMFLOW] reduce page IX lock when DB_INSPGCMP<=0 JTOOL: [mantis 1423] change JScrollPane to JPanel, no need for outer scrollbar DATE: 2023-05-02 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 DATE: 2023-04-27 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 DATE: 2023-04-25 MR#11076: [DM545] [MANTIS1108] support JDBC type 4 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-03-31 MR#11139: [OMFLOW] when multi-connection select/update blob, it's possible to hang in select blob data DATE: 2023-03-29 MR#11242: [QA REGRESSION] create async replicate get internal error DATE: 2023-03-28 MR#11243: [QA REGRESSION] select case when may get internal error DATE: 2023-03-27 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-17 JTOOL: refine journal message JTOOL: refine journal message DATE: 2023-03-16 JTOOL: cut trunk to 5.4.5 branch DATE: 2023-03-16 JTOOL: cut trunk to 5.4.5 branch DATE: 2022-05-12 MR#11185: [DBMR3587] Documentation: HIDDEN directive not mentioned -Mantis1319 MR#11192: [DBMR3593] [MANTIS1327] update statistics may get wrong statistics of index JTOOL: MANTIS 1328 close AsQueryPane's statement when dropping/removing AsQueryPane DATE: 2022-04-22 MR#11182: [DBM544]when insert into table,dmsql32 disappeared for no reason DATE: 2022-03-25 MR#10989: [DBMR3329] [MANTIS1100] do not set null for not-null column when setting DCI_NULL_ON_ZERO=1 DATE: 2022-03-22 MR#11118: [DBMR3491][MANTIS1245] Fix network problem with different DBMaker version 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-17 JTOOL: cut trunk to 5.4.4 branch DATE: 2022-03-17 JTOOL: cut trunk to 5.4.4 branch DATE: 2021-03-15 MR#11094: dci for visual cobol2019 execute program failed by xfd wrong version number. DATE: 2021-03-10 MR#10987: [DBMR3323] [MANTIS1094] ISDCI get Runtime connection ID MR#11093: [DBM543]migration test,execute SC return"SQL internal error " DATE: 2021-01-27 MR#11073: [DBM543]declare decimal variable,return error 5002 DATE: 2021-01-26 MR#11073: [DBM543]declare decimal variable,return error 5002 MR#11080: Schedule Task cause core dump 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-12 MR#11073: [DBM543]declare decimal variable,return error 5002 DATE: 2021-01-11 MR#11072: JDBC driver exception using commons-configuration2-2.7 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) 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] {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 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