(This issue was migrated from the old bug tracker of SQLiteStudio)
Original ID from old bug tracker: 193
Originally created at: Thu Jul 28 13:38:17 2011
Originally last updated at: Thu Jul 28 13:38:17 2011
DESCRIPTION:
Stack trace:
Cannot parse objects DDL.
SQLite version is 3.7.4.
The DDL is:
CREATE VIEW [p\_newBudget] AS SELECT tab1 . username , round ( max ( CASE WHEN tab1 . last\_profit IS NULL THEN tab1 . profit ELSE ( ( tab1 . profit + tab1 . last\_profit ) / 2 ) END / 1000000.0 , 0 ) + max ( r . budget - tab1 . I , 0 ) , 1 ) AS newBudget\_Meuro
FROM room r ,
( SELECT p . \* , lp . last\_profit
FROM (
( SELECT tp . game\_code , tp . room\_name , tp . username , tp . profit ,
CASE WHEN ti . I IS NULL THEN 0 ELSE ti . I END AS I
FROM (
SELECT username , period\_gc AS game\_code , room\_name , CASE WHEN sum ( profit ) IS NULL THEN 0 ELSE sum ( profit ) END AS profit
FROM
( SELECT pr . player\_username AS username ,
pr . room\_game\_code AS period\_gc ,
pr . room\_name ,
CASE WHEN tp . profit IS NULL THEN 0 ELSE tp . profit END AS profit
FROM ( SELECT \*
FROM player\_room pr
WHERE pr . player\_game\_code = ( SELECT value FROM view\_parameters WHERE name = 'game\_code' )
AND pr . room\_name = ( SELECT value FROM view\_parameters WHERE name = 'room\_name' )
) pr LEFT OUTER JOIN p\_pool\_tech\_player tp
ON pr . player\_username = tp . username
AND pr . player\_game\_code = tp . period\_gc
AND pr . room\_name = tp . room\_name
)
GROUP BY username
) tp LEFT OUTER JOIN p\_total\_investments\_all ti ON tp . username = ti . username ) AS tab1
) p LEFT OUTER JOIN ( SELECT game\_code , room\_name , username , sum ( profit ) AS last\_profit
FROM aux\_last\_profit lp
WHERE lp . game\_code = ( SELECT value FROM view\_parameters WHERE name = 'game\_code' )
AND lp . room\_name = ( SELECT value FROM view\_parameters WHERE name = 'room\_name' )
AND lp . period = ( SELECT value - 1 FROM view\_parameters WHERE name = 'period' )
GROUP BY lp . username
) lp
ON p . username = lp . username
AND p . game\_code = lp . game\_code
AND p . room\_name = lp . room\_name
) tab1
WHERE r . game\_code = tab1 . game\_code
AND r . name = tab1 . room\_name
Error stack:
while executing
"error $err"
(object "::.mainWin.d.l.sb" method "::DBTree::editView" body line 12)
invoked from within
"editView"
("VIEW" arm line 2)
invoked from within
"switch -- [lindex $data 0] {
"DATABASE" {
if {[$db isOpen]} {
if {[$\_tree item isopen $it]} {
$\_tree item collapse $it
} else {
..."
(object "::.mainWin.d.l.sb" method "::DBTree::openClickedItem" body line 9)
invoked from within
"openClickedItem $x $y"
(object "::.mainWin.d.l.sb" method "::DBTree::doubleClicked" body line 4)
invoked from within
"::.mainWin.d.l.sb doubleClicked 111 375"
(command bound to event)
OPERATING SYSTEM:
Windows NT (6.1), intel
APPLICATION VERSION:
2.0.12
TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
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
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12