chain33 | Highly modular , blockchain development framework | Blockchain library
kandi X-RAY | chain33 Summary
kandi X-RAY | chain33 Summary
Highly modular, blockchain development framework following the KISS principle
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of chain33
chain33 Key Features
chain33 Examples and Code Snippets
Community Discussions
Trending Discussions on chain33
QUESTION
So I've changed my codes database from h2 to postgresql and I've noticed that the Inner Join call that is used in h2 is not giving the same results when I call it in postgresql. I've done research and after testing, I found out that the left join and other joins work perfectly it's only inner join giving me a different result. So, to get both output csv files to match, would I have to change the whole structure of the table or is there something similiar in postgresql that i'm overlooking?
...ANSWER
Answered 2017-Oct-13 at 02:22Assuming that you run the same ANSI-compliant query, with the same underlying data, in both H2 and Postgres, you should get the same result. There is nothing whatosever different about the behavior of INNER JOIN
in either database.
But a quick search for ORDER BY
in your code dump revealed that you are not doing any ordering in your queries. I noticed that Postgres coincidentally appears to be sorting on the data1
column, while H2 does not appear to be sorting at all. I suggest that the result sets are identical from the point of view of unsorted sets.
In general, if you expect a cetain ordering in your result set, you need to use ORDER BY
in the query which generates that data. So if you add ORDER BY data1
to both queries, I expect the results will appear the same for both H2 and Postgres.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install chain33
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page