alter table rename fail with error 42000

Bug #1036687 reported by Don Nolin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Akiban SQL Parser
Fix Released
Wishlist
Vy Nguyen

Bug Description

Using the CAOI schema, the follow command returns error 42000:

ALTER TABLE books RENAME TO books1

Akiban Server version: 1.4.0-SNAPSHOT.2043

Server.log trace:
Caused by: com.akiban.sql.parser.ParseException: Encountered " "rename" "RENAME "" at line 1, column 19.
Was expecting one of:
    "add" ...
    "all" ...
    "alter" ...
    "drop" ...
    "update" ...
    "locksize" ...
    "compress" ...

 at com.akiban.sql.parser.SQLGrammar.generateParseException(SQLGrammar.java:22607)
 at com.akiban.sql.parser.SQLGrammar.jj_consume_token(SQLGrammar.java:22452)
 at com.akiban.sql.parser.SQLGrammar.alterTableBody(SQLGrammar.java:13346)
 at com.akiban.sql.parser.SQLGrammar.alterStatement(SQLGrammar.java:13175)
 at com.akiban.sql.parser.SQLGrammar.spsAlterStatement(SQLGrammar.java:1906)
 at com.akiban.sql.parser.SQLGrammar.StatementPart(SQLGrammar.java:1731)
 at com.akiban.sql.parser.SQLGrammar.Statement(SQLGrammar.java:1644)
 at com.akiban.sql.parser.SQLGrammar.parseStatement(SQLGrammar.java:1631)
 at com.akiban.sql.parser.SQLParser.parseStatement(SQLParser.java:114)
 ... 4 more

Revision history for this message
Vy Nguyen (oontvoo) wrote :

This looks more like an 'unsupported feature' to me.

affects: akiban-server → akiban-sql-parser
Mike McMahon (mmcm)
Changed in akiban-sql-parser:
status: New → Confirmed
importance: Undecided → Wishlist
Vy Nguyen (oontvoo)
Changed in akiban-sql-parser:
status: Confirmed → Fix Released
assignee: nobody → Vy Nguyen (oontvoo)
Changed in akiban-sql-parser:
milestone: none → 1.0.11
information type: Private → Public
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.