allow queries with table joins across different databases

ORA-01791 due to bad driver name in Doctrine_Adapter_Oracle

ORA-00904 in Doctrine_Connection_Oracle

CLONE -Multiple connections and i18n (raised as unresolved - original ticket marked as resolved)

Doctrine is unable to handle table names with spaces

i am executing doctrine type query i am geting error please gave me reply

MySQL field aliases with triple ticks

Broken logic when doctrine translates limit's into subqueries, with joins. (with patch)

Non-Equal Nest Relations Not Working - from "Children" side

Doctrine ignored PORTABILITY_FIX_CASE and ATTR_FIELD_CASE settings when building query

Causing ORA-01791 when try to sort on relation field and use limit in query to Oracle DB

0 down vote favorite In some circumstances Doctrine_Core::getTable('%Name%') returns Doctrine_Table instance instead of %Name%Table one.

Version classes not built for models using package attribute

[PostgreSQL] In case model is build from existing database sequence name is invalid and doctrine throw exception

Result Cache

Aggregates functions do not return proper values when using many relationships and limits

Named parameters doesn't work on MSSQL anymore

Work on link-table and leftJoin

Ordering m2m relationship with column from related table (with orderBy option)

Warning: Invalid argument supplied for foreach() in SqlWalker.php line 899

Renaming a doctrine 'string' field may result in loss of data as the field's type changes. (MySQL)

limit() get lost on multiple joins

Doctrine_Relation_ForeignKey ignores ATTR_COLL_KEY attribute

save() also updates fields which should not be

Cannot update a field to NULL with MSSQL connection

Moving all ALTERS queries to the end of generated sql file (task build-sql)

Doctrine_Connection_Mssql dies on modifyLimitSubquery every time

Doctrine cache - Salt dissociation

Queries fail when a model contains underscore and we try to apply a limit

master-slave replication with i18n behavior

postHydrate not called for One to One relations, when ATTR_HYDRATE_OVERWRITE == false, and the record is cached in the table's identityMap

Model's default sorting breaks subqueries

Alias in select and having

CLONE [DC-558] incorrect handling of MODEL_CLASS_PREFIX causes Doctrine_Migration_Diff to drop the whole database when working from YAML (Regression)

Sequence name of build process is different to the one used in UnitOfWorks (based on DC521 with updated TestCase)

Incompatibilty between fixture import and accessors extends

Imported objects not converted to objects and parsed as string when a setter method exists

Call record->get('RelationManyToManyName', FALSE) corrupt the record and generate a exception when calling record->save()

Wrong data type for oracle integer

NULL Dates are translated to '0000-00-00' after upgrading to 1.2.2

Sluggable behavior does not check uniqueness on insert if a slug is manually set, causing SQL error/crash

_getCacheKeys() exhausts memory

Doctrine outputs invalid SQL when using Limit and Order By conditions in MSSQL

HYDRATE_RECORD_HIERARCHY broken with many roots

Doctrine_Record seems to have a bug with default values when updating

Lazy loading - doctrine makes extra queries into db

AddPendingJoinConditions doesn't work if alias equals model name

Inserts instead of updates for related objects

Doctrine is not compatible with PHP 5.4 due to change in serialize() behaviour.

Bug in select query when executed against postgreSQL

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.title' in 'field list'

Timestampable listener does not set timestamp fields on a copy of a Doctrine_Record

error with Timestamp data Validation

MSSQL Connection

Connection MSSQL replaceBoundParamsWithInlineValuesInQuery

data-load with invalid filename leads to purging of all the data in the database

Error:"When using..ATTR_AUTO_ACCESSOR_OVERRIDE you cannot.. name "data" ..." when running doctrine:build-schema ... except I'm NOT using that word

Using ->limit() in conjunction with many-to-many with mysql generates wrong SQL

Missing Foreign Key Constraint in SQL

Migration does not quote identifiers when checking migration version

Doctrine_Export_Oracle::alterTable() not properly quoting column identifier for change

[PATCH] Use multibyte version of strtolower

[PATCH] doctrine 1.2.4 ADD/DROP CONSTRAINT UNIQUE

PgSQL driver does not create indexes on foreign key columns

i am executing

i am executing doctrine type query i am geting error please gave me reply my query i am typed in descrition field

Doctrine migration does not set version when MySQL autocommit is false

