DDL - Powered by MinDoc

commit c18bf746a25321b9410e8c50c14afc9f469fbc36 (HEAD -> master, origin/master, origin/HEAD)
Author: zhangli zhangli@zbomc.com
Date: Sun Jan 28 09:30:41 2024 +0800

支持PG系列serial,smallserial,bigserial类型

commit 3342b514f3920215ececb28ec8aa071fe30553ba
Author: zhangli zhangli@zbomc.com
Date: Sat Jan 27 06:59:41 2024 +0800

兼容highgo，走postgresql路线

commit f7dfb2f9b36a2045bf2555928361d5c425a16009
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 25 16:15:59 2024 +0800

mysql/postgresql/opengaussdb to hana
varchar 改成nvarchar類型

commit acfc86b65e61387b5177e200d9264f43e068e61a
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 18 15:21:32 2024 +0800

支持source_dbtype=tdsql

commit 3db0288623c145d5aa437793c3f9fb103639ec62
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 18 07:43:16 2024 +0800

:…skipping…
commit c18bf746a25321b9410e8c50c14afc9f469fbc36 (HEAD -> master, origin/master, origin/HEAD)
Author: zhangli zhangli@zbomc.com
Date: Sun Jan 28 09:30:41 2024 +0800

支持PG系列serial,smallserial,bigserial类型

commit 3342b514f3920215ececb28ec8aa071fe30553ba
Author: zhangli zhangli@zbomc.com
Date: Sat Jan 27 06:59:41 2024 +0800

兼容highgo，走postgresql路线

commit f7dfb2f9b36a2045bf2555928361d5c425a16009
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 25 16:15:59 2024 +0800

mysql/postgresql/opengaussdb to hana
varchar 改成nvarchar類型

commit acfc86b65e61387b5177e200d9264f43e068e61a
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 18 15:21:32 2024 +0800

支持source_dbtype=tdsql

commit 3db0288623c145d5aa437793c3f9fb103639ec62
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 18 07:43:16 2024 +0800

mysql 增加列支持关键字信息

commit 074ba24380a1a297a1d15e14c75604c025598de1
Author: zhangli zhangli@zbomc.com
Date: Tue Jan 16 12:41:48 2024 +0800

1. 兼容FULLTEXT INDEX
2. 解析character set bug

commit efddddf053c84d8284b128df3d81bec7f61a4449
Author: zhangli zhangli@zbomc.com
Date: Thu Jan 11 10:12:41 2024 +0800

oracle 日志解析not null解析识别问题，以及null后边默认值问题，需要在default后处理 BUG

commit 576ef0bd7f9a9a643f8be0953637840fa6d739de
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Dec 31 23:27:48 2023 +0800

兼容目标是ANTDB FOR ORACLE模式数据库（主要是DATE,VARCHAR2类型）

commit 5c6362ac3bbe5de6221de3fb87da962d55e76502 (origin/szzq)
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Dec 29 15:26:33 2023 +0800

达梦约束名 支持自动生成约束名，cons开头名字优化

commit 0a199c12acca16c3fdc578c0fe886c6475b69973
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue Dec 19 07:02:55 2023 +0800

创建表 优化增加辅助列source part部分

commit 162fa522670cc3dbad2979962f5b37d03e502c3d
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Dec 18 21:48:41 2023 +0800

source key 修改到sqlkeymark中

commit 01ecd641e1c3cb98ac8940d0c59e3f61b13f4c08
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Dec 18 21:25:12 2023 +0800

mysql 兼容timestamp  to datetime类型 not null允许

commit fcee066db4b472a4adb06f9c52aa14082f996c2b
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Dec 17 11:13:54 2023 +0800

max compute 支持自动建立分区服务

commit 48741494bd4318b9578264448625616a88c8a817
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Thu Dec 14 20:34:05 2023 +0800

支持部分函数切换

commit f0ec9f0011a36bc8c5b441483d2bb57c3a899c5f
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Dec 6 14:12:31 2023 +0800

ZCBUS date - > ORACLE DATE

commit b1b736fc6d4554df122673bc64f297c9ed13d01e
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Nov 22 17:56:27 2023 +0800

20231122

commit 59b816e0e6d688a4444c2ea550569f61dc47ac96
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Nov 20 14:56:13 2023 +0800

alter table test add unique ind_uni(id);
转成
ALTER TABLE "PUBLIC"."OA_ATTACHEDFILES" ADD UNIQUE
zcbus_OA_ATTACHEDFILES_2 ("ID") ;
增加了索引名字

commit de6963dc2cce7694f487c59aeccef92e59afec25
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Thu Nov 16 22:34:50 2023 +0800

兼容修改操作只是修改default参数

commit 28133b6cdb1a5536fbe210be6980e0f1b8588033
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Nov 15 21:01:03 2023 +0800

达梦 sysdate()函数

commit 1ea3a7355ed0a61645d2075aaff1d09b68d847cb
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Nov 3 23:15:29 2023 +0800

BUG ： SQL SERVER - SQL SERVER 删除约束中，约束名字没有去掉[]符号

commit 76eba49d3fe2721353809d7392c24d62b56d952c
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Nov 1 07:11:36 2023 +0800

增加参数
source_time_date=，source_time_time=，target_time_date=，target_time_time=，insert_time_date=，insert_time_time=，source_user_name=，source_os_user_name=

commit 6c4ef06b308398ba8a2ff77e824342afbab1f8f4
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Oct 22 07:46:43 2023 +0800

解决mysql-mysql 注释过程中，默认值含有注释的部分

commit ec0d66dbeaa442dae50ee14871e783f6d46649b6
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Oct 20 15:35:00 2023 +0800

中间exit频繁退出问题

commit 3fcfccf2778148e7237dd85cd225e699fd3f72aa
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Oct 16 10:24:02 2023 +0800

HANA/PG解析，列sql含有括号，解析失败，bug已经解决

commit 67c2fa199ab596402f5c64eb7fbcddbf74fc0728
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Oct 15 20:30:04 2023 +0800

mysql 适配，建表varchar/char涉及到字符集问题。默认为utf8mb4，后续继续跟踪

commit 1abbee45821eb600670760912770b4c364bdd083
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue Oct 10 07:36:34 2023 +0800

开始兼容partition，未完成

commit 8c34d62ff24b794783e1b2615da31e07c0b573a8
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Sep 27 07:14:29 2023 +0800

时间类型默认值改成字符串

commit 0b5735fc1d7e112e60fb82942c357716e1b27724
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Sep 15 23:35:48 2023 +0800

兼容ORACLE -> POSTGRESQL
TIMESTAMP WITH LOCAL TIME ZONE，TIMESTAMP WITH TIME ZONE

commit 37e8e612c3b87da829fd2cd8b9d564064d5a6a74
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Sep 13 23:01:45 2023 +0800

支持kingbase v8r3

commit c0d16dd2df779914de8bff742c4e56d1dda1061f
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Aug 18 10:09:47 2023 +0800

增加SQLSERVER 适配，表级别注释问题

commit ab7557c51e5e2dca5d4aa2ed0bf9c81e9c1b9130
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Aug 13 18:20:02 2023 +0800

pg版本，顾虑自增序列号限制

commit cd9439e4290a7bdb0a546cd213d1c1e269aece11
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue Aug 8 16:41:15 2023 +0800

兼容oceanbase jdbc driver

commit 544c1f80bcaa67112df90e3fd3fe7d84febd94b1
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue Aug 8 11:49:27 2023 +0800

兼容Oceanbase-oracle版本，源端，目标端均采用oracle模式

commit 144c672182477b6e978d872c5dc19ac1de930c77
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue Aug 1 23:50:23 2023 +0800

创建索引，约束等，自行USE_ZCBUS_INDEX强制修改为zcbus对应索引

commit d612f20981379cb4dc102ca62baec37683aee2f1
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sat Jul 22 09:31:08 2023 +0800

兼容MYSQL  修改表结构部分
 | ALTER [COLUMN] col_name {
        SET DEFAULT {literal | (expr)}
      | SET {VISIBLE | INVISIBLE}
      | DROP DEFAULT
    }

commit 393ffbab4e97fc2fb0c59045092aa00cda47a898
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Jul 21 08:58:06 2023 +0800

支持hana 列增删改操作

commit cdf1eb5891ce957e798b634eac1c39a71fcee2c9
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Jul 7 06:43:52 2023 +0800

