NH-4053 - ISQLQuery - SetParameter doesn't work with more than 10 parameters

[nhibernate-bot]

Mateusz Dudek created an issue — 18th July 2017, 8:47:57:

When constructing a sql query using Session.CreateSQLQuery with 10 or more named parameters, SetParameter works incorrectly. For instance formatting the following query:

UPDATE SomeTable Set FirstColumn=:first, SecondColumn=:second <...> EleventhColumn=:eleven, TwelfthColumn=:twelve

Will result in:

UPDATE SomeTable Set FirstColumn='First', SecondColumn='Second' [...] EleventhColumn='Second'0, TwelfthColumn='Second'1

Which means that when NHbiernate indexes these parameters behind the scenes, after encountering two-digit number like 10, it only parses the first digit and leaves the rest unchanged.

[gliljas]

I'm unable to reproduce this. In what scenario would NH replace parameters with literals?

[markdchurchill]

Is this a postgres specific issue with :param1 = 'Foo' being substituted into :param15 resulting in 'Foo'5? Postgres uses this colon prefix style, and it's particularly messy.

[fredericDelaporte]

If you can reproduce this trouble, could you PR a test case? (See contributing.) If it is PostgreSQL specific, its TeamCity build will show it.