INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

For a fragmented table a complex set of expressions need to be
generated and stored in the systabamdata table. There is an
undocumented limit on the size of this parameter data based on
the LVARCHAR(8192) used. When the complex expression is large,
some part of the processing in the TimeSeries AM_CREATE method
or in the CREATE TABLE .. USING statement fails but does not
generate an error to indicate that the VTI table was not built.

create table f1 (id char(32) primary key, tsdata timeseries
(meter_data))
       fragment by expression
                partition p1  (id < 'A') in datadbs,
                partition p2  (id < 'B') in datadbs,
                partition p3  (id < 'C') in datadbs,
                partition p4  (id < 'D') in datadbs,
                partition p5  (id < 'E') in datadbs,
                partition p6  (id < 'F') in datadbs,
                partition p7  (id < 'G') in datadbs,
                partition p8  (id < 'H') in datadbs,
                partition p9  (id < 'I') in datadbs,
                partition p10 (id < 'J') in datadbs,
                partition p11 (id < 'K') in datadbs,
                partition p12 (id < 'L') in datadbs,
                partition p13 (id < 'M') in datadbs,
                partition p14 (id < 'N') in datadbs,
                partition p15 (id < 'O') in datadbs,
                partition p16 (id < 'P') in datadbs,
                partition p17 (id < 'Q') in datadbs,
                partition p18 (id < 'R') in datadbs,
                partition p19 (id < 'S') in datadbs,
                partition p20 (id < 'T') in datadbs,
                partition p21 (id < 'U') in datadbs,
                partition p22 (id < 'V') in datadbs,
                partition p23 (id < 'W') in datadbs,
                partition p24 (id < 'X') in datadbs,
                partition p25 (id < 'Y') in datadbs,
                partition p26 (id < 'Z') in datadbs,
                partition p27 (id >= 'Z') in datadbs;

execute procedure TSCreateVirtualTab(
        'v1',
        'f1',
        'irregular,calendar(ts_15min),threshold(0)',
        'fragment+elem_insert+reduced_log',
        'tsdata');

select * from v1;

The only error produced is when the table is accessed:

Table created.

Routine executed.

  206: The specified table (v1) is not in the database.

  111: ISAM error:  no record found.
Error in line 44
Near character position 16

****************************************************************
* USERS AFFECTED:                                              *
* Users of fragmented TS Virtual Tables                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description.  SQL silently failed in the create    *
* table statement, this was fixed.  Also additional options    *
* are provided in TSCreateVirtualTab to handle larger fragment *
* by expressions.                                              *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to the fix pack (12.10.xC7) if it is released.       *
* Otherwise 12.10.xC6 can be patched.                          *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.01.2016
28.06.2016
28.06.2016

12.10.xC6