CREATE TABLE `thetable` ( `2` varchar(12) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
mysql> select thetable.2 from thetable; +------+ | 2 | +------+ | aaaa | +------+ 1 row in set (0.00 sec)
But it fails in phpMyAdmin.
Logged In: YES user_id=192186
I actually can not reproduce this in current CVS, can you confirm?
Logged In: YES user_id=210714
You're right, it failed in 2.6.4 but no longer a bug in 2.7.0.
Still problematic:
CREATE TABLE `thetable` ( `002` varchar(12) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
select thetable.002 from thetable;
I am debugging it now.
Perhaps parser treates .002 as number and makes separate token from it?
In fact it's treating .002 as an alpha identifier, including the dot.
Logged In: YES user_id=326580 Originator: NO
select thetable.2,.2,2,thetable.a, thetable.002,.002, .002, 002, 2 from thetable
seems to work now
PLEASE TEST - also with other queries
Logged In: YES
user_id=192186
I actually can not reproduce this in current CVS, can you
confirm?
Logged In: YES
user_id=210714
You're right, it failed in 2.6.4 but no longer a bug in 2.7.0.
Logged In: YES
user_id=210714
Still problematic:
CREATE TABLE `thetable` (
`002` varchar(12) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
select thetable.002 from thetable;
I am debugging it now.
Logged In: YES
user_id=192186
Perhaps parser treates .002 as number and makes separate
token from it?
Logged In: YES
user_id=210714
In fact it's treating .002 as an alpha identifier, including
the dot.
Logged In: YES
user_id=326580
Originator: NO
select
thetable.2,.2,2,thetable.a, thetable.002,.002, .002, 002, 2
from thetable
seems to work now
PLEASE TEST - also with other queries