Hi All,



If I have a table with partitions and subpartitions I have found that
on some versions of Ingres the attempt to modify a partition or
subpartition to reconstruct will fail with E_QE0018.



This is so on: II 9.0.4 (a64.lnx/105)NPTL + 12707



But is OK on:

II 9.0.4 (a64.lnx/105)NPTL + 13137

II 9.1.1 (a64.lnx/103)NPTL + 13187

II 9.1.1 (a64.lnx/103)NPTL + 13212



I've looked through the patch notes and through the tech support site
but I cannot find a reference to a specific bug which was fixed in those
later versions.



I suspect this may have been fixed by accident, does anyone know a
specific bug number for this problem? I'm including this as a test in my
patch acceptance standards..and I'd sorta like to know if its been
described before.



Example:

CREATE TABLE lineitems_with_sub (

shipdate DATE NOT NULL WITH DEFAULT,

partno INTEGER NOT NULL WITH DEFAULT,

stuff VARCHAR(10) NOT NULL WITH DEFAULT

) WITH

PARTITION = ((RANGE ON shipdate

PARTITION p1 VALUES <= '31-Dec-2001',

PARTITION p2 VALUES <= '31-Dec-2002',

PARTITION p3 VALUES <= '31-Dec-2003',

PARTITION p4 VALUES > '31-Dec-2003')

SUBPARTITION (HASH ON partno

PARTITION h1 , PARTITION h2, PARTITION h3, PARTITION h4)

);

\p\g

-- If the bug is present, this fails with E_QE0018

modify lineitems_with_sub partition p1 to reconstruct;

\p\g

-- Ditto!

modify lineitems_with_sub partition h1 to reconstruct;

\p\g



Martin Bowes

Marty,

Your problem was fixed by the following:

Bug 119585
(GENERIC)
"MODIFY table partition part TO RECONSTRUCT" fails and
returns E_QE0018.


Robert

On Wed, 2009-02-04 at 10:04 +0000, Martin Bowes wrote:

Hi Robert,

Thanks for that.

Marty

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Robert Kibble
Sent: 04 February 2009 10:22
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] error modifying a table with a subpartition.

Marty,

Your problem was fixed by the following:

Bug 119585
(GENERIC)
"MODIFY table partition part TO RECONSTRUCT" fails and
returns E_QE0018.


Robert

On Wed, 2009-02-04 at 10:04 +0000, Martin Bowes wrote:
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres