Drizzle Studio giving error due to `CURRENT_TIMESTAMP` in schema

I am having some issues with drizzle studio. I am not able to query the results when there is a

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP included in my schema.

See schema on drizzle studio in the first image "1. schema" attached, it is having an error on line no. 20 for

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP
Error =

Cannot find name 'CURRENT_TIMESTAMP'.

Cannot find name 'CURRENT_TIMESTAMP'.

Cannot find name 'CURRENT_TIMESTAMP'.

Cannot find name 'CURRENT_TIMESTAMP'.

When I try to fetch data using the query

db.select().from(userCity);

db.select().from(userCity);

db.select().from(userCity);

db.select().from(userCity); , in the "queries" tab. See the second image "2. queries".

It shows error dialog, with error on console

ReferenceError: CURRENT_TIMESTAMP is not defined

ReferenceError: CURRENT_TIMESTAMP is not defined

ReferenceError: CURRENT_TIMESTAMP is not defined

ReferenceError: CURRENT_TIMESTAMP is not defined. See the third image "3. error".

whereas the same query in "sql" section is able to fetch the data. See the fourth image "4. sql".

Also, if in my schema, there are tables with no CURRENT_TIMESTAMP in it, it works as expected with no error.

My Drizzle Config:

import type { Config } from "drizzle-kit";

const uri = [
  "mysql://",
  process.env.DB_USERNAME,
  ":",
  process.env.DB_PASSWORD,
  "@",
  process.env.DB_HOST,
  ":3306/",
  process.env.DB_NAME,
].join("");

export default {
  schema: "../schema/src/tables",
  out: "../schema/drizzle",
  driver: "mysql2",
  dbCredentials: { uri },
  tablesFilter: ["*"],
} satisfies Config;

import type { Config } from "drizzle-kit";

const uri = [
  "mysql://",
  process.env.DB_USERNAME,
  ":",
  process.env.DB_PASSWORD,
  "@",
  process.env.DB_HOST,
  ":3306/",
  process.env.DB_NAME,
].join("");

export default {
  schema: "../schema/src/tables",
  out: "../schema/drizzle",
  driver: "mysql2",
  dbCredentials: { uri },
  tablesFilter: ["*"],
} satisfies Config;

import type { Config } from "drizzle-kit";

const uri = [
  "mysql://",
  process.env.DB_USERNAME,
  ":",
  process.env.DB_PASSWORD,
  "@",
  process.env.DB_HOST,
  ":3306/",
  process.env.DB_NAME,
].join("");

export default {
  schema: "../schema/src/tables",
  out: "../schema/drizzle",
  driver: "mysql2",
  dbCredentials: { uri },
  tablesFilter: ["*"],
} satisfies Config;

import type { Config } from "drizzle-kit";

const uri = [
  "mysql://",
  process.env.DB_USERNAME,
  ":",
  process.env.DB_PASSWORD,
  "@",
  process.env.DB_HOST,
  ":3306/",
  process.env.DB_NAME,
].join("");

export default {
  schema: "../schema/src/tables",
  out: "../schema/drizzle",
  driver: "mysql2",
  dbCredentials: { uri },
  tablesFilter: ["*"],
} satisfies Config;

My Drizzle Schema:

import { sql } from "drizzle-orm";
import { int, primaryKey, timestamp, varchar } from "drizzle-orm/mysql-core";

import { tableCreator } from "./_table";

export const userCity = tableCreator(
  "user_city",
  {
    cityid: int("CITYID").autoincrement().notNull(),
    cityname: varchar("CITYNAME", { length: 100 }).notNull(),
    state: varchar("STATE", { length: 100 }),
    udpateby: int("UDPATEBY").notNull(),
    update: timestamp("UPDATE", { mode: "date" })
      .default(sql`CURRENT_TIMESTAMP`)
      .onUpdateNow()
      .notNull(),
  },
  (table) => {
    return {
      userCityCityid: primaryKey({
        columns: [table.cityid],
        name: "user_city_CITYID",
      }),
    };
  },
);

import { sql } from "drizzle-orm";
import { int, primaryKey, timestamp, varchar } from "drizzle-orm/mysql-core";

import { tableCreator } from "./_table";

export const userCity = tableCreator(
  "user_city",
  {
    cityid: int("CITYID").autoincrement().notNull(),
    cityname: varchar("CITYNAME", { length: 100 }).notNull(),
    state: varchar("STATE", { length: 100 }),
    udpateby: int("UDPATEBY").notNull(),
    update: timestamp("UPDATE", { mode: "date" })
      .default(sql`CURRENT_TIMESTAMP`)
      .onUpdateNow()
      .notNull(),
  },
  (table) => {
    return {
      userCityCityid: primaryKey({
        columns: [table.cityid],
        name: "user_city_CITYID",
      }),
    };
  },
);

import { sql } from "drizzle-orm";
import { int, primaryKey, timestamp, varchar } from "drizzle-orm/mysql-core";

import { tableCreator } from "./_table";

export const userCity = tableCreator(
  "user_city",
  {
    cityid: int("CITYID").autoincrement().notNull(),
    cityname: varchar("CITYNAME", { length: 100 }).notNull(),
    state: varchar("STATE", { length: 100 }),
    udpateby: int("UDPATEBY").notNull(),
    update: timestamp("UPDATE", { mode: "date" })
      .default(sql`CURRENT_TIMESTAMP`)
      .onUpdateNow()
      .notNull(),
  },
  (table) => {
    return {
      userCityCityid: primaryKey({
        columns: [table.cityid],
        name: "user_city_CITYID",
      }),
    };
  },
);

import { sql } from "drizzle-orm";
import { int, primaryKey, timestamp, varchar } from "drizzle-orm/mysql-core";

import { tableCreator } from "./_table";

export const userCity = tableCreator(
  "user_city",
  {
    cityid: int("CITYID").autoincrement().notNull(),
    cityname: varchar("CITYNAME", { length: 100 }).notNull(),
    state: varchar("STATE", { length: 100 }),
    udpateby: int("UDPATEBY").notNull(),
    update: timestamp("UPDATE", { mode: "date" })
      .default(sql`CURRENT_TIMESTAMP`)
      .onUpdateNow()
      .notNull(),
  },
  (table) => {
    return {
      userCityCityid: primaryKey({
        columns: [table.cityid],
        name: "user_city_CITYID",
      }),
    };
  },
);

No replies yetBe the first to reply to this messageJoin

Drizzle Studio giving error due to `CURRENT_TIMESTAMP` in schema

Similar Threads

Similar Threads

Similar Threads