StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmysql decimal query issue
primarykey
Id
3423497
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-08-06T11:55:35.500
FavoriteCount
0
LastActivityDate
2010-08-06T12:09:23.863
LastEditDate
2010-08-06T12:03:37.013
LastEditorUserId
394649
OwnerUserId
412998
ParentId
0
PostTypeId
1
Score
0
ViewCount
860
LastEditorDisplayName
text
Body
First off I am running mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0 Sorry for the formatting but I don't have the ability to copy it so I have to type it in. the two fields in question are the following <pre><code>id int(11) startj1950 decimal(38,6) mysql> select id,startj1950 from store where id = 32513; +------------------+ | id | startj1950 | +----------|----------------------| |32513 | 1912181654.500000 | ----------------------------------- mysql> select id from store where startj1950=1912181654.500000; Empty set </code></pre> So I figured I was messing up somehow in the copy so I would let mysql get the value for me. <pre><code>mysql> select id from store where startj1950=(select startj1950 from store where id=32513); Empty set </code></pre> But it works for other results <pre><code>mysql> select id,startj1950 from store where id = 32513; +------------------+ | id | startj1950 | +----------|----------------------| |18675 | 1907365784.570000 | ----------------------------------- mysql> select id from store where startj1950=1907365784.570000; +----------+ | id | +----------| |18675 | ------------ mysql> select id from store where startj1950=(select startj1950 from store where id=18675); +----------+ | id | +----------| |18675 | ------------ </code></pre> I figure I either have hit a mysql bug or I am misunderstanding some sort of concept. Thanks in advance for the help.
Tags
<mysql>
Title
mysql decimal query issue
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USdeinst
UserOwnerUserId
1. USTenniguy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.