kazyakj / northwindextended Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/northwindextended
Automatically exported from code.google.com/p/northwindextended
The quote signs on field names are not necessary - in fact -they come in the
way!
the script as is - create field names like '"OrderID"' instead of 'OrderId'
What steps will reproduce the problem?
1. created db
2. ran the script as is
3. query: SELECT OrderID FROM orders;
Expected: recordset with 1 column
FOUND: error column OrderID does not exist.
For evidence, when querying SELECT "OrderID" FROM orders; - it works...
Tried on Posgtgres v9.3+154
Original issue reported on code.google.com by [email protected]
on 24 Jan 2015 at 11:53
Hi,
There are no insert statements for Categories, Employees etc., How to migrate date in these tables to Oracle/Postgress?
Original issue reported on code.google.com by [email protected]
on 16 Nov 2012 at 6:31
What steps will reproduce the problem?
1. The SQLite3 version doesn't have foreign keys
Please provide any additional information below.
I was looking for an identical database to use across multiple environments,
and your project was exactly what I was looking for.
The SQLite sql that is posted is missing foreign key relationships between the
tables. I've updated the SQLite version and attached the file below.
Original issue reported on code.google.com by [email protected]
on 9 Feb 2013 at 12:21
Attachments:
in order to work with commercial sqlite management tool, these lines should be
added in the beginning of the script:
-- disable foreign key support temporary
PRAGMA foreign_keys = OFF;
Original issue reported on code.google.com by [email protected]
on 7 Jan 2014 at 11:12
What steps will reproduce the problem?
1. in postgresql, any "normal" select command, such as
SELECT * FROM Customers WHERE City LIKE '%lin%';
will throw an error.
What is the expected output? What do you see instead?
expect matching db rows
displays error:
northwind=#ERROR: column "City" does not exist
LINE 1: select City from public.customers;
What version of the product are you using? On what operating system?
select version();
version
--------------------------------------------------------------------------------
------------------------------
PostgreSQL 9.3.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Please provide any additional information below.
You could change the query to include quotes around the col names, but I saw
that as a pain in the long run, and it's not normal for postgresql syntax
(imho). I used vi to edit out the double quotes in two steps from the .sql
file. The .sql file is in three general sections, table creation, data insert,
and constraint creation. I did a global change from line 1 to line 280, the
create table section, changing the " character to null. There are " characters
in the data in insert, so down below I repeated the change for the constraints
that get added after the inserts starting at line 3736.
I've attached the edited version to this issue.
Original issue reported on code.google.com by [email protected]
on 15 Apr 2014 at 9:06
Attachments:
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.