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.

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

ORA-00904 in Doctrine_Connection_Oracle

ORA-01791 due to bad driver name in Doctrine_Adapter_Oracle

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

Doctrine is unable to handle table names with spaces

allow queries with table joins across different databases

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

Named parameters doesn't work on MSSQL anymore

Work on link-table and leftJoin

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

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

save() also updates fields which should not be

Cannot update a field to NULL with MSSQL connection

Doctrine_Connection_Mssql dies on modifyLimitSubquery every time

Doctrine cache - Salt dissociation

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

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

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

Lazy loading - doctrine makes extra queries into db

AddPendingJoinConditions doesn't work if alias equals model name

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

Doctrine_Record seems to have a bug with default values when updating

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()

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

json schema import broken

Doctrine_Task_BuildAllReload does not call generate-models-from-yaml

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

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

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

[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

type mismatch for keyfield in column aggregation

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

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

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

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

Doctrine take wrong connction

fetchOne defect

Doctrine_Pager ignores custom COUNT query

I18n and PostgreSQL and DmVersionable

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

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

Can't save Doctrine Expression AES_ENCRYPT into a utf8_general_ci field

Make Doctrine_Record_UnknownPropertyException error more descriptive

Doctrine_Query (execute / fetchOne) memory leak

Xcache Cache Driver is not documented

Expose hardDelete method on node object when SoftDelete behavior is used

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

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

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

Doctrine_Collection::loadRelated uses getLocal instead of getLocalFieldName

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

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'

One-to-many relationship returns Doctrine_Record instead of Doctrine_Collection

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

Basic Request return one element.

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

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

i am executing

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)

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 save() only checks one level deep on one-to-one relations.

Statements with empty results are not correctly closed

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

Default Order By incorrectly propagating to relations

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

Copy uses mutators but does not use accessors

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

MSSQL doctrine inner join group by problem

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

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

fromArray makes unnessesary cals to database

Precedence problem in SQL generation allows bypass of pending joins

Spatial index type for mysql

Impossible to use other formats than YAML in data import

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

Cross Schema stored procedures are not recognized

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 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

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

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

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

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

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

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

Joined records stated as dirty (whereas they are not modified)

preDql events on connection & manager level

Duplicate entry integrity constraint error when updating Searchable record with indexed fields from a template

Problem linking many-to-many relationships

ORACLE: The generate DQL with i18n behavior doesn't correct

Incorrect insert order in i18n entities

Refined definition of relations regarding "copy()" cloning behaviour

doctrine migration fails with taggable extension

Nesting Taggable and I18N

Change in 1.2 to Doctrine_Event::skipOperation() functionality

::isValidType fails when input format is different from php default format

I18n and inheritance

Record Hydration error

using boolean logic in select don't work

Doctrine incorrectly assigns a NULL value to primary key fields

Unexpected results with equal many-to-many relations

Error defining "unique" constraint in a translated (i18n) column

aliased fields from root class are not recognized als root class fields, if they're the only one

Eliminate queries produced by Doctrine_Node_NestedSet::getDescendants() when possible

Doctrine_Query->load crashes with additional ending whitespace in JOIN

Add timezone support for time and timestamp datatype in PostgreSQL

bit(1) columns are broken

Let the parser ignore .* (hidden) files

doctrine_cache_keys bigger than 1mb

Doctrine_Hydrator_ArrayDriver may segfault Php when loaded by Zend Framework Autoloader

mssql fails on find($key)

query cache doesn't cache _isLimitSubqueryUsed

Migrations not respecting ATTR_TBLNAME_FORMAT

Conservative loading not working

No description of ATTR_DEFAULT_IDENTIFIER_OPTIONS now in "Chapter 4 Configuration"

I18n record generator assumes relation alias is the table name

Doctrine_Table getTable singleton issue

Relating to Translation table (generated by Doctrine_I18n) doesn't work correctly after resetting connection

createTablesFromModels() wants to create already existing FOREIGN KEY constraints

Doctrine serializes arrays, objects, etc. like 'string', which is never bigger than a TEXT, limited to 65535 characters (in MySQL)

Doctrine fails to create correct table structure if model is named "User"

concrete inheritance doesn't create all relations

setting "Doctrine_Core::ATTR_EXPORT" to "Doctrine_Core::EXPORT_TABLES" prevents i18n table creation

Call to a member function evictAll() if a table is retrieved, that is not existent

Error in self referencing (nest relations) and tableName.

Doctrine_Query can't map a main query colum inside a subquery with join

Doctrine manual does not document that columns can be added with simple inheritance, or the semantics of accessing those columns in the parent

Documentation unclear about linking inherited objects

Oracle identifier too long in normal SELECT when using longer table name or column

Trouble with auto including generate Base class with specifik name

Multi-table query (left-join) problem in the Doctrine_Hydrator_Graph class

Problem saving Self Referencing (Nest Relations)

Wrong SQL output from Doctrine_Expression for pgsql with timestamp with time zone field

Running out of memory while executing single record lookup.

doctrine pager class with sql server stored procedure

Data dump fails on tables with quoted identifiers

Doctrine/Import/Mssql.php does not handle default values

Doctrine_Pager query "influences" Doctrine::getTable() query

Implement a self-reference class mechanism without the usage of associative classes

Schema: package property for model

Add pre/postHydrateResultSet() events

Pager breaks when HAVING clause references existing table column

Wrong query parameter order when using limit() on PostgreSQL

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

migration fails for long foreign key names

Call to undefined method Doctrine_Adapter_Mysqli::setAttribute()

Unable to create relations with several fields

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

unidirectionnal hasMany definition

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

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

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

migration problem

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

Separate the properties of the parent and the children

New sequence generation for PostgreSQL SQL code results in errors

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

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

[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

Hydrate Array does not return full array, when Hydrate Scalar does

ORACLE: Missing fields on subquery with Many:Many

Select distinct limit problem

Distinct query does not work

issue when changing the connection inside Doctrine_Query::preQuery() on a model using a behavior

Doctrine_Pager bug with Oracle. getNumResults doesn't return the correct number of records

MSSQL Server: Enabling MARS prevents the saving of records.

Duplicate CREATE TABLE entries in schema.sql when using column_inheritance

Savepoint-rollback ignored in nested transaction context.

->where() add parentheses

sometimes not all the constraints are created for a many to many relation

Join and WITH keywords : documentation is confusing

Doctrine_Query_Set incorrectly rewrites expressions

Doctrine should warn when a columns / table name match a reserved word

Taggable extension bound to inherited class also binds to all classes, which extend the base one

Limit gets lost when doing self join