Title: Incorrect parsing of view DDLs · Issue #174 · dalibo/sqlserver2pgsql · GitHub
Open Graph Title: Incorrect parsing of view DDLs · Issue #174 · dalibo/sqlserver2pgsql
X Title: Incorrect parsing of view DDLs · Issue #174 · dalibo/sqlserver2pgsql
Description: Hi Team, If we have columns in square brackets in the source sql server schema as well as the dump, the columns in the view DDL gets parsed as is with the brackets which causes errors. Source schema: CREATE VIEW [Male_emp] AS SELECT [Nam...
Open Graph Description: Hi Team, If we have columns in square brackets in the source sql server schema as well as the dump, the columns in the view DDL gets parsed as is with the brackets which causes errors. Source schem...
X Description: Hi Team, If we have columns in square brackets in the source sql server schema as well as the dump, the columns in the view DDL gets parsed as is with the brackets which causes errors. Source schem...
Opengraph URL: https://github.com/dalibo/sqlserver2pgsql/issues/174
X: @github
Domain: patch-diff.githubusercontent.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Incorrect parsing of view DDLs","articleBody":"Hi Team,\r\nIf we have columns in square brackets in the source sql server schema as well as the dump, the columns in the view DDL gets parsed as is with the brackets which causes errors.\r\n\r\nSource schema:\r\n\r\n```\r\nCREATE VIEW [Male_emp] \r\nAS\r\nSELECT \r\n[Name], [Gender]\r\nFROM Employee\r\nWHERE Gender = 'Male';\r\n\r\ngo\r\n```\r\n\r\nDump file using mssql-scripter:\r\n\r\n```\r\n/****** Object: View [dbo].[Male_emp] Script Date: 2/27/23 8:17:03 AM ******/\r\nSET ANSI_NULLS ON\r\nGO\r\nSET QUOTED_IDENTIFIER OFF\r\nGO\r\n\r\nCREATE VIEW [dbo].[Male_emp]\r\nAS\r\nSELECT\r\n[Name], [Gender]\r\nFROM Employee\r\nWHERE Gender = 'Male';\r\n\r\nGO\r\n```\r\n\r\nConverted schema:\r\n\r\n```\r\nCREATE VIEW \"public\".\"male_emp\" AS\r\nSELECT\r\n[Name], [Gender]\r\nFROM Employee\r\nWHERE Gender = 'Male';\r\n```\r\n\r\nCorresponding error:\r\n\r\n```\r\nERROR: syntax error at or near \"[\"\r\nLINE 3: [Name], [Gender]\r\n ^\r\n```\r\n\r\nThanks a lot for your help.","author":{"url":"https://github.com/shubham-yb","@type":"Person","name":"shubham-yb"},"datePublished":"2023-02-27T08:53:37.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/174/sqlserver2pgsql/issues/174"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:cf2a8705-b32b-ae04-108d-d10d340a7621 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | E9B4:392487:69AB10F:9089C57:69786DC6 |
| html-safe-nonce | 9cb265fde91b9ee55aab8c2fb6407a2af49c45477c75361af92010ea167c046a |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFOUI0OjM5MjQ4Nzo2OUFCMTBGOjkwODlDNTc6Njk3ODZEQzYiLCJ2aXNpdG9yX2lkIjoiMTQzMzA1NTcyNzQ0MTE3ODA1NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | b42028c2d33f0b165cc8eaf32bae5d9f4bff162fbffc77323f8de3203fdeb8db |
| hovercard-subject-tag | issue:1600743114 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/dalibo/sqlserver2pgsql/174/issue_layout |
| twitter:image | https://opengraph.githubassets.com/0223347f9510e5cbe4d9e0618f15c61674d1bde80d8cc4e6f5d7077700fd0f82/dalibo/sqlserver2pgsql/issues/174 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/0223347f9510e5cbe4d9e0618f15c61674d1bde80d8cc4e6f5d7077700fd0f82/dalibo/sqlserver2pgsql/issues/174 |
| og:image:alt | Hi Team, If we have columns in square brackets in the source sql server schema as well as the dump, the columns in the view DDL gets parsed as is with the brackets which causes errors. Source schem... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | shubham-yb |
| hostname | github.com |
| expected-hostname | github.com |
| None | 2981c597c945c1d90ac6fa355ce7929b2f413dfe7872ca5c435ee53a24a1de50 |
| turbo-cache-control | no-preview |
| go-import | github.com/dalibo/sqlserver2pgsql git https://github.com/dalibo/sqlserver2pgsql.git |
| octolytics-dimension-user_id | 182275 |
| octolytics-dimension-user_login | dalibo |
| octolytics-dimension-repository_id | 12059094 |
| octolytics-dimension-repository_nwo | dalibo/sqlserver2pgsql |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 12059094 |
| octolytics-dimension-repository_network_root_nwo | dalibo/sqlserver2pgsql |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 520b65a872113b919c1bbdb03834a50af15859fd |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width