{"action":"created","issue":{"url":"https://api.github.com/repos/JustinPealing/html-query-plan/issues/76","repository_url":"https://api.github.com/repos/JustinPealing/html-query-plan","labels_url":"https://api.github.com/repos/JustinPealing/html-query-plan/issues/76/labels{/name}","comments_url":"https://api.github.com/repos/JustinPealing/html-query-plan/issues/76/comments","events_url":"https://api.github.com/repos/JustinPealing/html-query-plan/issues/76/events","html_url":"https://github.com/JustinPealing/html-query-plan/issues/76","id":342224402,"node_id":"MDU6SXNzdWUzNDIyMjQ0MDI=","number":76,"title":"When the double quotes exists in the sql, the viwe disappears.","user":{"login":"Evanna51","id":14267703,"node_id":"MDQ6VXNlcjE0MjY3NzAz","avatar_url":"https://avatars1.githubusercontent.com/u/14267703?v=4","gravatar_id":"","url":"https://api.github.com/users/Evanna51","html_url":"https://github.com/Evanna51","followers_url":"https://api.github.com/users/Evanna51/followers","following_url":"https://api.github.com/users/Evanna51/following{/other_user}","gists_url":"https://api.github.com/users/Evanna51/gists{/gist_id}","starred_url":"https://api.github.com/users/Evanna51/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Evanna51/subscriptions","organizations_url":"https://api.github.com/users/Evanna51/orgs","repos_url":"https://api.github.com/users/Evanna51/repos","events_url":"https://api.github.com/users/Evanna51/events{/privacy}","received_events_url":"https://api.github.com/users/Evanna51/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-07-18T08:21:28Z","updated_at":"2018-07-24T10:52:03Z","closed_at":"2018-07-24T10:52:03Z","author_association":"NONE","body":"- Frist，I executed these statements：\r\n`SET SHOWPLAN_XML ON;\r\nSELECT* FROM \"table1\";\r\nSET SHOWPLAN_XML OFF;`\r\n\r\n- and  then got the query plan XML is\r\n > `\r\n<ShowPlanXML xmlns=\\\"http://schemas.microsoft.com/sqlserver/2004/07/showplan\\\" Version=\\\"1.1\\\" Build=\\\"10.50.6000.34\\\"><BatchSequence><Batch><Statements><StmtSimple StatementText=\\\"SELECT * FROM \\\"table1\\\" \\\" StatementId=\\\"1\\\" StatementCompId=\\\"1\\\" StatementType=\\\"SELECT\\\" StatementSubTreeCost=\\\"0.0032831\\\" StatementEstRows=\\\"1\\\" StatementOptmLevel=\\\"TRIVIAL\\\" QueryHash=\\\"0xEEFA6029482A8458\\\" QueryPlanHash=\\\"0x7352F083D47DB39C\\\"><StatementSetOptions QUOTED_IDENTIFIER=\\\"true\\\" ARITHABORT=\\\"false\\\" CONCAT_NULL_YIELDS_NULL=\\\"true\\\" ANSI_NULLS=\\\"true\\\" ANSI_PADDING=\\\"true\\\" ANSI_WARNINGS=\\\"true\\\" NUMERIC_ROUNDABORT=\\\"false\\\"/><QueryPlan CachedPlanSize=\\\"8\\\" CompileTime=\\\"0\\\" CompileCPU=\\\"0\\\" CompileMemory=\\\"56\\\"><RelOp NodeId=\\\"0\\\" PhysicalOp=\\\"Table Scan\\\" LogicalOp=\\\"Table Scan\\\" EstimateRows=\\\"1\\\" EstimateIO=\\\"0.0032035\\\" EstimateCPU=\\\"7.96e-005\\\" AvgRowSize=\\\"36\\\" EstimatedTotalSubtreeCost=\\\"0.0032831\\\" TableCardinality=\\\"0\\\" Parallel=\\\"0\\\" EstimateRebinds=\\\"0\\\" EstimateRewinds=\\\"0\\\"><OutputList><ColumnReference Database=\\\"[dabatable1]\\\" Schema=\\\"[schema1]\\\" Table=\\\"[table1]\\\" Column=\\\"n\\\"/></OutputList><TableScan Ordered=\\\"0\\\" ForcedIndex=\\\"0\\\" ForceScan=\\\"0\\\" NoExpandHint=\\\"0\\\"><DefinedValues><DefinedValue><ColumnReference Database=\\\"[dabatable1]\\\" Schema=\\\"[schema1]\\\" Table=\\\"[table1]\\\" Column=\\\"n\\\"/></DefinedValue></DefinedValues><Object Database=\\\"[dabatable1]\\\" Schema=\\\"[schema1]\\\" Table=\\\"[table1]\\\" IndexKind=\\\"Heap\\\"/></TableScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>;`\r\n- and the view zone is nothing.\r\nbut if I executed statements without  **double quotes**  like `SELECT* FROM table1` or `SELECT* FROM [table1]`, then it is  correct.\r\n\r\nHow can I solve this problem?m( _　_ )m \r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/JustinPealing/html-query-plan/issues/comments/407364653","html_url":"https://github.com/JustinPealing/html-query-plan/issues/76#issuecomment-407364653","issue_url":"https://api.github.com/repos/JustinPealing/html-query-plan/issues/76","id":407364653,"node_id":"MDEyOklzc3VlQ29tbWVudDQwNzM2NDY1Mw==","user":{"login":"Evanna51","id":14267703,"node_id":"MDQ6VXNlcjE0MjY3NzAz","avatar_url":"https://avatars1.githubusercontent.com/u/14267703?v=4","gravatar_id":"","url":"https://api.github.com/users/Evanna51","html_url":"https://github.com/Evanna51","followers_url":"https://api.github.com/users/Evanna51/followers","following_url":"https://api.github.com/users/Evanna51/following{/other_user}","gists_url":"https://api.github.com/users/Evanna51/gists{/gist_id}","starred_url":"https://api.github.com/users/Evanna51/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Evanna51/subscriptions","organizations_url":"https://api.github.com/users/Evanna51/orgs","repos_url":"https://api.github.com/users/Evanna51/repos","events_url":"https://api.github.com/users/Evanna51/events{/privacy}","received_events_url":"https://api.github.com/users/Evanna51/received_events","type":"User","site_admin":false},"created_at":"2018-07-24T10:52:03Z","updated_at":"2018-07-24T10:52:03Z","author_association":"NONE","body":"Thank you!  But  there is no tips or note in the readme  about  Special characters needs  to encode .\r\n\r\nSorry for this issue that I  should have asked questions on stackoverflow however You gave the answer so gently."}}
{"actor":{"display_login":"Evanna51"}}