Bug #2602 Glitch in syntax for CACHE INDEX/LOAD INDEX INTO CACHE

• Submitted: 1 Feb 2004 15:13
• Modified: 2 Feb 2004 9:37
• Reporter: Paul DuBois
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• Assigned to: Igor Babaev
• CPU Architecture: Any

[1 Feb 2004 15:13] Paul DuBois

Description:
sql_yacc.yy syntax for the CACHE INDEX and LOAD
INDEX INTO CACHE statements is a bit incorrect.

The syntax allows these modifiers before index
names: INDEX, INDEXES, KEYS

That's different than other statements, which allow
the modifiers: INDEX, KEY

How to repeat:
Look at sql_yacc.yy

Suggested fix:
Remove INDEXES and KEYS as allowable modifiers.
Add KEY as an allowable modifier.

The result is that INDEX and KEY are allowable.

(This is per discussion with Igor.)

[2 Feb 2004 9:37] Igor Babaev

Fixed in sql_yacc.yy