René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"could not determine data type of parameter","articleBody":"### Version\r\n\r\n1.16.0\r\n\r\n### What happened?\r\n\r\nStatements that cannot parse the column name can be executed, and the type cannot be inferred after changing the name of $2\r\n\r\n\r\n### Relevant log output\r\n\r\n```shell\r\n# package commcarddb\r\nqueries/commcard/commcard.sql:1:1: could not determine data type of parameter $2\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE public.solar_commcard_mapping (\r\n    id integer NOT NULL,\r\n    \"deviceId\" integer NOT NULL,\r\n    version character varying(32) DEFAULT ''::character varying NOT NULL,\r\n    sn character varying(32) DEFAULT ''::character varying NOT NULL,\r\n    \"createdAt\" timestamp with time zone DEFAULT now(),\r\n    \"updatedAt\" timestamp with time zone DEFAULT now()\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\nThis will work, but $2 won't resolve the column name\r\n\r\n\r\n-- name: InsertMappping :batchexec \r\nWITH table1 AS\r\n(\r\n    SELECT \"version\" from solar_commcard_mapping where \"deviceId\" = $1 order by \"updatedAt\" desc limit 1\r\n)\r\nINSERT INTO solar_commcard_mapping(\"deviceId\", \"version\", \"sn\",\"updatedAt\")\r\nSELECT $1,$2::text,$3,$4 WHERE not exists(SELECT * from table1 where table1.\"version\" = $2::text)  or not exists (select * from table1) ;\r\n\r\n```\r\n\r\n# package commcarddb\r\nqueries/commcard/commcard.sql:1:1: could not determine data type of parameter $2\r\n```\r\nWITH table1 AS\r\n(\r\n    SELECT \"version\" from solar_commcard_mapping where \"deviceId\" = $1 order by \"updatedAt\" desc limit 1\r\n)\r\nINSERT INTO solar_commcard_mapping(\"deviceId\", \"version\", \"sn\",\"updatedAt\")\r\nSELECT $1,@version::text,$3,$4 WHERE not exists(SELECT * from table1 where table1.\"version\" = @version::text)  or not exists (select * from table1) ;\r\n```\r\n```\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: \"2\"\r\nsql:\r\n  - schema: \"./schema/\"\r\n    queries: \"./queries/dumpservice/\"\r\n    engine: \"postgresql\"\r\n    gen:\r\n      go:\r\n        package: \"dumpservicedb\"\r\n        sql_package: \"pgx/v4\"\r\n        out: \"./sql/queries/dumpservicedb\"\r\n        emit_exact_table_names: true\r\n        emit_json_tags: true\r\n  - schema: \"./schema/\"\r\n    queries: \"./queries/mapping/\"\r\n    engine: \"postgresql\"\r\n    gen:\r\n      go:\r\n        package: \"mappingdb\"\r\n        sql_package: \"pgx/v4\"\r\n        out: \"./sql/queries/mappingdb\"\r\n        emit_exact_table_names: true\r\n        emit_json_tags: true\r\n  - schema: \"./schema/\"\r\n    queries: \"./queries/sitemapping/\"\r\n    engine: \"postgresql\"\r\n    gen:\r\n      go:\r\n        package: \"sitemappingdb\"\r\n        sql_package: \"pgx/v4\"\r\n        out: \"./sql/queries/sitemappingdb\"\r\n        emit_exact_table_names: true\r\n        emit_json_tags: true\r\n  - schema: \"./schema/\"\r\n    queries: \"./queries/commcard/\"\r\n    engine: \"postgresql\"\r\n    gen:\r\n      go:\r\n        package: \"commcarddb\"\r\n        sql_package: \"pgx/v4\"\r\n        out: \"./sql/queries/commcarddb\"\r\n        emit_exact_table_names: true\r\n        emit_json_tags: true\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/5fbfef02281fb67691c3cec9b2d084e5fde4329dcef538c7c84013fb2be45663\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/wj-stack","@type":"Person","name":"wj-stack"},"datePublished":"2023-03-17T01:11:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/2152/sqlc/issues/2152"}