Doctrine Project

  • Log In Access more options
    • Online Help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What’s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
Doctrine 2 - ORM
  • Doctrine 2 - ORM
  • DDC-2193

Named native query bug?

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Bug Bug
  • Status: Awaiting Feedback Awaiting Feedback
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: None
  • Security Level: All
  • Labels:
    None

Description

@NamedNativeQueries is a useful thing, but I have found some problems during my using.
1、Normal

 /**
 * @NamedNativeQueries({
 *      @NamedNativeQuery(
 *          name            = "fetchMultipleJoinsEntityResults",
 *          resultSetMapping= "mappingMultipleJoinsEntityResults",
 *          query            = "SELECT * FROM test "
 *      )
 * })
 */

2、Error,cannot connect to the server

 /**
 * @NamedNativeQueries({
 *      @NamedNativeQuery(
 *          name            = "fetchMultipleJoinsEntityResults",
 *          resultSetMapping= "mappingMultipleJoinsEntityResults",
 *          query            = "SELECT * 
            FROM test "
 *      )
 * })
 */

3、Cannot use alias.The same problem as the second one.

.......
 query            = "SELECT a as test FROM test "
  • Options
    • Sort By Name
    • Sort By Date
    • Ascending
    • Descending
    • Download All

Attachments

  1. File
    DDC2193Test.php
    16/Dec/12 8:48 PM
    2 kB
    Fabio B. Silva

Activity

Ascending order - Click to sort in descending order
  • All
  • Comments
  • History
  • Activity
  • Source
Fabio B. Silva made changes - 12/Dec/12 1:49 PM
Field Original Value New Value
Description @NamedNativeQueries is a useful thing, but I have found some problems during my using.
1、Normal
 * @NamedNativeQueries({
 * @NamedNativeQuery(
 * name = "fetchMultipleJoinsEntityResults",
 * resultSetMapping= "mappingMultipleJoinsEntityResults",
 * query = "SELECT * FROM test "
 * )
 * })
2、Error,cannot connect to the server
 * @NamedNativeQueries({
 * @NamedNativeQuery(
 * name = "fetchMultipleJoinsEntityResults",
 * resultSetMapping= "mappingMultipleJoinsEntityResults",
 * query = "SELECT *
            FROM test "
 * )
 * })
3、Cannot use alias.The same problem as the second one.
.......
 query = "SELECT a as test FROM test "
@NamedNativeQueries is a useful thing, but I have found some problems during my using.
1、Normal
{code}
 /**
 * @NamedNativeQueries({
 * @NamedNativeQuery(
 * name = "fetchMultipleJoinsEntityResults",
 * resultSetMapping= "mappingMultipleJoinsEntityResults",
 * query = "SELECT * FROM test "
 * )
 * })
 */
{code}
2、Error,cannot connect to the server
{code}
 /**
 * @NamedNativeQueries({
 * @NamedNativeQuery(
 * name = "fetchMultipleJoinsEntityResults",
 * resultSetMapping= "mappingMultipleJoinsEntityResults",
 * query = "SELECT *
            FROM test "
 * )
 * })
 */
{code}
3、Cannot use alias.The same problem as the second one.
{code}
.......
 query = "SELECT a as test FROM test "
{code}
Fabio B. Silva made changes - 16/Dec/12 8:48 PM
Attachment DDC2193Test.php [ 11363 ]
Fabio B. Silva made changes - 26/Dec/12 8:37 PM
Status Open [ 1 ] Awaiting Feedback [ 10000 ]

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    dingdangjyz
Vote (0)
Watch (3)

Dates

  • Created:
    11/Dec/12 1:43 AM
    Updated:
    31/Dec/12 4:02 AM
  • Atlassian JIRA (v5.2.7#850-sha1:b2af0c8)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Doctrine Project. Try JIRA - bug tracking software for your team.