My exact MySQL version is 5.7.29-0ubuntu0.18.04.1. And I'm beginning to think that I'm getting crazy...  Just try these queries:  CREATE TABLE `float_bug` (   `v` FLOAT NOT NULL ) ENGINE=INNODB DEFAULT CHARSET=utf8;   INSERT INTO float_bug VALUES(92160596);   SELECT * FROM float_bug;   Returns 92160600.  Then I tried these:  SELECT * FROM float_bug WHERE v = 92160596; SELECT * FROM float_bug WHERE v BETWEEN 92160596 AND 92160600;   Both return nothing!  However this  SELECT * FROM float_bug WHERE v = 92160592;   Returns 92160600.  I'm ready to throw my computer into the wall, but unfortunately that won't help because I have exactly the same behaviour on my remote server and I can't throw it into the wall physically.  Any ideas what is going on here?
I am developing a PHP application in which I am in need to store values bigger than 1 million, but with the flexibility of having floating points. I know the traditional float and double. I am looking to store only up to two decimal points, and will only handle operations with numbers that have 2 decimals exclusively.  I have chosen my column type of double and unsigned, but whenever I store a row with a value bigger than one million, it gets truncated to 999999.99  Why is this? I am looking for the right datatype/solution. If you could point me in the right direction, I will appreciate it a lot!  Thank you for your time in advance!  Cheers.
$\phi \times \theta$ is faithful iff $(|Z(H)| ,|Z(K)|)=1$ for faithful characters $\phi \in Irr(H)$ and $\theta \in Irr(K)$ . Show that $z^5-1=(z-1)(z^2+2z\cos{\pi \over 5}+1)(z^2-2z\cos{2\pi \over 5}+1)$ How can I prevent URLDownloadToFile from retrieving from the cache? I am using URLDownloadToFile to retrieve a file from a website. Subsequent calls return the original file rather than an updated version.  I assume it is retrieving a cached version. Watched screen recording but it's not saved to the desktop I recently recorded a session with my dad. I stopped the recording after the session ended (with the setting set to save to Desktop), clicked the icon that appeared on the lower right corner to open the file, and played back a few minutes to make sure it worked. I then clicked Share to send it via AirDrop to my computer, which did not work; the status remained &quot;cancelled&quot; despite my efforts. I assumed I'd be able to access it through my phone by sending it through a third app, so I pressed cancel on the AirDrop pop-up window. The entire screen recording closed and (apparently) vanished forever after the action. I'm extremely frustrated because I can't seem to locate this video. Why does instanceof return false for some literals? &quot;foo&quot; instanceof String //=&gt; false &quot;foo&quot; instanceof Object //=&gt; false  true instanceof Boolean //=&gt; false true instanceof Object //=&gt; false false instanceof Boolean //=&gt; false false instanceof Object //=&gt; false  12.21 instanceof Number //=&gt; false /foo/ instanceof RegExp //=&gt; true  // the tests against Object really don't make sense  Array literals and Object literals match... [0,1] instanceof Array //=&gt; true {0:1} instanceof Object //=&gt; true  Why don't all of them? Or, why don't they all not? And, what are they an instance of, then? It's the same in FF3, IE7, Opera, and Chrome. So, at least it's consistent. Unable to start Oracle database We have an Oracle database, one data file (users tablespace) of the instance got corrupt and another data file (containing application data) was deleted due to some issue.  The database is in ARCHIVELOG mode, but we neither have data file backup of both data files nor the pertaining archive logs. Hence, I guess we cannot go ahead with the recovery of data files. I am unable to open the database as the data files are not available and face.   ORA-01589: must use RESETLOGS or NORESETLOGS option for database open    I am just able to STARTUP MOUNT the database  I wanted to ask if we can somehow we can open the database by taking both the tablespaces offline after STARTUP MOUNT the database instance. Or if there is any other way I can start the database.   There was a power issue and the  server got abruptly shutdown. When we tried to restart the database and found that we were facing ORA-01589: must use RESETLOGS or NORESETLOGS option for database open. On further analysis we found that 2 of datafiles were creating problem as one got corrupt other deleted as mentioned. As of now if I try to restart the database it says one datafile which belongs to users tablespace need recovery. I wanted to confirm as if we can start the instance by bringing the tablespace offline.  I tried:  SQL&gt; select open_mode from v$database;  OPEN_MODE ---------- MOUNTED  SQL&gt; alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/flowsystems/oradata02/flsta02/system01.dbf'   I don't have any archive logs. Find all polynomials $P$ such that $P(x^2+1)=P(x)^2+1$ Find all polynomials $P$ such that   $$P(x^2+1)=P(x)^2+1$$ Matching exact string with JavaScript How can I test if a RegEx matches a string exactly?  var r = /a/; r.test("a"); // returns true r.test("ba"); // returns true testExact(r, "ba"); // should return false testExact(r, "a"); // should return true Comparing two strings in Bash I have the following if block in my bash script:  if [ ${PACKAGENAME} -eq kakadu-v6_4-00902C ]; then   echo "successfully entered if block!!" fi   The script execution is not entering my if block even though $PACKAGENAME is equal to kakadu-v6_4-00902C. What am I doing wrong? What is the difference between cascade & inverse in hibernate, what are they used for? One server with multiple desktops "heads" with VNC I am managing a system of kiosks.  Each kiosk currently is running a web browser with the application for the kiosk running in the browser.  Each kiosk needs to be able to display separate content.  At times, the application running in the web browser freezes.  Thus, I have to go out to the site to refresh the page.  I want to see if there is a way to have one central server that has multiple browser heads.  Then each kiosk would run a program like VNC to display one of the heads.  This way when the program freezes, I just have to login to the central server and refresh the page.  Getting VNC or another remote desktop software installed on the clients is no problem.  What I am looking for is a way to have VNC remote into a specific head of a head of a web browser.  Does such a thing exist?  Or do I have to run a VM for each kiosk to remote into?  Any advice, pointers, or solutions would be helpful. I would like to redirect a URL with uppercase characters http://localhost/A/B to a lowercase version http://localhost/a/b using the .htaccess file. Using regex I can capture A and B but is it possible to convert them to lowercase? $g\in G$ maximal order in $G$ abelian then $G=\left\oplus H$ If $g\in G$ is an element of maximal order in a finite abelian group $G$ then exists $H\leq G$ such that $G=\left&lt;g\right&gt;\oplus H$  Attempt: Using fundamental theorem I know that $G=C_{n_1}\times\cdots\times C_{n_k}$ where $n_i|n_{i+1}$. With some work I proved $|\left&lt;g\right&gt;|=n_k$, so $C_{n_k}\cong \left&lt;g\right&gt;$. Then $G\cong H\times \left&lt;g\right&gt;$, but this is not an equality. Recommendations for Numerical Analysis texts? Will i be granted ESTA after getting rejected thrice on different nationality? I had applied for B1/B2 on my previous nationality but it got rejected Thrice.  I had planned on visiting my mother as she lives there. my last refusal was 3 years back. Now i have gained an European nationality and I am thinking of applying for ESTA so I can visit my mother. I have doubts if it will be accepted because I'll have to disclose about my previous refusals.  What should I do? because if I don't disclose my previous refusals I fear I might be rejected permanently. How do I update my TeX distribution? I'm trying to compile a document that only works with an up-to-date distribution, so I'd like to know: how do I update my distribution? Please provide screenshots where appropriate.  List of answers           To keep an eye on what’s going on at CTAN you may subscribe to the  or the RSS feed feed://www.mail-archive.com/ctan-ann@dante.de/maillist.xml Web service - current time zone for a city? Is there a web service of some sort (or any other way) to pull a current time zone settings for a (US) city. For the parts of the country that don't follow the Daylight Saving Time and basically jump timezones when everyone else is switching summer/winter time... I don't fancy creating own database of the places that don't follow DST. Is there a way to pull this data on demand?   I need this for the database server (not for client workstations) - there entities stored in the database that have City, State as properties. I need know current timezone for these entities at any moment of time. How to zip a whole folder using PHP Is $\frac{\textrm{d}y}{\textrm{d}x}$ not a ratio? In the book Thomas's Calculus (11th edition) it is mentioned (Section 3.8 pg 225) that the derivative $dy/dx$ is not a ratio. Couldn't it be interpreted as a ratio, because according to the formula $dy = f'(x)dx$ we are able to plug in values for $dx$ and calculate a $dy$ (differential). Then if we rearrange we get $dy/dx$ which could be seen as a ratio.   I wonder if the author says this because $dx$ is an independent variable, and $dy$ is a dependent variable, for $dy/dx$ to be a ratio both variables need to be independent.. maybe? Get latest Flash player on Ubuntu I know, it's been asked before but I couldn't really get a satisfying answer for some details/backgrounds and I guess it's an important question for many.    Some application seem only to be running with Adobe Flash 15 (or at least I know it does, because I have that version on my Windows Partition).  The official Adobe website says:     NOTE: Adobe Flash Player 11.2 will be the last version to target Linux as a supported platform. Adobe will continue to provide security backports to Flash Player 11.2 for Linux.   Some search on the web like "Ubuntu Adobe Flash 15" or similar does not return any good websites.  I found something that says   (using a "pepper-based version"), and  .   Is it impossible to use this for Firefox too? Would it be a privacy risk?  Are there no alternative projects (I know it's closed source but there are so many so very bright people out there using something similar to wine but just for the plugin....)?  How about the Mac-Version? Shouldn't someone be able to port that one to Linux?