Skip to:

Skip to Jira Navigation
Skip to Side Navigation
Skip to Main Content

Wrong SqlType size set for LIKE statement

Description

The fix for prevents parameters being silently truncated by throwing an error. When a LIKE clause is generated, the sql-type has a size corresponding to the mapping of the property, but the parameter should be allowed to be 2 characters larger to allow a '%' at either side.

Environment

None

Linked work items

is duplicated by

MSSQL Like criteria doesn't work if expression length is more then column length

is related to

Throw exception instead of silently truncate string and blob data

Wrong parameter size in query with MsSql2000Dialect,MsSql2005Dialect and MsSql2008Dialect

Activity

Oskar Berggren May 30, 2012 at 6:31 PM

Closing issues fixed in 3.3.1.CR1.

Richard Brown January 26, 2012 at 4:04 PM

A nicer fix may be to get the ICriteria/HQL generation to not set the SqlType.Length for LIKE clauses.

Richard Brown January 26, 2012 at 4:02 PM

Changed SQL parameter lengths set in the driver to use the defaults for the type (rather than a specific length).

Resize issue view side panel

Fixed

Details

Assignee

Richard Brown

Reporter

Richard Brown

Components

Fix versions

Affects versions

Priority

Minor

Who's Looking?

Open Who's Looking?

Created January 26, 2012 at 2:16 PM

Updated September 26, 2017 at 11:43 AM

Resolved January 26, 2012 at 4:02 PM

Who's Looking?