Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-196

JBoss-QL "IS NOT EMPTY" doesn't work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • None
    • None
    • None
    • None

    Description

      SourceForge Submitter: johgr814 .
      I'm running JBoss 3.0.1RC1 with Postgres 7.2.

      The JBoss-QL "IS NOT EMPTY" statement doesn't work
      it simply generates the SQL-statement "TRUE".

      Sample:

      JBoss-QL:
      SELECT DISTINCT OBJECT(p) FROM Person p, IN
      (p.nodePersonRoles) npr WHERE npr.node.tId LIKE ?1
      AND p.cards IS NOT EMPTY

      Generates SQL:
      SELECT DISTINCT t0_p.person_id
      FROM person t0_p, node_person_role t2_npr, card
      t3_p_cards, node t1_npr_node
      WHERE (t1_npr_node.t_id LIKE '1.' AND TRUE)
      AND (t0_p.person_id=t3_p_cards.person_id
      AND t2_npr.node_id=t1_npr_node.node_id
      AND t0_p.person_id=t2_npr.person

      Attachments

        Activity

          People

            starksm64 Scott Stark (Inactive)
            sourceforge-user SourceForge legacy user (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: