[IBATISNET-29] Pound signs not handled correctly when used in combination with $Foo$ syntax and dynamic sql.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: DataMapper 1.1
• Fix Version/s: DataMapper 1.2.0
• Environment: IBatisNet.DataMapper; [assembly: AssemblyVersion("1.1.458")]
• Assignee: Gilles Bayon
• Reporter: liu ron
• Created: 01/Apr/05 00:58
• Updated: 13/Apr/05 04:25
• Resolved: 13/Apr/05 04:25

Description

When the following syntax is used:

##$Foo$##

and Foo is set via:

map["Foo"] = new DateTime(2005, 1, 2, 3, 4, 5);

Ibatis seems to process the line correctly. I expect the following text to be sent to the database:

#1/2/2005 3:04:05#

The logs don't explicitly state that that text is being sent to the database but the code seems to work correctly.

When a dynamic sql block is used with the ##$Foo$## syntax, Ibatis incorrectly throws a ProbeException because it tries to re-evaluate "1/2/2005 3:04:05" as a key in the Hashtable. For example this snippet of text:

(Concert.ConcertDate = ##$StartDate$##)
<isNotEmpty prepend="AND" property="EndDate">
(Concert.ConcertDate = ##$EndDate$##)
</isNotEmpty>

Raises a ProbeException with the following error message: There is no Get property named '1/2/2005 3' in class 'Hashtable'. The next character after the 3 is a colon which Ibatis uses for inline parameters. It appears that Ibatis is trying to re-evaluate what's between the dollar signs.