[CALCITE-3344] In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier, and for Sybase ASE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: jdbc-adapter
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 14/Sep/19 03:09
• Updated: 06/Mar/20 04:35
• Resolved: 20/Sep/19 19:55

Description

In JDBC adapter, generate "SELECT TOP(n)" for Microsoft SQL Server (MSSQL) 2008 and earlier, because it doesn't support "FETCH".

For MSSQL 2012 and higher, continue to generate "FETCH NEXT n ROWS".

I have started work here: https://github.com/julianhyde/calcite/tree/3344-top-n