code: def test_update(self):
      # update a table with a metadata filter
      sql = """
              UPDATE milvus_test.testable
              SET test = 'test2'
              WHERE test = 'test'
          """
      self.run_sql(sql)
      # check if the data is updated
      sql = """
              SELECT * FROM milvus_test.testable
              WHERE test = 'test2'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # update the embeddings
      sql = """
              UPDATE milvus_test.testable
              SET embedding = [3.0, 2.0, 1.0]
              WHERE test = 'test2'
          """
      self.run_sql(sql)
      # check if the data is updated
      sql = """
              SELECT * FROM milvus_test.testable
              WHERE test = 'test2'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
      assert ret.embedding[0] == [3.0, 2.0, 1.0]
  
      # update multiple columns
      sql = """
              UPDATE milvus_test.testable
              SET test = 'test3',
                  embedding = [1.0, 2.0, 3.0]
                  content = 'this is a test'
              WHERE test = 'test2'
          """
      self.run_sql(sql)
      # check if the data is updated
      sql = """
              SELECT * FROM milvus_test.testable
              WHERE test = 'test3'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
      assert ret.embedding[0] == [1.0, 2.0, 3.0]
      assert ret.content[0] == "this is a test"
  
      # update a table with a search vector filter is not allowed
      sql = """
              UPDATE milvus_test.testable
              SET `metadata.test = 'test2'
              WHERE search_vector = [1.0, 2.0, 3.0]
          """
      with pytest.raises(Exception):
          self.run_sql(sql)
  
      # update a table without any filters is allowed
      sql = """
              UPDATE milvus_test.testable
              SET metadata.test = 'test3'
          """
      self.run_sql(sql)
      # check if the data is updated
      sql = """
              SELECT * FROM milvus_test.testable
              WHERE `metadata.test` = 'test3'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # update a table with a search vector filter and a metadata filter is not allowed
      sql = """
              UPDATE milvus_test.testable
              SET metadata.test = 'test3'
              WHERE metadata.test = 'test2'
              AND search_vector = [1.0, 2.0, 3.0]
          """
      with pytest.raises(Exception):
          self.run_sql(sql)
  
file_path: mindsdb/tests/handler_tests/test_milvus_handler.py
imports: import importlib
  from unittest.mock import patch
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from ..unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 9 for calling the TestMilvusHandler obj's underlying member method code with example usage: obj.test_update() without return types