Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Invalid
-
Affects Version/s: 1.1.4, 1.1.5
-
Fix Version/s: None
-
Component/s: Schema Files
-
Labels:None
-
Environment:Linux, Oracle 10g
Description
Doctrine generates invalid sql statements when using default values for several column types - the reult is an empty default value wich cause error when trying to create the db schema.
The following modification was used as a workaround (maybe it's not the best way for other databases):
doctrine formater.php (line 191).
case 'date':
case 'time':
case 'timestamp':
case 'string':
case 'char':
case 'varchar':
case 'text':
case 'gzip':
case 'blob':
case 'clob':
case 'enum':
case 'boolean':
// remove this line: $this->conn->connect();
// remove this line: return $this->conn->getDbh()->quote
($input);
// add the line below
return "'" . str_replace("'","''",$input) . "'";