GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — SQL Editor unexpected token with numeric db suffix and table name prefix · Issue #607 · phpmyadmin/sql-parser

SQL Editor unexpected token with numeric db suffix and table name prefix #607

New issue
Copy link
New issue
Copy link
Open
#632
Open
SQL Editor unexpected token with numeric db suffix and table name prefix#607
#632
Copy link
Labels
bug

Description

@cjhewett
cjhewett
opened on May 17, 2024
Issue body actions

Describe the bug

A numeric database suffix combined with a numeric table name prefix causes a false positive SQL editor error.

To Reproduce

Steps to reproduce the behavior:

  1. Go to any SQL Editor page
  2. Enter
    INSERT INTO foo_1.2_bar SELECT * FROM foo;
    or
    UPDATE foo_1.2_bar SET a = 1;
  3. See error

Unexpected token (near .2)

Expected behavior

Neither of these should flag as syntax errors

The bug does not affect SELECTs e.g.
SELECT * FROM foo_1.2_bar;

Screenshots

image

Server configuration

  • Operating system: el8
  • Database version: 10.11.7-MariaDB
  • PHP version: 8.3.6
  • phpMyAdmin version: 5.2.1-1

Client configuration

  • Browser: Chrome
  • Operating system: Win 10

Activity

  1. williamdes
    transferred this issue fromphpmyadmin/phpmyadminon Jan 17, 2025
  2. williamdes
    added
    bug
    on Jan 17, 2025
  3. williamdes
    added a commit that references this issue on Oct 13, 2026

    Merge #632 - Fix lex number at start of name followed by _ or $

    This issue will close once commit e08e9d2 is merged into the 'master' branch.
    e08e9d2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bug

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.