Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-7246

Crash Due to Unhandled JDBC Type Code 0 for NULL Values

    XMLWordPrintableJSON

Details

    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

      Attachments

        Issue Links

          Activity

            People

              satyakommula Satya Kommula
              satyakommula Satya Kommula
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: