Commit Graph

659 Commits

Author SHA1 Message Date
Chris Cranford
ea536a27db DBZ-6716 Support Oracle DROP USER statements 2023-07-31 03:03:03 -04:00
mfvitale
b8462e8fe0 DBZ-6599 Support single line statement without semicolon ending 2023-07-20 10:10:16 -04:00
Chris Cranford
1b265c84bc DBZ-6677 Support altering an Oracle table's column visibility 2023-07-18 09:46:27 +02:00
Debezium Builder
267dfda8a6 [maven-release-plugin] prepare for next development iteration 2023-07-17 10:40:52 +00:00
Debezium Builder
0d3cef6a29 [maven-release-plugin] prepare release v2.4.0.Alpha1 2023-07-17 10:40:52 +00:00
Vojtech Juranek
4b0290a0b1 DBZ-6651 Avoid confusing label and IPv6 address
Some label combined with some keywords (when written without a space
in between, which is valid for MySQL) can look like beginning of an IPv6
address, e.g.

    aaa:BEGIN

is currectly prased as IPv6 address `aaa:be` and leads to a parsing
failure.

Make parsing of IPv6 address more robust and require at least two `:`
to make sure there is no confusion with labels.
2023-07-13 09:56:39 +02:00
mfvitale
7811d86edf DBZ-3925 Add support for FLUSH FIREWALL_RULES for Azure Database for MySQL Single Server instance 2023-07-05 16:34:26 -04:00
harveyyue
e211fe7d06 DBZ-6622 MySQL ALTER USER with RETAIN CURRENT PASSWORD fails with parsing exception 2023-06-30 03:09:49 -04:00
mfvitale
a386df3898 DBZ-6613 Support ARRAY keyword in declare statement 2023-06-28 13:48:48 -04:00
Vojtech Juranek
0163120bc5 DBZ-6590 Support CAST AS (UN)SIGNED INT
CLI example:

    > SELECT CAST('1' AS UNSIGNED INT);
    +---------------------------+
    | CAST('1' AS UNSIGNED INT) |
    +---------------------------+
    |                         1 |
    +---------------------------+
2023-06-21 12:09:43 +02:00
Vojtech Juranek
cc6aa0e20f DBZ-6590 Support MySQL CAST AS DEC
CLI example:

    > SELECT CAST('1' AS DEC);
    +------------------+
    | CAST('1' AS DEC) |
    +------------------+
    |                1 |
    +------------------+
2023-06-21 12:09:43 +02:00
Vojtech Juranek
47a1a99293 DBZ-6585 Support dropping multiple Oracle partitions 2023-06-21 11:23:05 +02:00
Debezium Builder
60f730d383 [maven-release-plugin] prepare for next development iteration 2023-06-20 13:21:31 +00:00
Debezium Builder
150396e4c8 [maven-release-plugin] prepare release v2.3.0.Final 2023-06-20 13:21:31 +00:00
harveyyue
17be519d1f DBZ-6519 Parse mysql table name failed which ending with backslash 2023-06-09 14:33:19 +02:00
Debezium Builder
5d1b00588a [maven-release-plugin] prepare for next development iteration 2023-06-09 09:23:38 +00:00
Debezium Builder
d1e6107517 [maven-release-plugin] prepare release v2.3.0.CR1 2023-06-09 09:23:37 +00:00
Tommy Karlsson
567931d1ba DBZ-6537 Allow "national" as identifier in MySql 2023-06-09 06:10:38 +02:00
ani-sha
135b64ee52 DBZ-6508 Allow LIST_VALUES_CLAUSE to use negative numbers 2023-06-08 14:58:50 +02:00
蔡灿材
23de00ca95 DBZ-6435 MySql in debezium-parser-ddl does not support table keyword parsing 2023-06-07 16:37:15 +02:00
蔡灿材
35a479b228 DBZ-6435 MySql in debezium-parser-ddl does not support table keyword parsing 2023-06-07 16:37:15 +02:00
蔡灿材
b5ba2cf3fb DBZ-6435 MySql in debezium-parser-ddl does not support table keyword parsing 2023-06-07 16:37:15 +02:00
ani-sha
3993f3eaad DBZ-6507 Add MATERIALIZED VIEW LOG clause 2023-06-01 08:42:21 -04:00
Debezium Builder
aa5b2131fc [maven-release-plugin] prepare for next development iteration 2023-05-26 10:35:20 +00:00
Debezium Builder
9cc9b3c29a [maven-release-plugin] prepare release v2.3.0.Beta1 2023-05-26 10:35:20 +00:00
ani-sha
f20fe32b4f DBZ-6492 Support logical_replication_clause in Oracle 2023-05-23 08:30:36 +02:00
ani-sha
6d404d242e DBZ-6479 Add missing privileges as per MySQL 8.0.x 2023-05-23 08:25:49 +02:00
Jochen Schalanda
bdb43a2235 DBZ-6459 [MariaDB] Add support for userstat plugin keywords
The MariaDB User Statistics (userstat) plugin adds 4 new keywords:

`USER_STATISTICS`, `CLIENT_STATISTICS`, `INDEX_STATISTICS`, and `TABLE_STATISTICS`

Additionally, it adds unusual variants of the `SHOW` and `FLUSH` statements which aren't covered by the MariaDB SQL grammar yet, for example

```
SHOW TABLE_STATISTICS;
FLUSH USER_STATISTICS;
```

See also:

- https://mariadb.com/kb/en/user-statistics/
- https://mariadb.com/kb/en/show-client-statistics/
- https://mariadb.com/kb/en/show-index-statistics/
- https://mariadb.com/kb/en/show-table-statistics/
- https://mariadb.com/kb/en/show-user-statistics/

Refs https://github.com/antlr/grammars-v4/pull/3400
2023-05-15 14:56:36 +02:00
Debezium Builder
a5b44767bc [maven-release-plugin] prepare for next development iteration 2023-05-11 11:05:24 +00:00
Debezium Builder
1b1a7531f2 [maven-release-plugin] prepare release v2.3.0.Alpha1 2023-05-11 11:05:24 +00:00
Chris Cranford
1a44431114 DBZ-6442 Support FORCE-clause in DROP TABLE 2023-05-10 12:10:15 +02:00
gongchanghua
38cdcb2152 DBZ-6446 Support shrink clause for Oracle index partition 2023-05-09 12:15:15 +02:00
caicancai
473925c0a5 DBZ-6401 MySql in debezium-parser-ddl :The inserted sql statement reports an error 2023-05-01 10:27:28 -04:00
gongchanghua
a836a6ee9c DBZ-6386 Support shrink clause for Oracle table partition 2023-04-27 09:10:13 -04:00
Debezium Builder
bb1b79f3bd [maven-release-plugin] prepare for next development iteration 2023-04-20 09:09:43 +02:00
Debezium Builder
5483b4de99 [maven-release-plugin] prepare release v2.2.0.Final 2023-04-20 09:09:43 +02:00
Jiri Pechanec
12bec973ff DBZ-6331 Flag as MariaDB only grammar 2023-04-19 09:30:18 +02:00
ani-sha
d4eec9f6da DBZ-6331 Add support for WITH SYSTEM VERSIONING table option 2023-04-19 09:30:18 +02:00
caicancai
514afb72eb DBZ-6336 MySql in debezium-parser-ddl does not support with keyword parsing 2023-04-18 07:59:25 +02:00
Debezium Builder
976a47a3a3 [maven-release-plugin] prepare for next development iteration 2023-04-14 08:46:06 +00:00
Debezium Builder
1ca8399e8b [maven-release-plugin] prepare release v2.2.0.CR1 2023-04-14 08:46:06 +00:00
Jochen Schalanda
917a80c04a DBZ-6316 Add variant of ALTER TABLE ADD UNIQUE IF NOT EXISTS
Refs https://github.com/antlr/grammars-v4/pull/3085
2023-04-13 10:28:59 +02:00
Jochen Schalanda
30102b9fa4 DBZ-6316 Add support for Table Value Constructors
Refs https://github.com/antlr/grammars-v4/pull/3076
Refs https://github.com/antlr/grammars-v4/pull/3077
2023-04-13 10:28:59 +02:00
Jochen Schalanda
054cfb99b8 DBZ-6316 Support all privileges of MariaDB 10.6 in MySQL grammar
Refs https://github.com/antlr/grammars-v4/pull/3075
2023-04-13 10:28:59 +02:00
mfvitale
60448e9c79 DBZ-6314 Add revoke statement for Oracle parser 2023-04-05 10:01:00 -04:00
Debezium Builder
5c650fd054 [maven-release-plugin] prepare for next development iteration 2023-03-31 10:00:16 +00:00
Debezium Builder
68ffc4833b [maven-release-plugin] prepare release v2.2.0.Beta1 2023-03-31 10:00:16 +00:00
Anisha Mohanty
c20ab276d6 DBZ-6255 Add keyword UUID to keywordsCanBeId rule 2023-03-30 16:21:30 +02:00
ani-sha
a8324bc21e DBZ-6255 Support UUID data type for MariaDB 2023-03-30 16:21:30 +02:00
Chris Cranford
f9bb5eb82f DBZ-6221 Correctly interpret CHARACTER/CHARACTER VARYING data types while streaming 2023-03-28 14:45:12 +02:00
sondn
7a70eddf48 DBZ-6250 Missing a keyword which can be used as column name 2023-03-27 10:36:54 +02:00
mfvitale
4980f94a31 DBZ-6243: Fix MySql parser to permit alias in single delete statements 2023-03-23 08:26:54 +01:00
Jiri Pechanec
a88dcd4488 DBZ-6211 Corrected formatting 2023-03-22 10:07:15 +01:00
ani-sha
1fb8cfcb7a DBZ-6211 Add missing privileges as per MySQL 8.x 2023-03-22 10:07:15 +01:00
ani-sha
7f5b45a890 DBZ-6124 Add alterByAlterCheckTableConstraint rule for ALTER TABLE 2023-03-16 11:30:39 +01:00
Chris Cranford
88c6419dae DBZ-6124 Restore old rule, rearranged dataType rules 2023-03-16 11:30:39 +01:00
Anisha Mohanty
3b1a43edf9 DBZ-6124 Modify CREATE and ALTER TABLE rules 2023-03-16 11:30:39 +01:00
ani-sha
d34891e1e9 DBZ-6194 Use CHARSET for alterByConvertCharset clause 2023-03-16 08:01:12 +01:00
ani-sha
1847c9b116 DBZ-6188 Allow optional uidList for partitionFunctionKey rule 2023-03-16 07:56:38 +01:00
Jiri Pechanec
97ce3fa09e DBZ-6186 Mark as MariaDB only 2023-03-09 08:38:31 +01:00
Nir Levy
c6ca9125d9 DBZ-6186: Add support for GRANT DELETE HISTORY in mariadb 2023-03-09 08:38:31 +01:00
Debezium Builder
55d65e9618 [maven-release-plugin] prepare for next development iteration 2023-03-08 11:38:17 +00:00
Debezium Builder
6d183c3dc1 [maven-release-plugin] prepare release v2.2.0.Alpha3 2023-03-08 11:38:16 +00:00
Debezium Builder
2245ceda44 [maven-release-plugin] prepare for next development iteration 2023-02-16 11:28:25 +00:00
Debezium Builder
20f3b16e8a [maven-release-plugin] prepare release v2.2.0.Alpha2 2023-02-16 11:28:25 +00:00
Anisha Mohanty
232579a236 DBZ-6016 Add CLUSTERING KEY constraint for TOKUDB 2023-01-26 07:36:17 +01:00
Anisha Mohanty
e4a94d55dd DBZ-6020 ALTER and CREATE USER allow ROLE option 2023-01-25 09:00:50 +01:00
Chris Cranford
ca4c61da4c DBZ-6031 Support compression/logging clauses after LOB storage clauses 2023-01-24 14:30:09 +01:00
Anisha Mohanty
a8716fcb61 DBZ-6019 Role REVOKE with user-like role name 2023-01-24 14:24:17 +01:00
Debezium Builder
04f5291a2d [maven-release-plugin] prepare for next development iteration 2023-01-19 11:32:10 +00:00
Debezium Builder
027527963e [maven-release-plugin] prepare release v2.2.0.Alpha1 2023-01-19 11:32:10 +00:00
Mark Lambert
f0a1fa8a67 DBZ-4669 Use the newer version of plugins to consolidate remaining duplicates plugin versions 2023-01-11 06:44:53 +01:00
Debezium Builder
cf1720e4cb [maven-release-plugin] prepare for next development iteration 2022-12-22 10:11:54 +00:00
Debezium Builder
b4ea9b46cd [maven-release-plugin] prepare release v2.1.0.Final 2022-12-22 10:11:53 +00:00
Raul Estrada
f7579237fe DBZ-3575 JSON_TABLE expression 2022-12-21 12:34:17 +01:00
Raul Estrada
c1493c8e20 DBZ-3575 Comments review 2022-12-21 12:34:17 +01:00
Raul Estrada
282717fa55 DBZ-3575 Implement support for JSON_TABLE in MySQL parser 2022-12-21 12:34:17 +01:00
Raul Estrada
f5d5aefa65 DBZ-3575 Implement support for JSON_TABLE in MySQL parser 2022-12-21 12:34:17 +01:00
Raul Estrada
9ca3498cff DBZ-3575 Implement support for JSON_TABLE in MySQL parser 2022-12-21 12:34:17 +01:00
Raul Estrada
863e00e43b DBZ-3575 Implement support for JSON_TABLE in MySQL parser 2022-12-21 12:34:17 +01:00
Debezium Builder
177a60a9d3 [maven-release-plugin] prepare for next development iteration 2022-12-16 09:33:38 +00:00
Debezium Builder
f805db8c3c [maven-release-plugin] prepare release v2.1.0.Beta1 2022-12-16 09:33:38 +00:00
Raul Estrada
dd96ccc27d DBZ-5888 MariaDB-grammar 2022-12-14 14:42:29 +01:00
Raul Estrada
17c99fadd2 DBZ-3576 Implement window function in MySQL parser 2022-12-14 08:28:11 +01:00
Nir Levy
39393299e4 DBZ-5904 Suppport INSERT INTO statements with dots in column names 2022-12-08 13:04:41 +01:00
Debezium Builder
81896ed334 [maven-release-plugin] prepare for next development iteration 2022-11-30 07:52:24 +00:00
Debezium Builder
1aac97b87c [maven-release-plugin] prepare release v2.1.0.Alpha2 2022-11-30 07:52:23 +00:00
Anisha Mohanty
68412ce15f DBZ-5876 ATTRIBUTE token for CREATE_USER and ALTER_USER clause 2022-11-29 13:21:26 +01:00
Anisha Mohanty
5c2c0f54be DBZ-5836 COMMENT string for CREATE_USER & ALTER_USER clause 2022-11-23 08:46:12 +01:00
Debezium Builder
e311dd1a67 [maven-release-plugin] prepare for next development iteration 2022-11-10 13:29:06 +00:00
Debezium Builder
e3bf53440a [maven-release-plugin] prepare release v2.1.0.Alpha1 2022-11-10 13:29:05 +00:00
harveyyue
f2e7e6cc3b DBZ-5802 Mysql connector alter table with database name parse failed 2022-11-07 08:20:16 +01:00
jcechace
5bf3dad9fd DBZ-5779 Migrated debezium-ddl-parser to AssertJ 2022-11-02 08:50:26 +01:00
Anisha Mohanty
9010fa65ff DBZ-5726 Use DEFAULT_COLLATION_CLAUSE 2022-10-19 07:01:28 -04:00
Anisha Mohanty
0c897925c5 DBZ-5734 Modify SPLIT_TABLE_PARTITION clause 2022-10-18 12:40:26 -04:00
Debezium Builder
4d35fb8011 [maven-release-plugin] prepare for next development iteration 2022-10-14 11:26:32 +00:00
Debezium Builder
7bd1551c99 [maven-release-plugin] prepare release v2.0.0.Final 2022-10-14 11:26:32 +00:00
Jochen Schalanda
45ec33c17b DBZ-5724 Add PRIMARY as keyword to MySQL grammar to fix index hints
Index hints using the primary index (`USE INDEX(PRIMARY)`) are currently
failing because `PRIMARY` is missing from the list of keywords in the
ANTLR-based MySQL parser.

According to https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-P,
`PRIMARY` is a reserved keyword.

Index hints: https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
2022-10-14 08:35:53 +02:00
harveyyue
0b86504fbc DBZ-5679 Function DATE_ADD can be used as an identifier 2022-10-11 06:03:19 +02:00
harveyyue
348c13b6f8 DBZ-5708 MySqlConnector parse create view statement failed 2022-10-11 05:57:21 +02:00
Debezium Builder
884254aba1 [maven-release-plugin] prepare for next development iteration 2022-10-07 09:27:52 +00:00
Debezium Builder
a0f3263fa6 [maven-release-plugin] prepare release v2.0.0.CR1 2022-10-07 09:27:51 +00:00
harveyyue
991dd7ce81 DBZ-5674 Invalid DDL statement could not be parsed crashes kafka-connect for MySql 2022-10-06 07:46:22 +02:00
Nir Levy
db7b80fcdd DBZ-5662 Support statement as table / column name in MySql
Broken in DBZ-5650
2022-09-28 10:12:05 -04:00
Nir Levy
8167a5d794 DBZ-5650 Support set statement in mariadb
From MariaDB 10.1.2, pre-query variables are supported
src: https://mariadb.com/kb/en/set-statement/
2022-09-27 13:47:48 +02:00
Nir Levy
5413e553a8 DBZ-5636 support for using any expression in kill statements 2022-09-23 05:44:04 +02:00
Jiri Pechanec
2d79e2b68b DBZ-5643 TABLE_TYPE can be identifier 2022-09-22 11:14:22 -04:00
harveyyue
bf1e7c89d8 DBZ-5633 Support grant LOAD FROM S3, SELECT INTO S3, INVOKE LAMBDA with aws mysql 2022-09-21 10:03:01 -04:00
harveyyue
5fc23b0945 DBZ-5631 Support for seting stats_sample_pages=default in alter table statements 2022-09-21 07:20:07 +02:00
harveyyue
f341724fa9 DBZ-5623 DDL Parsing Error 2022-09-20 17:18:57 -04:00
harveyyue
f16d8432da DBZ-5622 Support READ ONLY/ENCRYPTION options for alter database statment 2022-09-19 15:51:34 -04:00
Debezium Builder
218d414552 [maven-release-plugin] prepare for next development iteration 2022-09-16 06:36:40 +00:00
Debezium Builder
567f57c47b [maven-release-plugin] prepare release v2.0.0.Beta2 2022-09-16 06:36:39 +00:00
harveyyue
f21ebc98fe DBZ-5609 Oracle connector couldn't parse type_name mdsys.sdo_geometry 2022-09-14 15:57:41 -04:00
Anisha Mohanty
05e08c27b0 DBZ-5605 Support DEFAULT ON NULL in COLUMN_DEFINITION clause 2022-09-14 15:43:57 -04:00
Anisha Mohanty
a0daef37e2 DBZ-5592 Include COMPUTE_CLAUSE in PHYSICAL_ATTRIBUTE_CLAUSE 2022-09-13 10:05:53 +02:00
Anisha Mohanty
6365a6b41f DBZ-5592 Allow LIST_VALUE_CLAUSE to use TIMESTAMP LITERAL 2022-09-13 10:05:53 +02:00
harveyyue
34ca57640d DBZ-5595 Comment on materialized DDL statement couldn't be parsed 2022-09-13 09:03:37 +02:00
Sergei Morozov
2e0a9e8574 DBZ-5550: Add EMPTY as a keyword that can be used as name 2022-08-24 08:46:11 +02:00
Anisha Mohanty
3b6b44eff8 DBZ-5222 Add PASSWORDLESS_USER_ADMIN privilege 2022-08-22 14:10:55 +02:00
Chris Cranford
07f05e8659 DBZ-5526 Support JSON-based CHECK conditions 2022-08-19 09:19:43 +02:00
harveyyue
e8a7651d73 DBZ-5508 DDL statement couldn't be parsed : mismatched input 'ENGINE' 2022-08-15 12:03:39 +02:00
harveyyue
5d27e6f9ab DBZ-5505 My connector parse the mariadb relevant sequence statement failed 2022-08-12 11:59:51 +02:00
Chris Cranford
58177b4685 DBZ-5488 Support undocumented DATAPUMP DDL clauses 2022-08-11 09:36:52 +02:00
harveyyue
831fadc09a DBZ-5499 Mysql connector parser the ddl statement failed when including keyword "buckets" 2022-08-10 09:37:23 +02:00
harveyyue
78cb8e5890 DBZ-5485 Support wait/nowait clause in mariadb 2022-08-07 11:54:01 -04:00
harveyyue
f86c88477a DBZ-5487 Adapt create function syntax of mariadb 2022-08-07 11:43:36 -04:00
Chris Cranford
22c0892ae2 DBZ-5472 Support CREATE INDEX using TABLESPACE with quoted identifiers 2022-08-04 15:21:05 -04:00
Debezium Builder
1ab51ae8d0 [maven-release-plugin] prepare for next development iteration 2022-07-26 18:13:10 +00:00
Debezium Builder
d247a48b79 [maven-release-plugin] prepare release v2.0.0.Beta1 2022-07-26 18:13:09 +00:00
Anisha Mohanty
04941330c3 DBZ-5390 Reorder relational_property definition to give priority to out_of_line_constraint 2022-07-14 08:55:21 +02:00
Debezium Builder
6fd1441af3 [maven-release-plugin] prepare for next development iteration 2022-07-01 09:21:49 +00:00
Debezium Builder
99402af634 [maven-release-plugin] prepare release v2.0.0.Alpha3 2022-07-01 09:21:48 +00:00
Vojtech Juranek
5f1d420fb5 DBZ-5273 Support using variables in KILL command 2022-06-20 13:13:35 +02:00
harveyyue
a608569217 DBZ-5271 Support set role statement for mysql8 2022-06-20 09:04:15 +02:00
Chris Cranford
93af38c189 DBZ-5241 Parse character set introducers on default values 2022-06-13 14:23:12 +02:00
Chris Cranford
1d7f53f9b7 DBZ-5237 Allow LOB storage cause to use quoted string identifiers 2022-06-13 13:30:42 +02:00
Chris Cranford
dd87650120 DBZ-5230 Extend syntax support for ALTER TABLE TRUNCATE PARTITION 2022-06-13 13:10:23 +02:00
Debezium Builder
6fff3a2876 [maven-release-plugin] prepare for next development iteration 2022-06-09 11:49:26 +00:00
Debezium Builder
b2e2e351df [maven-release-plugin] prepare release v2.0.0.Alpha2 2022-06-09 11:49:26 +00:00
harveyyue
6c39302379 DBZ-5201 Debezium does NOT support unix_timestamp() as DEFAULT value 2022-06-08 13:33:10 +02:00
Anisha Mohanty
51e148edf3 DBZ-5210 Support constraint_clauses in add_modify_drop_column_clauses 2022-06-08 12:41:24 +02:00
Anisha Mohanty
327e7fd7b3 DBZ-5200 Accept multiple lob_storage_parameters & tablespace_name as experssion 2022-06-07 14:46:17 -04:00
harveyyue
eb7b56e649 DBZ-5211 DDL statement couldn't be parsed - Oracle connector 1.9.3.Final 2022-06-07 14:43:41 -04:00
Chris Cranford
62782bf806 DBZ-4958 Annotate MariaDB-specific 2022-05-24 08:37:37 +02:00
Chris Cranford
fd7934598f DBZ-4958 Support CREATE OR REPLACE TABLE syntax for MySQL 2022-05-24 08:37:37 +02:00
harveyyue
b0175ead02 DBZ-5121 Support if not exists/if exists key words in alter table statement 2022-05-11 14:16:58 -04:00
AlexMiroshnikov
5a9e90be99 DBZ-4780 Add LATERAL to keywordsCanBeId 2022-05-10 10:34:38 +02:00
AlexMiroshnikov
5bbc32c896 DBZ-4780 Introduce support of LATERAL operator 2022-05-10 10:34:38 +02:00
Chris Cranford
5ab416c86d DBZ-5108 Add ENABLED to the regular_id rule 2022-05-10 10:18:24 +02:00