In the Timestampable Listener, the 'alias' behavior option is not used when determining the database fieldname

bindComponent not called before inherited classes base definitions

Geographical behaviour generates wrong INSERT statement in PostgreSQL if latitude/logitude not specified

[PATCH] Doctrine ignores unique option for integers (PostgreSQL)

wierd behaviour with setTableName - table name doesn't get set

When putting a subquery in the where clause which includes a join and a limit the limit subquery algorithm mistakenly modifies the subquery

missing oci_type in Doctrine_Adapter_Statement_Oracle->bindParam

ATTR_TBLNAME_FORMAT not used when creating models from database

Typos in filename and php tags

Wrong parsing on HAVING clause

Query cache key can be incorrectly generated

MySQL Driver possibly subject to sql injections with PDO::quote()

Doctrine collections are overwritten when created by inner join queries that agree on the WHERE

UPDATE query generate ambiguous statement

Doctrine_Data_Import creates unnecessary transactions, big slowdown

I18n - Translated fields are not deleted when record in master table is deleted

Views abstraction model

Doctrine_Connection::execute() and Doctrine_Connection::exec() fail if Doctrine_Event::skipOperation() is triggered

migrations should allow generation of SQL in place of DB manipulation

createIndexSql and dropConstant do not correct set index name suffix

doctrine migration does not use tblname_format

Pessimistic locking locks entire table rather than record

Fixtures loading is repeated for each database connections

Options for building models aren't forwarded from CLI to Manager instance

Class prefix isn't being appended when importing data

Doctrine save() only checks one level deep on one-to-one relations.

generateFile = true - problematic implementation, see symfony ticket #4522

Statements with empty results are not correctly closed

Tree result sets hydrators are checking for column level not field level

I18n and PostgreSQL and DmVersionable

Problems with fetchArray() combined with leftJoin() by using aliases of columns

Default Order By incorrectly propagating to relations

Copy uses mutators but does not use accessors

Bug in OCI8 adapter's freeCursor function causes exception with HYDRATE_ON_DEMAND

DC-952 updating Models with Intra-Table Relations cascades strangely

MSSQL doctrine inner join group by problem

Validation error (unique) when inserting an object with Searchable behavior

Loading fixtures containing data for Versionable/Searchable Models fails due to Duplicate-Key errors

tinyint(1) with default value in schema.yml generates blank default value, gives SQLSTATE[42000]

Doctrine fails when using link() on OneToMany because of failing save

Error in generating the field size and error in the generation of the date fields for postgres

(patch)allow Native floats and double precision field types for MySQL, Oracle, Pgsql

Oracle Doctrine_RawSql()->count() generates illegal SQL

Precedence problem in SQL generation allows bypass of pending joins

fromArray makes unnessesary cals to database

Spatial index type for mysql

Doctrine - loading a YAML fixture with French characters, replaces the accents with junk

Patch for Doctrine ..... to identify in some cases autoincremented fields in oracle

Impossible to use other formats than YAML in data import

Cross Schema stored procedures are not recognized

json schema import broken

Doctrine_Task_BuildAllReload does not call generate-models-from-yaml

One-to-one relationship with cascading deletion and softdelete creates empty records

Newly generated Migration Classes failing to load due to method used to determine class name

Complex query with DISTINCT and LIMIT on pgsql causes a SQLSTATE exception - problem in doctrine_subquery_alias

createIndexSql and dropIndexSql don't use the same logic to get the index name

[Migrations] Drop not null is not working in Postgres

Query with left join and group clause returns only one row, even though there are multiple results

missing hasOne() method-call in many-to-many relation

type mismatch for keyfield in column aggregation

The ability to add WITH ROLLUP to a group by in a query

The ability to add sql in the query between the first word and body of the query (allowing "SELECT STRAIGHT_JOIN" etc)

Import/Pgsql.php: listTableColumns - SQL failure with PostgreSQL

Doctrine take wrong connction

fetchOne defect

Doctrine_Pager ignores custom COUNT query

A method that can run in a model when the model is autoloaded

A way of checking if a model has been loaded via the loaded loadModels method

Sub queries do not work properly in the on clause of a join

Can't save Doctrine Expression AES_ENCRYPT into a utf8_general_ci field

when I delete fields from a table in oracle 10g and I execute build schema keeps bringing me those same fields that no longer exist.

Doctrine_Query (execute / fetchOne) memory leak

