Bug #13928 Query with 11 fields

• Submitted: 11 Oct 2005 14:39
• Modified: 12 Nov 2005 2:12
• Reporter: [ name withheld ]
• Status: No Feedback
• Category: Connectors: DBD::mysql ( Perl )
• Severity: S3 (Non-critical)
• Version: 4.1.9
• OS: Linux (Redhat)
• Assigned to: Assigned Account
• CPU Architecture: Any

[11 Oct 2005 14:39] [ name withheld ]

Description:
I dit this query:
SELECT `1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10`,`time` FROM table WHERE x=1
 
When open column 10 I get column time. So I place `time` on another place like this:
SELECT `time`,`1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10` FROM table WHERE x=1
That works fine.

My MySQL Version: mysql 3.23.58-2.3  on Plesk

How to repeat:
By carry out the following query:
SELECT `1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10`,`time` FROM table WHERE x=1

[11 Oct 2005 14:42] [ name withheld ]

I use EasyPHP and there is the same problem. The Mysql version is there 4.1.9

[12 Oct 2005 2:12] Jorge del Conde

Hi!

Can you please send me a complete test-case that reproduces this problem ?

Thanks !

[13 Nov 2005 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".