code: def test_update(self):
      # update a table with a metadata filter
      sql = """
              UPDATE pinecone_test.testtable
              SET metadata.test = 'test2'
              WHERE metadata.test = 'test'
          """
      # sql shoudl fail
      with pytest.raises(Exception):
          self.run_sql(sql)
  
file_path: mindsdb/tests/handler_tests/test_pinecone_handler.py
imports: import importlib
  from unittest.mock import patch
  import os
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from tests.unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 7 for calling the TestPineconeHandler obj's underlying member method code with example usage: obj.test_update() without return types