db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject Re: column number mismatch error
Date Thu, 14 Feb 2008 15:49:36 GMT
On Thu, Feb 14, 2008 at 4:30 AM, Knut Anders Hatlen <Knut.Hatlen@sun.com> wrote:
> Amir Michail <amichail@gmail.com> writes:
>
>  > On Feb 13, 2008 7:13 PM, Amir Michail <amichail@gmail.com> wrote:
>  >>
>  >> On Feb 13, 2008 3:51 PM, Amir Michail <amichail@gmail.com> wrote:
>  >> > Hi,
>  >> >
>  >> > What does this error mean?
>  >> >
>  >> > ERROR XSCH5: In a base table there was a mismatch between the
>  >> > requested column number 9 and the maximum number of columns 10.
>  >> >
>  >> > This happens when I tried to add a reference to a primary key.
>
>  Hi Amir,
>
>  Could you post the SQL statement you are trying to execute and the
>  schema for the tables involved? I think the error means that an attempt
>  to add a column to a table/conglomerate failed because the conglomerate
>  already has a column with the given id. I think this is an internal
>  error, and it could be a bug in Derby.
>

The integrity check did not reveal any error.

But this fails:

ij> alter table levels add column shape_id int references shapes;
ERROR XSCH5: In a base table there was a mismatch between the
requested column number 9 and the maximum number of columns 10.

Amir

>
>  >> Do you think my db is corrupted?
>  >
>  > What's the command for checking db integrity?
>
>  http://db.apache.org/derby/docs/10.3/adminguide/cadminconsist01.html
>
>  --
>  Knut Anders
>

Mime
View raw message