1

Closed

ODBQ: SQL Messages gets truncated to 208 characters

description

SQL Messages returned after executing some SQL are truncated to 208 characters.

Example: We run a SQL similar to this -

PRINT 'INSERT INTO X (obj_name, parent_obj, obj_xtype, obj_desc, total_columns, total_defaults, total_indexes, total_foreign_keys, total_primary_key, total_constraints, total_unique_keys, created, isignored) VALUES '
       + '('
       + '''' + RTRIM((@obj_name)) + ''''      + ','
       + '''' + RTRIM((@parent_obj)) + ''''    + ','
       + '''' + RTRIM((@obj_xtype)) + ''''     + ','
       + '''' + RTRIM((@obj_desc)) + ''''      + ','
       +        RTRIM((@total_columns))        + ','
       +        RTRIM((@total_defaults))       + ','
       +        RTRIM((@total_indexes))        + ','
       +        RTRIM((@total_foreign_keys))   + ','
       +        RTRIM((@total_primary_key))    + ','
       +        RTRIM((@total_constraints))    + ','
       +        RTRIM((@total_unique_keys))    + ','
       + '''' + RTRIM((@created)) + ''''       + ','
       +        RTRIM((@isignored))
       + ')'
The expected output is:

INSERT INTO X (obj_name, parent_obj, obj_xtype, obj_desc, total_columns, total_defaults, total_indexes, total_foreign_keys, total_primary_key, total_constraints, total_unique_keys, created, isignored) VALUES ('asi_actions','0','U','Table',9,2,0,0,0,0,0,'Aug 9 2010 4:17PM',1)

Instead the output I see is:
INSERT INTO X (obj_name, parent_obj, obj_xtype, obj_desc, total_columns, total_defaults, total_indexes, total_foreign_keys, total_primary_key, total_constraints, total_unique_keys, created, isigno
GO
Closed Nov 11, 2010 at 9:55 PM by
Released in 1.2.

comments

dblock wrote Aug 13, 2010 at 1:00 PM

Sending content: Source\CodePlex\msiext\trunk\src\Common\ODBC\ConnectionUnitTests.cpp
Sending content: Source\CodePlex\msiext\trunk\src\Common\ODBC\ConnectionUnitTests.h
Sending content: Source\CodePlex\msiext\trunk\src\Common\ODBC\Handle.cpp
Completed: At revision: 64684