Fork me on GitHub
#honeysql
<
2023-05-23
>
Ben Lieberman17:05:42

I'm getting this exception from the SQL Server JDBC driver

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WITH'.
The query itself is a simple CREATE TABLE statement that has no usages of WITH as far as I can see. I used honeysql to generate the query (including the :with-columns syntax) and that's the only thing I can think of that might be a problem here, but I don't see how. (I'm also a SQL noob though.) Insights appreciated.

seancorfield18:05:04

Show us the HoneySQL calls and what they produce.

Ben Lieberman19:05:30

Stumbled on my own typo, actually. Thanks!

2