Is BIGINT still supported as an datatype for the ID´s in the full text search?

[adnandewdrops (Adnan Sirur)]

Hello,

Initially when we created the database, we chose to create the ID´s in BIGINT for all our tables. It worked just fine with the full text search. But recently we are not able to perform any full text search and get this error saying “The conversion from BIGINT to OTHER is not supported”. You can find an attachment of the error message.

Is BIGINT not supported by full text search anymore?

Is the BIGINT value being converted to some other datatype for performing the full text search and hence the error?

Regards,
Adnan

[adnandewdrops (Adnan Sirur)]

Hello,

Would really like some help on this. Thanks!

Regards,
Adnan

[gorbunkov (Maxim Gorbunkov)]

Hi,
please provide a small demo project that demonstrates your error.

[adnandewdrops (Adnan Sirur)]

Hello,

Thanks for the reply.

Please find a small demo project and the error screenshot in the attachments. Also, do not alter the db scripts, since the Identifiers needs to be a BigInt.

Regards,
Adnan

demoProj.zip (364.3K)

[gorbunkov (Maxim Gorbunkov)]

Seems that it’s a bug. See the related issue.

[adnandewdrops (Adnan Sirur)]

We have a lot of data currently in the production phase, When is the issue expected to be fixed ?

Is there a work around of sorts which would get the full text search to work ?

[gorbunkov (Maxim Gorbunkov)]

We plan to publish the 6.6 bugfix release in next few days.

[adnandewdrops (Adnan Sirur)]

Thank you!

[system]

See the following issue in our bug tracker:

https://youtrack.cuba-platform.com/issue/PL-9879