Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MsSqlCeDialect should correct override string manipulation functions

Description

MsSqlCeDialect should override length functions with len function

RegisterFunction("length", new StandardSQLFunction("len", NHibernateUtil.Int32));
RegisterFunction("locate", new StandardSQLFunction("charindex", NHibernateUtil.Int32));
RegisterFunction("replace", new StandardSafeSQLFunction("replace", NHibernateUtil.String, 3));
RegisterFunction("rtrim", new StandardSQLFunction("rtrim"));
RegisterFunction("ltrim", new StandardSQLFunction("LTRIM_lce_ltrim"));
RegisterFunction("upper", new StandardSQLFunction("upper"));
RegisterFunction("lower", new StandardSQLFunction("lower"));

RegisterFunction("trim", new AnsiTrimEmulationFunction());

http://msdn.microsoft.com/en-us/library/ms174077(v=sql.90).aspx

Environment

None

Activity

Alex Zaytsev 
January 23, 2014 at 1:54 AM

Ported back to 3.4.x as 4e167e8eca433fd9f556d83cb45a2c74413468ac

Alex Zaytsev 
June 20, 2012 at 10:41 AM

Additional commit 8338b3563c88c7f225a4d580c3225ebb09a42d6c

Alex Zaytsev 
June 20, 2012 at 7:17 AM

Commited to master f58cc00f5fc7e8ab78d95f3582003aae25cfa6b8

Maybe NH 3.3.2 release?

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created June 20, 2012 at 7:16 AM
Updated September 21, 2014 at 12:44 PM
Resolved June 20, 2012 at 7:17 AM
Who's Looking?