PapaFinn
DTDrizzle Team
•Created by PapaFinn on 7/10/2024 in #help
Inner joining and left joining the same table (aliased) causes the return type to be never
We just closed the related open issue: https://github.com/drizzle-team/drizzle-orm/issues/2989
The fix is simply to use
alias instead of aliasedTable.16 replies
DTDrizzle Team
•Created by sunshne2263 on 12/23/2023 in #help
Is FULLTEXT Search Possible in MySQL via FULLTEXT Index?
I have the same question ☝️
5 replies
DTDrizzle Team
•Created by PapaFinn on 7/10/2024 in #help
Inner joining and left joining the same table (aliased) causes the return type to be never
I had the same thought just a few days ago. Can do.
16 replies
DTDrizzle Team
•Created by PapaFinn on 7/10/2024 in #help
Inner joining and left joining the same table (aliased) causes the return type to be never
Unfortunately had to do the same.
16 replies
DTDrizzle Team
•Created by PapaFinn on 7/10/2024 in #help
Inner joining and left joining the same table (aliased) causes the return type to be never
Another note is that, types aside, my query works as intended with one inner join and one left join.
16 replies
DTDrizzle Team
•Created by philbookst on 5/11/2023 in #help
DatabaseError: Duplicate column name 'id'
We figured it out! It was a fundamental misunderstanding on our end with how SQL works with subqueries. To fix it, we did need to reach for some custom sql strings.
5 replies
DTDrizzle Team
•Created by philbookst on 5/11/2023 in #help
DatabaseError: Duplicate column name 'id'
@philbookst Did you ever figure this out? We're at loss on our end 😅
5 replies
DTDrizzle Team
•Created by LeFuncq on 11/29/2023 in #help
TypeError: Cannot read properties of undefined (reading 'type') on drizzle kit push command
Had the same issue, but with an index. Same error and same workaround though. Had to change the index to a regular index from a unique one and then I could delete it with a separate push.
6 replies
DTDrizzle Team
•Created by Shadow_Darsan on 12/24/2023 in #help
Error [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './relations' is not defined by "exports"
So the only solution is to downgrade? Is this something that needs to be fixed in the library?
3 replies
DTDrizzle Team
•Created by PizzaConsole on 10/10/2023 in #help
Cannot join tables where the columns name are the same.
27 replies
DTDrizzle Team
•Created by PizzaConsole on 10/10/2023 in #help
Cannot join tables where the columns name are the same.
Sorry for mobile formatting 😅
27 replies
DTDrizzle Team
•Created by PizzaConsole on 10/10/2023 in #help
Cannot join tables where the columns name are the same.
const firstAlias = aliasedTable(myTable, "firstAlias")
const secondAlias = aliasedTable(myTable, "secondAlias")
const fetchedData = drizzleClient
.select({
first: getTableColumns(firstAlias),
second: getTableColumns(secondAlias)
})
.from(myTable)
.innerJoin(firstAlias, eq(firstAlias.someColumn, someValue))
.leftJoin(secondAlias, eq(secondAlias.someColukn, someOtherValue))
27 replies
DTDrizzle Team
•Created by PizzaConsole on 10/10/2023 in #help
Cannot join tables where the columns name are the same.
I feel like I don’t fully understand the issue. Did something like the following not work for you?
27 replies
DTDrizzle Team
•Created by PapaFinn on 6/20/2023 in #help
Extracting literal values from Drizzle enums
I’d be curious to know how to do all of the above though I was specifically asking about creating a zod schema you parse with.
7 replies
DTDrizzle Team
•Created by Luxaritas on 4/11/2023 in #help
Typescript build fails with large number of columns
Yep, you're right! Just tested with hundreds more columns and it takes quite a long time. Not even sure how long as I never saw anything come up 😅
195 replies
DTDrizzle Team
•Created by Luxaritas on 4/11/2023 in #help
Typescript build fails with large number of columns
I use Neovim with the built in LSP and code suggestions are instant, so it’s not just coc.
195 replies
DTDrizzle Team
•Created by PapaFinn on 4/27/2023 in #help
Does Drizzle support MySQL's LAST_INSERT_ID function?
Answered my own question. For anyone else with the same question — the value returned from an insert includes the
insertId. Man I love Drizzle 🫠12 replies