go to post Dmitry Maslennikov · Dec 10 Now, how wonderful would be, if InterSystems produced official product like this, and Community Edition would get much higher number of connections available there, when nothing needed only for Enterprise is left there.
go to post Dmitry Maslennikov · Dec 10 Have a look at VSCode, Studio already reached end of life, no reason to keep using it.
go to post Dmitry Maslennikov · Dec 10 Why not to put which standard exactly it exactly? It says, see the documentation for more information. Where it is? The only found page have not been changes for a few versions. Where is JSON_VALUE, JSON_QUERY, JSON_EXISTS that defined in the standard?
go to post Dmitry Maslennikov · Dec 9 Most of the time it generates queries that make no sense. But still supposed to be working. CREATE TABLE t0(c0 BIT ); SELECT * FROM t0 WHERE (c0 IN (c0, c0, c0, c0)); Gives SQL Error [400] [S1000]: [SQLCODE: <-400>:<Fatal error occurred>] [Location: <Prepare>] [%msg: <<UNDEFINED>in+4^%qaqpnl *mt("v","4")>] https://ideas.intersystems.com/ideas/DPI-I-881
go to post Dmitry Maslennikov · Dec 8 Yeah, I know that it's works without those brackets. But the thing is that SQLancer generates SQL queries randomly, and expected to produce queries that looks ridiculous, but syntactically correct and expected to work On community edition due to small amount of licensed connections, and issue with fast releasing available connections, and probably due to too many failures on the network layer in the communication it's very fast start to fail to connect due to license limit.
go to post Dmitry Maslennikov · Dec 8 I saw you used mine sqlalchemy-iris, looks like implementation is much easier this way, thanks.
go to post Dmitry Maslennikov · Dec 4 WebTerminal not a terminal in that terms, it's a just an emulation, you need to use real terminal.
go to post Dmitry Maslennikov · Dec 1 InterSystems now publishes driver to the maven central repository, so instead of github repo, should be used this for maven <dependency> <groupId>com.intersystems</groupId> <artifactId>intersystems-jdbc</artifactId> <version>3.10.5</version> </dependency> or in gradle implementation("com.intersystems:intersystems-jdbc:3.10.5")
go to post Dmitry Maslennikov · Nov 27 It does not look like that my implementation will be even approved for the contest. I may need to find a better idea to implement for the contest, while it's extended
go to post Dmitry Maslennikov · Nov 26 Still don't see any issues with $select, that look like Analyzer issue
go to post Dmitry Maslennikov · Nov 26 Are you sure that you use it correctly, do you have a much closer example that will show that behaviour?
go to post Dmitry Maslennikov · Nov 24 Microsoft is not even against publishing drivers in open source
go to post Dmitry Maslennikov · Nov 20 Why would you need XML from CLS? When you can load cls files using $system.OBJ.Import()
go to post Dmitry Maslennikov · Nov 20 it fails on 2024.1 USER>s json=[{"s":"iPhone1"},{"s":"iPhone2"},{"s":"IPHONE3"},{"s":"IPHONE4"},{"s":"Phone5"}] USER>d ##class(%ASQ.SetUtils).pp(json.apply("$[*]?(@.s like_regex '\p{LL}\w+')")) <THROW>parse+8^%ASQ.Parser.1 *%Exception.StatusException ERROR #30000: ASQ SYNTAX: Error in expression, found 'string '\p{LL}\w+'', expected ')' USER 4e1>w $zv IRIS for UNIX (Ubuntu Server LTS for ARM64 Containers) 2024.1 (Build 267_2_23660U) Wed Aug 28 2024 15:23:37 EDT
go to post Dmitry Maslennikov · Nov 20 Finally there is something, but that's still look like way less then it actually supports There should be `like_regex` predicate, which would help with case insensitive search, but I did not manage to get it working. Looks like it partially implemented, at least on the version 2024.1 I'm using
go to post Dmitry Maslennikov · Nov 20 Thanks, I've asked for this for the last 10 years at least. I thought there was supposed to be a very different driver for NodeJS, with SQL support, driver published I don't know what for, and who will use it without access to SQL. Python driver, I would not say the best implementation, I tried to report about issues there, and were told that's not going to be fixed.
go to post Dmitry Maslennikov · Nov 19 Is ASQ or JSON Path in IRIS already documented or not? I can't find anything in the documentation And I tried to play with JSONPath online, and I can't figure out why InterSystems ASQ, does not understand at all what perfectly works there. So, is ASQ is a superset of JSONPath or just fully different implementation? How to test it? It just always complains, and with no documentation quite difficult to understand what's going on, and how to fix it
