SQLTools is blocking user snippets

[bodzebod]

Hi,
I used to have user snippets for inserting static code in my SQL files, based on my company's standards.
My snippets are called by entering the words "head" and "tail".
However, when I install SQLTools, those words are no longer recognized.
Please can you advise ? Thank you!

My user snippet:

{
	// Place your global snippets here. Each snippet is defined under a snippet name and has a scope, prefix, body and 
	// description. Add comma separated ids of the languages where the snippet is applicable in the scope field. If scope 
	// is left empty or omitted, the snippet gets applied to all languages. The prefix is what is 
	// used to trigger the snippet and the body will be expanded and inserted. Possible variables are: 
	// $1, $2 for tab stops, $0 for the final cursor position, and ${1:label}, ${2:another} for placeholders. 
	// Placeholders with the same ids are connected.
	// Example:
	// "Print to console": {
	// 	"scope": "javascript,typescript",
	// 	"prefix": "log",
	// 	"body": [
	// 		"console.log('$1');",
	// 		"$2"
	// 	],
	// 	"description": "Log output to console"
	// }
	"Oracle PLSQL Header": {
		"scope": "sql",
		"prefix": "head",
		"body": [
				"\nSET ECHO ON",
				"WHENEVER SQLERROR EXIT FAILURE ROLLBACK",
				"\n", 
				"PROMPT 'BEGIN OF THE SCRIPT : ${1:script_name}' \n"
		],
		"description": "Add header to PLSQL script for SVN commit"
	},

	"Oracle PLSQL Tail": {
		"scope": "sql",
		"prefix": "tail",
		"body": [
			"INSERT INTO DB_SCRIPTS",
			"(DCR_NO, DCR_DESC, DATE_APPLIED, VERSION)",
			"SELECT COALESCE(MAX(DCR_NO),0)+1, '${1:script_name}', CURRENT_TIMESTAMP, '${2:version}' FROM DB_SCRIPTS;\n",		 
			"\n",	 
			"PROMPT 'END OF THE SCRIPT : ${1:script_name}'",
			"--",
			"--End of Script",
			"--",
			"COMMIT;",
			"EXIT"
		],
		"description": "Add tail to PLSQL script for SVN commit"
	}
}

[mtxr]

Hi,

sorry for the late reply, I had to deal with some stuff here in the past week, I'll take a look at this within this week.

Thanks!

[mtxr]

@bodzebod I don't know exactly if I got this issue to reproduce it.
Look, if I hit Ctrl+space to get suggestions, I see your snippets that I've added here:

And if I start h and wait or hit ctrl_space, I see it too:

Can you describe a bit more what is happening or how were you using before the extension and how can I reproduce it after installing?

My personal snippets are also working fine, so I need more details to understand this.

[forrcaho]

I am also having a problem with snippets.

I did not know about the Ctrl+space shortcut; I'm used to just typing in the snippet prefix, and it will show up in the list of completions (along with other possible completions).

The Ctrl+space shortcut makes my snippets show up, which is a good workaround to have, but unless I use that, I do not see snippets in my list of completions whenever I have an SQLTools db connection open. This is true not only in the Session.sql editor window, but all editor windows I have open, related to sql or not.

Once I disconnect from the db, snippets resume showing up among my completion options.

Some details which may or may not be relevant:

• I am connecting to an AWS Redshift db.
• I am working on a remote system via the Remote - SSH extension.
• I am using Insiders edition.

[bodzebod]

Sorry for the late reply, I retried and I don't have issues anymore indeed.
I guess I made a mistake somewhere and misunderstand what happened. It looks like sqltools is not preventing my snippets to work.
So the issue report can be closed. Thank you for your support!