René's URL Explorer Experiment


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

direct link

Domain: patch-diff.githubusercontent.com


Hey, it has json ld scripts:
{"@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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:cf2a8705-b32b-ae04-108d-d10d340a7621
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idE9B4:392487:69AB10F:9089C57:69786DC6
html-safe-nonce9cb265fde91b9ee55aab8c2fb6407a2af49c45477c75361af92010ea167c046a
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFOUI0OjM5MjQ4Nzo2OUFCMTBGOjkwODlDNTc6Njk3ODZEQzYiLCJ2aXNpdG9yX2lkIjoiMTQzMzA1NTcyNzQ0MTE3ODA1NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacb42028c2d33f0b165cc8eaf32bae5d9f4bff162fbffc77323f8de3203fdeb8db
hovercard-subject-tagissue:1600743114
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/dalibo/sqlserver2pgsql/174/issue_layout
twitter:imagehttps://opengraph.githubassets.com/0223347f9510e5cbe4d9e0618f15c61674d1bde80d8cc4e6f5d7077700fd0f82/dalibo/sqlserver2pgsql/issues/174
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/0223347f9510e5cbe4d9e0618f15c61674d1bde80d8cc4e6f5d7077700fd0f82/dalibo/sqlserver2pgsql/issues/174
og:image:altHi 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameshubham-yb
hostnamegithub.com
expected-hostnamegithub.com
None2981c597c945c1d90ac6fa355ce7929b2f413dfe7872ca5c435ee53a24a1de50
turbo-cache-controlno-preview
go-importgithub.com/dalibo/sqlserver2pgsql git https://github.com/dalibo/sqlserver2pgsql.git
octolytics-dimension-user_id182275
octolytics-dimension-user_logindalibo
octolytics-dimension-repository_id12059094
octolytics-dimension-repository_nwodalibo/sqlserver2pgsql
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id12059094
octolytics-dimension-repository_network_root_nwodalibo/sqlserver2pgsql
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release520b65a872113b919c1bbdb03834a50af15859fd
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues/174#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fdalibo%2Fsqlserver2pgsql%2Fissues%2F174
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fdalibo%2Fsqlserver2pgsql%2Fissues%2F174
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=dalibo%2Fsqlserver2pgsql
Reloadhttps://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues/174
Reloadhttps://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues/174
Reloadhttps://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues/174
dalibo https://patch-diff.githubusercontent.com/dalibo
sqlserver2pgsqlhttps://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fdalibo%2Fsqlserver2pgsql
Fork 119 https://patch-diff.githubusercontent.com/login?return_to=%2Fdalibo%2Fsqlserver2pgsql
Star 531 https://patch-diff.githubusercontent.com/login?return_to=%2Fdalibo%2Fsqlserver2pgsql
Code https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql
Issues 15 https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues
Pull requests 0 https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/pulls
Actions https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/actions
Projects 0 https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/projects
Wiki https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/wiki
Security 0 https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/security
Insights https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/pulse
Code https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql
Issues https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues
Pull requests https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/pulls
Actions https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/actions
Projects https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/projects
Wiki https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/wiki
Security https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/security
Insights https://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/pulse
New issuehttps://patch-diff.githubusercontent.com/login?return_to=https://github.com/dalibo/sqlserver2pgsql/issues/174
New issuehttps://patch-diff.githubusercontent.com/login?return_to=https://github.com/dalibo/sqlserver2pgsql/issues/174
Incorrect parsing of view DDLshttps://patch-diff.githubusercontent.com/dalibo/sqlserver2pgsql/issues/174#top
https://github.com/shubham-yb
https://github.com/shubham-yb
shubham-ybhttps://github.com/shubham-yb
on Feb 27, 2023https://github.com/dalibo/sqlserver2pgsql/issues/174#issue-1600743114
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.