• Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.4
    • Component/s: DQL
    • Security Level: All
    • Labels:
    • Environment:
      Using Doctrine in Symfony 2.2.1 on Windows Platform


      The following DQL :

      SELECT s,ba,c,mno,ss,sws,ccs,cns,cws FROM WLCoreBundle:SIM s INNER JOIN s.billingAccount ba LEFT JOIN s.connection c INNER JOIN s.status ss LEFT JOIN s.workflowStatus sws INNER JOIN c.customerStatus ccs INNER JOIN c.networkStatus cns LEFT JOIN c
      .workflowStatus cws INNER JOIN s.mno mno ORDER BY c.msisdn ASC

      Produces the following SQL :

      SELECT * FROM (SELECT AS id0, c0_.iccid AS iccid1, c0_.created AS created2, c0_.updated AS updated3, c0_.spreference AS spreference4, ASid5, c1_.account_number AS account_number6, AS name7, c1_.address1 AS address18, c1_.address2 AS address29, c1_.address3 AS address310, c1_.address4 AS address411, c1_.address5 AS address512, c1_.address6 AS address613, c1_.email_address AS email_address14, c1_.spreference AS spreference15, AS id16, c2_.msisdn AS msisdn17, c2_.local AS local18, c2_.imsi AS imsi19, AS data20, c2_.fax AS fax21, c2_.api AS api22, c2_.activation_date AS activation_date23, c2_.contract_end_date AS contract_end_date24, c2_.created AS created25, c2_.updated AS updated26, c2_.spreference AS spreference27, AS id28, c3_.ident AS ident29, c3_.label AS label30, c3_.description AS description31, AS id32, c4_.ident AS ident33, c4_.label AS label34, c4_.description AS description35, c4_.customer_label AS customer_label36, c4_.customer_description AS customer_description37, AS id38, c5_.ident AS ident39, c5_.label AS label40, c5_.description AS description41, AS id42, c6_.ident AS ident43, c6_.label AS label44, c6_.description AS description45, AS id46, c7_.ident AS ident47, c7_.label AS label48, c7_.description AS description49, c7_.customer_label AS customer_label50, c7_.customer_description AS customer_description51, AS id52, AS name53, c8_.email_address AS email_address54, c8_.is_active AS is_active55, c8_.spreference AS spreference56, c0_.billing_account AS billing_account57, c0_.customerHierarchy AS customerHierarchy58, c0_.mno AS mno59, c0_.status AS status60, c0_.workflow_status AS workflow_status61, c1_.customer_hierarchy AS customer_hierarchy62, AS country63, c1_.tax_rate AS tax_rate64, c1_.currency AS currency65, c1_.status AS status66, c1_.priority AS priority67, c2_.sim AS sim68, c2_.customer_status AS customer_status69, c2_.network_status AS network_status70, c2_.workflow_status AS workflow_status71, ROW_NUMBER() OVER (ORDER BY msisdn17 ASC) AS doctrine_rownum FROM core_sim c0_ WITH (NOLOCK) INNER JOIN core_billing_account c1_ ON c0_.billing_account = LEFT JOIN core_connection c2_ ON = c2_.sim INNER JOIN core_sim_status c3_ ON c0_.status = LEFT JOIN core_sim_workflow_status c4_ ON c0_.workflow_status = INNER JOIN core_connection_customer_status c5_ ON c2_.customer_status = INNER JOIN core_connection_network_status c6_ ON c2_.network_status = LEFT JOIN core_connection_workflow_status c7_ ON c2_.workflow_status = INNER JOIN core_mno c8_ ON c0_.mno = AS doctrine_tbl WHERE doctrine_rownum BETWEEN 1 AND 10

      Which returns an error :

      SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'msisdn17'.

      Same query works fine in Doctrine 2.3



          • Assignee:
            fabio.bat.silva Fabio B. Silva
            manseuk Paul Mansell
          • Votes:
            0 Vote for this issue
            4 Start watching this issue


            • Created: