Title: Opening USE [master] line not understood · Issue #154 · dalibo/sqlserver2pgsql · GitHub
Open Graph Title: Opening USE [master] line not understood · Issue #154 · dalibo/sqlserver2pgsql
X Title: Opening USE [master] line not understood · Issue #154 · dalibo/sqlserver2pgsql
Description: The first two lines of my MS SQL script are USE [master] GO I'm encountering the following bug: $ sqlserver2pgsql/sqlserver2pgsql.pl -f db.schema.sql -b output_before_script -a output_after_script -u output_unsure_script Wide character i...
Open Graph Description: The first two lines of my MS SQL script are USE [master] GO I'm encountering the following bug: $ sqlserver2pgsql/sqlserver2pgsql.pl -f db.schema.sql -b output_before_script -a output_after_script ...
X Description: The first two lines of my MS SQL script are USE [master] GO I'm encountering the following bug: $ sqlserver2pgsql/sqlserver2pgsql.pl -f db.schema.sql -b output_before_script -a output_after_scr...
Opengraph URL: https://github.com/dalibo/sqlserver2pgsql/issues/154
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Opening USE [master] line not understood","articleBody":"The first two lines of my MS SQL script are\r\n```\r\nUSE [master]\r\nGO\r\n```\r\n\r\nI'm encountering the following bug:\r\n```\r\n$ sqlserver2pgsql/sqlserver2pgsql.pl -f db.schema.sql -b output_before_script -a output_after_script -u output_unsure_script\r\n\r\nWide character in die at sqlserver2pgsql/sqlserver2pgsql.pl line 2470, \u003c$file\u003e line 1.\r\nLine \u003cUSE [master]\r\n\u003e (1) not understood. This is a bug at sqlserver2pgsql/sqlserver2pgsql.pl line 2470, \u003c$file\u003e line 1.\r\n```\r\n\r\nThe error occurs on [this line](https://github.com/dalibo/sqlserver2pgsql/blob/340b38137b5b405b9b48dded5182fb39e2871843/sqlserver2pgsql.pl#L2470) and from what I can tell, the parentheses in [this line](https://github.com/dalibo/sqlserver2pgsql/blob/master/sqlserver2pgsql.pl#L2323) seem to be preventing the match.\r\n\r\nMy perl is unfortunately fairly rusty, so I'm not sure how to fix this, or even why I'm getting this error in the first place. \r\n\r\nMore info:\r\n```\r\n$ file db.schema.sql \u0026\u0026 uname -a \u0026\u0026 perl --version\r\ndb.schema.sql: UTF-8 Unicode (with BOM) text, with very long lines\r\nLinux 6a37df95ea7c 5.8.0-50-generic #56~20.04.1-Ubuntu SMP Mon Apr 12 21:46:35 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux\r\n\r\nThis is perl 5, version 30, subversion 0 (v5.30.0) built for x86_64-linux-gnu-thread-multi\r\n(with 50 registered patches, see perl -V for more detail)\r\n...\r\n```\r\n\r\n","author":{"url":"https://github.com/maresb","@type":"Person","name":"maresb"},"datePublished":"2021-05-11T11:51:52.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/154/sqlserver2pgsql/issues/154"}
| 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:fed25099-33e6-b15a-0117-85f8efb5da35 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | DAD4:20099F:4DDAAC:67A39B:6A613A8C |
| html-safe-nonce | d7c2d55cd9f96e3b4d815354af29a46d01a3211f99e7a644811a123e7f3e6c7c |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEQUQ0OjIwMDk5Rjo0RERBQUM6NjdBMzlCOjZBNjEzQThDIiwidmlzaXRvcl9pZCI6IjQ0MTUyODYwNTIwNTM0MDAyMDQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | bc937a15e20ec23675334596e869c895a03cc00ab69a4bd6bd0741447e51a3be |
| hovercard-subject-tag | issue:887025852 |
| 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/154/issue_layout |
| twitter:image | https://opengraph.githubassets.com/9fc137112e5324de2a2247d075c7393b126d5982165139417e8e4a15fde92d9a/dalibo/sqlserver2pgsql/issues/154 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/9fc137112e5324de2a2247d075c7393b126d5982165139417e8e4a15fde92d9a/dalibo/sqlserver2pgsql/issues/154 |
| og:image:alt | The first two lines of my MS SQL script are USE [master] GO I'm encountering the following bug: $ sqlserver2pgsql/sqlserver2pgsql.pl -f db.schema.sql -b output_before_script -a output_after_script ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | maresb |
| hostname | github.com |
| expected-hostname | github.com |
| None | 2b7a3d1e6770dc7153450d820fcfe9a7851c4cf2251dcc29c7ad3c5cd1b9e88b |
| 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 | 78cf9d43f120d1f03636ca22ab420bcbb1712804 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width