[
https://issues.apache.org/jira/browse/CALCITE-1895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16113654#comment-16113654
]
Julian Hyde commented on CALCITE-1895:
--------------------------------------
It's tricky to add a new database to CI. But that shouldn't be the goal. I
think your goal should be to run
{code}mvn -Dcalcite.test.db=mssql test{code}
from the command line. To do this, add a new value MSSQL to enum
DatabaseInstance in CalciteAssert. Then populate your database manually. It's
straightforward to populate the SCOTT schema (EMP, DEPT etc.)
Maybe eventually we can get that database into Vagrant or Docker.
I'm reviewing and testing your PR now.
> Substring operator broken for MSSQL
> -----------------------------------
>
> Key: CALCITE-1895
> URL: https://issues.apache.org/jira/browse/CALCITE-1895
> Project: Calcite
> Issue Type: Bug
> Components: jdbc-adapter
> Reporter: Chris Baynes
> Assignee: Julian Hyde
>
> The format mssql uses looks like:
> SUBSTRING(input, start, length)
> but the default is currently to unparse to SUBSTRING(input FROM start FOR
> length)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
