[MDEV-16724] CONNECT Engine's SRCDEF does not work with MS SQL 2016 Created: 2018-07-10 Updated: 2018-07-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Connect |
| Affects Version/s: | 10.2.16 |
| Fix Version/s: | 10.2 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Kathryn Sizemore | Assignee: | Olivier Bertrand |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | connect-engine | ||
| Environment: |
CentOS 7 |
||
| Description |
|
When trying to create a connect engine table with SRCDEF to a SQL Server 2016 source, it returns this error: "ERROR 1105 (HY000): Invalid Srcdef" CREATE TABLE `Party` ENGINE=CONNECT CONNECTION='DSN=sql_server2016;uid=username;pwd=password;TDS_Version=7.4' `TABLE_TYPE`='ODBC' `TABLE_TYPE`='ODBC' `SRCDEF`='SELECT * FROM dbo.Party' `BLOCK_SIZE`=1000; I had to use `TABNAME`='Party' instead to make this work. In a second environment I've successfully created a Connect table with a 2012 MS SQL server source with the exact same syntax above and SRCDEF above. Seems to be specific to the MS SQL Server version. |