[teiid-issues] [JBoss JIRA] (TEIID-4127) Command DB Logging - SQLCMD attribute VARCHAR(8196) is too small for large queries

[Van Halbert (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Van Halbert updated TEIID-4127:
-------------------------------

Steps to Reproduce:
1. Setup MySQL
2. execute politie_mysql.sql sample database // see attachment
3. Setup DV with connection to mysql
4. Setup datasource in DV/EAP to mysql // java:Politie
5. Deploy VDB named DutchPolice.vdb // see attachment
6. Execute VDB DutchPolice and execute following SQL statement:
SELECT * FROM Politie_VBL.joined;

>  Command DB Logging - SQLCMD attribute VARCHAR(8196) is too small for large queries 
> ------------------------------------------------------------------------------------
>
>                 Key: TEIID-4127
>                 URL: https://issues.jboss.org/browse/TEIID-4127
>             Project: Teiid
>          Issue Type: Bug
>          Components: Tools
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>
>  Command DB Logging - SQLCMD attribute VARCHAR(8196) is too small for large queries
> Setup DV to use the command logging database instead of log files.
> Was testing a large join with a left outer join to test another issue and run into 
> an issue with 
> Version-Release number of selected component (if applicable):
> 6.4.3



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)