Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21113

For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be generated.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • hpl/sql
    • None
    • Reviewed

    Description

      In HPL/SQL, ' SELECT * FROM a WHERE NOT (1 = 2) ' will generate to incorrect SQL ' SELECT * FROM a WHERE (1 = 2) ', the 'NOT' in boolean expression is missing.

      Attachments

        1. HIVE-21113.1.patch
          2 kB
          Baoning He

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ywhbn Baoning He Assign to me
            ywhbn Baoning He
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment