Hello Igniters, Yup, it's THAT time once again as we haven't ultimately settled on anything with the subj. as of yet, but I believe that now with DDL on its way this talk can't be avoided anymore (sorry guys).
The last time we talked about Ignite specific stuff we need to have in CREATE TABLE (key fields list, affinity key, am I missing anything?), the simplest approach suggested by Sergi was that we simply use WITH part of H2's CREATE TABLE to pass stuff we need. This could work, but needless to say that such commands would look plain ugly. I think we should go with custom syntax after all, BUT not in a way suggested before by Sergi (propose Apache Ignite mode to H2). Instead, I suggest that we propose to H2 patch that would allow plugging in *custom SQL parser* directly based on theirs (quite elegant one) – I've had a look at their code, and this should not be hard. Work on such a patch making syntax parsing overridable would take a couple days which is not much time AND would give us the opportunity to introduce to Ignite virtually any syntax we wish - both now and in the future. Without worrying about compatibility with H2 ever again, that is. Thoughts? After we agree on this principally and after H2 patch for custom parsing is ready, we can roll our sleeves and focus on syntax itself. - Alex
