[jira] [Created] (DERBY-7134) MERGE not Working over Nework

[Jira]

Thomas Lußnig created DERBY-7134:
------------------------------------

             Summary: MERGE not Working over Nework
                 Key: DERBY-7134
                 URL: https://issues.apache.org/jira/browse/DERBY-7134
             Project: Derby
          Issue Type: Bug
          Components: Network Client
    Affects Versions: 10.15.2.0
         Environment: Windows , Derby 
            Reporter: Thomas Lußnig


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)

 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)