Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Fri, 14 Sep 2012 06:01:08 +1100 (NCT)
From: "Brandon Williams (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <233663990.76282.1347562868313.JavaMail.jiratomcat@arcas>
In-Reply-To: <1886138383.19025.1346368507597.JavaMail.jiratomcat@arcas>
Subject: [jira] [Comment Edited] (CASSANDRA-4594) COPY TO and COPY FROM
 don't default to consistent ordering of columns
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-4594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13455144#comment-13455144 ] 

Brandon Williams edited comment on CASSANDRA-4594 at 9/14/12 5:59 AM:
----------------------------------------------------------------------

Committed your 1.1 fix, and committed 4491 to 1.2 but I can't get your 1.2 branch to apply to cql3handling.py.
                
      was (Author: brandon.williams):
    Committed your 1.1 fix, and committed 4491 to 1.2 but I can't your 1.2 branch to apply to cql3handling.py.
                  
> COPY TO and COPY FROM don't default to consistent ordering of columns
> ---------------------------------------------------------------------
>
>                 Key: CASSANDRA-4594
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4594
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Happens in CQLSH 2, may or may not happen in CQLSH 3
>            Reporter: Tyler Patterson
>            Assignee: paul cannon
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 1.1.6
>
>
> Here is the input:
> {code}                                                         
> CREATE KEYSPACE test WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor = 1;
> USE test;                                                                       
>                                                                                 
> CREATE TABLE airplanes (                                                        
>                 name text PRIMARY KEY,                                          
>                 manufacturer ascii,                                             
>                 year int,                                                       
>                 mach float                                                      
>             );                                                                  
>                                                                                 
> INSERT INTO airplanes (name, manufacturer, year, mach) VALUES ('P38-Lightning', 'Lockheed', 1937, '.7');
>                                                                                 
> COPY airplanes TO 'temp.cfg' WITH HEADER=true;                                  
>                                                                                 
> TRUNCATE airplanes;                                                                
>                                                                                    
> COPY airplanes FROM 'temp.cfg' WITH HEADER=true;                                
>                                                                                    
> SELECT * FROM airplanes;
> {code}
> Here is what happens when executed. Note how it tried to import the float into the int column:
> {code}
> cqlsh:test> DROP KEYSPACE test;                                                                
> cqlsh:test> CREATE KEYSPACE test WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor = 1;
> cqlsh:test> USE test;                                                                       
> cqlsh:test>                                                                                    
> cqlsh:test> CREATE TABLE airplanes (                                            
>         ...                 name text PRIMARY KEY,                              
>         ...                 manufacturer ascii,                                 
>         ...                 year int,                                           
>         ...                 mach float                                          
>         ...             );                                                      
> cqlsh:test>                                                                     
> cqlsh:test> INSERT INTO airplanes (name, manufacturer, year, mach) VALUES ('P38-Lightning', 'Lockheed', 1937, '.7');
> cqlsh:test>                                                                     
> cqlsh:test> COPY airplanes TO 'temp.cfg' WITH HEADER=true;                      
> 1 rows exported in 0.003 seconds.                                               
> cqlsh:test> TRUNCATE airplanes;                                                 
> cqlsh:test>                                                                     
> cqlsh:test> COPY airplanes FROM 'temp.cfg' WITH HEADER=true;                    
> Bad Request: unable to make int from '0.7'                                      
> Aborting import at record #0 (line 1). Previously-inserted values still present.
> 0 rows imported in 0.002 seconds.
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira