You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by Daniel Barclay <db...@maprtech.com> on 2015/03/18 07:34:45 UTC

Re: Review Request 32083: DRILL-2463: Implement JDBC NULL -> dummy value mapping in AvaticaDrillSqlAccessor and SqlAccessors.

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32083/
-----------------------------------------------------------

(Updated March 18, 2015, 6:34 a.m.)


Review request for drill, Mehant Baid and Parth Chandra.


Summary (updated)
-----------------

DRILL-2463: Implement JDBC NULL -> dummy value mapping in AvaticaDrillSqlAccessor and SqlAccessors.


Repository: drill-git


Description (updated)
-------

Added null checks to ResultSet.getTYPE(...) methods to return dummy values for SQL NULL (e.g., 0 for getInt(...), Java null for getString()).


Diffs (updated)
-----

  exec/java-exec/src/main/codegen/config.fmpp 5dc7360 
  exec/java-exec/src/main/codegen/templates/SqlAccessors.java b569185 
  exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/BoundCheckingAccessor.java 7e8da2c 
  exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/SqlAccessor.java b8480b4 
  exec/jdbc/src/main/java/org/apache/drill/jdbc/AvaticaDrillSqlAccessor.java cf5829a 
  exec/jdbc/src/test/java/org/apache/drill/jdbc/test/Drill2463GetNullsFailedWithAssertionsBugTest.java PRE-CREATION 

Diff: https://reviews.apache.org/r/32083/diff/


Testing
-------

Ran new tests for JDBC metadata fixes (DRILL-2420--related) and existing tests.


Thanks,

Daniel Barclay


Re: Review Request 32083: DRILL-2463: Implement JDBC NULL -> dummy value mapping in AvaticaDrillSqlAccessor and SqlAccessors.

Posted by Parth Chandra <pc...@maprtech.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32083/#review77793
-----------------------------------------------------------

Ship it!


Minor comments that can be addressed later


exec/java-exec/src/main/codegen/config.fmpp
<https://reviews.apache.org/r/32083/#comment126067>

    Formatiing change with no other change in the file should be in a separate (formatting) patch.



exec/java-exec/src/main/codegen/templates/SqlAccessors.java
<https://reviews.apache.org/r/32083/#comment126072>

    You will probably need to add the getString method for all varlen types.


- Parth Chandra


On March 23, 2015, 8:21 p.m., Daniel Barclay wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/32083/
> -----------------------------------------------------------
> 
> (Updated March 23, 2015, 8:21 p.m.)
> 
> 
> Review request for drill, Mehant Baid and Parth Chandra.
> 
> 
> Repository: drill-git
> 
> 
> Description
> -------
> 
> Added null checks to ResultSet.getTYPE(...) methods to return dummy values for SQL NULL (e.g., 0 for getInt(...), Java null for getString()).
> 
> 
> Diffs
> -----
> 
>   exec/java-exec/src/main/codegen/config.fmpp 5dc7360 
>   exec/java-exec/src/main/codegen/templates/SqlAccessors.java 3039e5c 
>   exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/BoundCheckingAccessor.java 7e8da2c 
>   exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/SqlAccessor.java b69ae54 
>   exec/jdbc/src/main/java/org/apache/drill/jdbc/AvaticaDrillSqlAccessor.java 3702257 
>   exec/jdbc/src/test/java/org/apache/drill/jdbc/test/Drill2463GetNullsFailedWithAssertionsBugTest.java PRE-CREATION 
> 
> Diff: https://reviews.apache.org/r/32083/diff/
> 
> 
> Testing
> -------
> 
> Ran new tests for JDBC metadata fixes (DRILL-2420--related) and existing tests.
> 
> 
> Thanks,
> 
> Daniel Barclay
> 
>


Re: Review Request 32083: DRILL-2463: Implement JDBC NULL -> dummy value mapping in AvaticaDrillSqlAccessor and SqlAccessors.

Posted by Mehant Baid <ba...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32083/#review77944
-----------------------------------------------------------



exec/java-exec/src/main/codegen/templates/SqlAccessors.java
<https://reviews.apache.org/r/32083/#comment126308>

    Like we discussed offline, we are performing the isnull checks in the SqlAccessor layer and also in the Vector's accessor.



exec/java-exec/src/main/codegen/templates/SqlAccessors.java
<https://reviews.apache.org/r/32083/#comment126303>

    We don't have TimeStampTZ any more. You can remove this block.


- Mehant Baid


On March 23, 2015, 8:21 p.m., Daniel Barclay wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/32083/
> -----------------------------------------------------------
> 
> (Updated March 23, 2015, 8:21 p.m.)
> 
> 
> Review request for drill, Mehant Baid and Parth Chandra.
> 
> 
> Repository: drill-git
> 
> 
> Description
> -------
> 
> Added null checks to ResultSet.getTYPE(...) methods to return dummy values for SQL NULL (e.g., 0 for getInt(...), Java null for getString()).
> 
> 
> Diffs
> -----
> 
>   exec/java-exec/src/main/codegen/config.fmpp 5dc7360 
>   exec/java-exec/src/main/codegen/templates/SqlAccessors.java 3039e5c 
>   exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/BoundCheckingAccessor.java 7e8da2c 
>   exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/SqlAccessor.java b69ae54 
>   exec/jdbc/src/main/java/org/apache/drill/jdbc/AvaticaDrillSqlAccessor.java 3702257 
>   exec/jdbc/src/test/java/org/apache/drill/jdbc/test/Drill2463GetNullsFailedWithAssertionsBugTest.java PRE-CREATION 
> 
> Diff: https://reviews.apache.org/r/32083/diff/
> 
> 
> Testing
> -------
> 
> Ran new tests for JDBC metadata fixes (DRILL-2420--related) and existing tests.
> 
> 
> Thanks,
> 
> Daniel Barclay
> 
>


Re: Review Request 32083: DRILL-2463: Implement JDBC NULL -> dummy value mapping in AvaticaDrillSqlAccessor and SqlAccessors.

Posted by Daniel Barclay <db...@maprtech.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32083/
-----------------------------------------------------------

(Updated March 23, 2015, 8:21 p.m.)


Review request for drill, Mehant Baid and Parth Chandra.


Repository: drill-git


Description
-------

Added null checks to ResultSet.getTYPE(...) methods to return dummy values for SQL NULL (e.g., 0 for getInt(...), Java null for getString()).


Diffs (updated)
-----

  exec/java-exec/src/main/codegen/config.fmpp 5dc7360 
  exec/java-exec/src/main/codegen/templates/SqlAccessors.java 3039e5c 
  exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/BoundCheckingAccessor.java 7e8da2c 
  exec/java-exec/src/main/java/org/apache/drill/exec/vector/accessor/SqlAccessor.java b69ae54 
  exec/jdbc/src/main/java/org/apache/drill/jdbc/AvaticaDrillSqlAccessor.java 3702257 
  exec/jdbc/src/test/java/org/apache/drill/jdbc/test/Drill2463GetNullsFailedWithAssertionsBugTest.java PRE-CREATION 

Diff: https://reviews.apache.org/r/32083/diff/


Testing
-------

Ran new tests for JDBC metadata fixes (DRILL-2420--related) and existing tests.


Thanks,

Daniel Barclay