Steps : 

1. Connect to VoltDB

2. Execute below queries in query analyzer [I have connected  voltDB 6.8 version and used  voltDB 6.8.jar file under ADS lib folder. Database connected successfully.]

 

CREATE TABLE ANSWERS1 ( 
   ID             INTEGER NOT NULL,
   QUESTION_ID    INTEGER NOT NULL,
   TEXT           VARCHAR(50) NOT NULL,
   CONSTRAINT VOLTDB_AUTOGEN_IDX_PK_ANSWERS_ID PRIMARY KEY(ID)
)
GO

INSERT INTO ANSWERS1 VALUES (1, 2, 'ANSWER 1 TO QUESTION 2')
GO
INSERT INTO ANSWERS1 VALUES (2, 1, 'ANSWER 1 TO QUESTION 1')
GO
INSERT INTO ANSWERS1 VALUES (3, 1, 'ANSWER 2 TO QUESTION 1')
GO

 

3. Now open new query analyzer and write below query.

 

SELECT * FROM ANSWERS1
GO

4. Click on Execute Edit icon 

5. Table data window opened.

6. Try to edit any value and Click on Save & Close icon

 

Below error message in the Messages Tab

 

Unexpected Error: Query(1/1) General Provider Error (GRACEFUL_FAILURE): 'Unexpected Ad Hoc Planning Error: java.lang.RuntimeException: Error compiling query: org.voltdb.planner.PlanningErrorException: Error in "UPDATE "VoltDB"."ANSWERS1" SET "TEXT"='ANSWER 1 TO QUESTION 22' WHERE "ID"=1" invalid schema name: VoltDB'

 

Observation : 

Error observed because query is generated with schema name.

If we copy same query and remove the schema name -> query works fine in query analyzer.

 

Observed in ADS 16 also.