christopheleroy

Update parser/deparser weirdness with "function" (postgres context, but expected everywhere)

3

The below simple request fails its Parsing and can never be execute: `` update shipment_request set is_retired=1, retired_ts = now(), retired_uid = ?v WHERE reqid = ?n and is_retired=0 ``...

nullpointerexception on unconventional query

1

On a big SELECT /union/ SELECT / union ... query, which the parser declares is unparseable (but works when executing "plain vanilla"), the query cannot be executed because I get:...

I think line 1012 in this file is where a column name that is missing will be counted as "Null", bringing a cryptic "NullPointerException" and a 500 to the Yada...

SQL parsing oddities (with json datatype in Postgres)

5

The use of Postgres fields is awesome, but Yada does not consistently parse the queries - I'm just making a not of this. This fails: UPDATE MAMBA_MAP SET criteria =...

dumbfounded by a simple query, perhaps due to a simple subquery

6

Hello, the relatively simply query below fails. I have no idea why. This works in SQL: update COUNTRY_SITE_PERSON SET mod_time = systimestamp, is_active=0, mod_emp521 = (select emp521 from person where...

Suggestion on name-parameters in (sql) queries

7

Hello, Here is an example that illustrates why I'm suggesting this. So, we have a row of data that may be flagged in the app as "missing" to mean, missing...

Subselects making miseries

1

I had to change: INSERT into DEPOT_STUDY_PERSON_LINK(DEPOT_STUDY_PERSON_LINK_ID, PERSON_ID, STUDY_ID, DEPOT_ID, INV_UPLOAD_ID,INV_EFFECTIVE_DATE, COMMIT_TIME, IS_ACTIVE, MOD_TIME) SELECT ?n, (SELECT MIN(PERSON_ID) FROM PERSON WHERE lower(EMP521)=?v), (SELECT STUDY_ID FROM STUDY WHERE PROTOCOL_NUMBER = ?v),...