[#ZF-8443] Informix-querys with Zend_DB_Adapter_Ibm_Pdo fail with SQL-error due to quoted field names. - Zend Framework Issue Tracker

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Not an Issue
Affects Version/s: 1.9.6
Fix Version/s: 1.10.1
Component/s: Zend_Db
Labels:
None

Description

Informix-querys with Zend_DB_Adapter_Ibm_Pdo fail with SQL-error due to standardly quoted field names.
Should be the possibility to set $_autoQuoteIdentifiers = false if Servertyp is IDS (Informix Dynamic Server).

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Christoph Löffler added a comment - 29/Jan/10 7:07 AM

I am a collegue of Gunnar Fratzke.
We discussed this topic and I think this is not a bug.

The error occured because our Informix installation is kind of special and does not accept quoted field names.

We found as solution to disable autoQuoteIdentifiers in XML Config:

<params>
    <host>hostname</host>
    <!-- ... -->
    <options>
        <autoQuoteIdentifiers>0</autoQuoteIdentifiers>
    </options>
  </params>

Show

Christoph Löffler added a comment - 29/Jan/10 7:07 AM I am a collegue of Gunnar Fratzke. We discussed this topic and I think this is not a bug. The error occured because our Informix installation is kind of special and does not accept quoted field names. We found as solution to disable autoQuoteIdentifiers in XML Config:

<params>
    <host>hostname</host>
    <!-- ... -->
    <options>
        <autoQuoteIdentifiers>0</autoQuoteIdentifiers>
    </options>
  </params>

Hide

Permalink

Mickael Perraud added a comment - 30/Jan/10 10:10 AM

It's effectively the goal of this option.
Closed as not an issue.

Show

Mickael Perraud added a comment - 30/Jan/10 10:10 AM It's effectively the goal of this option. Closed as not an issue.

People

Assignee:

Ralph Schindler

Reporter:

Gunnar Fratzke

Vote (0)

Watch (0)

Dates

Created:

02/Dec/09 6:11 AM

Updated:

30/Jan/10 10:10 AM

Resolved:

30/Jan/10 10:10 AM