Make Doctrine_Record_UnknownPropertyException error more descriptive

Xcache Cache Driver is not documented

Expose hardDelete method on node object when SoftDelete behavior is used

(PATCH) Migration fails when addColumn with type 'boolean' used with default value, resulting in incorrect 'ALTER TABLE' query in MySQL

Pager ignores default model hasMany ORDER BY statements, caused by getLimitSubquery ignoring same

Using default value for bigint fields generates an error

Typo. in Import/Pgsql.php

Using RANDOM() AS rand as last field WITHOUT a comma between them works, but not randomly

Foreign key id columns do not respect ATTR_DEFAULT_IDENTIFIER_OPTIONS

disabling deep option with toArray() drops relations in result

Doctrine should support mysql native float/double

Building schema doesn't work when tables have cross database foreign keys (MySQL).

Doctrine_Collection::loadRelated uses getLocal instead of getLocalFieldName

Doctrine Collection FromArray doesn't adhere to KeyColumn

Doctrine_Manager::parsePdoDsn() doesn't work properly [+patch]

Versionable + I18n creates additional migration with irrelevant data

cannot access the version models using object->CLASSNAMEVersion in v1.2.3

Hydrator fatal error: Found non-unique key mapping named 'lang'

Basic Request return one element.

One-to-many relationship returns Doctrine_Record instead of Doctrine_Collection

Allow parameters to be passed to Doctrine_Query::select()

Update Execute Params do not persist

When importing fixtures some times the fixtures will be loaded in the wrong order causing broken foreign key relations

NestedSet not moving children of child nodes correctly

calling getLastModified() after saving the object without any modifications returns the last modified fields

Doctrine::ATTR_IDXNAME_FORMAT and Doctrine::ATTR_FKNAME_FORMAT are inconsistently applied during migrations

Bug In Debian "Can't parse dsn.."!

Models that extend a baseclass other than Doctrine_Record treat that baseclass as if it were a model

Connection.UnitOfWork::buildFlushTree when loading data from yml file, Incorrect ordering of tables by their relations

INNER JOIN example is same as previous LEFT JOIN example

Diff generator doesn't load models from specified paths

Custom Behaviors/Templates cause autoloader errors

Doctrine_Core::getPath() not working when inside phar, due to a bug in php

having not work as expected and described

I am using symfony 1.4

Error in Doctrine method execute()

Error Generate Schema.yml Database Oracle

Can not set a default value of 'CURRENT_TIMESTAMP' in a table definition for mysql

One of our Foreign Keys is not being inserted/passed

DataDict for MySQL excludes the possibility to have an actual floating point column

Alias linking wrong

Doctrine_Connection_Mssql::replaceBoundParamsWithInlineValuesInQuery regex failing to replace all '?' instances [patch+]

"Primary columns are implied to be notnull in Doctrine" but are not

Add support for AFTER in migration addColumn function

Inconsistent record validation on a notnull foreign key when the local relation is set

When altering an existing column PGSQL can't convert to SERIAL for autoincrement

Data type in YAML schema spacing issue

Importing fixtures fails when GoogleI18n used with "Couldn't create collection index. Record field 'lang' was null."

Migration for up() not adding suffix for index

Hydrator/RecordDriver/setLastElement And APC useResultCache

MSSQL - ORDER BY on text columns throws mssql error 306 [+patch]

Custom Doctrine_Query UPDATE statement inside migration scope not working

Versionable does not work with column alias on primary keys [+patch]

Nested aggregate fields do not hydrate to the right object

protected method _isValueModified returns wrong result

Postgresql and query cache

Doctrine relations: Doctrine_Record::fromArray() does not update local field when new linked record is created

Doctrine_Query_Abstract::set() Does not handle boolean values correctly.

Equal nest relation uses incorrect SQL and returns incorrect data

i8n behavior

Multiple template implementation (setImpl)

Doctrine_Query::parseFunctionExpression() produces unexpected results if the expression contains a function

Change column Postgres

Records containing a one-to-one relation are hydrated as dirty/modified

Can't mix Soft and Hard deletes. Fix with patch provided.

import->listTableColumns / export->alterTableSql issues

Doctrine query with the Oracle SOUNDEX function

Doctrine_Inflector::unaccent() Problem with array keys for Norwegian characters

Better documentation for the generated getInstance method in generated *Table.class.php files

