INDEX_STATEMENTS = {
    'basic': (
        'CREATE INDEX by_city ON {}(city.f.f)',
        'CREATE INDEX by_county ON {}(county.f.f)',
        'CREATE INDEX by_realm ON {}(realm.f)',
    ),
    'range': (
        'CREATE INDEX by_coins ON {}(coins.f)',
        'CREATE INDEX by_achievement ON {}(achievements)',
        'CREATE INDEX by_category ON {}(category)',
        'CREATE INDEX by_year ON {}(year)',
    ),
    'multi_emits': (
        'CREATE INDEX by_city ON {}(city.f.f)',
        'CREATE INDEX by_county ON {}(county.f.f)',
        'CREATE INDEX by_country ON {}(country.f)',
    ),
    'body': (
        'CREATE INDEX by_city ON {}(city.f.f)',
        'CREATE INDEX by_realm ON {}(realm.f)',
        'CREATE INDEX by_country ON {}(country.f)',
    ),
    'group_by': (
        'CREATE INDEX by_state ON {}(state.f)',
        'CREATE INDEX by_year ON {}(year)',
        'CREATE INDEX by_gmtime ON {}(gmtime)',
        'CREATE INDEX by_full_state ON {}(full_state.f)',
    ),
    'distinct': (
        'CREATE INDEX by_state ON {}(state.f)',
        'CREATE INDEX by_year ON {}(year)',
        'CREATE INDEX by_full_state ON {}(full_state.f)',
    ),
}

INDEX_STATEMENTS = {
    'basic': (
        'CREATE INDEX by_city ON `{}` (city.f.f)',
        'CREATE INDEX by_county ON `{}` (county.f.f)',
        'CREATE INDEX by_realm ON `{}` (`realm.f`)',
    ),
    'range': (
        'CREATE INDEX by_coins ON `{}` (coins.f)',
        'CREATE INDEX by_achievement ON `{}` (achievements)',
        'CREATE INDEX by_category ON `{}` (category)',
        'CREATE INDEX by_year ON `{}` (year)',
    ),
    'multi_emits': (
        'CREATE INDEX by_city ON `{}` (city.f.f)',
        'CREATE INDEX by_county ON `{}` (county.f.f)',
        'CREATE INDEX by_country ON `{}` (country.f)',
    ),
    'body': (
        'CREATE INDEX by_city ON `{}` (city.f.f)',
        'CREATE INDEX by_realm ON `{}` (`realm.f`)',
        'CREATE INDEX by_country ON `{}` (country.f)',
    ),
    'group_by': (
        'CREATE INDEX by_state ON `{}` (state.f)',
        'CREATE INDEX by_year ON `{}` (year)',
        'CREATE INDEX by_gmtime ON `{}` (gmtime)',
        'CREATE INDEX by_full_state ON `{}` (full_state.f)',
    ),
    'distinct': (
        'CREATE INDEX by_state ON `{}` (state.f)',
        'CREATE INDEX by_year ON `{}` (year)',
        'CREATE INDEX by_full_state ON `{}` (full_state.f)',
    ),
}

Correct syntax while creating indexes
Correct syntax while creating indexes

Change-Id: I90625647d8723531dbc7498d5d25e84ef1a3ed2b
Reviewed-on: http://review.couchbase.org/50007
Tested-by: buildbot <80754af91bfb6d1073585b046fe0a474ce868509@couchbase.com>
Reviewed-by: Michael Wiederhold <a17fed27eaa842282862ff7c1b9c8395a26ac320@couchbase.com>

  INDEX_STATEMENTS = {
      'basic': (
-         'CREATE INDEX by_city ON {}(city.f.f)',
+         'CREATE INDEX by_city ON `{}` (city.f.f)',
-         'CREATE INDEX by_county ON {}(county.f.f)',
+         'CREATE INDEX by_county ON `{}` (county.f.f)',
-         'CREATE INDEX by_realm ON {}(realm.f)',
+         'CREATE INDEX by_realm ON `{}` (`realm.f`)',
      ),
      'range': (
-         'CREATE INDEX by_coins ON {}(coins.f)',
+         'CREATE INDEX by_coins ON `{}` (coins.f)',
-         'CREATE INDEX by_achievement ON {}(achievements)',
+         'CREATE INDEX by_achievement ON `{}` (achievements)',
-         'CREATE INDEX by_category ON {}(category)',
+         'CREATE INDEX by_category ON `{}` (category)',
-         'CREATE INDEX by_year ON {}(year)',
+         'CREATE INDEX by_year ON `{}` (year)',
      ),
      'multi_emits': (
-         'CREATE INDEX by_city ON {}(city.f.f)',
+         'CREATE INDEX by_city ON `{}` (city.f.f)',
-         'CREATE INDEX by_county ON {}(county.f.f)',
+         'CREATE INDEX by_county ON `{}` (county.f.f)',
-         'CREATE INDEX by_country ON {}(country.f)',
+         'CREATE INDEX by_country ON `{}` (country.f)',
      ),
      'body': (
-         'CREATE INDEX by_city ON {}(city.f.f)',
+         'CREATE INDEX by_city ON `{}` (city.f.f)',
-         'CREATE INDEX by_realm ON {}(realm.f)',
+         'CREATE INDEX by_realm ON `{}` (`realm.f`)',
-         'CREATE INDEX by_country ON {}(country.f)',
+         'CREATE INDEX by_country ON `{}` (country.f)',
      ),
      'group_by': (
-         'CREATE INDEX by_state ON {}(state.f)',
+         'CREATE INDEX by_state ON `{}` (state.f)',
-         'CREATE INDEX by_year ON {}(year)',
+         'CREATE INDEX by_year ON `{}` (year)',
-         'CREATE INDEX by_gmtime ON {}(gmtime)',
+         'CREATE INDEX by_gmtime ON `{}` (gmtime)',
-         'CREATE INDEX by_full_state ON {}(full_state.f)',
+         'CREATE INDEX by_full_state ON `{}` (full_state.f)',
      ),
      'distinct': (
-         'CREATE INDEX by_state ON {}(state.f)',
+         'CREATE INDEX by_state ON `{}` (state.f)',
-         'CREATE INDEX by_year ON {}(year)',
+         'CREATE INDEX by_year ON `{}` (year)',
-         'CREATE INDEX by_full_state ON {}(full_state.f)',
+         'CREATE INDEX by_full_state ON `{}` (full_state.f)',
      ),
  }
  
