[
https://issues.apache.org/jira/browse/PHOENIX-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15584763#comment-15584763
]
Ankit Singhal commented on PHOENIX-3349:
----------------------------------------
Thanks [~rajeshbabu],
committed 4.8, 4.x branches and master.
> DROP TABLE and DROP SEQUENCE not working with schemas
> -----------------------------------------------------
>
> Key: PHOENIX-3349
> URL: https://issues.apache.org/jira/browse/PHOENIX-3349
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.1
> Reporter: Francis Chuang
> Assignee: Ankit Singhal
> Labels: schema
> Fix For: 4.9.0, 4.8.2
>
> Attachments: PHOENIX-3349.patch
>
>
> I am using 4.8.1 with HBase 1.2.3. I am talking to Phoenix using the Phoenix
> Query Server (Avatica)
> phoenix.schema.isNamespaceMappingEnabled is set to true in my configuration.
> To reproduce the problem:
> 1. Execute CREATE SCHEMA IF NOT EXISTS myschema
> 2. Open a connection to the query server and set the schema to myschema by
> setting the info map to {"schema": "myschema"} in the OpenConnectionRequest:
> https://calcite.apache.org/docs/avatica_protobuf_reference.html#openconnectionrequest
> 2. Execute CREATE TABLE test_table1 (id integer not null primary key)
> 3. ExecuteUPSERT INTO test_table1 (id) VALUES(1)
> Until this point, the schema and table were all created correctly. Upserting
> also works. If we check system.catalog, we can confirm that the table was
> created as myschema.test_table1.
> 4. If we attempt to drop the table using the same connection, it neglects to
> include the schema, so it fails: DROP TABLE test_table1
> {code}
> RuntimeException: org.apache.phoenix.schema.TableNotFoundException: ERROR
> 1012 (42M03): Table undefined. tableName=TEST_TABLE1 ->
> TableNotFoundException: ERROR 1012 (42M03): Table undefined.
> tableName=TEST_TABLE1
> {code}
> The same problem can be reproduced with DROP SEQUENCE.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
