code: def test_vector_search(self, postgres_handler_mock):
      df = pd.DataFrame(
          {
              "id": ["id1", "id2", "id3", "id4", "id5", "id6"],
              "content": [
                  "test content",
                  "test paragraph",
                  "toast types",
                  "",
                  "tast misspelled",
                  "hello",
              ],
              "metadata": [
                  '{"price": 10}',
                  '{"price": 100}',
                  '{"price": 30}',
                  '{"test": "test1"}',
                  '{"test": "test2"}',
                  '{"test": "test3"}',
              ],
              "embeddings": [
                  [1.0, 2.0, 3.0],
                  [5.0, 2.0, 8.0],
                  [3.0, 6.0, 3.0],
                  [1.0, 2.0, 3.0],
                  [3.0, 1.0, 8.0],
                  [1.0, 3.0, 7.0],
              ],
          }
      )
      self.set_handler(
          postgres_handler_mock, "pg", tables={"testingtable": df}
      )
      # create a table
      sql = """
              CREATE TABLE xata_test.testingtable (
                  SELECT * FROM pg.df
              )
          """
      self.drop_table("testingtable")
      self.run_sql(sql)
      # query a table with a search vector, without limit
      sql = """
              SELECT * FROM xata_test.testingtable
              WHERE search_vector = '[1.0, 2.0, 3.0]'
          """
      assert self.run_sql(sql).shape[0] == 6
      # query a table with a search vector, with limit
      sql = """
              SELECT * FROM xata_test.testingtable
              WHERE search_vector = '[1.0, 2.0, 3.0]'
              LIMIT 1
          """
      assert self.run_sql(sql).shape[0] == 1
      # query a table with a search vector, and content column
      sql = """
              SELECT * FROM xata_test.testingtable
              WHERE search_vector = '[1.0, 2.0, 3.0]'
              AND content LIKE 'test%'
          """
      assert self.run_sql(sql).shape[0] == 2
      # query a table with a metadata filter and a search vector does not work
      sql = """
              SELECT * FROM xata_test.testingtable
              WHERE metadata.price < 200
              AND search_vector = '[1.0, 2.0, 3.0]'
          """
      with pytest.raises(Exception):
          self.run_sql(sql)
      self.drop_table("testingtable")
  
imports: import os
  import importlib
  from unittest.mock import patch
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from mindsdb.tests.unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 11 for calling the TestXetaHandler obj's underlying member method code with example usage: obj.test_vector_search(postgres_handler_mock) without return types