Drizzle TeamDT
Drizzle Team•3y ago
Hortasha

Query issue - Syntax error at or near "$1"

Hello, I currently got this error recently:
PostgresError: syntax error at or near "$1"

This is the query i am trying to make. Note that this worked fine very recently.

const [ latestOppdatering, ] = await client.select()
  .from( oppdateringTable )
  .orderBy( desc( oppdateringTable.oppdateringsid ) )
  .limit( 1 );


If i use "toSQL()" in order to see what is being queried. I get the following:

{
  sql: 'select  from $1 order by $2 desc limit $3',
  params: [
    PgTable {
      dato: [PgTimestamp],
      endringstype: [PgText],
      oppdateringsid: [PgInteger],
      organisasjonsnummer: [PgText],
      createdAt: [PgTimestamp],
      updatedAt: [PgTimestamp],
      [Symbol(IsAlias)]: false,
      [Symbol(ExtraConfigBuilder)]: undefined,
      [Symbol(IsDrizzleTable)]: true,
      [Symbol(OriginalName)]: 'oppdatering',
      [Symbol(Name)]: 'oppdatering',
      [Symbol(Schema)]: 'brreg',
      [Symbol(BaseName)]: 'oppdatering',
      [Symbol(InlineForeignKeys)]: [],
      [Symbol(Columns)]: [Object]
    },
    PgInteger {
      table: [PgTable],
      config: [Object],
      name: 'oppdateringsid',
      notNull: true,
      default: undefined,
      hasDefault: undefined,
      primary: true
    },
    1
  ]
}

I was expecting it to do 'select * from $1 order by $2 desc limit $3'
Using 0.26.5

Trying to upgrade to 0:27 gives a bunch of type errors for some reason:
Like: '[isDrizzleTable]' is missing in type 'pgTable<{name: "enhet"; schema: "brreg"; columns: { ... }; ...}>'
Find that type error strange since i do not expect isDrizzleTable to be required in a schema i define? Anyone familiar with any of this, or what might be occuring here?
image.png
Was this page helpful?