diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-16 20:31:48 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-16 20:31:48 +0300 |
| commit | ae57debaba17f6069262dfd1e41fe4c9a54b957b (patch) | |
| tree | dbfa657f25eb38a380d67e5711499e075476830f /mysql-test/t/select.test | |
| parent | 7eb0ae193bb59e98e9a0b24b037e2cc13c2c80f7 (diff) | |
| download | mariadb-git-ae57debaba17f6069262dfd1e41fe4c9a54b957b.tar.gz | |
A fix for bigints with quoted constants ..
Same princpile can be applied to other expressions
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 159746e4dde..e553ee38499 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -1730,3 +1730,11 @@ CREATE TABLE t2 ( hmid int(10) unsigned default NULL, volid int(10) unsigned d INSERT INTO t2 VALUES (1,3,10,'2002-06-01 08:00:00',35),(1,3,1010,'2002-06-01 12:00:01',35); SELECT a.gvid, (SUM(CASE b.sampletid WHEN 140 THEN b.samplevalue ELSE 0 END)) as the_success,(SUM(CASE b.sampletid WHEN 141 THEN b.samplevalue ELSE 0 END)) as the_fail,(SUM(CASE b.sampletid WHEN 142 THEN b.samplevalue ELSE 0 END)) as the_size,(SUM(CASE b.sampletid WHEN 143 THEN b.samplevalue ELSE 0 END)) as the_time FROM t1 a, t2 b WHERE a.hmid = b.hmid AND a.volid = b.volid AND b.sampletime >= 'NULL' AND b.sampletime < 'NULL' AND b.sampletid IN (140, 141, 142, 143) GROUP BY a.gvid; DROP TABLE t1,t2; +create table t1 ( A_Id bigint(20) NOT NULL default '0', A_UpdateBy char(10) NOT NULL default '', A_UpdateDate bigint(20) NOT NULL default '0', A_UpdateSerial int(11) NOT NULL default '0', other_types bigint(20) NOT NULL default '0', wss_type bigint(20) NOT NULL default '0'); +INSERT INTO t1 VALUES (102935998719055004,'brade',1029359987,2,102935229116544068,102935229216544093); +select wss_type from t1 where wss_type ='102935229216544106'; +select wss_type from t1 where wss_type ='102935229216544105'; +select wss_type from t1 where wss_type ='102935229216544104'; +select wss_type from t1 where wss_type ='102935229216544093'; +select wss_type from t1 where wss_type =102935229216544093; +drop table t1; |