DT
Drizzle Teammakaron pelnoziarnisty

Wrong type on decimals

Hello, I have encountered something interesting. The first screenshot shows what I'm inserting into the products table, second shows the schema of the products table and the third one shows what I get when I query the products table. As you can see all decimal fields are now strings but typescript is telling me that they're numbers.
No description
No description
No description
B
bloberenober405d ago
Hmm, decimals should be strings everywhere This is postgres, correct? OK, this is apparently MySQL, since it's declared as number in there Let me fix
MP
makaron pelnoziarnisty405d ago
yep this is mysql
B
bloberenober405d ago
@coldhands fixed in 0.23.6
Want results from more Discord servers?
Add your server
More Posts
CheckHello there, from this discussion: https://discord.com/channels/1043890932593987624/1090486363251544cascadesI know you can add `.references()` to set up foreign keys in a table definition, but how do you set jsonb field definition.What's the right way to define a jsonb field? I have a type `type MetaData = {keywords?: string[];}"Extend" tables by other tablesHey all, first of all great work with drizzle. Haven't had the time to play around with it so far. Bmaximum call stack exceededWeird bug where whenever I add a `where` `eq` clause getting maximum call stack exceededDrizzle recommended way to migrate resetApologies if this is a stupid question, I just recently migrated out of prisma and into drizzle. Onecompound uniqueIndexIn Prisma, I have in my schema definition the following declaration that requires userId and timestaplanetscale: how to index col using drizzle?Hi, seems most of the samples are pg. I'm using planetscale, and no having any luck figuring out how[Bug?] Drizzle generates a broken query when passing an explicit value for a column as `undefined`I've translated most of my logic from Prisma usage -> Drizzle. Noticed an issue where when explicitlHelp improving my queryIf feel like this is far from how what it actually should look like in drizzle could I get some poinLeft join with JSONI'm using PlanetScale (MySQL) and have 2 tables: orders and products. Every order contains basic infDrizzle-kit throws module not found error for internal files imported through absolute pathI've attached the error log and how the error was fixed.drizzle bug won't let me update mysql tablewrote a bug ticket on github describing the bug but just wanted to post here as well for visibility Generated Collate valueNot sure if this is relevant but I'm translating a Prisma schema into drizzle. Every Prisma table ha