>Description:
using the field name sequence_number in two tables and doing a join on
sequence_number gives NULL as an output in the sequence_number field of one of the
tables.
>How-To-Repeat:
mysql> select users.sequence_number,jba_customers.sequence_number from
users,jba_customers
mysql> where jba_customers.sequence_number=users.sequence_number and
users.sequence_number="934";
+-----------------+-----------------+
| sequence_number | sequence_number |
+-----------------+-----------------+
| NULL | 934 |
| NULL | 934 |
+-----------------+-----------------+
2 rows in set (0.34 sec)
>Fix:
Change the field name to something other then sequence_number
mysql> alter table users change sequence_number seq_num char(4);
mysql> select users.seq_num,jba_customers.seq_num from users,jba_customers
mysql> where jba_customers.seq_num=users.seq_num and users.seq_num="934";
+---------+---------+
| seq_num | seq_num |
+---------+---------+
| 934 | 934 |
| 934 | 934 |
+---------+---------+
2 rows in set (0.49 sec)
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
Inactive Media Group
>MySQL support: none
>Synopsis: Using the field name 'sequence_number'
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.22.32 (Source distribution)
>Environment:
System: Linux gambit.eyemg.com 2.2.14-5.0.14smp #1 SMP Sun Mar 26 13:03:52 PST 2000
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --localstatedir=/usr2/var
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
