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