Snowflake: Number of Rows Inserted

[jim256]

I just ran the following query:

INSERT INTO [DATABASE].[SCHEMA].[TABLE]

	SELECT
		*
	FROM
		[DATABASE].[SCHEMA].[OTHER_TABLE]
;

I had truncated the table immediately before, and verified it was empty with a SELECT * on it.

The target table had 0 rows before the insert and 2270614 after it, but the results pane showed 0 were inserted:

Not sure if this is an issue on Snowflake's end or not.

I would upload or email the log, but it has been a while since I've cleared it out (so it's extremely long and I'm not sure where I can cut things off to still include what's needed) and there are a lot of company IP addresses, table names, database names, etc. in there and I'm afraid I might miss one.

[hankinsoft]

Fixed for the next build.

[hankinsoft]

Latest build (2020.38) is available which should sort this out. Please let me know if you get a chance.

[jim256]

@hankinsoft, it's been reporting the correct number of rows. A very solid update, indeed. Thanks!

[jim256]

@hankinsoft, I figured you'd prefer I re-open this one over creating a new issue.

This issue seems to be present when doing updates. If I run an UPDATE statement that modifies thousands of records, SQLPro Studio returns:

[hankinsoft]

I've submitted to a bug report to libsnowflakeclient about this: #216.