[ https://issues.apache.org/jira/browse/PHOENIX-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15585155#comment-15585155 ]
Hudson commented on PHOENIX-3349: --------------------------------- SUCCESS: Integrated in Jenkins build Phoenix-4.8-HBase-1.2 #37 (See [https://builds.apache.org/job/Phoenix-4.8-HBase-1.2/37/]) PHOENIX-3349 DROP TABLE and DROP SEQUENCE not working with schemas (ankitsinghal59: rev da3cc87d2307a1d8446ba6f1172968a1a79962e0) * (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/UseSchemaIT.java * (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/SequenceManager.java * (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java > 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)