Индуска моя опять отчебучила.

[tima]

Она все в декрете, а я все бултыхаюсь в капканах, которые она понаставила.

Полдня потратил сегодня. Нашел только что. Поэтому хочу всем сказать - Ребята! Не забывайте cast NULL or empty string!!! Это было что-то. Только логикой дошел, никакими дебагами не получалось - уж больно много SQLов она в UNION нашарашила...

"Back when I was 5, my dad would tell me 'always use source control, son'. Of course, I didn't understand what the heck he was talking about. But now I do. NOW I do."

Tim Borodin, programmer-child-at-heart. Thought #7.6.2.1.

Comments

[kpoxa-e.livejournal.com]

Какой, нафиг, source control!
Не имейте дел с индусами, и будет вам шастье :)

Just curious.

[sto-rozh.livejournal.com]

Cust Null to what?

Re: Just curious.

[tima.livejournal.com]

there is a big union with 4 or 5 SQLs. All of them have the field defined as CHAR. In the last one (she added without my supervision) she put that field as - "". Which Informix by default considered VARCHAR. So the ouput of the entire script got truncated to 255 chars in that field. And that was a note field having ALL escalation notes for a server. So the ticketing system got mad not receiving notes from us ...

Casted the "" to CHAR like that - NULL::CHAR - fixed the problem.