hana sysdate 修改为CURRENT_UTCTIMESTAMP

commit b88818a5c87377acc34f1bd378cfa7c2a2217ea6
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Jun 18 17:42:54 2023 +0800

兼容PG 列RENAME操作

commit b1dde7020b1ea4e03c7b458a2f0f4461806d8294
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun May 21 23:19:47 2023 +0800

postgresql oracle -> pg varchar长度翻倍

commit a2849bf84a3b57a230e0391fe3c339bd66dfd97f (origin/v3)
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue May 16 21:13:09 2023 +0800

mysql date/time 长度改成20 字节

commit 09d2b3ab892d020cde6d54716b98981484da89cb
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun May 14 23:14:15 2023 +0800

达梦数据库部分bug

commit 03f17d28f2b98ec9cc5034812b9baed272d374f8
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue May 9 20:45:08 2023 +0800

兼容OPENGAUSSDB

commit a00c8d1edaa12060d8dbaa1ebe391710632a9406
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun May 7 20:19:37 2023 +0800

max compute DDL兼容

commit 42a41a6bed4b233f95d780af92836b5aaf714de5
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Apr 28 14:25:12 2023 +0800

兼容maxcompute类型

gbase8a增加typemap操作

commit 0752d1bdaeb73f17e40a7db363a093eb528a09e6
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Apr 26 07:55:15 2023 +0800

部分达梦SQL解析问题，以及pg数据应用USING 关键字空格问题

commit c2b66994e25d8dae4fb6180a180f72ff6a1fc499
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Apr 24 22:22:52 2023 +0800

解決遠端兼容NUMERIC,BIGINT,TIME等类型的问题

commit 166ef6dddd4548558c9d6644cf2e2c8da40074ad
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Apr 23 07:17:32 2023 +0800

兼容GBASE8A
支持达梦数据库binary/varbinary,small/tinyint/byte等类型翻译
comment操作中，支持达梦数据库

commit 56739a886c744dae04a132c865e198e061bea6a8
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Apr 14 12:55:33 2023 +0800

异构数据库同步过程中，索引名重复的问题
1. 第一个索引会正常创建
2. 第二个索引会自动修改索引名，继续创建

commit 8fc0f07a1e54c3609e7ea88f0eae9f2c9415c67e
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Apr 12 20:19:20 2023 +0800

MYSQL -> postgresql 增加序列号自增序列功能

序列号命名规则为seq_zcbus_{表名}

commit 4e71489704f784f0c21f61f4a7b65abade1a6f3c
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Mar 22 10:07:08 2023 +0800

postgresql 查询列是否存在视图 sql有问题，已经优化

commit ea84963ba278930cf7bb13de921e34bd7aa59ae5
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Mar 20 13:14:14 2023 +0800

sybase to zcbus
char -> varchar

commit ebd324c2ea356bae5ce142a122e667430b945e51
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Mar 17 08:53:29 2023 +0800

PG DDL解析，增加default 值验证 ，支持数字，和字符串

commit eae20d980cd1b3c48d3f1af814c19ada395d9b8c
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Mon Mar 13 22:54:43 2023 +0800

pg
 1. 修改關鍵字做列明的問題
 2. 数字中，numeric整数部分超大，优化
 3. 恢复pg中default值对应::integer等类型信息

commit 60044afb3bff5250bff9912dc87cc10770707010
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Mar 12 09:42:37 2023 +0800

支持达梦

增加并行获取创建索引序列静态参数

commit b8e12a714d5ab1650b239db588814f475e04e02c
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Feb 17 13:49:21 2023 +0800

增加zcbus_sequence_no附加参数

commit fd782b0a0ad7e74f127c8ffb93377fb9d8d9b6f5
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Fri Feb 17 12:58:50 2023 +0800

mysql /oracle to postgresql (varchar长度不变)

commit 0759f24cdb0208bcfe71c6f89b7c751dee96a9e5
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Wed Feb 15 16:03:15 2023 +0800

sybase sysname 改成varchar(128)长度

commit b6f6134bd2a6123968e34b5267835be412ea4809
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Tue Feb 7 23:18:50 2023 +0800

20220207

commit fe119556bf7f8b3c1fa0bb76a77a45963780590c
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sun Feb 5 07:31:22 2023 +0800

支持INFORMIX

commit 73586ebeb7b41b919c3e68b4da1b47d2d2642ef0
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sat Feb 4 22:44:42 2023 +0800

pg中decimal操作，后边长度更新

commit 14d96bb6f0d566bcea9b4906612d2f45bee72d25
Author: Administrator <Administrator@SK-20221001TNLA>
Date: Sat Feb 4 22:23:28 2023 +0800

1、支持PG中，正常到處全表SQL一句信息
2、修改PG表列操作，修改MODIFY TYPE後邊DECIMAL后便字符串問題

commit c04dd124d08b19154e52062554cea60bf86802b2
Author: zhangli 270309613@qq.com
Date: Sat Nov 5 22:08:16 2022 +0800

DDL验证浮点数，优化18:00值，原来识别次数为浮点数，现在已修正

commit d71830ade2541ca1da265cd8f316111e99b57eaf
Author: zhangli 270309613@qq.com
Date: Sat Oct 29 07:28:24 2022 +0800

pg解析日志type关键字列信息处理方式

commit f165530f4e86133cbd22060d9f094e39481b9538
Author: zhangli 270309613@qq.com
Date: Wed Oct 26 07:16:37 2022 +0800

1、postgresql 翻譯完成的索引部分，索引名字為添加数据库对应引号
2、zcbus to postgresql， int8类型转成bigint类型

commit 0d813961b5a7756823962ffd94dd11e8cf5ad39c
Author: zhangli 270309613@qq.com
Date: Sun Oct 23 15:28:39 2022 +0800

支持click house

commit 4c78dbe2579847b4173a5df4ce91da709f8da8b3
Author: zhangli 270309613@qq.com
Date: Wed Oct 12 06:45:34 2022 +0800

异构 sqlserver 增加适配，char->nchar类型

commit 74e76347cb3de43961f143f227fd8cf8be030e39
Author: zhangli 270309613@qq.com
Date: Wed Jul 20 20:40:47 2022 +0800

Geometry 类型支持，varchar，长度为max

commit d381f9d494055efd8c3fa954ed5b8a2b887ee9cb
Author: zhangli 270309613@qq.com
Date: Fri Jun 24 23:49:17 2022 +0800

parsesigddl

commit bfdef40018c668b14b9b33ac1ace53f62154a6a1
Author: zhangli 270309613@qq.com
Date: Fri Jun 24 23:42:29 2022 +0800

增加ParseSigDDL函数，返回解析函数对象

commit ee1fbc80407d041e28c1b2eef274e4aeba70f6a6
Author: zhangli 270309613@qq.com
Date: Thu Jun 9 15:48:03 2022 +0800

支持filter_index参数，在遇到此参数的时候，如果存在index操作，则过滤掉销管操作

commit 3af07596da674cfd16b1966e8e5dfa9574be1df9
Author: zhangli 270309613@qq.com
Date: Wed Jun 8 20:20:46 2022 +0800

支持filter_index

commit ee780a5d4fc9de618ca65f49fac8b9b93622025b
Author: zhangli 270309613@qq.com
Date: Wed Jun 8 17:44:45 2022 +0800

parseddl 修改参数为zcbusddldto

commit b1315800e1439874071ec15b289a348e3f89d347
Author: zhangli 270309613@qq.com
Date: Wed Jun 8 12:09:12 2022 +0800

支持YASHANDB ddl翻译

commit aca09052ac9354f8a0b6dde60e49fb08d9cc04ec
Author: zhangli 270309613@qq.com
Date: Sat Jun 4 22:50:32 2022 +0800

索引增加約束

commit b3f9ff9498eae1d8d0dfd0a0c32df1c3f5c6e564
Author: zhangli 270309613@qq.com
Date: Sat Jun 4 07:41:37 2022 +0800

忽略大小写的问题

commit 25e208c6efca16991c3dd4d460f3741be4821bfd
Author: zhangli 270309613@qq.com
Date: Sat Jun 4 06:29:19 2022 +0800

hana 字典兼容支持

commit 6be8ae27e856175627735360c29a3d9d13ba2591
Author: zhangli 270309613@qq.com
Date: Fri Jun 3 12:33:16 2022 +0800

支持HANA入库操作

