mysql damage result set

Hello

I make an regexp select statement over two tables. The Result set comes
Back without errors. But If I look into the resultSets sometimes the
ColumnName is Missing. Anyone knows about this problem or how to fix
this ?
Without the regexp everything is fine:

Kontakte.Id INTEGER
Kontakte.Anrede VARCHAR
Kontakte.Name VARCHAR
Kontakte.nt1 TINYINT

With regexp:
Kontakte.Id INTEGER
..Anrede VARCHAR
..Name VARCHAR
Kontakte.nt1 TINYINT

On MYSQL 4 no errors with regexp ...
Only switching to mysql 5 this error comes ...

Re: mysql damage result set

diwe schrieb:

> Hello
>
> I make an regexp select statement over two tables. The Result set comes
> Back without errors. But If I look into the resultSets sometimes the
> ColumnName is Missing. Anyone knows about this problem or how to fix
> this ?
> Without the regexp everything is fine:
>
> Kontakte.Id INTEGER
> Kontakte.Anrede VARCHAR
> Kontakte.Name VARCHAR
> Kontakte.nt1 TINYINT
>
> With regexp:
> Kontakte.Id INTEGER
> .Anrede VARCHAR
> .Name VARCHAR
> Kontakte.nt1 TINYINT
>
> On MYSQL 4 no errors with regexp ...
> Only switching to mysql 5 this error comes ...
For everyone who wants to know ... I think the table was damaged I
dropped and recreate the Table and it works ... but mysql check -> no
error ....