[MCOL-1307] Adapter can't recognize database schema written with backtick Created: 2018-03-27  Updated: 2023-10-26  Resolved: 2018-11-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.4
Fix Version/s: 1.1.7, 1.2.1

Type: Bug Priority: Minor
Reporter: Elena Kotsinova (Inactive) Assignee: Elena Kotsinova (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: JPEG File backticks.JPG    
Issue Links:
Blocks
is blocked by MCOL-1309 SystemCatalog.getTable doesn't suppor... Closed
Sprint: 2018-19

 Description   

1. Create transformation using spoon tool
2. Use MariaDB ColumnStore Bulk Loader module to map fields from input module to database.
3. Fill in target database name with name of existing database but with backticks.
4. Click on Field mapping tab > Custom mapping button

Result:
Database not found error appears.

Expected:
To recognize database name with backticks, or don't allow using of backticks in the field.

 Comments   
Comment by Jens Röwekamp (Inactive) [ 2018-10-29 ]

Attached the verify listener that checks the table field input to the database field.

For QA:

  • check if you can still insert database names with back-ticks in PDI 7 or PDI 8
  • execute the regression test suite
Comment by Elena Kotsinova (Inactive) [ 2018-11-02 ]

Tested with 1.1.7 builds for CentOS and Windows

Generated at Thu Feb 08 02:27:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.