Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1440

Allow COUNT(*) instead of COUNT(t0.id) for simple queries as an option

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.3, 1.3.0, 2.0.0-beta
    • Component/s: None
    • Labels:
      None

      Description

      SQL generated for "select p for PObject p" is SELECT COUNT(t0.id) FROM POBJECT t0". This is valid and according to JPQL spec which does not accept COUNT.

      However, JDBC Drivers for legacy databases may not always support COUNT(columnName) as reported in [1].

      OpenJPA should support such cases with a boolean option DBDictionary.useWildCardForCount.

      [1] http://n2.nabble.com/COUNT-t-to-COUNT-tc4176827.html#a4176827

      1. OPENJPA-1440-1.2.x.patch.txt
        6 kB
        Heath Thomann
      2. OPENJPA-1440-1.3.x.patch.txt
        6 kB
        Heath Thomann

        Activity

        Hide
        jpaheath Heath Thomann added a comment -

        Updated header per Pinaki.

        Show
        jpaheath Heath Thomann added a comment - Updated header per Pinaki.
        Hide
        jpaheath Heath Thomann added a comment -

        Added OPENJPA-1440-1.23.x.patch.txt for 1.2.x code and the OPENJPA-1440-1.3.x.patch.txt for 1.3.x code, as their names imply.

        Show
        jpaheath Heath Thomann added a comment - Added OPENJPA-1440 -1.23.x.patch.txt for 1.2.x code and the OPENJPA-1440 -1.3.x.patch.txt for 1.3.x code, as their names imply.
        Hide
        ppoddar@apache.org Pinaki Poddar added a comment -

        Please correct the header on the TestCase attached with the patch.

        Show
        ppoddar@apache.org Pinaki Poddar added a comment - Please correct the header on the TestCase attached with the patch.
        Hide
        xiaoqinfeng2000 Xiaoqin Feng added a comment -

        I am on vacation from 12/20/2009  to 12/26/2009.

        If you have any question on deployment and JEE bugs, please contact Saurabh Arora or my manager Maruthi Nuthikattu.

        For emergency, contact me at 925-209-5517.

        Show
        xiaoqinfeng2000 Xiaoqin Feng added a comment - I am on vacation from 12/20/2009  to 12/26/2009. If you have any question on deployment and JEE bugs, please contact Saurabh Arora or my manager Maruthi Nuthikattu. For emergency, contact me at 925-209-5517.

          People

          • Assignee:
            ppoddar@apache.org Pinaki Poddar
            Reporter:
            ppoddar@apache.org Pinaki Poddar
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development