Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #3885 (closed)

Opened 9 years ago

Closed 9 years ago

Last modified 8 years ago

Non-nullable string fields may need to have a space inserted.

Reported by: jamoore Owned by: jamoore
Priority: blocker Milestone: OMERO-Beta4.3
Component: ORM Version: n.a.
Keywords: n.a. Cc:
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: 0.0d
Sprint: 2011-01-27 (4)

Description

As seen when using empty passwords (see r8806 (trunk) and r8859 (Beta4.2)), some databases consider an empty string to be equivalent to NULL in all cases. Where we try to store "" as the value of a non-nullable field, the database will insert a NULL and the insert/update will fail.

Change History (7)

comment:1 Changed 9 years ago by jmoore

  • Type changed from User Story to Task

comment:2 Changed 9 years ago by jmoore

  • Remaining Time set to 0.5

comment:3 Changed 9 years ago by jmoore

  • Status changed from new to assigned

comment:4 Changed 9 years ago by Josh <josh@…>

  • Remaining Time changed from 0.5 to 0
  • Resolution set to fixed
  • Status changed from assigned to closed

(In [a77f08e7e0dc487661208705703182695c831950/ome.git]) Adding coalesce for restrictive RDBMs (Fix #3885)

comment:5 Changed 9 years ago by jmoore <josh@…>

(In [8f91a282c758fb74649f7b61a8c50a7b9bbf6b45/ome.git] on branch dev_4_1_custom) Adding coalesce for restrictive RDBMs (Fix #3885)

comment:6 Changed 8 years ago by jmoore <josh@…>

(In [8f91a282c758fb74649f7b61a8c50a7b9bbf6b45/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Adding coalesce for restrictive RDBMs (Fix #3885)

comment:7 Changed 8 years ago by Josh <josh@…>

(In [d57e6df76cb089ed983c30a3f6d0780c0de97207/ome.git]on branches master, develop, feature/5252-import-cancel, fix/4463, python-gateway) Adding coalesce for restrictive RDBMs (Fix #3885)

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.78442 sec.)

We're Hiring!