[DERBY-7134] MERGE not Working over Nework

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.15.2.0
• Component/s: Network Client
• Environment: Windows , Derby
• Urgency: Normal
• Bug behavior facts: Embedded/Client difference, Seen in production
• Assignee: Unassigned
• Reporter: Thomas Lußnig
• Created: 08/Mar/22 06:43
• Updated: 02/May/23 15:23

Description

I Receive an error after sending Merge Statement via Netowrk to derby network server.
The error was first mentioned 5 Years ago:

• https://stackoverflow.com/questions/41587515/derby-merge-statement-results-in-insufficient-data-while-reading-from-the-netwo

And is till now active in derby.

SQL-Fehler: Unzureichende Daten beim Lesen aus dem Netz. Erwartet wurden mindestens 21.272 Byte, empfangen wurden jedoch nur 0 Byte. Die Verbindung wurde beendet.

MERGE INTO HUND USING SYSIBM.SYSDUMMY1 ON HUND.name='name'
    WHEN MATCHED THEN UPDATE SET zwinger='ZW',zbn='zb'
    WHEN NOT MATCHED THEN INSERT (name,zwinger,zbn)VALUES('a','zw','zb')
    ;

Tue Mar 08 07:23:32 CET 2022 : Cannot invoke "String.length()" because "<parameter1>" is null

java.lang.NullPointerException: Cannot invoke "String.length()" because "<parameter1>" is null

    at org.apache.derby.impl.drda.DDMWriter.maxEncodedLength(DDMWriter.java:1138)

    at org.apache.derby.impl.drda.DDMWriter.writeString(DDMWriter.java:1252)

    at org.apache.derby.impl.drda.DRDAConnThread.writeSQLCAGRP(DRDAConnThread.java:6338)

    at org.apache.derby.impl.drda.DRDAConnThread.writeSQLCARD(DRDAConnThread.java:6167)

    at org.apache.derby.impl.drda.DRDAConnThread.writeSQLCARDs(DRDAConnThread.java:6109)

    at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:836)

    at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:300)