Project

General

Profile

Bug(バグ) #419

Use unnecessary "IS NULL" matching for the NOT NULL column CommunityMember.is_pre (NOT NULL制約の付いている community_member.is_pre カラムに対して不要な IS NULL での比較をしている)

Added by Rimpei Ogawa almost 14 years ago. Updated almost 14 years ago.

Status:
Fixed(完了)
Priority:
Normal(通常)
Assignee:
Target version:
Start date:
2010-01-01
Due date:
% Done:

100%

3.6 で発生するか:
Unknown (未調査)
3.8 で発生するか:
Unknown (未調査)

Description

From 2964d2750d5a

uses:

(is_pre = 0 OR is_pre IS NULL)

instead of:

position <> "pre" 

but "is_pre IS NULL" is unwanted because the `is_pre` column is NOT NULL.


Related issues

Related to OpenPNE 3 - Enhancement(機能追加・改善) #228: Add an ability for sub-manager of community. コミュニティ副管理人機能を追加 Fixed(完了) 2009-11-11

Associated revisions

Revision d6fb3f13 (diff)
Added by Rimpei Ogawa almost 14 years ago

removed "IS NULL" matchings for the is_pre column (fixes #419)

History

#1 Updated by Rimpei Ogawa almost 14 years ago

  • Status changed from Accepted(着手) to Pending Review(レビュー待ち)
  • % Done changed from 0 to 50

更新履歴commit:"d6fb3f134c2612149a9f3ce07231960e6c32587b"で適用されました。

#2 Updated by Kousuke Ebihara almost 14 years ago

  • Status changed from Pending Review(レビュー待ち) to Fixed(完了)
  • % Done changed from 50 to 100

Also available in: Atom PDF