Error in log on Django connection

[tarkhil]

Bug Description:

                SELECT VERSION(),
                       @@sql_mode,
                       @@default_storage_engine,
                       @@sql_auto_is_null,
                       @@lower_case_table_names,
                       CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL
             # error=P01: syntax error, unexpected IS near 'IS NOT NULL

upon connection by Django. As far as I understand, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL is a valid SQL, or manticore is assumed not to understand it?

Manticore Search Version:

6.2.12 dc5144d@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)

Operating System Version:

Ubuntu 22.04.3 LTS

Have you tried the latest development version?

• Yes

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

• Task estimated
• Specification created, reviewed, and approved
• Implementation completed
• Tests developed
• Documentation updated
• Documentation proofread
• Changelog updated

[sanikolaev]

CONVERT_TZ() has nothing to do with Manticore. @tarkhil, do you mean that you tried to use Manticore instead of MySQL in Django and it failed? Unfortunately, not every tool designed for use with MySQL is compatible with Manticore.

Another related issue is #670