Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Labels:None
-
Environment:win7 xamp mysql
Description
Hello, I have the following XML mapping
<entity name="Auth" table="Auth">
<id name="itemname" column="itemname" type="string" length="64" />
<id name="userid" column="userid" type="string" length="64" />
<field name="bizrule" column="bizrule" type="text" nullable="true" />
<field name="data" column="data" type="text" nullable="true" />
</entity>
And the sql output is:
CREATE TABLE Auth (itemname VARCHAR(255) NOT NULL, userid VARCHAR(255) NOT NULL, bizrule LONGTEXT DEFAULT NULL, data LONGTEXT DEFAULT NULL, PRIMARY KEY(itemname, userid)) ENGINE ...
So, the length atrtibute is always ignored. In MyIsam it breaks the script because of the maximum key limit 
Activity
Lazar Otasevic
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Description |
Hello, I have the following XML mapping <entity name="Auth" table="Auth"> <id name="itemname" column="itemname" type="string" length="64" /> <id name="userid" column="userid" type="string" length="64" /> <field name="bizrule" column="bizrule" type="text" nullable="true" /> <field name="data" column="data" type="text" nullable="true" /> </entity> And the sql output is: CREATE TABLE Auth (itemname VARCHAR(255) NOT NULL, userid VARCHAR(255) NOT NULL, bizrule LONGTEXT DEFAULT NULL, data LONGTEXT DEFAULT NULL, PRIMARY KEY(itemname, userid)) ENGINE; So, the length atrtibute is always ignored. In MyIsam it breaks the script because of the maximum key limit :( |
Hello, I have the following XML mapping <entity name="Auth" table="Auth"> <id name="itemname" column="itemname" type="string" length="64" /> <id name="userid" column="userid" type="string" length="64" /> <field name="bizrule" column="bizrule" type="text" nullable="true" /> <field name="data" column="data" type="text" nullable="true" /> </entity> And the sql output is: CREATE TABLE Auth (itemname VARCHAR(255) NOT NULL, userid VARCHAR(255) NOT NULL, bizrule LONGTEXT DEFAULT NULL, data LONGTEXT DEFAULT NULL, PRIMARY KEY(itemname, userid)) ENGINE ... So, the length atrtibute is always ignored. In MyIsam it breaks the script because of the maximum key limit :( |
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
- Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=OXM-1, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)