cockroachdb / cockroachdb/examples-orms
Create table statement incorrect on front page
- Dominant language
- Go
- Stars
- 82
- Forks
- 37
- PR merge metrics
- No merged PRs in 30d
Description
There needs to a common after the DECIMAL declaration.
root@:26257/company_java_hibernate> CREATE TABLE IF NOT EXISTS orders (
-> id SERIAL PRIMARY KEY,
-> subtotal DECIMAL(18,2)
-> customer_id INT REFERENCES customers(id),
-> );
invalid syntax: statement ignored: syntax error at or near "customer_id"
Contributor guide
No contributing guide indexed for this repository
Research direction
Start on the repository's front page and locate the displayed CREATE TABLE statement for the orders table. Compare it with the SQL shown in this issue and correct the missing comma after DECIMAL(18,2). Done means the example is valid SQL and no longer reports a syntax error near customer_id.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100