Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORDER BY returning Connector Error PG::Error: ERROR: Executing ODBC query #92

Open
ethervoid opened this issue Nov 8, 2018 · 0 comments
Labels

Comments

@ethervoid
Copy link

Context

Please explain here below what you were doing when the issue happened

Executing a query agains SQL Server with a JOIN and an ORDER BY clause

Steps to Reproduce

Please break down here below all the needed steps to reproduce the issue

  1. Import dataset using the connector
  2. Example query SELECT ct.id, st.name FROM sqlserver_test_table st JOIN connector_join_test ct ON st.id = ct.id ORDER BY ct.id

Current Result

Please describe here below the current result you got

2018-11-08 11:55:56 UTC: Running on server cdb-dev with PID: 31350
2018-11-08 11:55:56 UTC: Before importer run
2018-11-08 11:55:56 UTC: ConnectorRunner {"provider":"sqlserver","table":"sqlserver_test_table","sql_query":"SELECT ct.id, st.name FROM sqlserver_test_table st JOIN connector_join_test ct ON st.id = ct.id ORDER BY ct.id"}
2018-11-08 11:55:56 UTC: Copy connected table
2018-11-08 11:55:57 UTC: Connector Copy table  cdb_importer.importer_4052bf56e34d11e886d60204e4dfe4d8
2018-11-08 11:55:57 UTC: Creating Server
2018-11-08 11:55:57 UTC: Creating Usermaps
2018-11-08 11:55:57 UTC: Creating Foreign Table
2018-11-08 11:55:59 UTC: Copying Foreign Table
2018-11-08 11:56:00 UTC: Connector Error PG::Error: ERROR:  Executing ODBC query

2018-11-08 11:56:00 UTC: Connector cleanup
2018-11-08 11:56:00 UTC: Connector cleaned-up
2018-11-08 11:56:00 UTC: ConnectorRunner Error PG::Error: ERROR:  Executing ODBC query

2018-11-08 11:56:00 UTC: Proceeding to register
2018-11-08 11:56:00 UTC: After importer run
2018-11-08 11:56:00 UTC: After dispatch
2018-11-08 11:56:00 UTC: ERROR!
===LOG END===

Expected result

Please describe here below what should be the expected behaviour

Import the dataset correctly

System trying to connect to and version

What system were you trying to connect (PostgreSQL, MySQL, etc) and what version

Microsoft SQL Azure (RTM) - 12.0.2000.8

Additional info

Please add any information of interest here below

@ethervoid ethervoid added the bug label Nov 8, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant