firebird-automations

Commented by: Cosmin Apreutesei (cosmin_ap2) Since some ppl are watching this, I found out that LIST\(DISTINCT\) enforces a sort which solves half of the problems\. That's just an implementation detail,...

Commented by: Cosmin Apreutesei (cosmin_ap2) Just found out about the GROUP\_CONCAT operator of mysql \[1\]\. So how'bout LIST\(\[DISTINCT\] expr \[,expr \.\.\.\] \[ORDER BY \{unsigned\_integer \| col\_name \| expr\} \[ASC \|...

Commented by: Dany Marmur (dany) I am currently solving this problem using a CTE like so: WITH EDU\_EPT AS \( SELECT EEPT2\.TARGET\_SWE FROM EDUCATION\_EVENT\_PR\_TRGT EEPT2 WHERE EEPT2\.EDUCATION\_EVENT\_ID = :EDU\_EVENT\_ID ORDER...

Modified by: Sean Leyne (seanleyne) description: The LIST\(\) function could rock, if only you could control the order of elements\. Right now I can't use it to display data since...

Commented by: Kjell Rilbe (kjellrilbe) Any news about this? Any new operations in Firebird that adds other \(documented\) approaches to achieve the same thing?

Modified by: @pavel-zotov Attachment: eval\-too\-long\-expr\-leads\-fb\-to\-crash\.7z \[ 13413 \]

Commented by: @pavel-zotov PS\. What looks weird is that duration of work this script before it crashes in FB can strongly vary: from \~40s for odd to 5\-10 s for...

Commented by: @dyemanov Stack overflow, I suppose\. I doubt we can do anyhting with that in the short term\. Maybe only report this error properly on Windows \(we do that...

Commented by: @dyemanov Duplicate for [CORE395](https://github.com/FirebirdSQL/firebird/issues?q=CORE395+in%3Atitle)?

Commented by: @pavel-zotov \> Duplicate for [CORE395](https://github.com/FirebirdSQL/firebird/issues?q=CORE395+in%3Atitle)? Yes, exactly\. But ticket 395 has less terms \(maybe because older version of FB crashed earlier :\)\)