The tool stopped working on MacOS 15.4

[legosx]

Version

1.28.0

What happened?

Running the tool via:

go run -mod=mod github.com/sqlc-dev/sqlc/cmd/sqlc generate

Getting the log:

Relevant log output

# github.com/pganalyze/pg_query_go/v5/parser
src_port_snprintf.c:374:1: error: static declaration of 'strchrnul' follows non-static declaration
/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX.sdk/usr/include/_string.h:198:9: note: previous declaration is here
src_port_snprintf.c:438:27: warning: 'strchrnul' is only available on macOS 15.4 or newer [-Wunguarded-availability-new]
/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX.sdk/usr/include/_string.h:198:9: note: 'strchrnul' has been marked as being introduced in macOS 15.4 here, but the deployment target is macOS 15.0.0
src_port_snprintf.c:438:27: note: enclose 'strchrnul' in a __builtin_available check to silence this warning

Database schema

Any schema

SQL queries

Any queries

Configuration

Fails even without any config

Playground URL

I think it's clear without it

What operating system are you using?

MacOS 15.4

What database engines are you using?

Postgres

What type of code are you generating?

Go code

[hishamk]

Same error as well

[hishamk]

Set export MACOSX_DEPLOYMENT_TARGET=15.4

But the static declaration is causing issues:

src_port_snprintf.c:374:1: error: static declaration of 'strchrnul' follows non-static declaration
/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX.sdk/usr/include/_string.h:198:9: note: previous declaration is here
db/db.go:21: running "go": exit status 1

[jrmullins]

I was able to get around this by adding this to my zshrc

export CGO_CFLAGS="-DHAVE_STRCHRNUL"

[havsar]

export CGO_CFLAGS="-DHAVE_STRCHRNUL -mmacosx-version-min=15.4"
export MACOSX_DEPLOYMENT_TARGET="15.4"

This is a temporary solution that worked for me until it gets fixed.

[nginx-nickc]

sqlc from main, with github.com/pganalyze/pg_query_go/v6@v6.1.0 seems to work too.

[rubberduck203]

Not sure if this helps. I stumbled across this issue while looking for a solution to the same problem with the ruby gem pg_query.
pganalyze/pg_query#327

[pgr0ss]

If I understand correctly, we need the pg_query_go upgrade (which is part of #3922) and then we need a new release of sqlc. Any chance we can get a timeline on these changes? Thanks!

[kyleconroy]

Yep! New release was supposed to go out last week, but I'm glad I waited for pg_query_go 6.1.0 to land