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

["Igor Sapego (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-7362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Igor Sapego reassigned IGNITE-7362:
-----------------------------------

    Assignee: Igor Sapego

> 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
>            Assignee: Igor Sapego
>            Priority: Major
>             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
(v7.6.3#76005)