1
Vote

Global Temp Issue

description

The analyze process reports that "Global Temp Tables Are Not Valid" when it finds two sequential ##'s in code. The issue is that the code could be remarked out, or used in an insert statement. I.E.:
 
INSERT INTO tblMyTable(MyStringField) SELECT '###"

comments

ghuey wrote Oct 13, 2010 at 9:59 PM

Ok, I will make a change to the NotSupportedByAzureFile.config in v3.4.1. For now, if you want, you can edit the config file and ## and change it to "\s##". This will kind of resolve the problem, but not fully. I could put something like SELECT ' ##' and still get the error message. Thing to note here is that this is not a SQL parsing engine like you get in SQL Server. I am limited to Regex so end the end, you will have to look at the message and say, oh yea, this is not really a problem, just ignore and go on. If you have a better suggestion on how I can resolve this with Regex, let me know.

Thanks,
George

DeanShoultz wrote Nov 5, 2010 at 9:19 PM

Sounds perfect George...thank you