MySQL generation fails to load indexes

[luis-mozn]

Trying to use Bob instead of sqlc to compile sql queries to Go.
Using the latest bobgen-mysql (mysql image 8.0) fails with:

2025/06/27 15:01:06 unable to fetch table data: unable to load indexes: sql: Scan error on column index 5, name "descending": sql/driver: couldn't convert <nil> (<nil>) into type bool
exit status 1

The most recent version I tested that seemed to work was v0.27.0

[stephenafamo]

Can you share an example of your config?

[luis-mozn]

@stephenafamo I ran with just the following:

mysql:
  queries:
    - ./queries

And command

MYSQL_DSN="<redacted>:<redacted>@tcp(localhost:3306)/mydb" go run github.com/stephenafamo/bob/gen/bobgen-mysql@latest -c ./bobgen.yaml

[stephenafamo]

Thanks. Found the issue. I'll fix it over the weekend.

[stephenafamo]

Can you share an example schema?

I am primarily interested in which index has no collation (ASC or DESC). I've tried creating HASH or SPATIAL indexes, but these report a collation.

I need this to test if my fix works as expected.

[luis-mozn]

@stephenafamo Here's an abridged example of an index where 'collation' is null in our schema:

CREATE TABLE `redacted_table_name` (
                                                ...
                                                `value` longtext NOT NULL,
                                                ...
                                                FULLTEXT KEY `value_ft_index` (`value`),

All of them seem to be in a similar format to this

[stephenafamo]

Should be fixed by #473