[jira] [Created] (METAMODEL-131) Create table with composite primary key gives error.

[Hosur Narahari (JIRA)]

Hosur Narahari created METAMODEL-131:
----------------------------------------

             Summary: Create table with composite primary key gives error.
                 Key: METAMODEL-131
                 URL: https://issues.apache.org/jira/browse/METAMODEL-131
             Project: Apache MetaModel
          Issue Type: Bug
            Reporter: Hosur Narahari


Creating table with primary key is not possible since while generating sql we 
add "PRIMARY KEY" keyword to each column which results in error in case of 
composite primary keys. Below is the code.

context.executeUpdate(new UpdateScript() {
                        
                        @Override
                        public void run(UpdateCallback callback) {
                                callback.createTable("amass", "test").
                                
withColumn("id").ofType(ColumnType.INTEGER).ofSize(16).asPrimaryKey()
                                
.withColumn("name").ofType(ColumnType.VARCHAR).ofSize(255).asPrimaryKey()
                                .execute();
                        }
                });

I am using mysql. Am I using it in the wrong way?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)