About former_SQLA_member1694875

former_SQLA_member1694875

Hi, There is the Locks During Deletes section in the docs, but it lacks info about triggers. I need a confirmation about row-level BEFORE DELETE trigger firing time: does it fire just after write lock is acquired on the row to be deleted? It would be...

former_SQLA_member1694875

According to EXECUTE IMMEDIATE statement docs: Only global variables can be referenced in a statement executed by EXECUTE IMMEDIATE. I have three cases that show this is not always true at least in builds 16.0.0.2614 and 17.0.10.5771 (and 11.0.1.31...

former_SQLA_member1694875

I have some problems with sp_parse_json procedure (the docs) in v16.0.0.2614 (haven't tested in v17 yet). Here is a script to reproduce (I've simplified json string as much as I could, the real string is much more complex): begin declare @json lo...

former_SQLA_member1694875

SQL Anywhere 16.0.0.2471 We get an error message "Procedure 'openxml' not found" when calling OPENXML operator (till SA12 it was called 'system procedure' in the docs) with quotes, e. g.: select test from "openxml"(null,'/Test') with(test integer);...

former_SQLA_member1694875

Hi, SQL Anywhere 16.0.0.2471. We get "Remote server '...' could not be found" error (SQLCODE=-659) when non-dba user executes a procedure (owned by dba) which selects remote data from proxy table into temporary table. I've prepared sample script...

former_SQLA_member1694875

this will cause the relative belated connection to wait until the first connection is finish The LOCK MUTEX statement has an optional TIMEOUT clause, which can help prevent this.

former_SQLA_member1694875

Understood. Thanks.

former_SQLA_member1694875

I would expect the same result in both examples, i. e. I would expect sa_parse_json to generate ARRAY of ARRAY of INT (instead of ARRAY of VARCHAR).

former_SQLA_member1694875

I don't mean to add an element to an array if that array is supposed to be empty. I am talking about the structure of generated data type, while actual data in that structure should of course reflect the input string. Maybe these two examples will ex...

former_SQLA_member1694875

Thank you for the explanation. As to the issue #1, wouldn't it be possible to implement a little bit different behavior (maybe dependant on some additional argument), that in case of an empty TestA[[2]].TestA array, sp_parse_json would determine the ...

User Statistics

User Activity

Do BEFORE DELETE triggers fire after write lock is acquired?

EXECUTE IMMEDIATE with variable references

Questions about sp_parse_json procedure (SA16)

Procedure 'openxml' not found (SA16 bug?)

Remote server not found when selecting into temp table in procedure (SA16 bugs?)

Re: Scope Clause in CREATE MUTEX

Re: EXECUTE IMMEDIATE with variable references

Re: Questions about sp_parse_json procedure (SA16)

Re: Questions about sp_parse_json procedure (SA16)

Re: Questions about sp_parse_json procedure (SA16)