commit c680bb77b8794c44abb9d65436f78fba6f18748a
Author: zhangli 270309613@qq.com
Date: Mon Apr 18 07:02:30 2022 +0800

postgresql 类型适配bug

commit 57dd5dfb8d361e813d0e51d37b6494232c91b5b9
Author: zhangli 270309613@qq.com
Date: Wed Mar 23 15:41:18 2022 +0800

默认值中含有-，仅含有-，isnumber函数判断出现问题，已经处理

commit 2e4cccc1230a0a04d560c0c4db4e36b316d539d7
Author: zhangli 270309613@qq.com
Date: Wed Mar 23 14:55:15 2022 +0800

mysql oracle 注释单引号问题

commit d16b5c377ed3c8007081c857b89a3bab6f242346
Author: zhangli 270309613@qq.com
Date: Tue Mar 22 16:42:22 2022 +0800

处理默认值含有字符串问题

commit 89f5bc82a94fa338c536ab673feaf855ea7a0a0a
Author: zhangli 270309613@qq.com
Date: Mon Mar 21 13:59:52 2022 +0800

解析mysql列，长度描述含有空格的问题

commit 1b2d5d8818a8cafdce514091696a8336790e9b6f
Author: zhangli 270309613@qq.com
Date: Mon Mar 21 13:26:43 2022 +0800

ORACLE varchar2 列長度超過Oracle长度限制字節之後，自動為Oracle字符串长度上线为限制，不在增加

commit 61753dbaf7178f0128874880dcd6c65a330b8530
Author: zhangli 270309613@qq.com
Date: Thu Mar 17 00:43:05 2022 +0800

兼容老版本ParseDDLSQL版本

commit 4eaf2efe10d35751de913c7049cdfcdba02e63ce
Author: zhangli 270309613@qq.com
Date: Thu Mar 17 00:31:02 2022 +0800

DDL翻译，同类型数据库，修改用户名，表名

commit d6079bfc7f1e3aec0f224337eca8cdbd77d4649c
Author: zhangli 270309613@qq.com
Date: Fri Mar 11 13:40:38 2022 +0800

增加检查ZcbusDDLDto对象

commit 2f2f4a5165a2c6cf9772743bc9871653de9d676e
Author: zhangli 270309613@qq.com
Date: Thu Mar 10 13:02:44 2022 +0800

alter table test add (aac decimal(18,2),bb int);
 alter table test add d int,drop column a,add c int;
 alter table test add ba decimal(18,2);
 alter table test add (ba decimal(18,2));
支持添加列多种组合模式

commit 142743b509b97b9e83cedebd8b98288a3c9b8f51
Author: zhangli 270309613@qq.com
Date: Thu Mar 10 13:00:51 2022 +0800

解决mysql日志解析，alter 操作中，一次添加多个列操作的SQL

例如:
alter table test add (aa decimal(18,2));

commit 4f69ef4bcd3b000ed67e5dc847bcb9d54617d60f
Author: zhangli 270309613@qq.com
Date: Tue Mar 8 04:31:49 2022 +0800

删除ORACLE列的过程中，遇到列存在约束上，则自动删除相关约束

commit aafe5a6b0a02f69e2f56381603b27f8767f6c704
Author: zhangli 270309613@qq.com
Date: Tue Mar 8 03:56:03 2022 +0800

默认值问题 ，如果不支持的默认值，则取消默认值设置

commit 89e9854092a40124a040752c22314fd5bdc07e84
Author: zhangli 270309613@qq.com
Date: Mon Mar 7 18:17:15 2022 +0800

commit 2d370d1fd6f14211009e4616c587150856b06b42
Author: zhangli 270309613@qq.com
Date: Sun Mar 6 10:19:31 2022 +0800

sqlserver 修改列，检查索引，主键约束等问题

commit 6f24a9094162e7344b78af95f036afbac4c2acaf
Author: zhangli 270309613@qq.com
Date: Thu Mar 3 12:42:19 2022 +0800

truncate partition方式，更新oracle判断逻辑，加工update global index 单独指定到ORACLE中


mysql> ALTER TABLE `zcbus01`.`bus_in_op_real_table_info` TRUNCATE
PARTITION P_1234  UPDATE GLOBAL INDEXES ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'UPDATE GLOBAL INDEXES' at line 1
mysql> ALTER TABLE `zcbus01`.`bus_in_op_real_table_info` TRUNCATE
PARTITION P_1234   ;
Query OK, 0 rows affected (0.02 sec)

commit 4674ea1ff377d86c122da6b89f346ad2c309c0aa
Author: zhangli 270309613@qq.com
Date: Thu Mar 3 12:32:55 2022 +0800

mysql 创建表，表级COMMENT 需要在partation前面

commit 7fd300a209303b6b7c75d63a1e28654d2c7acfa8
Author: zhangli 270309613@qq.com
Date: Fri Feb 25 17:43:40 2022 +0800

解决单引号内含有--等信息

commit 7b80645c5e5651dedb06a79b286e6d13c1436dac
Author: changzhiang changzhiang@shuidihuzhu.com
Date: Tue Jan 11 23:01:31 2022 +0800

修改maven打包版本

commit 013f6a01149d5966093da4289153122e458572ff
Merge: 68efbef ae7b3cf
Author: zhangli 270309613@qq.com
Date: Sun Jan 9 17:16:32 2022 +0800

format

commit a7f0549cc473ea00693e3320ec2ad12d1c665a97
Author: zhangli 270309613@qq.com
Date: Sun Jul 11 20:39:51 2021 +0800

v20210711

commit f3d7072159ccb1e81ad7501ef8037ad783cff9e7
Author: zhangli 270309613@qq.com
Date: Sat Jul 3 10:34:09 2021 +0800

POSTGRESQL sql优化

commit 3f0e8720aa63f666bec6e574773892dce413aca6
Author: zhangli 270309613@qq.com
Date: Fri Jul 2 11:47:19 2021 +0800

pg 升级sql使用pg_开头的表，不再使用information_schema下的表

commit d88cb2d7dc8d367eef57a70da5863bf94d80c084
Author: zhangli 270309613@qq.com
Date: Wed Jun 30 08:45:11 2021 +0800

移動java 對象位置

commit adf98e8e772c38b8d02a171347da103b29d36157
Author: zhangli 270309613@qq.com
Date: Tue Jun 29 20:23:07 2021 +0800

pg 刪除約束，SQL 拆分為約束索引兩種方式

commit 019397719b1695fbbcd1009ca70f582dce66c628
Author: zhangli 270309613@qq.com
Date: Sun Jun 27 22:51:48 2021 +0800

mysql synctype exp 多用戶，多表

commit 9693d68031caf9ef1aec116d11a5e65f2a1571c4
Author: zhangli 270309613@qq.com
Date: Sun Jun 27 21:25:01 2021 +0800

synctable 兼容操作

commit 0ba7c941c1483db416006b5cbcaef993ab6a9164
Author: zhangli 270309613@qq.com
Date: Sun Jun 27 17:26:52 2021 +0800

兼容restapi版本

commit b704aafaee71f179ec3a62a730f31f2f9abfa8cf
Author: zhangli 270309613@qq.com
Date: Wed Jun 16 15:20:00 2021 +0800

postgresql 部分sql优化

commit c352902481c11d3e9d71f32a6a2730d10c960064
Author: zhangli 270309613@qq.com
Date: Fri Jun 11 15:19:07 2021 +0800

ddl 支持oceanbase-mysql/oracle格式类型

commit 868d4d86fc0d99607aaca7c671508f95017a6d3e
Author: zhangli 270309613@qq.com
Date: Tue Jun 8 08:39:36 2021 +0800

sqlserver 验证主键约束是否和表名一样，如果一致，则跳过

commit 3d30345da1b40bbc825a49beeb6a55d85f813e2f
Author: zhangli 270309613@qq.com
Date: Tue Jun 8 05:41:06 2021 +0800

sqlserver 主键、唯一键、索引与表名重名的问题

commit 25d1767668d9ffce7d371cdc79f74317a81bf806
Author: zhangli 270309613@qq.com
Date: Sat Jun 5 10:49:36 2021 +0800

解析sqlserver 关键字取消问题

commit 13a3026c27006c137450cb8c0f709a5db9d5c98c
Author: zhangli 270309613@qq.com
Date: Thu Jun 3 20:41:24 2021 +0800

特殊字段异常处理机制

