Bug #4011 | Mysql return invalid column names when query is written in small caps. | ||
---|---|---|---|
Submitted: | 4 Jun 2004 16:24 | Modified: | 21 Aug 2004 4:34 |
Reporter: | Sylwester Zarebski | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S3 (Non-critical) |
Version: | 4.1.2-alpha-standard | OS: | Linux (RH 9) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[4 Jun 2004 16:24]
Sylwester Zarebski
[4 Jun 2004 17:03]
Dean Ellis
Can you provide a repeatable test case, with the SQL to create, populate and query the table, demonstrating this behavior? I'm not having any success repeating it, so some form of test case would be very helpful.
[8 Jun 2004 19:32]
Sylwester Zarebski
No, i can not provide repeatable test, because i encounter this bug few times only. To find some past few days i played with mysql client, and now i mostly suspect it. Let me explain my test.. i commonly open mysql client in screen session and let it be under some screen for few days, and then from some moment client start to show weird result's columns. If i quit client and run again, the same problem shows (is it in mysql cache??), but if i quit client, and do not run for e.g. one or two days, then client do show correctly. Very weird... and except it (very minor problem) everything works pretty nice (and much better than 3.xx versions). Problem resolution#2: do not run mysql client too long ;-).