[teiid-issues] [JBoss JIRA] (TEIID-4127) Command DB Logging - SQLCMD attribute VARCHAR(8196) is too small for large queries
Van Halbert (JIRA)
issues at jboss.org
Mon Apr 11 10:50:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189940#comment-13189940 ]
Van Halbert edited comment on TEIID-4127 at 4/11/16 10:49 AM:
--------------------------------------------------------------
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:MySQLDS
5. Deploy VDB named MyVDB.vdb // see attachment
6. Execute VDB MyVDB and execute following SQL statement:
SELECT * FROM Mytable.joined;
was (Author: van.halbert):
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)
More information about the teiid-issues
mailing list