Hello to all,<div><br></div><div>a left join which have only right table columns in join condition seems to produce invalid bat.</div><div>Assume we have the tables below:</div><div><br></div><div><div>CREATE TABLE tableA(x integer, y integer);</div>
<div>INSERT INTO tableA values(1,10);</div><div>INSERT INTO tableA values(2,20);</div><div>CREATE TABLE tableB(x integer, y integer);</div><div>INSERT INTO tableB values(1,-10);</div><div>INSERT INTO tableB values(2,-20);</div>
<div><br></div><div>and pose the query:</div><div><div>SELECT A.x, A.y, B.x, B.y</div><div>FROM tableA A</div><div>LEFT JOIN tableB B ON ( B.y &lt; -10 ) ;</div></div><div><br></div><div>the expected results are:</div><div>
<div><div><div>+------+----- +------+------+</div><div>|  x    |   y  | x     | y     |</div><div>+===+===+===+===+</div><div>|    1  |   10 |    2 |  -20 |</div><div>|    2  |   20 |    2 |  -20 |</div><div>+------+------+------+------+</div>
</div></div></div><div><br></div><div><br></div><div>but mclient prints this message:</div><div><div>TypeException:user.s1_1[36]:&#39;algebra.kdifference&#39; undefined in: _55:any := algebra.kdifference(_54:bat[:oid,:int], _44:bat[:void,:oid])</div>
<div>TypeException:user.s1_1[37]:&#39;algebra.markT&#39; undefined in: _56:any := algebra.markT(_55:any, _21:oid)</div><div>TypeException:user.s1_1[38]:&#39;bat.reverse&#39; undefined in: _57:any := bat.reverse(_56:any)</div>
<div>TypeException:user.s1_1[39]:&#39;algebra.join&#39; undefined in: _58:any := algebra.join(_57:any, _20:bat[:oid,:int])</div><div>TypeException:user.s1_1[41]:&#39;algebra.leftjoin&#39; undefined in: _60:any := algebra.leftjoin(_59:bat[:oid,:void], _54:bat[:oid,:int])</div>
<div>TypeException:user.s1_1[43]:&#39;bat.append&#39; undefined in: _64:any := bat.append(_61:bat[:oid,:int], _60:any, _65:bit)</div><div>TypeException:user.s1_1[44]:&#39;bat.append&#39; undefined in: _66:any := bat.append(_64:any, _58:any, _65:bit)</div>
<div>TypeException:user.s1_1[55]:&#39;algebra.join&#39; undefined in: _80:any := algebra.join(_57:any, _79:bat[:oid,:int])</div><div>TypeException:user.s1_1[61]:&#39;algebra.leftjoin&#39; undefined in: _90:any := algebra.leftjoin(_59:bat[:oid,:void], _89:bat[:oid,:int])</div>
<div>TypeException:user.s1_1[63]:&#39;bat.append&#39; undefined in: _92:any := bat.append(_91:bat[:oid,:int], _90:any, _65:bit)</div><div>TypeException:user.s1_1[64]:&#39;bat.append&#39; undefined in: _93:any := bat.append(_92:any, _80:any, _65:bit)</div>
<div>TypeException:user.s1_1[70]:&#39;algebra.project&#39; undefined in: _102:any := algebra.project(_57:any, _100:int)</div><div>TypeException:user.s1_1[83]:&#39;bat.append&#39; undefined in: _119:any := bat.append(_117:bat[:oid,:int], _102:any, _118:bit)</div>
<div>TypeException:user.s1_1[89]:&#39;algebra.project&#39; undefined in: _126:any := algebra.project(_57:any, _125:int)</div><div>TypeException:user.s1_1[96]:&#39;bat.append&#39; undefined in: _133:any := bat.append(_132:bat[:oid,:int], _126:any, _118:bit)</div>
<div>SQLException:SQLengine:Program contains errors</div></div><div><br></div><div><br></div>For ease I attach sql scripts for creating tables and posing the query</div><div><br></div><div>Best regards,<br>George Garbis<br>

</div>