This is a project for our CS 3380 database class. All files and code will be kept here.
Group members: Chris Dopuch Ben Riemann Breona Butler Corey Jumper Adam Faszl
The insert query, for some reason, defaults to inserting the entry with expid = 1 and will increment by 1 each time the query is run. As a result, on a fresh \i database.sql the query will fail 4 times until it gets to expid = 4 as up until that point it is trying to insert an experiment with an expid which is already used (we have 3 experiments by default -- the query successively tries to insert the experiment with expid 1, then 2, then 3, and will succeed with expid = 4 the fourth time it runs), violating the primary key uniqueness constraint. Subsequent runs of the query work fine and increment as expected.
I'm not sure why this is happening -- my guess is that it has something to do with the sql script and not the query as the query looks fine and the problem is not affecting other tables under similar circumstances.
$query = "INSERT INTO database.experiments (name, payment, requirements) VALUES ($1, $2, $3)";
expid is not specified and should automatically take the next value in the series, but the table and its series appear to be out of sync.
I'm unable to reproduce it reliably at this point. It seems to happen more frequently around logins/outs.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.