Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Syntax Error when input variable used as array length #46

Open
kevinclancy opened this issue May 24, 2024 · 0 comments
Open

SQL Syntax Error when input variable used as array length #46

kevinclancy opened this issue May 24, 2024 · 0 comments

Comments

@kevinclancy
Copy link

The following code:

let create_countries =
  let country_alias_length = 3 in
  [%rapper
    execute
      {sql|
      CREATE TABLE countries(
        id int PRIMARY KEY,
        alias char( %int{country_alias_length} ),
        name char(20),
        time_created timestamp,
        UNIQUE(alias)
      )
      |sql}
  ]

Produces the following error message:

Error in ppx_rapper: Syntax error in SQL: 'syntax error at or near "?"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant