GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — Optional WHERE parameters via $1 IS NULL OR - redeclared in this block - query_parameter_limit · Issue #4191 · sqlc-dev/sqlc Open Labels DescriptionVersion1.30.0 What happened?Fail to generate go gode when using named argument >1 for optional SELECT WHERE query case suggested solution does not work in 1.30.0 in golang
would generate go compile error Relevant log outputGo auto-generated code go build # query_parameter_limit = 4 (important) will generate (ISSUE) duplicate func args # query_parameter_limit = 1 will generate struct, no duplicate (NO ISSUE) sqlc/maindb/users.sql.go:25:64: name redeclared in this block sqlc/maindb/users.sql.go:25:50: other declaration of name Database schemaCREATE TABLE users (name TEXT NOT NULL); SQL queries-- name: ListUsers :many SELECT * FROM users WHERE (name = sqlc.narg('name') OR sqlc.narg('name') IS NULL) Configurationversion: "2" sql: - engine: "mysql" queries: "./db/maindb/queries/" schema: "./db/maindb/migrations/" gen: go: package: "maindb" out: "internal/infra/sqlc/maindb" sql_package: "database/sql" sql_driver: "github.com/go-sql-driver/mysql" emit_interface: true emit_json_tags: true json_tags_case_style: "camel" emit_prepared_queries: true emit_exact_table_names: true emit_empty_slices: true emit_result_struct_pointers: true emit_params_struct_pointers: true query_parameter_limit: 4 emit_db_tags: true emit_enum_valid_method: true emit_all_enum_values: true emit_sql_as_comment: true What operating system are you using?macOS What database engines are you using?MySQL What type of code are you generating?Go Activity
MetadataMetadataAssigneesLabelsTypeProjectsMilestoneRelationshipsDevelopmentIssue actions |
| You are visitor 01402503 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |