mORMot Open Source

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

regression with in Params to CreateAndFillPrepare in 2105

Hi AB

today i got this new regression.

        TAutoFree.One(LRecLTNachricht, TSQLLTNachricht.CreateAndFillPrepare(Database,
                      'Richtung=? and Status=? and (NachrichtTyp in (?,?,?,?,?,?)) order by RowID', [10,
                                                                                           20,
                                                                                           305, 205, 180, 20, 60, 40]));

0151129 19375760 EXC   	EDocVariant {"Message":"Unexpected array size"} at 0053B6C4  stack trace API 00563030 00563058 0040AE4C 7758B9B4 77578F5F 0053B6C4 0055992C 00559E30 00A5D9DA 005DE268 005ED8EF 005D5F52 005D3739 005C9EFF 005C9FAE 00C14EC1 00939EB7 008BD0B3 008BB74B 008BB7AB 004CD11C 0040B9FE 771F38F4 77565663 7756562E 

The Exception raises in SynCommons 49194  at TDocVariantData(Where.ValueVariant).InitJSONInPlace(pointer(Where.Value),JSON_OPTIONS_FAST);

Where = ('(', '', False, False, 9, opIn, '', '[:(305]', '(:(305):,:(205):,:(180):,:(20):,:(60):,:(40):)) order by RowID', 7, 0, '', Nicht verfügbarer Wert)

and has no terminating ]

---

Rad Studio 12.1 Santorini

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,665

Website

Re: regression with in Params to CreateAndFillPrepare in 2105

Get rid of the parenthesis.

'Richtung=? and Status=? and NachrichtTyp in (?,?,?,?,?,?) order by RowID'

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

Re: regression with in Params to CreateAndFillPrepare in 2105

ok - i made the extra paranthesis for "security" reason

---

Rad Studio 12.1 Santorini