Skip to content

[BUG] Does not support Oracle placeholders like :1, :2, :name. #520

Description

@ledel037

Bug Description

Does not support Oracle placeholders like :1, :2, :name.

  1. unexpected token: COLON (':')

Code Example

	astNode, err := gosqlx.ParseWithDialect(sql, keywords.DialectOracle)
	if err != nil {
		return nil, fmt.Errorf("failed to parse SQL: %w", err)
	}

SQL Query

       sql := fmt.Sprintf(`SELECT %s FROM %s WHERE virtual_fund_id = :1`, virtualFundSelectColumns, virtualFundTable)
        rows, err := r.client.ExecuteQuery(ctx, sql, []interface{}{fundID})

Environment

  • OS: centos 7.9
  • Go Version: 1.24.13
  • GoSQLX Version: 1.12.1

Additional Context

I can only use Go version 1.24.13 for now, so I have to stick with GoSQLX 1.12.1. I haven't verified whether later versions are supported.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions