Fork me on GitHub
#sql
<
2019-02-21
>
viesti06:02:30

Hola! When would 0.7.9 version seem likely for release? We are using 0.7.6 because of this issue: https://dev.clojure.org/jira/browse/JDBC-176, would like to jump onto a newer version to avoid confusion within the team ๐Ÿ™‚

seancorfield06:02:19

@viesti I wasn't planning to release 0.7.9 once I've figured out what to do about https://dev.clojure.org/jira/browse/JDBC-174

seancorfield06:02:26

At this point, I'm leaning toward just updating the docstring to caution about DB-specific behavior/options and punting on a better solution in next.jdbc.

seancorfield06:02:08

I'll set myself a reminder to deal with this tomorrow at work since we moved my main scheduled task from tomorrow to next Tuesday ๐Ÿ™‚

viesti06:02:25

after quick glance Iโ€™d agree, since thereโ€™s new development ahead with next.jdbc

viesti06:02:32

nothing is burning at our side, just wanted to quickly ask about the 0.7.9, so no worries, thanks for the reply ๐Ÿ™‚

viesti06:02:47

sounds like a good co-aligned set of work

seancorfield18:02:01

org.clojure/java.jdbc 0.7.9 is headed to Maven Central. Will announce in several places once it shows up there later today.

parrot 10
seancorfield18:02:44

Here's what's in it: Changes in 0.7.9 Fix behavior of multi-inserts when database does not support generated keys JDBC-176. Added highly experimental support for datafy/nav (in clojure.java.jdbc.datafy namespace). This includes a convention-based approach to foreign keys with some assistance from a :schema option. This is subject to change and is provided mostly for informational purposes, as an example of the new functionality in Clojure 1.10. This includes a fix for the conventions from JDBC-175. Add note about rewriting batched operations to insert-multi! for some drivers JDBC-174. Support Oracle SID style URLs (dbtype can be oracle:sid which maps to oracle:thin and uses : as the separator before the dbname value) JDBC-173.

viesti19:02:23

Awesome, thanks! ๐Ÿ™‚

seancorfield19:02:03

Thanks for the nudge. We've not been in need of the 0.7.9 changes at work and I've been so focused on next.jdbc that I had forgotten about it.

myguidingstar19:02:43

I have this piece of sql that works with Mariadb but cause Mysql 5.7 to yell invalid syntax https://gist.github.com/myguidingstar/d3e861f1ea895a27d826f898e4cbe728

myguidingstar19:02:58

what's the problem?

noisesmith19:02:28

it's funny that cow/index becomes cowindex in the error message

seancorfield19:02:59

CTEs are new in MySQL 8, aren't they? So 5.7 doesn't support them.

seancorfield19:02:39

Yup, confirmed. New in 8, not available in 5.7.