We’ve been trying to track down a problem and have come across what looks like a bug.
We’re using DA 9.4.109.1375 on Delphi 10.2.3 Enterprise, against an MSSQL database using FireDAC.
The problem occurs where we have table columns of type nvarchar(max). We create a command in the schema to retrieve values from such columns via an out parameter, which is set to a type of WideMemo, which should be the correct type for such columns.
Depending on exactly what data is in these columns, we are seeing erratic behaviour. Sometimes it works fine, sometimes the resulting text is truncated, sometimes corrupted and sometimes the whole app just locks up and times out.
I’ve managed to reproduce this and am attaching a small example which illustrates the problem. There’s an SQL script in there which will create the simple test database with a single table with one record in it, containing some random text taken from a licence agreement.
The client app calls a service function on the server which executes a schema command to retrieve the data from two columns. Simply running both server and client and clicking the button causes the whole thing to completely lock up when I test it here.
We’ve tried it with other large blocks of text and sometimes it truncates, sometimes corrupts, sometimes repeated clicking will return increasingly random snippets of text. It’s all very bizarre.
Can you try this yourself and see what you find? Thanks.
WideMemoTest.rar (26.1 KB)