Space is Trimmed on Varchar Columns With Trailing Space
(Doc ID 2851733.1)
Last updated on NOVEMBER 03, 2023
Applies to:
Oracle Analytics Cloud - Version January 2022 (6.4) and laterOracle 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 |