Menu

#1726 (ok 2.10.1) table dot numeric field name

2.6.3-pl1
fixed
1
2013-06-11
2005-07-16
No

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.

Discussion

  • Michal Čihař

    Michal Čihař - 2005-10-09

    Logged In: YES
    user_id=192186

    I actually can not reproduce this in current CVS, can you
    confirm?

     
  • Marc Delisle

    Marc Delisle - 2005-10-09

    Logged In: YES
    user_id=210714

    You're right, it failed in 2.6.4 but no longer a bug in 2.7.0.

     
  • Marc Delisle

    Marc Delisle - 2005-10-09
    • summary: table dot numeric field name --> (in 2.7.0) table dot numeric field name
    • assigned_to: nobody --> nijel
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2005-11-02

    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.

     
  • Marc Delisle

    Marc Delisle - 2005-11-02
    • priority: 1 --> 5
    • status: open-fixed --> open-accepted
     
  • Michal Čihař

    Michal Čihař - 2005-11-02

    Logged In: YES
    user_id=192186

    Perhaps parser treates .002 as number and makes separate
    token from it?

     
  • Marc Delisle

    Marc Delisle - 2005-11-02

    Logged In: YES
    user_id=210714

    In fact it's treating .002 as an alpha identifier, including
    the dot.

     
  • Michal Čihař

    Michal Čihař - 2005-11-16
    • status: open-accepted --> open
     
  • Michal Čihař

    Michal Čihař - 2005-11-16
    • summary: (in 2.7.0) table dot numeric field name --> table dot numeric field name
    • assigned_to: nijel --> nobody
     
  • Marc Delisle

    Marc Delisle - 2006-01-06
    • priority: 5 --> 3
     
  • Sebastian Mendel

    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

     
  • Sebastian Mendel

    • summary: table dot numeric field name --> (ok 2.11) table dot numeric field name
    • assigned_to: nobody --> cybot_tm
    • priority: 3 --> 1
    • status: open --> open-fixed
     
  • Sebastian Mendel

    • summary: (ok 2.11) table dot numeric field name --> (ok 2.10.1) table dot numeric field name
     
  • Marc Delisle

    Marc Delisle - 2007-04-24
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed