Maksim Zhuravkov created IGNITE-24152:
-----------------------------------------

             Summary: Sql. Dml. Varbinary value in dynamic parameter is 
truncated if its length is larger than 65536 
                 Key: IGNITE-24152
                 URL: https://issues.apache.org/jira/browse/IGNITE-24152
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Maksim Zhuravkov


it is possible to create a table with that has a VARBINARY column with length 
that is larger than 65536 but inserting values in this column results in data 
truncation upon write. 

{code:java}
@Test
    public void test() {
        sql("CREATE TABLE t(id INT PRIMARY KEY, val VARBINARY(2000000))");

        Object s = "1".repeat(1024*1024*20).getBytes(StandardCharsets.UTF_8);
        sql("INSERT INTO t VALUES(1, ?)", s);

        for (var row : sql("SELECT id, val FROM t")) {
            byte[] bytes = (byte[]) row.get(1);
            System.err.println(row.get(0) + ", " + bytes.length);
            // Prints 1, 65536
        }
    }
{code}







--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to