[
https://issues.apache.org/jira/browse/PHOENIX-7246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Satya Kommula updated PHOENIX-7246:
-----------------------------------
Description:
*Steps to Reproduce:*
SQL
{noformat}
SELECT NULL
{noformat}
crash:
{noformat}
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/tests/test_types.py",
line 383, in test_select_null
cursor.execute("SELECT NULL")
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 234, in execute
self._process_results(results)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 181, in _process_results
return self._process_result(results[0])
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 175, in _process_result
self._set_signature(result.signature if result.HasField('signature') else
None)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 148, in _set_signature
dtype = TypeHelper.from_column(column)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/types.py",
line 297, in from_column
return TypeHelper._from_jdbc(column.type.id)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/types.py",
line 305, in _from_jdbc
raise NotImplementedError('JDBC TYPE CODE {} is not
supported'.format(jdbc_code))
NotImplementedError: JDBC TYPE CODE 0 is not supported{noformat}
was:
*{*}Steps to Reproduce{*}*:
SQL
{noformat}
SELECT NULL
{noformat}
crash:
{noformat}
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/tests/test_types.py",
line 383, in test_select_null
cursor.execute("SELECT NULL")
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 234, in execute
self._process_results(results)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 181, in _process_results
return self._process_result(results[0])
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 175, in _process_result
self._set_signature(result.signature if result.HasField('signature') else
None)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
line 148, in _set_signature
dtype = TypeHelper.from_column(column)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/types.py",
line 297, in from_column
return TypeHelper._from_jdbc(column.type.id)
File
"/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/types.py",
line 305, in _from_jdbc
raise NotImplementedError('JDBC TYPE CODE {} is not
supported'.format(jdbc_code))
NotImplementedError: JDBC TYPE CODE 0 is not supported{noformat}
> Crash Due to Unhandled JDBC Type Code 0 for NULL Values
> -------------------------------------------------------
>
> Key: PHOENIX-7246
> URL: https://issues.apache.org/jira/browse/PHOENIX-7246
> Project: Phoenix
> Issue Type: Bug
> Components: python, queryserver
> Affects Versions: python-phoenixdb-1.2.1
> Reporter: Satya Kommula
> Assignee: Satya Kommula
> Priority: Major
>
> *Steps to Reproduce:*
> SQL
> {noformat}
> SELECT NULL
> {noformat}
> crash:
> {noformat}
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/tests/test_types.py",
> line 383, in test_select_null
> cursor.execute("SELECT NULL")
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
> line 234, in execute
> self._process_results(results)
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
> line 181, in _process_results
> return self._process_result(results[0])
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
> line 175, in _process_result
> self._set_signature(result.signature if result.HasField('signature') else
> None)
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/cursor.py",
> line 148, in _set_signature
> dtype = TypeHelper.from_column(column)
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/types.py",
> line 297, in from_column
> return TypeHelper._from_jdbc(column.type.id)
> File
> "/home/satyakommula/opensource/phoenix-queryserver/python-phoenixdb/phoenixdb/types.py",
> line 305, in _from_jdbc
> raise NotImplementedError('JDBC TYPE CODE {} is not
> supported'.format(jdbc_code))
> NotImplementedError: JDBC TYPE CODE 0 is not supported{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
