[PHOENIX-7246] Crash Due to Unhandled JDBC Type Code 0 for NULL Values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: python-phoenixdb-1.2.1
• Fix Version/s: queryserver-6.0.1, python-phoenixdb-1.2.2
• Component/s: python, queryserver
• Assignee: Satya Kommula
• Reporter: Satya Kommula
• Created: 02/Mar/24 03:58
• Updated: 02/Mar/24 10:19
• Resolved: 02/Mar/24 10:19

Description

Steps to Reproduce:
SQL

SELECT NULL

crash:

----------------------------------------------------------------------
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

Issue Links

• links to: GitHub Pull Request #148