#1439: Different column type of database abstraction & command line sql
generation
-----------------------------------+----------------------------------------
Reporter: quocbao | Owner: jwage
Type: defect | Status: new
Priority: minor | Milestone: 1.0.1
Component: Attributes | Version: 1.0
Keywords: | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
I use a schema file to define a table as follow :
{{{
NewsStory:
tableName: newsstories
columns:
story_id:
name: story_id as Id
type: integer
unsigned: 1
primary: true
autoincrement: true
...
}}}
When I use command line interface to generate sql, here is the result :
{{{
CREATE TABLE newsstories (story_id BIGINT UNSIGNED AUTO_INCREMENT, ...
}}}
But if I use database abstraction to create the same table
{{{
$cnn->export->createTable('newsstories ',array(
'story_id' => array(
'type' => 'integer',
'length' => 4,
'unsigned' => true,
'notnull' => false,
'primary' => true,
'autoincrement' => true,
),
));
}}}
Will generate a table as follow
{{{
story_id int(10) UNSIGNED
}}}
So with the same definition, database abstraction give different sql (type
of story_id is INT) and command line sql generation give different sql
(type of story_id is bigint)
I think this is a bug and it should be fixed
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1439>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
