mysql damage result set

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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:

Quoted text here. Click to load it
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 ....

Site Timeline