My Oracle Support Banner

Space is Trimmed on Varchar Columns With Trailing Space (Doc ID 2851733.1)

Last updated on MARCH 03, 2022

Applies to:

Oracle Analytics Cloud - Version January 2022 (6.4) and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

On database, there is a data that has a trailing space.
When displaying a table or a pivot table visualization using this data, the space is trimmed.
So expected result may be not displayed.

- The steps to reproduce

1. Create a following table on ADW.

CREATE TABLE testtable
 ( name VARCHAR2(20) NOT NULL,
   tag  VARCHAR2(20),
   value  NUMBER(10)
 );
 
2. Insert following data into this table.
    The 'tag' column of the record whose 'name' column is 'C' and 'D' has a trailing space, like 'aaa '.

INSERT INTO testtable(name,tag,val) VALUES ('A','aaa',100);
INSERT INTO testtable(name,tag,val) VALUES ('B','aaa',200);
INSERT INTO testtable(name,tag,val) VALUES ('C','aaa ',300);
INSERT INTO testtable(name,tag,val) VALUES ('D','aaa ',400);

3. On OAC DV, create a new connection for ADW.

4. Create a new dataset using this table.

5. Create a new workbook with a pivot table as following.

   Rows: TAG, NAME
   Values: VAL
   Grand Total: Rows
   Subtotal: TAG
   
   Following screen is displayed.

  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.