GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Unordered cursor compare with NULLS value fails · Issue #914 · utPLSQL/utPLSQL

Unordered cursor compare with NULLS value fails #914

New issue
Copy link
New issue
Copy link
Closed
Closed
Unordered cursor compare with NULLS value fails#914
Copy link
Assignees
lwasylow
Labels
bug
Milestone
v3.1.7

Description

@lwasylow
lwasylow
opened on May 9, 2019
Issue body actions

Unordered with nulls fails due to using a direct compare of values it should use a :

function generate_equal_sql(a_col_name in varchar2) return varchar2 is
  begin
    return ' decode(a.'||a_col_name||','||' e.'||a_col_name||',1,0) = 1 ';
  end;

Activity

  1. lwasylow
    added this to the v3.1.7 milestone on May 9, 2019

  2. lwasylow commented on May 9, 2019

    @lwasylow
    lwasylow
    on May 9, 2019
    MemberAuthor
    More actions

    Fixed as part of Random Seed PR

  3. lwasylow
    self-assigned this
    on May 9, 2019
  4. lwasylow
    added
    bug
    on May 9, 2019
  5. lwasylow
    closed this as completedon May 9, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @lwasylow
    lwasylow

Labels

bug

Type

No type

Projects

No projects

    Milestone

    • v3.1.7

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions
    You are visitor 01402503 — GeezerVison does not store the pages you look up.
    Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.