commit 296ba4a3adeb84e4947c2fe4b4a3995183586ee8
Author: zhangli 270309613@qq.com
Date: Tue Jun 1 18:15:02 2021 +0800

MYSQL CHAR(0) VARCHAR(0) 问题长度默认改成1

commit c4a2b6e272f10ca30731d89ad9bcb5c6d8bd8f45
Author: zhangli 270309613@qq.com
Date: Sun May 30 15:05:32 2021 +0800

ZCBUS_TARGET_OPTIME  增加验证，0 不增加 1增加，默认列名ZCBUS_TARGET_OPTIME,如果设置为0,1
之外的字符串，则字符串为列名
ZCBUS_SOURCE_OPTIME  增加验证，0 不增加 1增加，默认列名ZCBUS_SOURCE_OPTIME,如果设置为0,1
之外的字符串，则字符串为列名
ZCBUS_SOURCE_OPTYPE  增加验证，0 不增加 1增加，默认列名ZCBUS_SOURCE_OPTYPE,如果设置为0,1
之外的字符串，则字符串为列名
ZCBUS_INSERT_OPTIME  增加验证，0 不增加 1增加，默认列名ZCBUS_INSERT_OPTIME,如果设置为0,1
之外的字符串，则字符串为列名

commit d1067e896214bbe4d993534b715e66a49bf509ba
Author: zhangli 270309613@qq.com
Date: Tue May 25 05:42:28 2021 +0800

创建表结构，分区结构中，返回null，修改为返回''

commit 00672cd873dcdb10d6ac8ec1e4bc523dd289d977
Author: zhangli 270309613@qq.com
Date: Wed May 19 08:39:57 2021 +0800

修改-addcol 四个参数
source_part   数据来源【可以支持多个字段】
             DEMO:
             1、仅输入一个字符串
                        则为数据来源字符串，此时针对ORACLE/MYSQL可以自动进行分区，字段名为ZCBUS_SOURCE_PART
             2、输入多个列名
                        如果多列，或者列名自定义可以使用列名:值方式拼接字段，","号隔开即可。
                col1:col1dt,col2:col2dt两列，此时DDL不支持分区，仅需要增加两列，默认字符串列长度为VARCHAR2/VARCHAR(40)
source_time   源数据commit时间   字段名为：ZCBUS_SOURCE_OPTIME
source_type   源端最后操作时间   字段名为：ZCBUS_SOURCE_OPTYPE
target_time   目标最后操作时间   字段名为：ZCBUS_TARGET_OPTIME
insert_time   目标端入库时间     字段名为：ZCBUS_INSERT_OPTIME

commit 996f8d74cc74d80a556685790bb64ff3c7bfbe7a
Author: zhangli 270309613@qq.com
Date: Mon May 17 08:26:05 2021 +0800

增加索引名字檢查，重複索引名字，自動改名

commit 34c0f2ca54a8d81dccee36c77fb6463373b135ed
Author: zhangli 270309613@qq.com
Date: Sun May 16 11:01:48 2021 +0800

约束判断调整   解决检查约束为空的问题

commit 7914a28e7fa9a6307ff90271b1c49c3fde8db12e
Author: zhangli 270309613@qq.com
Date: Sun May 16 06:17:44 2021 +0800

修复索引中含有_下划线开头的索引名，自动将索引名翻译成ZCBUS自动索引，适配到不同的数据库中

commit 4e2c9bcc5f2341c7ed07396c099c83e3334fdf6c
Author: zhangli 270309613@qq.com
Date: Sat May 15 09:01:05 2021 +0800

创建索引，遇到名字过长的时候，ORACLE数据库限制为30个字节，超过30个字节，自动翻译为zcbus索引名字

commit 7e982be9cfc7f8cb35ebd0284319d7f255a64f7f
Author: zhangli 270309613@qq.com
Date: Thu May 13 09:51:24 2021 +0800

解析ORACLE刪除列操作中，針對

                listsql.add("ALTER TABLE \"USER\".\"TB01\" DROP (\"F1\");\r\n");
                listsql.add("ALTER TABLE \"USER\".\"TB01\" DROP (\"F1\",F2);\r\n");
                中格式的操作

commit 708d5a7d121028cab2ddaaa7de03c54c25df917d
Author: zhangli 270309613@qq.com
Date: Mon May 10 19:43:21 2021 +0800

//              String sql="SELECT 1 id FROM sys.tables AS tbl INNER JOIN
sys.indexes AS i "
//                              + "ON (i.index_id > 0 and i.is_hypothetical = 0) AND
(i.object_id=tbl.object_id) "
//                              + "WHERE (i.is_primary_key + 2*i.is_unique_constraint=2) and
SCHEMA_NAME(tbl.schema_id)='"+tableSchema+"' "
//                              + "and tbl.name='"+tableName+"'and i.name='"+indexName+"'";

判断约束sql升级为：

                String sql="select 1 from sys.key_constraints where
parent_object_id=object_id('"+tableSchema.trim()+"."+tableName+"') and
name = '"+indexName+"' and type in ('PK','UQ')";

commit 5ae54258369a5cab565093379556d997008df8ae
Author: zhangli 270309613@qq.com
Date: Tue May 4 16:38:14 2021 +0800

parse select 操作

commit 9894f2f4358d9d75f42a1ebc88e335125e3dd2f7
Author: zhangli 270309613@qq.com
Date: Tue May 4 05:59:22 2021 +0800

增加SELECT 解析兼容，为多表关联提供基础SQL服务

commit bf5dc2a749f36aac4c543bfe9cf9fc27b49177e0
Author: zhangli 270309613@qq.com
Date: Thu Apr 29 17:34:47 2021 +0800

mysql int 类型default 为空的情况下，默认即为空

commit 9b75294bbd0b2d8bef1938d087d9f066e536662a
Author: zhangli 270309613@qq.com
Date: Wed Apr 28 15:30:28 2021 +0800

1、创建表解析constraint关键字后，添加消除特殊符号功能
2、mysql/oracle按照列检查索引的问题

commit 1e19e433e3c86041442c73dc8fd9990b72e4bb3a
Author: zhangli 270309613@qq.com
Date: Tue Apr 27 22:39:15 2021 +0800

修复mysql/ORACLE 索引按列检查，符合索引和普通索引中都含有需要检查的列，造成的查列问题

commit c550604c7dbd13e2e7e33cdf56ebd6a52a1b4983
Author: zhangli 270309613@qq.com
Date: Sun Apr 25 23:37:23 2021 +0800

添加mysql表级别的描述

commit da004976074d1215c05bec234ab9c8361af9d99c
Author: zhangli 270309613@qq.com
Date: Sat Apr 24 08:13:16 2021 +0800

写文件强制转换成UTF8字符集

commit b38bf61f96c30ec8ba6e55f30aaa0935f13d4a75
Author: zhangli 270309613@qq.com
Date: Sat Apr 24 07:39:28 2021 +0800

索引翻译默认不自动改名字

commit 977f1200b7fe57a030cec2d72238900d7d4e77fb
Author: zhangli 270309613@qq.com
Date: Sat Apr 17 22:02:26 2021 +0800

SYBASE 字典回查，约束，索引缺少案列查询

commit 8b864bddca75803b876627f9055b96f479a824b4
Author: zhangli 270309613@qq.com
Date: Tue Apr 13 12:01:41 2021 +0800

1、密码中含有特殊字符的问题
2、在每次启动，判断是否存在zbomc_sys_index_01的表，不存在则先创建。

commit c49ae90ff128b1e12f4f3956b577768fe335250a
Author: zhangli 270309613@qq.com
Date: Tue Apr 6 22:38:04 2021 +0800

MYSQL注释中含有单引号的问题

commit 68fdd362421dcd0520c970309b614390c1b58895
Author: zhangli 270309613@qq.com
Date: Mon Apr 5 13:41:54 2021 +0800

解析MYSQL 注释中，多个单引号的问题

commit 3e2ea6c69d68fbf3d29a21fa2d64b359d924c45a
Author: zhangli 270309613@qq.com
Date: Wed Mar 24 10:07:35 2021 +0800

追加文件，处理追加内容为空值的问题

commit c1e766e6c711c35e97275746a2e82df92c3b3398
Author: zhangli 270309613@qq.com
Date: Wed Mar 24 07:44:56 2021 +0800

mysql alter table modify 注釋丟失問題

commit c095ffba8a4154c2f73979ce6109e8c9889f4b7c
Author: zhangli 270309613@qq.com
Date: Tue Mar 16 08:00:59 2021 +0800

针对ZCBUSDDLSDK支持WEB DDL转换调用

commit 5c5464fa6b2939c0c6ea62f765fe04ca384c6612
Author: zhangli 270309613@qq.com
Date: Sun Mar 14 10:51:54 2021 +0800

支持web sdk ddl表结构获取以及翻译过程

commit a77edb56ef27bef4dc1664a4fb2e3e64f6251be8
Author: zhangli 270309613@qq.com
Date: Tue Mar 9 18:14:41 2021 +0800

时间类型翻译为SQLSERVER的时候，在2008以前，为datetime，2008以后，翻译为datetime2

commit 3d3a7000383cf84de8aa218d02f0640e64aae0c2
Author: zhangli 270309613@qq.com
Date: Sun Mar 7 21:06:22 2021 +0800

修改-add_col类型，增加source_part后边的值，支持了列名修改
source_part=colname:colvalue模式，将新加列名改成colname，可自定义

commit eeb4dd402a24ce419b7c36a58ff3e526500723ca
Author: zhangli 270309613@qq.com
Date: Wed Mar 3 17:49:09 2021 +0800

postgresql create table 取消unlogged屬性

commit 87b693d75f57fa8bdf1f5ee3c9cb46af70942e34
Author: zhangli 270309613@qq.com
Date: Wed Feb 24 07:50:58 2021 +0800

mysql ,deal alter drop primary key ,then first deal cancel properties
for auto_increment

commit 97f883d5521e342f1177cdd145f35198b1118f56
Author: zhangli 270309613@qq.com
Date: Sun Feb 21 18:15:15 2021 +0800

20210221

commit debc6af8ea2722550d676e5fbe060689e7e846d3
Author: zhangli 270309613@qq.com
Date: Fri Feb 19 19:38:51 2021 +0800

DB2 CHAR类型分析，空格位置需要将charpoint重置为0

commit 95e1ec369648f109e7b4f6a2578bcd6e47f8babc
Author: zhangli 270309613@qq.com
Date: Thu Feb 18 10:14:50 2021 +0800

mysql - postgresql/sqlserver 创建唯一键，由alter操作修改成create unique 操作

commit 7ff35fb74e956486cdb34d13539c63aad4bcc181
Author: zhangli 270309613@qq.com
Date: Wed Feb 10 21:26:01 2021 +0800

DB2 DDL字典查询更新

commit d6040de36048a6c4dbfc840fcfbf04f14ea45b30
Author: zhangli 270309613@qq.com
Date: Wed Feb 10 15:07:34 2021 +0800

解决了DB2初始解析遇到的一些bug

db2生成SQL      问题描述
"DROP TABLE test.test1
REORG TABLE test.test1"
"CREATE TABLE test.test1 (id integer NOT NULL ,name varchar(100) NOT
NULL ,add varchar(1000) )
ALTER TABLE test.test1 ADD PRIMARY KEY (id,name)
REORG TABLE test.test1"
"ALTER TABLE test.test1 ADD  col char(10)
REORG TABLE test.test1"
"ALTER TABLE test.test1 ALTER COLUMN  col SET DATA TYPE varchar(32)
REORG TABLE test.test1"
"Not Support sql : REORG TABLE test.test1
REORG TABLE test.test1" REORG语句暂时不支持
"ALTER TABLE test.test1 DROP COLUMN col
REORG TABLE test.test1"
"ALTER TABLE test.test1 ADD UNIQUE (id,name)
REORG TABLE test.test1" 没有查询约束是否存在
"ALTER TABLE test.test1 ADD CONSTRAINT  uk_test1 UNIQUE (id,name)
REORG TABLE test.test1" 没有查询约束是否存在
"生成语句失败，DDLParseMain.jar程序抛出异常
改完后：
ALTER TABLE test.test1 DROP UNIQUE uk_test1
REORG TABLE test.test1" "[2021-02-10 09:01:28,687] [main]
(ParseDDLSQL.java:113) WARN  - [ parse sql  ALTER TABLE test.test1 DROP
UNIQUE uk_test1 failed ...  ]
Exception in thread ""main"" java.lang.NullPointerException
 at com.zcbus.sql.ddlv2.parse.ParseDDLSQL.ParseDDLSqlV2(ParseDDLSQL.java:251)
 at com.zcbus.sql.ddlv2.parse.ParseDDLSQL.ParseDDLSql(ParseDDLSQL.java:36)
 at com.demo.DDLParseMain.ParseSigDDL(DDLParseMain.java:395)
 at com.demo.DDLParseMain.ParseParameter(DDLParseMain.java:324)
 at com.demo.DDLParseMain.<init>(DDLParseMain.java:35)
 at com.demo.DDLParseMain.main(DDLParseMain.java:39)
改完后问题：
没有查询约束是否存在"
"ALTER TABLE test.test1 ADD PRIMARY KEY(id,name)
REORG TABLE test.test1" 没有查询约束是否存在
"ALTER TABLE test.test1 ADD CONSTRAINT pk_test1 PRIMARY KEY(id,name)
REORG TABLE test.test1" 没有查询约束是否存在
"生成语句失败，DDLParseMain.jar程序抛出异常
改完后：
ALTER TABLE test.test1 DROP PRIMARY KEY
REORG TABLE test.test1" "[2021-02-10 09:03:21,498] [main]
(ParseDDLSQL.java:113) WARN  - [ parse sql  ALTER TABLE test.test1 DROP
PRIMARY KEY failed ...  ]
Exception in thread ""main"" java.lang.NullPointerException
 at com.zcbus.sql.ddlv2.parse.ParseDDLSQL.ParseDDLSqlV2(ParseDDLSQL.java:251)
 at com.zcbus.sql.ddlv2.parse.ParseDDLSQL.ParseDDLSql(ParseDDLSQL.java:36)
 at com.demo.DDLParseMain.ParseSigDDL(DDLParseMain.java:395)
 at com.demo.DDLParseMain.ParseParameter(DDLParseMain.java:324)
 at com.demo.DDLParseMain.<init>(DDLParseMain.java:35)
 at com.demo.DDLParseMain.main(DDLParseMain.java:39)
改完后问题：
没有查询约束是否存在"
"ALTER TABLE test.test1 ADD CHECK ( id<10)
REORG TABLE test.test1" 没有查询约束是否存在
"ALTER TABLE test.test1 ADD CONSTRAINT  ck_test1 CHECK ( id<10)
REORG TABLE test.test1" 没有查询约束是否存在
"DDLParseMain.jar程序跳过
改完后：
CREATE INDEX idx_zcbus_Go438EkmJgmR1RD ON test.test1 (id,name)
REORG TABLE test.test1" "[2021-02-10 09:18:13,590] [main]
(DbCommon.java:53) INFO  - [ test connect sucessfull... ]
[2021-02-10 09:18:13,598] [main] (DDLParseMain.java:302) INFO  - [ ifuse
zcbus idx :true ]
[2021-02-10 09:18:13,599] [main] (OperDbDict.java:367) INFO  - [ Check
dbtype db2 table test.zcbus_sys_index_01 if exists  ]
[2021-02-10 09:18:13,677] [main] (OperDbDict.java:403) INFO  - [  TABLE
test.zcbus_sys_index_01 exists !!!! ]
[2021-02-10 09:18:13,703] [main] (OperDbDict.java:514) INFO  - [ TABLE
test.test1 index idx_zcbus_hWZmb4acb4PfAif Not exists !!!! ]
[2021-02-10 09:18:13,757] [main] (DDLParseMain.java:411) INFO  - [
SKIP_DDL ]
[2021-02-10 09:18:13,758] [main] (DDLParseMain.java:414) INFO  - [ Save
sql [SKIP_DDL] to ddl.sql...  ]
改完后问题：
索引名需要指定SCHEMA名"
"drop index语句暂时不支持
改完后：
生成语句失败，DDLParseMain.jar程序抛出异常"     "[2021-02-10 09:19:54,401] [main]
(DDLAlterAdapter.java:161) INFO  - [ Not Support this database type for
3 ...  ]
[2021-02-10 09:19:54,402] [main] (DDLParseMain.java:411) INFO  - [  ]
[2021-02-10 09:19:54,402] [main] (DDLParseMain.java:414) INFO  - [ Save
sql [] to ddl.sql...  ]
[2021-02-10 09:19:54,403] [main] (DDLParseMain.java:411) INFO  - [ REORG
TABLE test.test1 ]
[2021-02-10 09:19:54,403] [main] (DDLParseMain.java:414) INFO  - [ Save
sql [REORG TABLE test.test1] to ddl.sql...  ]
改完后异常报错：
[2021-02-10 11:52:00,614] [main] (DDLParseMain.java:411) INFO  - [ DROP
INDEX test.idx_test  ]
[2021-02-10 11:52:00,615] [main] (TargetDatabaseSql.java:236) INFO  - [
test.idx_tes...  ]
Exception in thread ""main"" java.lang.NullPointerException
 at com.zcbus.DataBus.dbDict.OperDB2TableInfo.ifExistsConstraint(OperDB2TableInfo.java:407)
 at com.zcbus.DataBus.dbDict.OperDbDict.CheckConstraint(OperDbDict.java:583)
 at com.zcbus.Caches.TargetDatabaseSql.CheckAfterSql(TargetDatabaseSql.java:237)
 at com.demo.DDLParseMain.DealAfterSql(DDLParseMain.java:412)
 at com.demo.DDLParseMain.ParseSigDDL(DDLParseMain.java:403)
 at com.demo.DDLParseMain.ParseParameter(DDLParseMain.java:324)
 at com.demo.DDLParseMain.<init>(DDLParseMain.java:35)
 at com.demo.DDLParseMain.main(DDLParseMain.java:39)"
