(This issue was migrated from the old bug tracker of SQLiteStudio)
Original ID from old bug tracker: 1774
Originally created at: Mon Jan 28 21:48:48 2013
Originally last updated at: Mon Jan 28 21:48:48 2013
HOW TO REPRODUCE:
Example from exported DB:
-- View: hrmBPM
CREATE VIEW hrmBPM AS
SELECT \*
FROM hrm a
WHERE EXISTS (
SELECT DISTINCT lap\_time
FROM hrm
);
;
-- View: hrm
CREATE VIEW hrm AS
SELECT heartbeat.workout\ID AS workout\\_ID,
heartbeat.sensor\_hr\_number,
heartbeat.heartbeat\_ID,
heartbeat.lap\_time
FROM heartbeat
;
DESCRIPTION:
In the exported database is no clear hierarchy of View /
For example, there are several View, some of which uses some View the request. In case of export View parent may be behind the child, resulting in an error when creating a database from a script.
(This issue was migrated from the old bug tracker of SQLiteStudio)
Original ID from old bug tracker: 1774 Originally created at: Mon Jan 28 21:48:48 2013 Originally last updated at: Mon Jan 28 21:48:48 2013
HOW TO REPRODUCE: Example from exported DB:
-- View: hrmBPM CREATE VIEW hrmBPM AS SELECT \* FROM hrm a WHERE EXISTS ( SELECT DISTINCT lap\_time FROM hrm ); ;
-- View: hrm CREATE VIEW hrm AS SELECT heartbeat.workout\ID AS workout\\_ID, heartbeat.sensor\_hr\_number, heartbeat.heartbeat\_ID, heartbeat.lap\_time FROM heartbeat ;
DESCRIPTION: In the exported database is no clear hierarchy of View / For example, there are several View, some of which uses some View the request. In case of export View parent may be behind the child, resulting in an error when creating a database from a script.
OPERATING SYSTEM: Windows NT (6.1), intel
APPLICATION VERSION: 2.1.0
TCL PACKAGES: autoscroll.................... 1.1 crc16......................... 1.1.1 crc32......................... 1.3.1 csv........................... 0.7.2 fsdialog...................... 1.14 http.......................... 2.7.9 Itcl.......................... 3.4 Itk........................... 3.4 md4........................... 1.0.5 md5........................... 1.4.4 msgcat........................ 1.4.4 pdf4tcl....................... 0.8 sha1.......................... 2.0.3 sha256........................ 1.0.2 sqlite........................ 2.0 sqlite3....................... 3.7.13 Tcl........................... 8.5.11 tdbf.......................... 0.5 Thread........................ 2.6.7 Tk............................ 8.5.11 tkdnd......................... 2.6 tkpng......................... 0.7 treectrl...................... 2.3.2 ttk::theme::alt............... 8.5 ttk::theme::clam.............. 8.5 ttk::theme::classic........... 8.5 ttk::theme::default........... 8.5 ttk::theme::keramik........... 0.6.1 ttk::theme::keramik\_alt....... 0.6.1 ttk::theme::plastik........... 0.6.1 ttk::theme::vista............. 1.0 ttk::theme::winnative......... 8.5 ttk::theme::xpnative.......... 8.5 uuencode...................... 1.1.5 yencode....................... 1.1.3