-- Create sql in-place upgrade patch for bug7441712.
-- Modify datatype of column min and max in table wb_rt_dp_columnstats
-- from VARCHAR2(4000) to NVARCHAR2(2000). This sql file is called in 
-- upg11201to11202.sql.
--
-- Note: PLEASE connect as OWBSYS before execute the file.
--
-- Bug #'s/Datatypes updated
-- Bug 7441712 - DEF: PROFILE AGGREGATION RESULTS  SHOWS SOME  STRANGE CHARACTERS (NVARCHAR2)
--
ALTER TABLE wb_rt_dp_columnstats RENAME TO wb_rt_dp_columnstats_backup;
CREATE TABLE wb_rt_dp_columnstats (
    user_id                        NUMBER(11) default (sys_context('USERENV', 'CURRENT_USERID')) not null,
    invocation_id                  NUMBER(9,0),
    column_id                      NUMBER(9,0),
    column_name                    VARCHAR2(30),
    table_id                       NUMBER(9,0),
    num_nulls                      NUMBER(38,0),
    num_distinct                   NUMBER(38,0),
    min                            NVARCHAR2(2000),
    max                            NVARCHAR2(2000),
    avg                            NUMBER(38,0),
    stddev                         NUMBER(38,0),
    median                         NUMBER(38,0),
    common_format                  NUMBER(38,0),
    common_format_cnt              NUMBER(38,0),
    consensus_datatype             NUMBER(38,0),
    consensus_datatype_cnt         NUMBER(38,0),
    consensus_pattern              VARCHAR2(4000),
    consensus_pattern_cnt          NUMBER(38,0),
    consensus_pattern1             VARCHAR2(4000),
    consensus_pattern1_cnt         NUMBER(38,0),
    consensus_length               NUMBER(38,0),
    consensus_length_cnt           NUMBER(38,0),
    max_length                     NUMBER(38,0),
    min_length                     NUMBER(38,0),
    consensus_precision            NUMBER(38,0),
    consensus_precision_cnt        NUMBER(38,0),
    max_precision                  NUMBER(38,0),
    min_precision                  NUMBER(38,0),
    consensus_scale                NUMBER(38,0),
    consensus_scale_cnt            NUMBER(38,0),
    max_scale                      NUMBER(38,0),
    min_scale                      NUMBER(38,0)
);
INSERT INTO wb_rt_dp_columnstats SELECT  * FROM wb_rt_dp_columnstats_backup;
DROP TABLE wb_rt_dp_columnstats_backup;