472,142 Members | 1,338 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

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 ...

Jun 12 '06 #1
1 1300
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 ....

Jun 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by B. Pigman | last post: by
1 post views Thread by Joseph S. | last post: by
11 posts views Thread by macca | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.