defncopy - Unable to export any view from SQL 2016 with v1.00.80

[theangryangel]

Forgive what is probably a support question, but I swear I've had defncopy export views without issue before.

Using 1.00.80 any view I point it at I get an assertion error. Unfortunately with my blurry Friday-before-Christmas eyes I'm struggling to figure out why. Even the following;

create view _defncopy_test as 
select 1 as value

results in

defncopy: defncopy.c:578: print_results: Assertion `sizeof(sql_text) > dbcollen(dbproc, ctext)' failed.

I'm happy to continue digging into it and provide a patch, but I need a quick pointer in the right direction as I'm just not following properly.

[freddy77]

2017-12-22 11:38 GMT+00:00 Karl <notifications@github.com>:

Forgive what is probably a support question, but I swear I've had defncopy export views without issue before. Using 1.00.80 *any* view I point it at I get an assertion error. Unfortunately with my blurry Friday-before-Christmas eyes I'm struggling to figure out why. Even the following; create view _defncopy_test as select 1 as value `` results in defncopy: defncopy.c:578: print_results: Assertion `sizeof(sql_text) > dbcollen(dbproc, ctext)' failed. I'm happy to continue digging into it and provide a patch, but I need a quick pointer in the right direction as I'm just not following properly. I would suspect the text column of syscomments table now returns a type

with lot of data. Try to use "text size" option. If this does not help port a TDSDUMP, just to see the type. Frediano

[freddy77]

Increase just a bit the output buffer (sql_text) in order to make sure the possible converted string fits in it.
Thanks, 1.00.81 should be generated automatically tomorrow.