Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add outer and cross apply (mssql) #1074

Open
wants to merge 8 commits into
base: master
Choose a base branch
from
Open

Add outer and cross apply (mssql) #1074

Changes from 1 commit
Commits
Show all changes
8 commits
Select commit Hold shift click to select a range
a4d9146
add outer apply to table expression
Jul 7, 2024
7bdb790
add cross apply to table expression
Jul 8, 2024
0195d5e
run query in tests
Jul 8, 2024
282399e
test typings
Jul 8, 2024
112ec82
move test
Jul 8, 2024
feb3cfc
widen types to allow apply with table
Jul 8, 2024
409e21d
clean up rogue import
Jul 8, 2024
e2a3c29
clean up imports
Jul 8, 2024
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
run query in tests
  • Loading branch information
Drew Marshall committed Jul 8, 2024
commit 0195d5e4af140000ba27f390f66830ff1aa02579
26 changes: 26 additions & 0 deletions test/node/src/join.test.ts
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -82,6 82,19 @@ for (const dialect of DIALECTS) {
parameters: [],
},
})

const result = await q.execute()

expect(result).to.have.length(3)

expect(result).to.containSubset([
{
first_name: 'Jennifer',
name: 'Catto',
},
{ first_name: 'Arnold', name: 'Doggo' },
{ first_name: 'Sylvester', name: 'Hammo' },
] satisfies Partial<(typeof result)[number]>[])
})

it('should cross apply an expression', async () => {
Expand All @@ -106,6 119,19 @@ for (const dialect of DIALECTS) {
parameters: [],
},
})

const result = await q.execute()

expect(result).to.have.length(3)

expect(result).to.containSubset([
{
first_name: 'Jennifer',
name: 'Catto',
},
{ first_name: 'Arnold', name: 'Doggo' },
{ first_name: 'Sylvester', name: 'Hammo' },
] satisfies Partial<(typeof result)[number]>[])
})
})
}
Expand Down