Index on Boolean type failed

[jiqiang90]

Prerequisites

• [ ] Are you running the latest version(s)?
• [ ] Did you check the debugging guide?
• [ ] Did you check the FAQs and Discussions?
• [ ] Are you reporting to the correct repository?
• [ ] Did you search for an existing issue or pull request?

Description

To reproduce this:

Set an index on Boolean type field in schema. Like

  field5: Boolean  @index(unique: false)

And this will run sql:

CREATE INDEX "0x00e4ebcbb72226c0" ON "Polkadot-starter"."starter_entities" USING gist ("field5", "_block_range")

Get error :

data type boolean has no default operator class for access method "gist" Hint: You must specify an operator class for the index or define a default operator class for the data type.

Details

These details can help to reproduce the environment the issue is occurring

Local Environment: [You can get this information from executing subql version.] Query Version: [What is the version of the query service?] Indexer Version: [What is the version of the indexer service?] Network Details:

• [Network]
• [Block height, a block height where the issue is happening]
• [Dictionary endpoint, if used]

Steps to Reproduce

1. [First Step]
2. [Second Step]
3. [and so on...]

Example project: [A link to a minimal example that can reproduce the issue]

Expected behavior: [What you expected to happen]

Actual behavior: [What actually happened]

Any other information

Is there any other information you would like to add?

[ianhe8x]

related to #1668

[moda20]

@ianhe8x I am getting a very similar issue with an index on boolean type, but not on local development environment, only on the managed service cloud, is this still a known issue ?