trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Birdsall <dave.birds...@esgyn.com>
Subject RE: CQD to turn PCODE generation off?
Date Tue, 28 Mar 2017 23:25:03 GMT
Thanks, Qifan. That's even better. The CQD will work in Release builds as well as Debug builds.

-----Original Message-----
From: Qifan Chen [mailto:qifan.chen@esgyn.com] 
Sent: Tuesday, March 28, 2017 3:56 PM
To: dev@trafodion.incubator.apache.org
Subject: Re: CQD to turn PCODE generation off?

Hi Dave,


Another method is to apply CQD PCODE_OPT_LEVEL 'off'.  This will turn off PCODE completely.


Thanks --Qifan

________________________________
From: Dave Birdsall <dave.birdsall@esgyn.com>
Sent: Tuesday, March 28, 2017 5:16:56 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: CQD to turn PCODE generation off?

Never mind. I think I found it. (Always happens just after I write an e-mail.)

At the beginning of ex_expr::pCodeGenerate (exp/ExpPCodeExpGen.cpp) I see this code:

  if (getenv("NO_PCODE"))
    return ex_expr::EXPR_OK;

So the answer seems to be to set the environment variable NO_PCODE (to anything) in your Linux
shell, then enter sqlci.

Dave

-----Original Message-----
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Tuesday, March 28, 2017 3:13 PM
To: dev@trafodion.incubator.apache.org
Subject: CQD to turn PCODE generation off?

Hi,

If memory serves, long ago in a predecessor product there was a CQD that turned off PCODE
generation, forcing execution of the ex_clause's at run-time. But grepping around in sqlcomp/nadefaults.cpp
I don't see it.

Does anyone know off the top of their head if such a CQD still exists? And what is it?

Thanks,

Dave

Mime
View raw message