Reopen DC-125. Searchable: batchUpdateIndex has a memory leak

Join & On override

Doing introspection of postgres datagbases with sequences for columns does not generate 'nextval(sequence_name)::regclass' for default value

Generated SQL for indexes is faulty

sf1.4 i18n form create/update item extra insert

Aggregate column becomes NULL when using TableClass->create(array(...))

getConnectionForComponent and bindComponent are case sensitive

Cannot fromArray a toArray with many to many records

Connection::createQuery() can use wrong connection

Variable type different for return value from Doctrine_Record->toArray() depending on whether the object is from a select, or a save.

Renaming a NOT NULL column without a default value fails in MySQL migrations

preQuery() and getConnection() - multiple connections

Incorrect query for inherited many-to-many relation

MSSQL Server: No support for transaction savepoints

MSSQL Server: Support for RAND() in Doctrine_Expression_MSSQL

MSSQL Server / ODBC: Cannot order by a column aggregate when a limit subquery is required.

CascadeDelete not work properly on Versionable and on the AuditLog

In SQL query, field name is not replaced with real column name in right part of join condition

Cannot use named parameters in a 'limit(':max') clause

doctrine generate-migrations-diff throws "No php or yml files found at path"

[PATCH] fix migration builder for remove index

migration error when deleting 2 or more related classes

Warning: implode(): Invalid arguments passed in /Doctrine/Table.php on line on line 922

Add support for relations consist on two or more fileds

Sort of Migration Class Problem With More Than 9 Classes

issue with multiple connection handling

Pager returns incorrect page number when constructed on query with HAVING

[Documentation] Taking Advantage of Column Aggregation Inheritance

Length validator fail because it was bad initialized

Updating slug in I18N behaviour yields non-unique slug

ReOpen DC-46 - Unexpected behavior with whereIn() and empty array

Blameable relations import problem

String = 512 becomes TEXT

String(512) is being implemented as TEXT instead varchar(512) on MySQL

Wrong definition for MySQL string primary column

When inserting node as direct children of a root node, it seems the root node is not populated with new lft/rgt values...

Where fields not escaped properly when deleting associations.

Can not create a subquery in where

Columns of type 'array' adds default clause to the create table statement which isn't supported by MySQL.

After adding a Reference, the ForeignKeys in the DB are not updatet

HYDRATE_ARRAY causes timeout with no fields selected

Validation exception thrown only if internal nesting level == 1

Call to undefined method Doctrine_Adapter_Mysqli::setAttribute()

migration fails for long foreign key names

Unable to create relations with several fields

Subquery Doctrine Couldn't find class

When Export from Models to database is made some constraints may not be created

unidirectionnal hasMany definition

[PATCH] Doctrine_Record::option('orderBy', ...) of join's right side being applied to refTable in m2m relationship

Getting Doctrine_Validator_Exception on Doctrine_Record::replace() when using unique

Behavior geographical generates latitude DOUBLE(18, 2), longitude DOUBLE(18, 2) - it's not exact

Doctrine_Collection problem duplicate record

Slugs aren't created when inserting/updating a table row

Many-to-many: Using Association Class (refclass) property in query adds leftJoin

synchronizeWithArray and link-table

getPopularTags() query fails on Postgresql

Documentation

Add Undelete functionality to SoftDelete behaviour

Doctrine Integer Validator should use intval() rather than round(floatval())

Two queries on the same table seems to share set of fields

Doctrine_Query throws exception for custom hydrator that extends stock hydrator

Validator_Readonly fails for new objects

Impossible to create non-unique slugs

preHydrate/postHydrate events do not use proper sub-class component

DC-740 [PATCH] Local key relations without modifed fields but with modified relations are not saved

migration problem

New sequence generation for PostgreSQL SQL code results in errors

Separate the properties of the parent and the children

Chaining innerjoins can only be made uni-directional; order matters

Symfony doctrine doesnt save an M:M table if one of the tables is in a 1:1 relationship with another table

Limit and Offset breaks query with multiple non-join FROM statements

[Oracle] Query on M:M with relation name doesn't work

When using a join and giving an alias to each select column the hyrdrator only returns one row.

Query Cache causes exception when using array parameter and IN in a where clause

Array hydration fails when sorting DESC

refreshRelated() causes an id to be changed from string to int, causing an unnecessary update query.

Problem with non equal self referencing many to many relations