You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by Dave Birdsall <da...@esgyn.com> on 2017/03/28 22:13:25 UTC

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

RE: CQD to turn PCODE generation off?

Posted by Dave Birdsall <da...@esgyn.com>.
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 <da...@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

Re: CQD to turn PCODE generation off?

Posted by Qifan Chen <qi...@esgyn.com>.
Hi Dave,


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


Thanks --Qifan

________________________________
From: Dave Birdsall <da...@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

RE: CQD to turn PCODE generation off?

Posted by Dave Birdsall <da...@esgyn.com>.
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