"ALTER TABLE test.test1 ADD UNIQUE INDEX u_idx_test1 ( id,name )
REORG TABLE test.test1
改完后：
CREATE UNIQUE INDEX idx_zcbus_1xNO9xkzTqbhSuY ON test.test1 (id,name)
REORG TABLE test.test1" "创建唯一索引语法错误
改完后问题：
索引名需要指定SCHEMA名"
"drop index语句暂时不支持
改完后：
生成语句失败，DDLParseMain.jar程序抛出异常"     "[2021-02-10 09:19:54,401] [main]
(DDLAlterAdapter.java:161) INFO  - [ Not Support this database type for
3 ...  ]
[2021-02-10 09:19:54,402] [main] (DDLParseMain.java:411) INFO  - [  ]
[2021-02-10 09:19:54,402] [main] (DDLParseMain.java:414) INFO  - [ Save
sql [] to ddl.sql...  ]
[2021-02-10 09:19:54,403] [main] (DDLParseMain.java:411) INFO  - [ REORG
TABLE test.test1 ]
[2021-02-10 09:19:54,403] [main] (DDLParseMain.java:414) INFO  - [ Save
sql [REORG TABLE test.test1] to ddl.sql...  ]
改完后异常报错：
[2021-02-10 11:52:00,614] [main] (DDLParseMain.java:411) INFO  - [ DROP
INDEX test.idx_test  ]
[2021-02-10 11:52:00,615] [main] (TargetDatabaseSql.java:236) INFO  - [
test.idx_tes...  ]
Exception in thread ""main"" java.lang.NullPointerException
 at com.zcbus.DataBus.dbDict.OperDB2TableInfo.ifExistsConstraint(OperDB2TableInfo.java:407)
 at com.zcbus.DataBus.dbDict.OperDbDict.CheckConstraint(OperDbDict.java:583)
 at com.zcbus.Caches.TargetDatabaseSql.CheckAfterSql(TargetDatabaseSql.java:237)
 at com.demo.DDLParseMain.DealAfterSql(DDLParseMain.java:412)
 at com.demo.DDLParseMain.ParseSigDDL(DDLParseMain.java:403)
 at com.demo.DDLParseMain.ParseParameter(DDLParseMain.java:324)
 at com.demo.DDLParseMain.<init>(DDLParseMain.java:35)
 at com.demo.DDLParseMain.main(DDLParseMain.java:39)"

commit 90762f00cbb4dc702b40d3ccf37cf9d8ebf0487e
Author: zhangli 270309613@qq.com
Date: Tue Feb 9 09:26:59 2021 +0800

支持DB2 DDL sql解析和DDL sql应用
支持DDL数据字典查询

commit 1d72628188c1db93a37b198ccf66de7ab53162e2
Author: Administrator <Administrator@SC-202012061032>
Date: Sun Feb 7 17:35:58 2021 +0800

支持解析Oracle類型中VARCHAR(30 CHAR)類型

commit f743d190db9f265fc7335c37b1591f7b3f72a07a
Author: Administrator <Administrator@SC-202012061032>
Date: Fri Feb 5 23:37:46 2021 +0800

oracle default 值中含有函数，将过滤default值

commit 6698235bf0bff7cb4dc35e16985ba2b723ff81f4
Author: Administrator <Administrator@SC-202012061032>
Date: Fri Feb 5 13:52:50 2021 +0800

ParseBasicSql getsqltype中，增加SHOW/SET/MERGE/WITH几种类型

commit 2e60bd6e0fa7850a77ad298137ce798b309d11dc
Author: Administrator <Administrator@SC-202012061032>
Date: Thu Jan 28 08:48:38 2021 +0800

oracle 删除索引，解析bug
删除索引，操作增加是否是约束，如果是约束则按照约束删除，如果是索引，按照索引删除

commit 42c79fe6a0eea93e81945c0bb4b3c1735370ca85
Author: Administrator <Administrator@SC-202012061032>
Date: Wed Jan 6 08:40:58 2021 +0800

支持SQL类型解析返回
        ArrayList<String> sqllist = new ArrayList<>();
                sqllist.add("insert into ");
                sqllist.add("update abc ");
                sqllist.add("delete from  ");
                sqllist.add("select * from ");
                sqllist.add("alter table ");
                sqllist.add("drop table ");
                sqllist.add("truncate table ");
                sqllist.add("create table ");
                ParseBasicSql parseBasicSql = new ParseBasicSql();
                for (int i = 0; i < sqllist.size(); i++) {
                        System.out
                                        .println(parseBasicSql.GetSqlType(sqllist.get(i)) + ":" +
parseBasicSql.GetOpType(sqllist.get(i)));
                }

commit e71e54b26a8d143976932e0e0b16066eb1e56ba0
Author: Administrator <Administrator@SC-202012061032>
Date: Wed Jan 6 08:38:49 2021 +0800

支持 SQL類型解析
        ArrayList<String> sqllist = new ArrayList<>();
                sqllist.add("insert into ");
                sqllist.add("update abc ");
                sqllist.add("delete from  ");
                sqllist.add("select * from ");
                sqllist.add("alter table ");
                sqllist.add("drop table ");
                sqllist.add("truncate table ");
                sqllist.add("create table ");
                ParseBasicSql parseBasicSql = new ParseBasicSql();
                for (int i = 0; i < sqllist.size(); i++) {
                        System.out
                                        .println(parseBasicSql.GetSqlType(sqllist.get(i)) + ":" +
parseBasicSql.GetOpType(sqllist.get(i)));
                }

commit 63bfc95dea0082551f25e67ee08186fb3092b1e0
Author: Administrator <Administrator@SC-202012061032>
Date: Tue Jan 5 17:05:24 2021 +0800

调整添加主键操作，在合成过程中，由原来的先判断处理索引，修改为先处理约束，在处理索引。

commit 27f3df836ff12adf7e4d156f63efdf4746e3b558
Author: Administrator <Administrator@SC-202012061032>
Date: Tue Jan 5 15:51:00 2021 +0800

test

commit f661db16eb5042f244ad1a5d957c6fa9575bf251
Author: Administrator <Administrator@SC-202012061032>
Date: Tue Jan 5 15:49:28 2021 +0800

修改索引辅助表创建，翻译过程中，元表结构采用原数据库类型，后改称mysql数据类型

commit c39a66f326ce9e6f553000cfe6017a0b89b5d1c9
Author: zhangli zhangli@zbomc.com
Date: Thu Dec 31 10:02:17 2020 +0800

pg/oracle/sqlserver 增加删除约束和删除索引区别的sql

commit db7d0c7086332801137b092769b29ffbe9b556dd
Author: zhangli zhangli@zbomc.com
Date: Fri Dec 25 12:32:17 2020 +0800

2020/12/25 修改oracle 床架表的时候，optype=='modify' 中，optype为空的情况

commit f04087da00038c2ad769db1bf00d678e79371a30
Author: zhangli zhangli@zbomc.com
Date: Tue Dec 22 19:07:00 2020 +0800

mysql modify修改列，注释和modify形成了两次sql修改，第二次修改按照目标端条件修改，容易造成长度改回去操作，已经修复。

commit 758ca0037b0aa40050b409ea98d03ba86e44ad08
Author: zhangli zhangli@zbomc.com
Date: Mon Dec 21 22:23:04 2020 +0800

1、ORACLE 删除列操作，列名关键字取消特殊符号
2、POSTGRRES 删除列操作，列名关键字取消特殊符号
3、MYSQL 修复ALTER DROP COLUMN/ADD COLUMN同一列名。校验过程中，ADD增加忽略列名处理操作

commit 60366db4ff29cd5c674307bf1ea63b97c4fb21d1
Author: zhangli zhangli@zbomc.com
Date: Mon Dec 21 13:25:57 2020 +0800

SQLSERVER/postgresql 按照列检索索引是否存在的sql BUG

解析DROP INDEX ON TAB 支持

commit 90d8e5f6ce9a5e59509b2cb206eae51cb66441eb
Author: zhangli zhangli@zbomc.com
Date: Sat Dec 19 20:34:25 2020 +0800

alter table modify clobcol clob [oracle处理问题，这时候过滤修改列操作权限]

commit 85b2fda46f27d0a882e3512125fc63a77c422e6f
Author: zhangli zhangli@zbomc.com
Date: Mon Dec 7 22:06:11 2020 +0800

sybase/sybaseiq column 部分信息补齐功能【数据查询】

commit 7eefca743e280ac75ef95e460cafdffa5646d04b
Author: zhangli zhangli@zbomc.com
Date: Thu Dec 3 20:23:14 2020 +0800

支持sybase 按照列查询索引信息

commit f3d3960c542349bcd52afcc847bbba3b3ed0728a
Author: zhangli zhangli@zbomc.com
Date: Thu Dec 3 11:32:32 2020 +0800

支持sybaseiq/kingbase數據庫

commit 9ddc7356ec33fa6c5631458d0ec49d4f4086d4d1
Author: zhangli zhangli@zbomc.com
Date: Sun Nov 29 21:38:32 2020 +0800

mysql - oracle char类型，长度不变
               ZHS16GBK字符集 varchar类型 *2倍
               UTF8字符集        varchar类型 *3倍

commit 6be67cfa92939fb1f074ceb6c8c7c6bfedc617f2
Author: zhangli zhangli@zbomc.com
Date: Tue Nov 24 08:43:56 2020 +0800

ifchangedll标签改成ifchangeddl

commit 015c3023fdd4c7608e208ea414da28ff93e62be5
Author: zhangli zhangli@zbomc.com
Date: Thu Nov 19 10:18:53 2020 +0800

oracle comment 中，列信息，含有双引号，处理双引号的问题，BUG已经解决

commit 9f45794a0cd3c44f6d57bcf65fb56eaab35b3ecf
Author: zhangli zhangli@zbomc.com
Date: Mon Nov 16 17:31:31 2020 +0800

mysql - oracle 转换过程中， date数据类型默认值取消

commit 9a1e1d43496de792ac75016891fd77edab270553
Author: zhangli zhangli@zbomc.com
Date: Wed Nov 11 16:27:56 2020 +0800

sybase 中 浮点数，长度为空，报异常问题
sybase 应用字段名、用户名、表名中，支持[]括起来

commit 5590d38eb781b2360db39f8783851e06bb28e70d
Author: zhangli zhangli@zbomc.com
Date: Sun Nov 1 11:07:44 2020 +0800

mysql - > sqlserver
转换过程中，varchar翻倍，如果超过4000字节长度，总长度不超过8000，如果初始长度，超过8000，则自动转成text类型

commit c391501468f4789aa6743146d18f5a1cfb317909
Author: zhangli zhangli@zbomc.com
Date: Sun Nov 1 11:02:04 2020 +0800

mysql - > sqlserver
转换过程中，varchar翻倍，如果超过2000字节长度，总长度不超过4000，如果初始长度，超过4000，则自动转成text类型

commit bc58f314692246a094112022bb2f42c955c60ab9
Author: zhangli zhangli@zbomc.com
Date: Wed Oct 21 03:18:07 2020 +0800

postgresql alter  匹配列增加integer支持
              解决datatype为空的异常问题

commit 240df9c06d295ccf3698f7b59a2709f6e4c69901
Author: zhangli zhangli@zbomc.com
Date: Tue Oct 20 08:20:44 2020 +0800

oracle/mysql/sybase 删除主键的支持

commit e0d084224061dd17ea7b342a75628213e2de4ada
Author: zhangli zhangli@zbomc.com
Date: Tue Oct 13 22:07:18 2020 +0800

原来版本NCHAR/NVARCHAR转为VARCHAR。以及修正为
NVARCHAR/NCHAR转到NVARCHAR/NCHAR类型，mysql仍然为VARCHAR类型

commit 357e6123831389f8f09555f7c65ff22c2d749be0
Author: zhangli zhangli@zbomc.com
Date: Sun Oct 11 21:54:24 2020 +0800

postgresql 字段细节转换问题

commit 50fd384e2ea76160d913171e62c1e67ed52af1fc
Author: zhangli zhangli@zbomc.com
Date: Tue Oct 6 11:20:01 2020 +0800

sqlserver -> zcbus -> sqlserver 类型优化
datetime2 -> timestamp -> datetime2
datetime  -> datetime  -> datetime

commit ae9c4fa994abc962a85260096825c808e0f2d782
Author: zhangli zhangli@zbomc.com
Date: Mon Oct 5 22:44:00 2020 +0800

sybase 列为空的时候，自动设置位null

commit 49d50a4212b41e7dbeda716e4eaa622e250c4951
Author: zhangli zhangli@zbomc.com
Date: Mon Oct 5 16:05:50 2020 +0800

sqlserver - mysql time> time(3)
sqlserver - oracle time > varchar(20)

commit 94a348969e1bf812331c64dafe1bf982f89dc1e1
Author: zhangli zhangli@zbomc.com
Date: Mon Oct 5 12:34:46 2020 +0800

sqlserver -> mysql  time->time(3)
                    real->double

commit 47bdd7cd890434f3716035fbc75dee8ff6aae0c3
Author: zhangli zhangli@zbomc.com
Date: Wed Sep 30 22:45:12 2020 +0800

sqlserver 列中，支持类型使用[]符号括起来

commit c65b36384002ea24db89da367020e75e9f3aa84c
Author: zhangli zhangli@zbomc.com
Date: Wed Sep 30 13:10:14 2020 +0800

SYBASE
select indid from sysindexes where id=object_id('dbo.test_string') and (
status&2048=2048 || status&2=2 ) and name='con_zcbus_KxSIqyOLUqoEATj'
改成
select indid from sysindexes where id=object_id('dbo.test_string') and (
status&2048=2048 or status&2=2 ) and name='con_zcbus_KxSIqyOLUqoEATj'

commit a4aed5ad31fea746e93219048201d385786020d5
Author: zhangli zhangli@zbomc.com
Date: Tue Sep 29 13:50:12 2020 +0800

针对MYSQL创建表的sql 索引约束合并问题
如果含有主键、约束、索引中，含有列是一样的问题，软件会根据主键>约束>索引的权限情况下，优先创建，多余的对象，将自动忽略，

commit ccbf491c8fbfd825cce639c75209ebe0c39f25f4
Author: zhangli zhangli@zbomc.com
Date: Mon Sep 28 21:07:28 2020 +0800

zcbus to sybase [date\time]類型轉換
postgresql comment sql中，列有大小轉成實際大小寫

commit 5b25405ab5368eb8428a53138d84db81d2b27dbf
Author: zhangli zhangli@zbomc.com
Date: Sat Sep 26 20:26:27 2020 +0800

mysql binary/varbinary/blob 默认值设置为空
MYSQL -> ZCBUS 转换过程中,INT->DECIMAL改成INT->INTEGER类型

commit 18704fdd7c1958469f7a9a9f9a5e2a9f9c14f64a
Author: zhangli zhangli@zbomc.com
Date: Fri Sep 25 11:57:56 2020 +0800

修改sqlserver 视图获取方式

commit b792dd7a2e0d6d21ff21af47bf9a44506f902422
Author: zhangli zhangli@zbomc.com
Date: Thu Sep 24 14:40:35 2020 +0800

