[jira] [Created] (IGNITE-7362) ODBC: Third party libraries truncate any inserted varlen data to ColumnSize

[Anton Vinogradov (Jira)]

Igor Sapego created IGNITE-7362:
-----------------------------------

             Summary: ODBC: Third party libraries truncate any inserted varlen data to ColumnSize
                 Key: IGNITE-7362
                 URL: https://issues.apache.org/jira/browse/IGNITE-7362
             Project: Ignite
          Issue Type: Bug
          Components: odbc
    Affects Versions: 2.3
            Reporter: Igor Sapego
             Fix For: 2.5


Third-party frameworks and ODBC bindings for different languages use metadata requests results for columns (such as {{SQL_COLUMN_PRECISION}}) to truncate varlen data, inserted by the user, which is only 64 by default.

{code}
<?php

        ini_set("display_errors", 1);
        error_reporting(E_ALL);

        try {

                $ignite = new PDO('odbc:Apache Ignite');
                $ignite->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

                $sql = 'CREATE TABLE IF NOT EXISTS test_md5 (id int PRIMARY KEY, userkey
LONGVARCHAR, server LONGVARCHAR, tsession LONGVARCHAR, tpost LONGVARCHAR,
tget LONGVARCHAR, adddate int) WITH
"atomicity=transactional,cachegroup=somegroup"';
                $ignite->exec($sql);

                for($i=0; $i <= 10; $i++){
                        $dbs = $ignite->prepare("INSERT INTO test_md5 (id, userkey, server,
tsession, tpost, tget, adddate) VALUES ($i, 'Lorem ipsum dolor sit amet,
consectetur adipiscing elit, sed do elit, sed', 'b', 'c', 'd', 'e', 1)");
                        $dbs->execute();
                }


        } catch (PDOException $e) {
                print "Error!: " . $e->getMessage() . "\n";
                die();
        }

?>
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)