Correct syntax while creating indexes
## Code Before:
INDEX_STATEMENTS = {
    'basic': (
        'CREATE INDEX by_city ON {}(city.f.f)',
        'CREATE INDEX by_county ON {}(county.f.f)',
        'CREATE INDEX by_realm ON {}(realm.f)',
    ),
    'range': (
        'CREATE INDEX by_coins ON {}(coins.f)',
        'CREATE INDEX by_achievement ON {}(achievements)',
        'CREATE INDEX by_category ON {}(category)',
        'CREATE INDEX by_year ON {}(year)',
    ),
    'multi_emits': (
        'CREATE INDEX by_city ON {}(city.f.f)',
        'CREATE INDEX by_county ON {}(county.f.f)',
        'CREATE INDEX by_country ON {}(country.f)',
    ),
    'body': (
        'CREATE INDEX by_city ON {}(city.f.f)',
        'CREATE INDEX by_realm ON {}(realm.f)',
        'CREATE INDEX by_country ON {}(country.f)',
    ),
    'group_by': (
        'CREATE INDEX by_state ON {}(state.f)',
        'CREATE INDEX by_year ON {}(year)',
        'CREATE INDEX by_gmtime ON {}(gmtime)',
        'CREATE INDEX by_full_state ON {}(full_state.f)',
    ),
    'distinct': (
        'CREATE INDEX by_state ON {}(state.f)',
        'CREATE INDEX by_year ON {}(year)',
        'CREATE INDEX by_full_state ON {}(full_state.f)',
    ),
}

## Instruction:
Correct syntax while creating indexes
## Code After:
INDEX_STATEMENTS = {
    'basic': (
        'CREATE INDEX by_city ON `{}` (city.f.f)',
        'CREATE INDEX by_county ON `{}` (county.f.f)',
        'CREATE INDEX by_realm ON `{}` (`realm.f`)',
    ),
    'range': (
        'CREATE INDEX by_coins ON `{}` (coins.f)',
        'CREATE INDEX by_achievement ON `{}` (achievements)',
        'CREATE INDEX by_category ON `{}` (category)',
        'CREATE INDEX by_year ON `{}` (year)',
    ),
    'multi_emits': (
        'CREATE INDEX by_city ON `{}` (city.f.f)',
        'CREATE INDEX by_county ON `{}` (county.f.f)',
        'CREATE INDEX by_country ON `{}` (country.f)',
    ),
    'body': (
        'CREATE INDEX by_city ON `{}` (city.f.f)',
        'CREATE INDEX by_realm ON `{}` (`realm.f`)',
        'CREATE INDEX by_country ON `{}` (country.f)',
    ),
    'group_by': (
        'CREATE INDEX by_state ON `{}` (state.f)',
        'CREATE INDEX by_year ON `{}` (year)',
        'CREATE INDEX by_gmtime ON `{}` (gmtime)',
        'CREATE INDEX by_full_state ON `{}` (full_state.f)',
    ),
    'distinct': (
        'CREATE INDEX by_state ON `{}` (state.f)',
        'CREATE INDEX by_year ON `{}` (year)',
        'CREATE INDEX by_full_state ON `{}` (full_state.f)',
    ),
}
