mySQL query browser

Post Reply
ELCD_user
Posts: 16
Joined: 08 Mar 2013 13:59

mySQL query browser

Post by ELCD_user » 28 Apr 2015 10:08

Hello
I have generated a new database in openLCA 1.4.1 with the reference data inserted. I then opened the mySQL query browser and did a SELECT * FROM openlca_version; I would expect the query returns '1.4.1' but instead I get '3'. Any ideas why that is?
Regards
Ludwig
SQL_query_browser.png
SQL_query_browser.png (45.81 KiB) Viewed 3326 times

msrocka
Posts: 18
Joined: 29 Jan 2013 10:07

Re: mySQL query browser

Post by msrocka » 18 Jun 2015 22:16

Yes, this is confusing. It is the version of the database schema that is stored in this field and not the openLCA version. This field is a plain integer and is used to trigger automatic updates. Everytime we change the database schema we increment this version number.

(Note that we use Derby for embedded databases and MySQL for remote databases and the SQL query browser works for both; thus, it is not a MySQL query browser :)

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest