[
https://issues.apache.org/jira/browse/TRAFODION-2044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328297#comment-15328297
]
ASF GitHub Bot commented on TRAFODION-2044:
-------------------------------------------
Github user robertamarton commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/544#discussion_r66870205
--- Diff: core/sql/regress/seabase/TEST040 ---
@@ -0,0 +1,139 @@
+-- test for CREATE TABLE LIKE
+--
+-- @@@ START COPYRIGHT @@@
+--
+-- Licensed to the Apache Software Foundation (ASF) under one
+-- or more contributor license agreements. See the NOTICE file
+-- distributed with this work for additional information
+-- regarding copyright ownership. The ASF licenses this file
+-- to you under the Apache License, Version 2.0 (the
+-- "License"); you may not use this file except in compliance
+-- with the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing,
+-- software distributed under the License is distributed on an
+-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+-- KIND, either express or implied. See the License for the
+-- specific language governing permissions and limitations
+-- under the License.
+--
+-- @@@ END COPYRIGHT @@@
+
+set schema $$TEST_SCHEMA$$;
+log LOG040 clear;
+
--- End diff --
May want to add a "cleanup" first before starting the test. This way, if
this test failed previously, you are starting with a clean slate.
> CREATE TABLE LIKE with SALT USING clause uses source table partition count
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-2044
> URL: https://issues.apache.org/jira/browse/TRAFODION-2044
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmu
> Affects Versions: 2.0-incubating
> Environment: Trafodion 2.0 environment
> Reporter: Carol Pearson
> Assignee: David Wayne Birdsall
> Fix For: 2.1-incubating
>
>
> Using CREATE TABLE LIKE to create a table, then changing the number of
> partitions. The resulting new table number of partitions matches the
> partitioncount for the source table in the CREATE TABLE LIKE statement,
> rather than the value specified in the command:
> See the following commands:
> >>>create table tsource (c1 int not null, c2 int not null, primary key (c1))
> +>salt using 4 partitions;
> --- SQL operation complete.
> >>create table tsource_like like tsource salt using 8 partitions;
> --- SQL operation complete.
> >>showddl tsource_like
> +>;
> CREATE TABLE TRAFODION.SEABASE.TSOURCE_LIKE
> (
> C1 INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , C2 INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , PRIMARY KEY (C1 ASC)
> )
> SALT USING 4 PARTITIONS
> ;
> --- SQL operation complete.
> >>
> But table tsource_like was created using SALT USING 8 PARTITIONS
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
