Comments (6)
FYI I've not changed the table that has been re-ordered, but I have done recent backups etc, so wonder if those transactions affect the ordering. I can investigate further soon, but wondered what your thoughts were on the order.
from sqlhydra.
I have created a Contributing Wiki Page and added this issue.
from sqlhydra.
Hi John!
MargaretKrutikova has an open PR where she is sorting the columns by "ORDINAL_POSITION" for Postgres.
It looks like SQL Server has this same field, so we should definitely do the same there.
from sqlhydra.
I've started setting up the containers so I can run the tests. Due to no experience with devcontainers it took me a while to get it running and the install.sh run. I got there eventually, however when I cd into "src/Tests" and run "dotnet run" I get the following:
vscode ➜ /workspace/src/tests (main ✗) $ dotnet run
/usr/share/dotnet/sdk/5.0.402/Microsoft.Common.CurrentVersion.targets(4679,5): error MSB3021: Unable to copy file "/home/vscode/.nuget/packages/microsoft.build.framework/16.11.0/lib/netstandard2.0/Microsoft.Build.Framework.dll" to "bin/Debug/net5.0/Microsoft.Build.Framework.dll". Access to the path is denied. [/workspace/src/SqlHydra.Sqlite/SqlHydra.Sqlite.fsproj]
Is this how you run the tests, or am I doing something wrong?
from sqlhydra.
I have had the exact same issue. It happens when I have previously built the sln locally before opening in the devcontainer.
The solution I have a found is to delete all the obj
and bin
folders on my local pc. Once those are cleared, you should be able to call dotnet run
from the src/Tests
.
I should probably add a troubleshooting section for this.
from sqlhydra.
Thanks Jordan
from sqlhydra.
Related Issues (20)
- sqlhydra-npgsql generation tool doesn't pick up "array" columns HOT 10
- SqlServer: Cannot use `getId` against a `UNIQUEIDENTIFIER` column HOT 6
- Question about multiple inserts, possibility to not enforce the "match"? HOT 5
- Add Support for tuple in where clauses HOT 3
- `SqlHydra.ProviderDbType` Attribute requires SqlHydra.Query HOT 1
- User Defined Functions/ Table Valued Functions HOT 12
- Add support for dotnet 7 HOT 2
- Allow to generate the list of tables? HOT 29
- `deleteAll` failing with SqlHydra.Query 1.1.0 HOT 7
- Npgsql.PostgresException syntax error at or near "[" HOT 8
- How to use a correlated subquery? HOT 8
- Autogenerated code infers wrong type HOT 3
- Should CLI tools be consolidated into one? HOT 4
- SQLHydra's maxBy causes SqlHydra code to fail if querying an empty table HOT 5
- Using a where clause with leftJoin HOT 7
- Unable to use strings with isNotIn |<>| operation? HOT 11
- dotnet sqlhydra sqlite fails HOT 3
- Reading Option<byte[]> is broken HOT 4
- DateOnly/ TimeOnly Support HOT 12
- Conditional where's, orderBy's, and thenBy's HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlhydra.