http://bugs.winehq.org/show_bug.cgi?id=12071
Summary: MSI SQL joins on tables with many rows are extremely
slow
Product: Wine
Version: 0.9.57.
Platform: PC
OS/Version: Linux
Status: NEW
Severity: enhancement
Priority: P2
Component: msi
AssignedTo: truiken(a)gmail.com
ReportedBy: truiken(a)gmail.com
CC: ead1234(a)hotmail.com
With the current implementation of MSI SQL joins, we perform a Cartesian
product on the tables joined together. In the case where there is no WHERE
clause, this is the correct output, but if there is a WHERE clause, we still
perform the Cartesian product and then filter on the WHERE clause. Though it's
uncommon, there are a few installers (Visual Studio, Nero Express 7) that join
tables with thousands of rows. For example, say we have tables A, B, and C
s.t.
colA colB colC
----- ----- -----
1 1 1
2 2 2
... ... ...
1000 1000 1000
and we have the query
SELECT * FROM A, B, C WHERE `colA`=1 AND `colB`=1 AND `colC`=1
then the current implementation will create a new table with those columns
containing 1000*1000*1000=1 billion rows. Then we check each of the 1 billion
rows for any matches. There are several algorithms for optimizing joins:
http://en.wikipedia.org/wiki/Join_(SQL)#Join_algorithms
The solution I'll be working on is the merge join. This solution parses the
WHERE clause, starting with the two tables that the columns of the clause
belong to (colA -> A, colB -> B, etc) and joins those together, making sure to
eliminate rows based on the WHERE clause. Then the next table in the clause is
merged into the previously created table, eliminating rows. This continues
until there are no tables left. One optimization of this solution is to start
with parts of the WHERE clause that compare against literals. For example, the
query:
SELECT * FROM A, B, C WHERE `colA` = `colB` AND `colB` = 1 AND `colC` = 1
We'd start with "`colB` = 1" since the comparison is against a literal. We
perform 1000 comparisons on the rows of table B (count = 1000). The resulting
table is:
colB
----
1
then we do the same for table C (count = 1000), and the merged table is:
colB colC
---- ----
1 1
next we merge this table with table A:
colA colB colC
---- ---- ----
1 1 1
2 1 1
... ... ...
1000 1 1
and we search through this table for the condition `colA` = `colB` (count =
1000). So we've reduced billions of comparisons to 3000.
Unfortunately, the way our SQL engine is implemented, this will not be an easy
task.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=10314
Summary: Switched On Schoolhouse 2000 fails to start up
Product: Wine
Version: CVS/GIT
Platform: Other
URL: http://www.familychristianacademy.com/SOStest.html
OS/Version: other
Status: NEW
Keywords: download
Severity: enhancement
Priority: P2
Component: wine-misc
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: dank(a)kegel.com
While looking at bug 10313, I went looking for a
freely downloadable version of Switched-on Schoolhouse.
The only thing I found so far was a free downloadable placement test
for a school which seems to have been
made with Switched On Schoolhouse 2000.
When you run it, it locks up your X session, and you have
to do alt-control-backspace to shut down the X server
to regain control.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=12527
Summary: radio button groups don't work with up/down arrow keys
Product: Wine
Version: CVS/GIT
Platform: PC
URL: http://winmerge.org/
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P2
Component: user32
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: msclrhd(a)gmail.com
1. Open an application that has a radio button group, e.g.:
* WinMerge (http://winmerge.org/)
* Some installers
I will use WinMerge as the example for the rest of this bug report:
2. Press Ctrl+N to create a new document
3. Enter "A" in the "Untitled left pane"
4. Enter "B" in the "Untitled right pane"
5. Close the application
This will bring up a "Save modified files?" dialog. NOTE: Using tab to navigate
around the dialog sets the focus to the correct items in the correct sequence.
6. Press the left mouse button on one of the "Save changes" radio buttons
7. Press the down arrow key
This should select the "Discard changes" radio button. The button has the
focus, but is not selected. As a workaround, pressing the space key will select
the button.
8. Press the down arrow key
This should select the "Save changes" radio button, cycling the radio button
grouping. This does not work. If you are on the bottom group, it selects the
"Discard All" button. If you are on the top group, no item is selected and
pressing the down arrow key again selects the "Untitled right" edit box.
9. Press the left mouse button on one of the "Discard changes" radio buttons
10. Press the up arrow key
This should select the "Save changes" radio button. The button has the focus,
but is not selected. As a workaround, pressing the space key will select the
button.
11. Press the up arrow key
This should select the "Discard changes" radio button, cycling the radio button
grouping. This does not work. If you are on the bottom group, it selects the
"Untitled left" edit box. If you are on the top group, it selects the "Untitled
right" edit box.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=11095
Summary: some keyboard shortcuts do not work in the celestia
installer
Product: Wine
Version: 0.9.52.
Platform: PC
OS/Version: Linux
Status: NEW
Keywords: download
Severity: trivial
Priority: P2
Component: -unknown
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: thestig(a)google.com
I've seen this problem in some programs, but not others. Here's one problem
where it happens:
In the Celestia installer, on the initial page, it asks you to accept the GPL
license. By default, the radio button has "do not accept" selected.
On Windows, I can press "alt + a" to select the "accept" radio button. On Wine,
the "accept" button gets focus when I press "alt + a", but the radio button
doesn't get selected.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=12694
Summary: Air Rival Crashes after login
Product: Wine
Version: 0.9.59.
Platform: PC
URL: http://appdb.winehq.org/objectManager.php?sClass=version
&iId=11224&iTestingId=22275
OS/Version: Linux
Status: UNCONFIRMED
Severity: enhancement
Priority: P2
Component: -unknown
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: mifuyne(a)gmail.com
Created an attachment (id=12349)
--> (http://bugs.winehq.org/attachment.cgi?id=12349)
Log of Air Rival from Launch to Crash
The game crashes without going into the game itself. Been tested on different
versions of Windows (slightly different error on some version). The following
address leads to the log, from launcher to the crash point. It's also attached
to this report.
http://pastebin.org/30959
WINE was set to Emulate a virtual desktop at 1024 x 768 (thus avoiding the
resolution problem mentioned here:
http://appdb.winehq.org/objectManager.php?sClass=version&iId=11224&iTesting…
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=12457
Summary: SharpDevelop 2.2 crashes with NotImplementedException at
IWebBrowser2.get_LocationName()
Product: Wine
Version: CVS/GIT
Platform: Other
URL: http://www.icsharpcode.net/OpenSource/SD/Download/#Sharp
Develop22
OS/Version: other
Status: NEW
Keywords: download
Severity: normal
Priority: P2
Component: shdocvw
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: dank(a)kegel.com
http://lists.ximian.com/pipermail/mono-devel-list/2008-March/027227.html
was asking how to install SharpDevelop 2 under Wine, so I
gave it a try. "winetricks dotnet20" was enough to get it
to install and start, but after it put up the GUI, it
aborted with
fixme:shdocvw:WebBrowser_QueryInterface
(0x1af830)->({00000144-0000-0000-c000-000000000046} 0x33e800) interface not
supported
...
FATAL- System.NotImplementedException: The method or operation is not
implemented.
at System.Windows.Forms.UnsafeNativeMethods.IWebBrowser2.get_LocationName()
at System.Windows.Forms.WebBrowser.get_DocumentTitle()
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=12076
Summary: Database app refused to install unless
system32/drivers/etc/{services,host} exist
Product: Wine
Version: CVS/GIT
Platform: Other
OS/Version: other
Status: NEW
Keywords: Installer
Severity: normal
Priority: P2
Component: -unknown
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: dank(a)kegel.com
A user's informix-based app refused to install until
the empty files c:/windows/system32/drivers/etc/{services,host}
were created, see
http://winehq.org/pipermail/wine-users/2008-March/030256.html
I looked around a bit for other system32/drivers/etc files.
http://support.microsoft.com/kb/130024 describes hosts, services, and protocols
http://support.microsoft.com/kb/105997 describes lmhosts
It looks like some apps find that directory by looking at
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\DataBasePath
and MSN Messenger 7.5 f*cks up by changing that variable's type, see
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6343068
Getting this all right would be a lot of work. Just creating
two empty files might be reasonable, though, since it
allows the user's app to install.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=10955
Summary: Palm Desktop fixme's and errors in install and execute
Product: Wine
Version: 0.9.49.
Platform: PC-x86-64
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P2
Component: wine-misc
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: gc11772(a)optonline.net
Created an attachment (id=9891)
--> (http://bugs.winehq.org/attachment.cgi?id=9891)
Installing palm desktop
Installing Palm Desktop, get many fixme's and a few errors.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=12060
Summary: Three bugs in MilkDrop Visualization in WinAMP 5.5.2
Product: Wine
Version: CVS/GIT
Platform: PC
URL: http://download.nullsoft.com/winamp/client/winamp552_ful
l_en-us.exe
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P2
Component: directx-d3d
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: t.artem(a)mailcity.com
Created an attachment (id=11432)
--> (http://bugs.winehq.org/attachment.cgi?id=11432)
The way it looks like (red lines are painted intentionally)
1) Direct3D window is not placed withing its parent window
2) Some visualizations cause Direct3D window to be split weirdly (vertically by
two regions, then left region is split into two, and so on).
3) F1 button which has to show a help window within Direct3D window shows
garbage
Screenshot is attached.
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=11146
Summary: RootsMagic 3.2.5 crashes when using Publisher feature
Product: Wine
Version: 0.9.53.
Platform: PC
URL: http://appdb.winehq.org/objectManager.php?sClass=version
&iId=10416
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: -unknown
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: digimars(a)gmail.com
Created an attachment (id=10181)
--> (http://bugs.winehq.org/attachment.cgi?id=10181)
Wine output error message
When I click on the Publish icon on the RootsMagic toolbar at the top and
create a new book (by going clicking on the New button and giving it a name of
'test' for instance) I can select options without a problem (such as Cover
Page, Title Page, etc.). But when I click on the Add a Chapter button and
choose anyone in my list of people listed, the program completely crashes. It
doesn't matter if I choose Pedigree Chart, Scrapbook, Photo Tree or any of
them. They all go to a list of people that you can select from and all of the
entries will crash the application after you click on one of them.
A trial version of the app can be downloaded from here:
http://www.rootsmagic.com/demo.htm
--
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.