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=15270
Summary: Newest MapSource version (6.14.1) doesn't run anymore
with wine 1.1.4
Product: Wine
Version: 1.1.4
Platform: PC
OS/Version: Linux
Status: UNCONFIRMED
Severity: blocker
Priority: P2
Component: -unknown
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: sbuehne(a)web.de
Created an attachment (id=16066)
--> (http://bugs.winehq.org/attachment.cgi?id=16066)
wine error during startup of mapsource
I could run successfully mapsource version 6.11 inlcuding all functions with
wine version 1.1.4 on openSuse 11.0
After applying an upgrade to the software mapsource, wine crashes during
program start with the error message:
...
wine: Unhandled page fault on write access to 0x003c1000 at address 0x9863ab
(thread 0009), starting debugger...
Unhandled exception: page fault on write access to 0x003c1000 in 32-bit code
(0x009863ab).
Register dump:
CS:0073 SS:007b DS:007b ES:007b FS:0033 GS:003b
EIP:009863ab ESP:0033e0b8 EBP:0033e0c0 EFLAGS:00010202( - 00 - -RI1)
EAX:003c0000 EBX:011d0d70 ECX:01ffffce EDX:00000000
ESI:011d1d70 EDI:003c1000
..
I have created a trace file for this error with the command:
echo quit | WINEDEBUG=+relay wine MapSource.exe >& filename.out;
and tailed the last 1000 lines to the attached log file, inlcuding the error
message.
--
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=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=15315
Summary: Ace Online (aka Space Cowboy/Flysis/Air Rivals) does not
load past launcher with WINE
Product: Wine
Version: 1.0-rc3
Platform: PC
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P2
Component: -unknown
AssignedTo: wine-bugs(a)winehq.org
ReportedBy: littlegator(a)gmail.com
I'm somewhat new to Linux, so if anyone offers any fixes, I may not be sure how
to do it. Please inform me of the exact procedure of the fix (or anything that
may advance the situation) and I will gladly do what you ask.
Now, on to the problem. I load up Ace Online with WINE 1.0-rc3 and it brings me
to the launcher. I type in my login details, select my resolution (which is
1024 x 768), uncheck the "windowed" check box (which appears to have no effect
on the output), and wait. The game goes full screen and is white for a few
seconds. It switches to black, then, after about 10 or 15 seconds, a white
square appears in the middle of the screen. It disappear within a few frames of
appearing, and I'm stuck here. Same thing happens when windowed, it just isn't
full screen. During this process, it seems to be outputting every single
mission log in the game to the debug window. The output file is extremely long.
Now, my setup:
I'm running WINE 1.0-rc3 with DirectX9.0 installed using WineTricks. I'm
running a 1024x768 virtual desktop with no window decorations and window
manager can not control the windows.
My PC:
Intel Pentium 4 1.6GHz
512MB RAM (not sure on what type >_>)
ATI Radeon 9700 pro 128MB onboard RAM using latest Catalyst drivers
running 3.5.6-9.fc7 Fedora release: 2.6.21-1.3194.fc7
While I await a response, I'm going to attempt updating Fedora since it's
apparently an older version. I've attached the a couple output files and a
dxdiag if it may be useful.
--
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=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.