MYSQL/SQLSERVER/ORACLE 索引名中含有特殊关键字的问题，已经处理

commit eb12188bfd33af928b78cad8e7f654cf063d8c53
Author: zhangli zhangli@zbomc.com
Date: Mon Sep 21 21:32:23 2020 +0800

20200921

commit dc454a1086bd104132ebd933c0c8472f5b50e240
Author: zhangli zhangli@zbomc.com
Date: Fri Sep 18 23:34:28 2020 +0800

oracle sql中，integer列，轉換問題
字符串中，列含有特殊字符"-"處理

commit 1a9891b1e20ffbf800f75d8a86a3fec56d884788
Author: zhangli zhangli@zbomc.com
Date: Fri Sep 18 08:01:30 2020 +0800

for sync sqlserver/oracle produce/function/view

commit 68f9bb9369c7bd617b35f01ababcddf2fa0824fa
Author: zhangli zhangli@zbomc.com
Date: Mon Sep 14 12:47:04 2020 +0800

支持索引重命名的問題

commit eeafb53f54f741d06c196db827f515735213d001
Author: zhangli zhangli@zbomc.com
Date: Mon Sep 7 09:01:29 2020 +0800

多表合一分區方式支持，部分bug修復

commit 718257d93652a60dd44189133278fb03bd794f55
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 30 20:58:30 2020 +0800

20200830

commit 0ea68836696a5c437b338b9a93fa805ab0c9e99a
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 30 09:46:02 2020 +0800

mysql 合併分區創建表 語句bug

commit 117562e0d1b2eac044949c63f53550eed5edd87b
Author: zhangli zhangli@zbomc.com
Date: Sat Aug 29 03:19:36 2020 +0800

支持多表合一，分区功能

commit 1181246bc11af1aac32d9aba9cd011ae878340b2
Author: zhangli zhangli@zbomc.com
Date: Fri Aug 28 10:57:19 2020 +0800

ddl 列解析，修复

commit 721b05654efd0d5f6ddfe7a99d6a1f57f4fd7869
Author: zhangli zhangli@zbomc.com
Date: Fri Aug 28 10:50:53 2020 +0800

mysql 列名解析问题

commit 9d0235d032648a619e2d4ea9216c1539e8b4c765
Author: zhangli zhangli@zbomc.com
Date: Fri Aug 28 09:04:59 2020 +0800

sql 特殊字符串 ，在关键字添加``""[]等，后边紧接着关键字的是时候的问题

commit 7f52c70b94f9934eb2f31ec96d9f0b68e8887bad
Author: zhangli zhangli@zbomc.com
Date: Thu Aug 27 06:07:07 2020 +0800

-dropall/truncate 增加zcbus_source_part的时候分区验证功能

commit 8c46d6047aa0962522439d7803e15bfd6068ea79
Author: zhangli zhangli@zbomc.com
Date: Wed Aug 26 19:43:37 2020 +0800

sqlserver 列信息补齐，去掉ifdefault判断
针对-dropall/-truncate操作，去掉表名，用户名大写问题

commit 5764bcd74bac04bf2bce9f7e2a531494e170c5a6
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 23 19:20:00 2020 +0800

dropall参数，在truncate的时候，增加删除约束操作

commit a5fef64badb83bd6b0bb27f85dc1d4eb279f2921
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 23 16:22:28 2020 +0800

sqlserver 添加约束验证问题，以及创建索引验证方式。

commit 4cdbcf133ba621cdf4e3cef3d53984648b52fc34
Author: zhangli zhangli@zbomc.com
Date: Fri Aug 21 09:08:26 2020 +0800

添加針對SOURCE_PART=?分區操作的支持

commit eea45cb252cbe288ba4acff2bb5163c5edb2e487
Author: zhangli zhangli@zbomc.com
Date: Wed Aug 19 19:06:59 2020 +0800

add check column is null function

commit 69bb10e66c6d6782fb855df91d27af7153c550ac
Author: zhangli zhangli@zbomc.com
Date: Tue Aug 18 01:36:58 2020 +0800

oracle constraints/constraint类型增删操作

commit a5bea749a01467ba5b33b5b2f2a45dc14fb0d5ac
Author: zhangli zhangli@zbomc.com
Date: Mon Aug 17 12:29:44 2020 +0800

mysql date -> oracle date类型
mysql datetime -> oracle date类型

commit f83ae62e5b310c75f6d812690f27fcd7f5647bb6
Author: zhangli zhangli@zbomc.com
Date: Sat Aug 15 17:56:07 2020 +0800

增加SQLSERVER 创建索引，增加include属性

commit 57e5c78d95653cdf693ce75888cd9c95566e15fa
Author: zhangli zhangli@zbomc.com
Date: Sat Aug 15 11:26:01 2020 +0800

SQLSERVER        注释改造

IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description',
'SCHEMA', N'dbo',
'TABLE', N'FZ_QUEUE',
'COLUMN', N'KID')) > 0)
EXEC sp_updateextendedproperty @name = N'MS_Description', @value =
N'TEST_DEMO'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'FZ_QUEUE'
, @level2type = 'COLUMN', @level2name = N'KID'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value =
N'TEST_DEMO'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'FZ_QUEUE'
, @level2type = 'COLUMN', @level2name = N'KID'
GO

commit 30818b02bccfaa746676d9d050d41cb4b8cda7b6
Author: zhangli zhangli@zbomc.com
Date: Fri Aug 14 18:44:38 2020 +0800

sqlserver 注釋問題

commit 18a8b5696b780d000a673e9509260ce4def622e8
Author: zhangli zhangli@zbomc.com
Date: Fri Aug 14 11:40:58 2020 +0800

增加ddl中用戶，表，列對應關鍵字符串"`[]等

commit c9001bf595580eae7b5f1fa6b68cfb49bada700b
Author: zhangli zhangli@zbomc.com
Date: Wed Aug 12 21:46:43 2020 +0800

修复部分ddl解析bug

commit 8efdd037c52fd0e05cf4e1de8118858dcd9cc2c0
Author: zhangli zhangli@zbomc.com
Date: Mon Aug 10 21:15:03 2020 +0800

测试

commit 22b1f1c628f371caae91545236fe1a17a9f13b31
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 9 12:37:38 2020 +0800

1、跟进ORACLE数据库MAX_STRING_SIZE参数，判断是否为EXTENDED，则varchar长度界限为32767，否则默认长度为4000字节。
2、修改添加辅助字段为非空字段

commit 8cbbbe657bf6a2a4c0c67ba56b83d7be7ff8d14e
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 9 09:03:18 2020 +0800

修改exec 修改sqlserver列属性的时候，出现optype异常处理问题

commit fc268286520dfc408db543e74463f9c5b17d781a
Author: zhangli zhangli@zbomc.com
Date: Thu Aug 6 23:20:38 2020 +0800

无

commit 8df94d172dd95ff1713e2e1693793c745a870e71
Author: zhangli zhangli@zbomc.com
Date: Thu Aug 6 23:16:15 2020 +0800

解決SQL SERVER解析bug問題
alter table dbo.tb01 add constraint def_tb01  default(0) for defid;
ALTER TABLE zfl_target.tb01 ADD CONSTRAINT def_tb01;
解析後為
ALTER TABLE tb01   ADD  CONSTRAINT  def_tb01  DEFAULT  0  FOR   defid
WITH  VALUES

commit 4ff4e40a960d31e7fb23f1e66d7e53d441b70ae1
Author: zhangli zhangli@zbomc.com
Date: Wed Aug 5 23:24:51 2020 +0800

入Oracle类型，zcbus date类型由原来的varchar2类型转为date类型

commit 3f2eefbf7fdeae125eac38b53087518d9f3e1c67
Author: zhangli zhangli@zbomc.com
Date: Tue Aug 4 22:39:38 2020 +0800

复制列信息，由DATETIME类型转成DATE类型【ORACLE】

commit 3e48f3cc666f95f07045ecee161d3b8ec6a49640
Author: zhangli zhangli@zbomc.com
Date: Tue Aug 4 08:28:51 2020 +0800

支持oracle添加表空間，創建表和索引
支持oralce創建索引添加並行

commit 878ac3fd611902606ed0ab6df1a4df55dd737e74
Author: zhangli zhangli@zbomc.com
Date: Sun Aug 2 23:32:01 2020 +0800

文档更新时间: 2024-01-27 15:48 作者：阿力