code: def test_create_with_select(self, postgres_handler_mock):
      df = pd.DataFrame(
          {
              "id": ["id1", "id2"],
              "content": ["this is a test", "this is a test"],
              "metadata": ['{"test": "test"}', '{"test": "test"}'],
              "embeddings": [[1.0, 2.0, 3.0], [1.0, 2.0, 3.0]],
          }
      )
      self.set_handler(
          postgres_handler_mock, "pg", tables={"testingtable": df}
      )
      sql = """
          CREATE TABLE xata_test.testingtable (SELECT * FROM pg.df)
          """
      self.drop_table("testingtable")
      # this should work
      self.run_sql(sql)
      assert self.get_num_records("testingtable") == 2
      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 8 for calling the TestXetaHandler obj's underlying member method code with example usage: obj.test_create_with_select(postgres_handler_mock) without return types