× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported Feb 1, 2017  · raghavsingh last modified Feb 3, 2017

TeraData -> When session configured with TMODE=ANSI extraction of objects failing


customer request
Priority Low
Complexity Unknown
Component App - General
Version 17.0

  If you configure the session mode to ANSI, then the compare on character based strings will be case sensitive.  Teradata is a none case sensitive database but the comparing of strings will take case into consideration when mode is ansi.  We don't use the CASESPECIFIC or NOT CASESPECIFIC keywords in our extraction and instead consider teradata as not case sensitive.

  We need to adjust the connections isCaseSensitive() return value to take into consideration the TMODE setting.  When you right click on the following example and choose the "edit table data" action, the extraction should find the object in ANSI and TERADATA modes.

CREATE MULTISET TABLE <database>zTesT2, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO (col2 VARCHAR(25) CHARACTER SET LATIN CASESPECIFIC) PRIMARY INDEX (col2)

1 attachment
ivangron   Feb 1, 2017
Field Old Value New Value
Version 15.0 17.0
ivangron   Feb 1, 2017
Field Old Value New Value
Fixed Build v17.0.11-7, v18.0.0-preview-45
Resolution Fixed
Resolved Date Feb 1, 2017 7:01 PM
Status New Resolved
shilpasingh(*)   Feb 2, 2017
Field Old Value New Value
QA Assignee NielsGron (Niels Gron) raghavsingh (Raghvendra Singh)
raghavsingh   Feb 3, 2017
Field Old Value New Value
Status Resolved Closed

Issue #14971

Closed
Fixed
Resolved Feb 1, 2017
 
 
Completion
No due date
Fixed Build v17.0.11-7, v18.0.0-preview-45
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017