phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "alex kamil (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-2454) Upsert with Double.NaN returns NumberFormatException
Date Wed, 25 Nov 2015 20:17:10 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

alex kamil updated PHOENIX-2454:
--------------------------------
    Description: 
When saving Double.NaN via prepared statement into column of type Double getting NumberFormatException
(while expected behavior is saving null)

test case:

{code}
import java.sql.*;
public static void main(String [] args){
  try {
	  Connection phoenixConnection = DriverManager.getConnection("jdbc:phoenix:localhost");
	  String sql  = "CREATE TABLE test25 (id BIGINT not null primary key,  col1 double, col2
double)";
	  Statement stmt = phoenixConnection.createStatement();
	  stmt.executeUpdate(sql);
	  phoenixConnection.commit();
	  
	  sql = "UPSERT INTO test25 (id, col1,col2) VALUES (?,?,?)";
	  PreparedStatement ps = phoenixConnection.prepareStatement(sql);
	  ps.setInt(1, 12);
	  ps.setDouble(2, 2.5);
	  ps.setDouble(3, Double.NaN);
	  ps.executeUpdate();
	  phoenixConnection.commit();
	  phoenixConnection.close();
	  } catch (Exception e) {
	         e.printStackTrace();
	  }
}
{code}


  was:
When saving Double.NaN via prepared statement into column of type Double getting NumberFormatException
(while expected behavior is saving null)

test case:

import java.sql.*;
public static void main(String [] args){
  try {
	  Connection phoenixConnection = DriverManager.getConnection("jdbc:phoenix:localhost");
	  String sql  = "CREATE TABLE test25 (id BIGINT not null primary key,  col1 double, col2
double)";
	  Statement stmt = phoenixConnection.createStatement();
	  stmt.executeUpdate(sql);
	  phoenixConnection.commit();
	  
	  sql = "UPSERT INTO test25 (id, col1,col2) VALUES (?,?,?)";
	  PreparedStatement ps = phoenixConnection.prepareStatement(sql);
	  ps.setInt(1, 12);
	  ps.setDouble(2, 2.5);
	  ps.setDouble(3, Double.NaN);
	  ps.executeUpdate();
	  phoenixConnection.commit();
	  phoenixConnection.close();
	  } catch (Exception e) {
	         e.printStackTrace();
	  }
}



> Upsert with Double.NaN returns NumberFormatException
> ----------------------------------------------------
>
>                 Key: PHOENIX-2454
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2454
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: alex kamil
>            Priority: Minor
>
> When saving Double.NaN via prepared statement into column of type Double getting NumberFormatException
(while expected behavior is saving null)
> test case:
> {code}
> import java.sql.*;
> public static void main(String [] args){
>   try {
> 	  Connection phoenixConnection = DriverManager.getConnection("jdbc:phoenix:localhost");
> 	  String sql  = "CREATE TABLE test25 (id BIGINT not null primary key,  col1 double,
col2 double)";
> 	  Statement stmt = phoenixConnection.createStatement();
> 	  stmt.executeUpdate(sql);
> 	  phoenixConnection.commit();
> 	  
> 	  sql = "UPSERT INTO test25 (id, col1,col2) VALUES (?,?,?)";
> 	  PreparedStatement ps = phoenixConnection.prepareStatement(sql);
> 	  ps.setInt(1, 12);
> 	  ps.setDouble(2, 2.5);
> 	  ps.setDouble(3, Double.NaN);
> 	  ps.executeUpdate();
> 	  phoenixConnection.commit();
> 	  phoenixConnection.close();
> 	  } catch (Exception e) {
> 	         e.printStackTrace();
> 	  }
> }
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message