<commit_before># simple create table
"create table t1(id bigint, primary key(id))"
{
  "QueryType": "DDL",
  "Original": "create table t1(id bigint, primary key(id))",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "main",
      "Sharded": false
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create table t1(id bigint, primary key(id))",
    "SingleShardOnly": false
  }
}

# simple create table with keyspace
"create table user.t1(id bigint, primary key(id))"
{
  "QueryType": "DDL",
  "Original": "create table user.t1(id bigint, primary key(id))",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create table user.t1(id bigint, primary key(id))",
    "SingleShardOnly": false
  }
}

# DDL
"create table a(id int)"
{
  "QueryType": "DDL",
  "Original": "create table a(id int)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "main",
      "Sharded": false
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create table a(id int)",
    "SingleShardOnly": false
  }
}

# simple create table with table qualifier that does not exists
"create table a.b(id int)"
"no keyspace with name [a] found"

#Alter table
"alter table a ADD id int"
{
  "QueryType": "DDL",
  "Original": "alter table a ADD id int",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "main",
      "Sharded": false
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "alter table a ADD id int",
    "SingleShardOnly": false
  }
}

#Alter table with qualifier
"alter table user.b ADD id int"
{
  "QueryType": "DDL",
  "Original": "alter table user.b ADD id int",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "alter table user.b ADD id int",
    "SingleShardOnly": false
  }
}

#Alter table with unknown qualifier
"alter table a.b ADD id int"
"no keyspace with name [a] found"

# DDL
"create index a on user(id)"
{
  "QueryType": "DDL",
  "Original": "create index a on user(id)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create index a on user (id)",
    "SingleShardOnly": false
  }
}

# DDL with qualifier
"create index a on user.user(id)"
{
  "QueryType": "DDL",
  "Original": "create index a on user.user(id)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create index a on user (id)",
    "SingleShardOnly": false
  }
}
<commit_msg>Added Test for a table not in vschema in unsharded keyspace<commit_after># simple create table
"create table t1(id bigint, primary key(id))"
{
  "QueryType": "DDL",
  "Original": "create table t1(id bigint, primary key(id))",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "main",
      "Sharded": false
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create table t1(id bigint, primary key(id))",
    "SingleShardOnly": false
  }
}

# simple create table with keyspace
"create table user.t1(id bigint, primary key(id))"
{
  "QueryType": "DDL",
  "Original": "create table user.t1(id bigint, primary key(id))",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create table user.t1(id bigint, primary key(id))",
    "SingleShardOnly": false
  }
}

# DDL
"create table a(id int)"
{
  "QueryType": "DDL",
  "Original": "create table a(id int)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "main",
      "Sharded": false
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create table a(id int)",
    "SingleShardOnly": false
  }
}

# simple create table with table qualifier that does not exists
"create table a.b(id int)"
"no keyspace with name [a] found"

#Alter table
"alter table a ADD id int"
{
  "QueryType": "DDL",
  "Original": "alter table a ADD id int",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "main",
      "Sharded": false
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "alter table a ADD id int",
    "SingleShardOnly": false
  }
}

#Alter table with qualifier
"alter table user.b ADD id int"
{
  "QueryType": "DDL",
  "Original": "alter table user.b ADD id int",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "alter table user.b ADD id int",
    "SingleShardOnly": false
  }
}

#Alter table with unknown qualifier
"alter table a.b ADD id int"
"no keyspace with name [a] found"

# DDL
"create index a on user(id)"
{
  "QueryType": "DDL",
  "Original": "create index a on user(id)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create index a on user (id)",
    "SingleShardOnly": false
  }
}

# DDL with qualifier
"create index a on user.user(id)"
{
  "QueryType": "DDL",
  "Original": "create index a on user.user(id)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create index a on user (id)",
    "SingleShardOnly": false
  }
}

# DDL with qualifier
"create index a on main.unknown(id)"
{
  "QueryType": "DDL",
  "Original": "create index a on main.unknown(id)",
  "Instructions": {
    "OperatorType": "Send",
    "Keyspace": {
      "Name": "user",
      "Sharded": true
    },
    "TargetDestination": "AllShards()",
    "IsDML": false,
    "Query": "create index a on unknown (id)",
    "SingleShardOnly": false
  }
}

{'fraction_non_alphanumeric': 0.175422138836773, 'fraction_numerical': 0.001876172607879925, 'mean_word_length': 3.247675962815405, 'pattern_counts': {'":': 165, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3010136', 'n_tokens_mistral': 2265, 'n_tokens_neox': 2279, 'n_words': 645}