hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1476348 [19/29] - in /hive/branches/vectorization: ./ beeline/ beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/ beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/ beeline/src/test/org/apache/hive/beeline/ beeline...
Date Fri, 26 Apr 2013 19:16:13 GMT
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/create_insert_outputformat.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/create_insert_outputformat.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/create_insert_outputformat.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/create_insert_outputformat.q.out Fri Apr 26 19:14:49 2013
@@ -25,8 +25,6 @@ POSTHOOK: query: describe table_test_out
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table_test_output_format.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: table_test_output_format.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 value               	string              	None                
 PREHOOK: query: CREATE TABLE table_test_output_format_sequencefile(key INT, value STRING) STORED AS
@@ -62,8 +60,6 @@ POSTHOOK: Lineage: table_test_output_for
 POSTHOOK: Lineage: table_test_output_format.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: table_test_output_format_sequencefile.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: table_test_output_format_sequencefile.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 value               	string              	None                
 PREHOOK: query: CREATE TABLE table_test_output_format_hivesequencefile(key INT, value STRING) STORED AS
@@ -105,7 +101,5 @@ POSTHOOK: Lineage: table_test_output_for
 POSTHOOK: Lineage: table_test_output_format_hivesequencefile.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: table_test_output_format_sequencefile.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: table_test_output_format_sequencefile.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 value               	string              	None                

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/create_like_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/create_like_view.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/create_like_view.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/create_like_view.q.out Fri Apr 26 19:14:49 2013
@@ -23,8 +23,6 @@ PREHOOK: query: DESCRIBE table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	string              	None                
 PREHOOK: query: DESCRIBE FORMATTED table1
@@ -70,8 +68,6 @@ PREHOOK: query: DESCRIBE table2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table2
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	string              	None                
 PREHOOK: query: DESCRIBE FORMATTED table2
@@ -120,8 +116,6 @@ PREHOOK: query: DESCRIBE table3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	string              	None                
 PREHOOK: query: DESCRIBE FORMATTED table3

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/create_nested_type.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/create_nested_type.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/create_nested_type.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/create_nested_type.q.out Fri Apr 26 19:14:49 2013
@@ -17,8 +17,6 @@ PREHOOK: query: DESCRIBE table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	array<string>       	None                
 c                   	array<map<string,string>>	None                
@@ -27,8 +25,6 @@ PREHOOK: query: DESCRIBE EXTENDED table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	array<string>       	None                
 c                   	array<map<string,string>>	None                

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/create_view.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/create_view.q.out Fri Apr 26 19:14:49 2013
@@ -219,15 +219,11 @@ PREHOOK: query: DESCRIBE view1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 PREHOOK: query: DESCRIBE EXTENDED view1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -264,16 +260,12 @@ PREHOOK: query: DESCRIBE view2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view2
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 PREHOOK: query: DESCRIBE EXTENDED view2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view2
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -312,15 +304,11 @@ PREHOOK: query: DESCRIBE view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	None                
 PREHOOK: query: DESCRIBE EXTENDED view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -366,8 +354,6 @@ PREHOOK: query: DESCRIBE EXTENDED view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -415,8 +401,6 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
 -- of comparison for view descriptions
 DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -424,8 +408,6 @@ PREHOOK: query: DESCRIBE EXTENDED src1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED src1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -438,8 +420,6 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
 -- view descriptions
 DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -485,8 +465,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
 PREHOOK: type: ALTERTABLE_ADDCOLS
@@ -524,8 +502,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 value               	string              	None                
 PREHOOK: query: DESCRIBE view4
@@ -533,8 +509,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
 FROM view4 v1 join view4 v2
@@ -565,8 +539,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view5
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 key2                	int                 	None                
 PREHOOK: query: -- verify that column name and comment in DDL portion
@@ -586,8 +558,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view6
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	I cannot spell      
 PREHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
 CREATE VIEW view7 AS
@@ -718,8 +688,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view8
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 c                   	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -795,8 +763,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view9
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 m                   	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -872,8 +838,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view9
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 m                   	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -938,8 +902,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view10
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -1011,8 +973,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view11
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 boom                	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -1079,8 +1039,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view12
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 mycol               	int                 	None                
@@ -1165,8 +1123,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view13
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -1262,8 +1218,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view14
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 k1                  	string              	None                
 v1                  	string              	None                
 k2                  	string              	None                
@@ -1394,8 +1348,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view15
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value_count         	bigint              	None                
 	 	 
@@ -1481,8 +1433,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view16
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -1561,8 +1511,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view16
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 PREHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching table name
 DROP VIEW IF EXISTS table1
@@ -1580,8 +1528,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 value               	string              	None                
 PREHOOK: query: -- this should work since currently we don't track view->table

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/create_view_partitioned.q.out Fri Apr 26 19:14:49 2013
@@ -33,8 +33,6 @@ PREHOOK: query: DESCRIBE EXTENDED vp1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED vp1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/database.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/database.q.out Fri Apr 26 19:14:49 2013
@@ -129,8 +129,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- DESCRIBE table in non-default DB
 DESCRIBE test_table
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	string              	None                
 PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 DESCRIBE EXTENDED test_table
@@ -138,8 +136,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 DESCRIBE EXTENDED test_table
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -160,8 +156,6 @@ PREHOOK: query: DESCRIBE EXTENDED test_t
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED test_table_like
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -1344,8 +1338,6 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: temp_tbl2.c EXPRESSION [(temp_tbl)temp_tbl.null, ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/ddltime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/ddltime.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/ddltime.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/ddltime.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: desc extended T1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: desc extended T1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -29,8 +27,6 @@ POSTHOOK: query: desc extended T1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -55,8 +51,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
 POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -85,8 +79,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -112,8 +104,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -154,8 +144,6 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -200,8 +188,6 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -250,8 +236,6 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                

Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_precision.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_precision.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_precision.q.out Fri Apr 26 19:14:49 2013
@@ -34,72 +34,74 @@ NULL
 NULL
 NULL
 NULL
+NULL
+-99999999999999999999999999999999999999
 -999999999999999999999999999999999999
--9999999999999999999999999999999999
--999999999999999999999999999999999
--0.00000000000000000000000000000000001
+-99999999999999999999999999999999999
+-0.0000000000000000000000000000000000001
 0
-0.00000000000000000000000000000000001
+0.0000000000000000000000000000000000001
 0.123456789012345
-0.12345678901234567890123456789012345
+0.1234567890123456789012345678901234578
 1.234567890123456
-1.23456789012345678901234567890123456
+1.2345678901234567890123456789012345678
 12.34567890123456
-12.3456789012345678901234567890123456
+12.345678901234567890123456789012345678
 123.4567890123456
-123.456789012345678901234567890123456
+123.45678901234567890123456789012345678
 1234.567890123456
-1234.56789012345678901234567890123456
+1234.5678901234567890123456789012345678
 12345.67890123456
-12345.6789012345678901234567890123456
+12345.678901234567890123456789012345678
 123456.7890123456
-123456.789012345678901234567890123456
+123456.78901234567890123456789012345678
 1234567.890123456
-1234567.89012345678901234567890123456
+1234567.8901234567890123456789012345678
 12345678.90123456
-12345678.9012345678901234567890123456
+12345678.901234567890123456789012345678
 123456789.0123456
-123456789.012345678901234567890123456
+123456789.01234567890123456789012345678
 1234567890.123456
-1234567890.12345678901234567890123456
+1234567890.1234567890123456789012345678
 12345678901.23456
-12345678901.2345678901234567890123456
+12345678901.234567890123456789012345678
 123456789012.3456
-123456789012.345678901234567890123456
+123456789012.34567890123456789012345678
 1234567890123.456
-1234567890123.45678901234567890123456
+1234567890123.4567890123456789012345678
 12345678901234.56
-12345678901234.5678901234567890123456
+12345678901234.567890123456789012345678
 123456789012345.6
-123456789012345.678901234567890123456
-1234567890123456.78901234567890123456
-12345678901234567.8901234567890123456
-123456789012345678.901234567890123456
-1234567890123456789.01234567890123456
-12345678901234567890.1234567890123456
-123456789012345678901.234567890123456
-1234567890123456789012.34567890123456
-12345678901234567890123.4567890123456
-123456789012345678901234.567890123456
-1234567890123456789012345.67890123456
-12345678901234567890123456.7890123456
-123456789012345678901234567.890123456
-1234567890123456789012345678.90123456
-12345678901234567890123456789.0123456
-123456789012345678901234567890.123456
-1234567890123456789012345678901.23456
-12345678901234567890123456789012.3456
-123456789012345678901234567890123.456
-999999999999999999999999999999999
-1234567890123456789012345678901234.56
-9999999999999999999999999999999999
-12345678901234567890123456789012345.6
-123456789012345678901234567890123456
-123456789012345678901234567890123456
-123456789012345678901234567890123456
-123456789012345678901234567890123456
-123456789012345678901234567890123456
+123456789012345.67890123456789012345678
+1234567890123456.7890123456789012345678
+12345678901234567.890123456789012345678
+123456789012345678.90123456789012345678
+1234567890123456789.0123456789012345678
+12345678901234567890.123456789012345678
+123456789012345678901.23456789012345678
+1234567890123456789012.3456789012345678
+12345678901234567890123.456789012345678
+123456789012345678901234.56789012345678
+1234567890123456789012345.6789012345678
+12345678901234567890123456.789012345678
+123456789012345678901234567.89012345678
+1234567890123456789012345678.9012345678
+12345678901234567890123456789.012345678
+123456789012345678901234567890.12345678
+1234567890123456789012345678901.2345678
+12345678901234567890123456789012.345678
+123456789012345678901234567890123.45678
+1234567890123456789012345678901234.5678
+12345678901234567890123456789012345.678
+99999999999999999999999999999999999
+123456789012345678901234567890123456.78
 999999999999999999999999999999999999
+12345678901234567890123456789012345678
+12345678901234567890123456789012345678
+12345678901234567890123456789012345678
+12345678901234567890123456789012345678
+12345678901234567890123456789012345678
+99999999999999999999999999999999999999
 PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -115,72 +117,74 @@ NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
--999999999999999999999999999999999999	-999999999999999999999999999999999998	NULL
--9999999999999999999999999999999999	-9999999999999999999999999999999998	-10000000000000000000000000000000000
--999999999999999999999999999999999	-999999999999999999999999999999998	-1000000000000000000000000000000000
--0.00000000000000000000000000000000001	0.99999999999999999999999999999999999	-1.00000000000000000000000000000000001
+NULL	NULL	NULL
+-99999999999999999999999999999999999999	-99999999999999999999999999999999999998	NULL
+-999999999999999999999999999999999999	-999999999999999999999999999999999998	-1000000000000000000000000000000000000
+-99999999999999999999999999999999999	-99999999999999999999999999999999998	-100000000000000000000000000000000000
+-0.0000000000000000000000000000000000001	0.9999999999999999999999999999999999999	-1.0000000000000000000000000000000000001
 0	1	-1
-0.00000000000000000000000000000000001	1.00000000000000000000000000000000001	-0.99999999999999999999999999999999999
+0.0000000000000000000000000000000000001	1.0000000000000000000000000000000000001	-0.9999999999999999999999999999999999999
 0.123456789012345	1.123456789012345	-0.876543210987655
-0.12345678901234567890123456789012345	1.12345678901234567890123456789012345	-0.87654321098765432109876543210987655
+0.1234567890123456789012345678901234578	1.1234567890123456789012345678901234578	-0.8765432109876543210987654321098765422
 1.234567890123456	2.234567890123456	0.234567890123456
-1.23456789012345678901234567890123456	2.23456789012345678901234567890123456	0.23456789012345678901234567890123456
+1.2345678901234567890123456789012345678	2.2345678901234567890123456789012345678	0.2345678901234567890123456789012345678
 12.34567890123456	13.34567890123456	11.34567890123456
-12.3456789012345678901234567890123456	13.3456789012345678901234567890123456	11.3456789012345678901234567890123456
+12.345678901234567890123456789012345678	13.345678901234567890123456789012345678	11.345678901234567890123456789012345678
 123.4567890123456	124.4567890123456	122.4567890123456
-123.456789012345678901234567890123456	124.456789012345678901234567890123456	122.456789012345678901234567890123456
+123.45678901234567890123456789012345678	124.45678901234567890123456789012345678	122.45678901234567890123456789012345678
 1234.567890123456	1235.567890123456	1233.567890123456
-1234.56789012345678901234567890123456	1235.56789012345678901234567890123456	1233.56789012345678901234567890123456
+1234.5678901234567890123456789012345678	1235.5678901234567890123456789012345678	1233.5678901234567890123456789012345678
 12345.67890123456	12346.67890123456	12344.67890123456
-12345.6789012345678901234567890123456	12346.6789012345678901234567890123456	12344.6789012345678901234567890123456
+12345.678901234567890123456789012345678	12346.678901234567890123456789012345678	12344.678901234567890123456789012345678
 123456.7890123456	123457.7890123456	123455.7890123456
-123456.789012345678901234567890123456	123457.789012345678901234567890123456	123455.789012345678901234567890123456
+123456.78901234567890123456789012345678	123457.78901234567890123456789012345678	123455.78901234567890123456789012345678
 1234567.890123456	1234568.890123456	1234566.890123456
-1234567.89012345678901234567890123456	1234568.89012345678901234567890123456	1234566.89012345678901234567890123456
+1234567.8901234567890123456789012345678	1234568.8901234567890123456789012345678	1234566.8901234567890123456789012345678
 12345678.90123456	12345679.90123456	12345677.90123456
-12345678.9012345678901234567890123456	12345679.9012345678901234567890123456	12345677.9012345678901234567890123456
+12345678.901234567890123456789012345678	12345679.901234567890123456789012345678	12345677.901234567890123456789012345678
 123456789.0123456	123456790.0123456	123456788.0123456
-123456789.012345678901234567890123456	123456790.012345678901234567890123456	123456788.012345678901234567890123456
+123456789.01234567890123456789012345678	123456790.01234567890123456789012345678	123456788.01234567890123456789012345678
 1234567890.123456	1234567891.123456	1234567889.123456
-1234567890.12345678901234567890123456	1234567891.12345678901234567890123456	1234567889.12345678901234567890123456
+1234567890.1234567890123456789012345678	1234567891.1234567890123456789012345678	1234567889.1234567890123456789012345678
 12345678901.23456	12345678902.23456	12345678900.23456
-12345678901.2345678901234567890123456	12345678902.2345678901234567890123456	12345678900.2345678901234567890123456
+12345678901.234567890123456789012345678	12345678902.234567890123456789012345678	12345678900.234567890123456789012345678
 123456789012.3456	123456789013.3456	123456789011.3456
-123456789012.345678901234567890123456	123456789013.345678901234567890123456	123456789011.345678901234567890123456
+123456789012.34567890123456789012345678	123456789013.34567890123456789012345678	123456789011.34567890123456789012345678
 1234567890123.456	1234567890124.456	1234567890122.456
-1234567890123.45678901234567890123456	1234567890124.45678901234567890123456	1234567890122.45678901234567890123456
+1234567890123.4567890123456789012345678	1234567890124.4567890123456789012345678	1234567890122.4567890123456789012345678
 12345678901234.56	12345678901235.56	12345678901233.56
-12345678901234.5678901234567890123456	12345678901235.5678901234567890123456	12345678901233.5678901234567890123456
+12345678901234.567890123456789012345678	12345678901235.567890123456789012345678	12345678901233.567890123456789012345678
 123456789012345.6	123456789012346.6	123456789012344.6
-123456789012345.678901234567890123456	123456789012346.678901234567890123456	123456789012344.678901234567890123456
-1234567890123456.78901234567890123456	1234567890123457.78901234567890123456	1234567890123455.78901234567890123456
-12345678901234567.8901234567890123456	12345678901234568.8901234567890123456	12345678901234566.8901234567890123456
-123456789012345678.901234567890123456	123456789012345679.901234567890123456	123456789012345677.901234567890123456
-1234567890123456789.01234567890123456	1234567890123456790.01234567890123456	1234567890123456788.01234567890123456
-12345678901234567890.1234567890123456	12345678901234567891.1234567890123456	12345678901234567889.1234567890123456
-123456789012345678901.234567890123456	123456789012345678902.234567890123456	123456789012345678900.234567890123456
-1234567890123456789012.34567890123456	1234567890123456789013.34567890123456	1234567890123456789011.34567890123456
-12345678901234567890123.4567890123456	12345678901234567890124.4567890123456	12345678901234567890122.4567890123456
-123456789012345678901234.567890123456	123456789012345678901235.567890123456	123456789012345678901233.567890123456
-1234567890123456789012345.67890123456	1234567890123456789012346.67890123456	1234567890123456789012344.67890123456
-12345678901234567890123456.7890123456	12345678901234567890123457.7890123456	12345678901234567890123455.7890123456
-123456789012345678901234567.890123456	123456789012345678901234568.890123456	123456789012345678901234566.890123456
-1234567890123456789012345678.90123456	1234567890123456789012345679.90123456	1234567890123456789012345677.90123456
-12345678901234567890123456789.0123456	12345678901234567890123456790.0123456	12345678901234567890123456788.0123456
-123456789012345678901234567890.123456	123456789012345678901234567891.123456	123456789012345678901234567889.123456
-1234567890123456789012345678901.23456	1234567890123456789012345678902.23456	1234567890123456789012345678900.23456
-12345678901234567890123456789012.3456	12345678901234567890123456789013.3456	12345678901234567890123456789011.3456
-123456789012345678901234567890123.456	123456789012345678901234567890124.456	123456789012345678901234567890122.456
-999999999999999999999999999999999	1000000000000000000000000000000000	999999999999999999999999999999998
-1234567890123456789012345678901234.56	1234567890123456789012345678901235.56	1234567890123456789012345678901233.56
-9999999999999999999999999999999999	10000000000000000000000000000000000	9999999999999999999999999999999998
-12345678901234567890123456789012345.6	12345678901234567890123456789012346.6	12345678901234567890123456789012344.6
-123456789012345678901234567890123456	123456789012345678901234567890123457	123456789012345678901234567890123455
-123456789012345678901234567890123456	123456789012345678901234567890123457	123456789012345678901234567890123455
-123456789012345678901234567890123456	123456789012345678901234567890123457	123456789012345678901234567890123455
-123456789012345678901234567890123456	123456789012345678901234567890123457	123456789012345678901234567890123455
-123456789012345678901234567890123456	123456789012345678901234567890123457	123456789012345678901234567890123455
-999999999999999999999999999999999999	NULL	999999999999999999999999999999999998
+123456789012345.67890123456789012345678	123456789012346.67890123456789012345678	123456789012344.67890123456789012345678
+1234567890123456.7890123456789012345678	1234567890123457.7890123456789012345678	1234567890123455.7890123456789012345678
+12345678901234567.890123456789012345678	12345678901234568.890123456789012345678	12345678901234566.890123456789012345678
+123456789012345678.90123456789012345678	123456789012345679.90123456789012345678	123456789012345677.90123456789012345678
+1234567890123456789.0123456789012345678	1234567890123456790.0123456789012345678	1234567890123456788.0123456789012345678
+12345678901234567890.123456789012345678	12345678901234567891.123456789012345678	12345678901234567889.123456789012345678
+123456789012345678901.23456789012345678	123456789012345678902.23456789012345678	123456789012345678900.23456789012345678
+1234567890123456789012.3456789012345678	1234567890123456789013.3456789012345678	1234567890123456789011.3456789012345678
+12345678901234567890123.456789012345678	12345678901234567890124.456789012345678	12345678901234567890122.456789012345678
+123456789012345678901234.56789012345678	123456789012345678901235.56789012345678	123456789012345678901233.56789012345678
+1234567890123456789012345.6789012345678	1234567890123456789012346.6789012345678	1234567890123456789012344.6789012345678
+12345678901234567890123456.789012345678	12345678901234567890123457.789012345678	12345678901234567890123455.789012345678
+123456789012345678901234567.89012345678	123456789012345678901234568.89012345678	123456789012345678901234566.89012345678
+1234567890123456789012345678.9012345678	1234567890123456789012345679.9012345678	1234567890123456789012345677.9012345678
+12345678901234567890123456789.012345678	12345678901234567890123456790.012345678	12345678901234567890123456788.012345678
+123456789012345678901234567890.12345678	123456789012345678901234567891.12345678	123456789012345678901234567889.12345678
+1234567890123456789012345678901.2345678	1234567890123456789012345678902.2345678	1234567890123456789012345678900.2345678
+12345678901234567890123456789012.345678	12345678901234567890123456789013.345678	12345678901234567890123456789011.345678
+123456789012345678901234567890123.45678	123456789012345678901234567890124.45678	123456789012345678901234567890122.45678
+1234567890123456789012345678901234.5678	1234567890123456789012345678901235.5678	1234567890123456789012345678901233.5678
+12345678901234567890123456789012345.678	12345678901234567890123456789012346.678	12345678901234567890123456789012344.678
+99999999999999999999999999999999999	100000000000000000000000000000000000	99999999999999999999999999999999998
+123456789012345678901234567890123456.78	123456789012345678901234567890123457.78	123456789012345678901234567890123455.78
+999999999999999999999999999999999999	1000000000000000000000000000000000000	999999999999999999999999999999999998
+12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
+12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
+12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
+12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
+12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
+99999999999999999999999999999999999999	NULL	99999999999999999999999999999999999998
 PREHOOK: query: SELECT dec, dec * 2, dec / 3  FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -196,72 +200,74 @@ NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
--999999999999999999999999999999999999	NULL	-333333333333333333333333333333333333
--9999999999999999999999999999999999	-19999999999999999999999999999999998	-3333333333333333333333333333333333
--999999999999999999999999999999999	-1999999999999999999999999999999998	-333333333333333333333333333333333
--0.00000000000000000000000000000000001	-0.00000000000000000000000000000000002	0
+NULL	NULL	NULL
+-99999999999999999999999999999999999999	NULL	-33333333333333333333333333333333333333
+-999999999999999999999999999999999999	-1999999999999999999999999999999999998	-333333333333333333333333333333333333
+-99999999999999999999999999999999999	-199999999999999999999999999999999998	-33333333333333333333333333333333333
+-0.0000000000000000000000000000000000001	-0.0000000000000000000000000000000000002	0
 0	0	0
-0.00000000000000000000000000000000001	0.00000000000000000000000000000000002	0
+0.0000000000000000000000000000000000001	0.0000000000000000000000000000000000002	0
 0.123456789012345	0.24691357802469	0.041152263004115
-0.12345678901234567890123456789012345	0.2469135780246913578024691357802469	0.04115226300411522630041152263004115
+0.1234567890123456789012345678901234578	0.2469135780246913578024691357802469156	0.0411522630041152263004115226300411526
 1.234567890123456	2.469135780246912	0.411522630041152
-1.23456789012345678901234567890123456	2.46913578024691357802469135780246912	0.41152263004115226300411522630041152
+1.2345678901234567890123456789012345678	2.4691357802469135780246913578024691356	0.4115226300411522630041152263004115226
 12.34567890123456	24.69135780246912	4.11522630041152
-12.3456789012345678901234567890123456	24.6913578024691357802469135780246912	4.1152263004115226300411522630041152
+12.345678901234567890123456789012345678	24.691357802469135780246913578024691356	4.115226300411522630041152263004115226
 123.4567890123456	246.9135780246912	41.1522630041152
-123.456789012345678901234567890123456	246.913578024691357802469135780246912	41.152263004115226300411522630041152
+123.45678901234567890123456789012345678	246.91357802469135780246913578024691356	41.15226300411522630041152263004115226
 1234.567890123456	2469.135780246912	411.522630041152
-1234.56789012345678901234567890123456	2469.13578024691357802469135780246912	411.52263004115226300411522630041152
+1234.5678901234567890123456789012345678	2469.1357802469135780246913578024691356	411.5226300411522630041152263004115226
 12345.67890123456	24691.35780246912	4115.22630041152
-12345.6789012345678901234567890123456	24691.3578024691357802469135780246912	4115.2263004115226300411522630041152
+12345.678901234567890123456789012345678	24691.357802469135780246913578024691356	4115.226300411522630041152263004115226
 123456.7890123456	246913.5780246912	41152.2630041152
-123456.789012345678901234567890123456	246913.578024691357802469135780246912	41152.263004115226300411522630041152
+123456.78901234567890123456789012345678	246913.57802469135780246913578024691356	41152.26300411522630041152263004115226
 1234567.890123456	2469135.780246912	411522.630041152
-1234567.89012345678901234567890123456	2469135.78024691357802469135780246912	411522.63004115226300411522630041152
+1234567.8901234567890123456789012345678	2469135.7802469135780246913578024691356	411522.6300411522630041152263004115226
 12345678.90123456	24691357.80246912	4115226.30041152
-12345678.9012345678901234567890123456	24691357.8024691357802469135780246912	4115226.3004115226300411522630041152
+12345678.901234567890123456789012345678	24691357.802469135780246913578024691356	4115226.300411522630041152263004115226
 123456789.0123456	246913578.0246912	41152263.0041152
-123456789.012345678901234567890123456	246913578.024691357802469135780246912	41152263.004115226300411522630041152
+123456789.01234567890123456789012345678	246913578.02469135780246913578024691356	41152263.00411522630041152263004115226
 1234567890.123456	2469135780.246912	411522630.041152
-1234567890.12345678901234567890123456	2469135780.24691357802469135780246912	411522630.04115226300411522630041152
+1234567890.1234567890123456789012345678	2469135780.2469135780246913578024691356	411522630.0411522630041152263004115226
 12345678901.23456	24691357802.46912	4115226300.41152
-12345678901.2345678901234567890123456	24691357802.4691357802469135780246912	4115226300.4115226300411522630041152
+12345678901.234567890123456789012345678	24691357802.469135780246913578024691356	4115226300.411522630041152263004115226
 123456789012.3456	246913578024.6912	41152263004.1152
-123456789012.345678901234567890123456	246913578024.691357802469135780246912	41152263004.115226300411522630041152
+123456789012.34567890123456789012345678	246913578024.69135780246913578024691356	41152263004.11522630041152263004115226
 1234567890123.456	2469135780246.912	411522630041.152
-1234567890123.45678901234567890123456	2469135780246.91357802469135780246912	411522630041.15226300411522630041152
+1234567890123.4567890123456789012345678	2469135780246.9135780246913578024691356	411522630041.1522630041152263004115226
 12345678901234.56	24691357802469.12	4115226300411.52
-12345678901234.5678901234567890123456	24691357802469.1357802469135780246912	4115226300411.5226300411522630041152
+12345678901234.567890123456789012345678	24691357802469.135780246913578024691356	4115226300411.522630041152263004115226
 123456789012345.6	246913578024691.2	41152263004115.2
-123456789012345.678901234567890123456	246913578024691.357802469135780246912	41152263004115.226300411522630041152
-1234567890123456.78901234567890123456	2469135780246913.57802469135780246912	411522630041152.26300411522630041152
-12345678901234567.8901234567890123456	24691357802469135.7802469135780246912	4115226300411522.6300411522630041152
-123456789012345678.901234567890123456	246913578024691357.802469135780246912	41152263004115226.300411522630041152
-1234567890123456789.01234567890123456	2469135780246913578.02469135780246912	411522630041152263.00411522630041152
-12345678901234567890.1234567890123456	24691357802469135780.2469135780246912	4115226300411522630.0411522630041152
-123456789012345678901.234567890123456	246913578024691357802.469135780246912	41152263004115226300.411522630041152
-1234567890123456789012.34567890123456	2469135780246913578024.69135780246912	411522630041152263004.11522630041152
-12345678901234567890123.4567890123456	24691357802469135780246.9135780246912	4115226300411522630041.1522630041152
-123456789012345678901234.567890123456	246913578024691357802469.135780246912	41152263004115226300411.522630041152
-1234567890123456789012345.67890123456	2469135780246913578024691.35780246912	411522630041152263004115.22630041152
-12345678901234567890123456.7890123456	24691357802469135780246913.5780246912	4115226300411522630041152.2630041152
-123456789012345678901234567.890123456	246913578024691357802469135.780246912	41152263004115226300411522.630041152
-1234567890123456789012345678.90123456	2469135780246913578024691357.80246912	411522630041152263004115226.30041152
-12345678901234567890123456789.0123456	24691357802469135780246913578.0246912	4115226300411522630041152263.0041152
-123456789012345678901234567890.123456	246913578024691357802469135780.246912	41152263004115226300411522630.041152
-1234567890123456789012345678901.23456	2469135780246913578024691357802.46912	411522630041152263004115226300.41152
-12345678901234567890123456789012.3456	24691357802469135780246913578024.6912	4115226300411522630041152263004.1152
-123456789012345678901234567890123.456	246913578024691357802469135780246.912	41152263004115226300411522630041.152
-999999999999999999999999999999999	1999999999999999999999999999999998	333333333333333333333333333333333
-1234567890123456789012345678901234.56	2469135780246913578024691357802469.12	411522630041152263004115226300411.52
-9999999999999999999999999999999999	19999999999999999999999999999999998	3333333333333333333333333333333333
-12345678901234567890123456789012345.6	24691357802469135780246913578024691.2	4115226300411522630041152263004115.2
-123456789012345678901234567890123456	246913578024691357802469135780246912	41152263004115226300411522630041152
-123456789012345678901234567890123456	246913578024691357802469135780246912	41152263004115226300411522630041152
-123456789012345678901234567890123456	246913578024691357802469135780246912	41152263004115226300411522630041152
-123456789012345678901234567890123456	246913578024691357802469135780246912	41152263004115226300411522630041152
-123456789012345678901234567890123456	246913578024691357802469135780246912	41152263004115226300411522630041152
-999999999999999999999999999999999999	NULL	333333333333333333333333333333333333
+123456789012345.67890123456789012345678	246913578024691.35780246913578024691356	41152263004115.22630041152263004115226
+1234567890123456.7890123456789012345678	2469135780246913.5780246913578024691356	411522630041152.2630041152263004115226
+12345678901234567.890123456789012345678	24691357802469135.780246913578024691356	4115226300411522.630041152263004115226
+123456789012345678.90123456789012345678	246913578024691357.80246913578024691356	41152263004115226.30041152263004115226
+1234567890123456789.0123456789012345678	2469135780246913578.0246913578024691356	411522630041152263.0041152263004115226
+12345678901234567890.123456789012345678	24691357802469135780.246913578024691356	4115226300411522630.041152263004115226
+123456789012345678901.23456789012345678	246913578024691357802.46913578024691356	41152263004115226300.41152263004115226
+1234567890123456789012.3456789012345678	2469135780246913578024.6913578024691356	411522630041152263004.1152263004115226
+12345678901234567890123.456789012345678	24691357802469135780246.913578024691356	4115226300411522630041.152263004115226
+123456789012345678901234.56789012345678	246913578024691357802469.13578024691356	41152263004115226300411.52263004115226
+1234567890123456789012345.6789012345678	2469135780246913578024691.3578024691356	411522630041152263004115.2263004115226
+12345678901234567890123456.789012345678	24691357802469135780246913.578024691356	4115226300411522630041152.263004115226
+123456789012345678901234567.89012345678	246913578024691357802469135.78024691356	41152263004115226300411522.63004115226
+1234567890123456789012345678.9012345678	2469135780246913578024691357.8024691356	411522630041152263004115226.3004115226
+12345678901234567890123456789.012345678	24691357802469135780246913578.024691356	4115226300411522630041152263.004115226
+123456789012345678901234567890.12345678	246913578024691357802469135780.24691356	41152263004115226300411522630.04115226
+1234567890123456789012345678901.2345678	2469135780246913578024691357802.4691356	411522630041152263004115226300.4115226
+12345678901234567890123456789012.345678	24691357802469135780246913578024.691356	4115226300411522630041152263004.115226
+123456789012345678901234567890123.45678	246913578024691357802469135780246.91356	41152263004115226300411522630041.15226
+1234567890123456789012345678901234.5678	2469135780246913578024691357802469.1356	411522630041152263004115226300411.5226
+12345678901234567890123456789012345.678	24691357802469135780246913578024691.356	4115226300411522630041152263004115.226
+99999999999999999999999999999999999	199999999999999999999999999999999998	33333333333333333333333333333333333
+123456789012345678901234567890123456.78	246913578024691357802469135780246913.56	41152263004115226300411522630041152.26
+999999999999999999999999999999999999	1999999999999999999999999999999999998	333333333333333333333333333333333333
+12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
+12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
+12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
+12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
+12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
+99999999999999999999999999999999999999	NULL	33333333333333333333333333333333333333
 PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -277,72 +283,74 @@ NULL	NULL
 NULL	NULL
 NULL	NULL
 NULL	NULL
+NULL	NULL
+-99999999999999999999999999999999999999	-11111111111111111111111111111111111111
 -999999999999999999999999999999999999	-111111111111111111111111111111111111
--9999999999999999999999999999999999	-1111111111111111111111111111111111
--999999999999999999999999999999999	-111111111111111111111111111111111
--0.00000000000000000000000000000000001	0
+-99999999999999999999999999999999999	-11111111111111111111111111111111111
+-0.0000000000000000000000000000000000001	0
 0	0
-0.00000000000000000000000000000000001	0
-0.123456789012345	0.01371742100137166666666666666666667
-0.12345678901234567890123456789012345	0.01371742100137174210013717421001372
-1.234567890123456	0.13717421001371733333333333333333333
-1.23456789012345678901234567890123456	0.13717421001371742100137174210013717
-12.34567890123456	1.37174210013717333333333333333333333
-12.3456789012345678901234567890123456	1.37174210013717421001371742100137173
-123.4567890123456	13.7174210013717333333333333333333333
-123.456789012345678901234567890123456	13.7174210013717421001371742100137173
-1234.567890123456	137.174210013717333333333333333333333
-1234.56789012345678901234567890123456	137.174210013717421001371742100137173
-12345.67890123456	1371.74210013717333333333333333333333
-12345.6789012345678901234567890123456	1371.74210013717421001371742100137173
-123456.7890123456	13717.4210013717333333333333333333333
-123456.789012345678901234567890123456	13717.4210013717421001371742100137173
-1234567.890123456	137174.210013717333333333333333333333
-1234567.89012345678901234567890123456	137174.210013717421001371742100137173
-12345678.90123456	1371742.10013717333333333333333333333
-12345678.9012345678901234567890123456	1371742.10013717421001371742100137173
-123456789.0123456	13717421.0013717333333333333333333333
-123456789.012345678901234567890123456	13717421.0013717421001371742100137173
-1234567890.123456	137174210.013717333333333333333333333
-1234567890.12345678901234567890123456	137174210.013717421001371742100137173
-12345678901.23456	1371742100.13717333333333333333333333
-12345678901.2345678901234567890123456	1371742100.13717421001371742100137173
-123456789012.3456	13717421001.3717333333333333333333333
-123456789012.345678901234567890123456	13717421001.3717421001371742100137173
-1234567890123.456	137174210013.717333333333333333333333
-1234567890123.45678901234567890123456	137174210013.717421001371742100137173
-12345678901234.56	1371742100137.17333333333333333333333
-12345678901234.5678901234567890123456	1371742100137.17421001371742100137173
-123456789012345.6	13717421001371.7333333333333333333333
-123456789012345.678901234567890123456	13717421001371.7421001371742100137173
-1234567890123456.78901234567890123456	137174210013717.421001371742100137173
-12345678901234567.8901234567890123456	1371742100137174.21001371742100137173
-123456789012345678.901234567890123456	13717421001371742.1001371742100137173
-1234567890123456789.01234567890123456	137174210013717421.001371742100137173
-12345678901234567890.1234567890123456	1371742100137174210.01371742100137173
-123456789012345678901.234567890123456	13717421001371742100.1371742100137173
-1234567890123456789012.34567890123456	137174210013717421001.371742100137173
-12345678901234567890123.4567890123456	1371742100137174210013.71742100137173
-123456789012345678901234.567890123456	13717421001371742100137.1742100137173
-1234567890123456789012345.67890123456	137174210013717421001371.742100137173
-12345678901234567890123456.7890123456	1371742100137174210013717.42100137173
-123456789012345678901234567.890123456	13717421001371742100137174.2100137173
-1234567890123456789012345678.90123456	137174210013717421001371742.100137173
-12345678901234567890123456789.0123456	1371742100137174210013717421.00137173
-123456789012345678901234567890.123456	13717421001371742100137174210.0137173
-1234567890123456789012345678901.23456	137174210013717421001371742100.137173
-12345678901234567890123456789012.3456	1371742100137174210013717421001.37173
-123456789012345678901234567890123.456	13717421001371742100137174210013.7173
-999999999999999999999999999999999	111111111111111111111111111111111
-1234567890123456789012345678901234.56	137174210013717421001371742100137.173
-9999999999999999999999999999999999	1111111111111111111111111111111111
-12345678901234567890123456789012345.6	1371742100137174210013717421001371.73
-123456789012345678901234567890123456	13717421001371742100137174210013717.3
-123456789012345678901234567890123456	13717421001371742100137174210013717.3
-123456789012345678901234567890123456	13717421001371742100137174210013717.3
-123456789012345678901234567890123456	13717421001371742100137174210013717.3
-123456789012345678901234567890123456	13717421001371742100137174210013717.3
+0.0000000000000000000000000000000000001	0
+0.123456789012345	0.0137174210013716666666666666666666667
+0.1234567890123456789012345678901234578	0.0137174210013717421001371742100137175
+1.234567890123456	0.1371742100137173333333333333333333333
+1.2345678901234567890123456789012345678	0.1371742100137174210013717421001371742
+12.34567890123456	1.3717421001371733333333333333333333333
+12.345678901234567890123456789012345678	1.371742100137174210013717421001371742
+123.4567890123456	13.717421001371733333333333333333333333
+123.45678901234567890123456789012345678	13.71742100137174210013717421001371742
+1234.567890123456	137.17421001371733333333333333333333333
+1234.5678901234567890123456789012345678	137.1742100137174210013717421001371742
+12345.67890123456	1371.7421001371733333333333333333333333
+12345.678901234567890123456789012345678	1371.742100137174210013717421001371742
+123456.7890123456	13717.421001371733333333333333333333333
+123456.78901234567890123456789012345678	13717.42100137174210013717421001371742
+1234567.890123456	137174.21001371733333333333333333333333
+1234567.8901234567890123456789012345678	137174.2100137174210013717421001371742
+12345678.90123456	1371742.1001371733333333333333333333333
+12345678.901234567890123456789012345678	1371742.100137174210013717421001371742
+123456789.0123456	13717421.001371733333333333333333333333
+123456789.01234567890123456789012345678	13717421.00137174210013717421001371742
+1234567890.123456	137174210.01371733333333333333333333333
+1234567890.1234567890123456789012345678	137174210.0137174210013717421001371742
+12345678901.23456	1371742100.1371733333333333333333333333
+12345678901.234567890123456789012345678	1371742100.137174210013717421001371742
+123456789012.3456	13717421001.371733333333333333333333333
+123456789012.34567890123456789012345678	13717421001.37174210013717421001371742
+1234567890123.456	137174210013.71733333333333333333333333
+1234567890123.4567890123456789012345678	137174210013.7174210013717421001371742
+12345678901234.56	1371742100137.1733333333333333333333333
+12345678901234.567890123456789012345678	1371742100137.174210013717421001371742
+123456789012345.6	13717421001371.733333333333333333333333
+123456789012345.67890123456789012345678	13717421001371.74210013717421001371742
+1234567890123456.7890123456789012345678	137174210013717.4210013717421001371742
+12345678901234567.890123456789012345678	1371742100137174.210013717421001371742
+123456789012345678.90123456789012345678	13717421001371742.10013717421001371742
+1234567890123456789.0123456789012345678	137174210013717421.0013717421001371742
+12345678901234567890.123456789012345678	1371742100137174210.013717421001371742
+123456789012345678901.23456789012345678	13717421001371742100.13717421001371742
+1234567890123456789012.3456789012345678	137174210013717421001.3717421001371742
+12345678901234567890123.456789012345678	1371742100137174210013.717421001371742
+123456789012345678901234.56789012345678	13717421001371742100137.17421001371742
+1234567890123456789012345.6789012345678	137174210013717421001371.7421001371742
+12345678901234567890123456.789012345678	1371742100137174210013717.421001371742
+123456789012345678901234567.89012345678	13717421001371742100137174.21001371742
+1234567890123456789012345678.9012345678	137174210013717421001371742.1001371742
+12345678901234567890123456789.012345678	1371742100137174210013717421.001371742
+123456789012345678901234567890.12345678	13717421001371742100137174210.01371742
+1234567890123456789012345678901.2345678	137174210013717421001371742100.1371742
+12345678901234567890123456789012.345678	1371742100137174210013717421001.371742
+123456789012345678901234567890123.45678	13717421001371742100137174210013.71742
+1234567890123456789012345678901234.5678	137174210013717421001371742100137.1742
+12345678901234567890123456789012345.678	1371742100137174210013717421001371.742
+99999999999999999999999999999999999	11111111111111111111111111111111111
+123456789012345678901234567890123456.78	13717421001371742100137174210013717.42
 999999999999999999999999999999999999	111111111111111111111111111111111111
+12345678901234567890123456789012345678	1371742100137174210013717421001371742
+12345678901234567890123456789012345678	1371742100137174210013717421001371742
+12345678901234567890123456789012345678	1371742100137174210013717421001371742
+12345678901234567890123456789012345678	1371742100137174210013717421001371742
+12345678901234567890123456789012345678	1371742100137174210013717421001371742
+99999999999999999999999999999999999999	11111111111111111111111111111111111111
 PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -358,72 +366,74 @@ NULL	NULL
 NULL	NULL
 NULL	NULL
 NULL	NULL
+NULL	NULL
+-99999999999999999999999999999999999999	-3703703703703703703703703703703703703.7
 -999999999999999999999999999999999999	-37037037037037037037037037037037037
--9999999999999999999999999999999999	-370370370370370370370370370370370.333
--999999999999999999999999999999999	-37037037037037037037037037037037
--0.00000000000000000000000000000000001	0
+-99999999999999999999999999999999999	-3703703703703703703703703703703703.6667
+-0.0000000000000000000000000000000000001	0
 0	0
-0.00000000000000000000000000000000001	0
-0.123456789012345	0.00457247366712388888888888888888889
-0.12345678901234567890123456789012345	0.00457247366712391403337905807000457
-1.234567890123456	0.04572473667123911111111111111111111
-1.23456789012345678901234567890123456	0.04572473667123914033379058070004572
-12.34567890123456	0.45724736671239111111111111111111111
-12.3456789012345678901234567890123456	0.45724736671239140333790580700045724
-123.4567890123456	4.57247366712391111111111111111111111
-123.456789012345678901234567890123456	4.57247366712391403337905807000457244
-1234.567890123456	45.7247366712391111111111111111111111
-1234.56789012345678901234567890123456	45.7247366712391403337905807000457244
-12345.67890123456	457.247366712391111111111111111111111
-12345.6789012345678901234567890123456	457.247366712391403337905807000457244
-123456.7890123456	4572.47366712391111111111111111111111
-123456.789012345678901234567890123456	4572.47366712391403337905807000457244
-1234567.890123456	45724.7366712391111111111111111111111
-1234567.89012345678901234567890123456	45724.7366712391403337905807000457244
-12345678.90123456	457247.366712391111111111111111111111
-12345678.9012345678901234567890123456	457247.366712391403337905807000457244
-123456789.0123456	4572473.66712391111111111111111111111
-123456789.012345678901234567890123456	4572473.66712391403337905807000457244
-1234567890.123456	45724736.6712391111111111111111111111
-1234567890.12345678901234567890123456	45724736.6712391403337905807000457244
-12345678901.23456	457247366.712391111111111111111111111
-12345678901.2345678901234567890123456	457247366.712391403337905807000457244
-123456789012.3456	4572473667.12391111111111111111111111
-123456789012.345678901234567890123456	4572473667.12391403337905807000457244
-1234567890123.456	45724736671.2391111111111111111111111
-1234567890123.45678901234567890123456	45724736671.2391403337905807000457244
-12345678901234.56	457247366712.391111111111111111111111
-12345678901234.5678901234567890123456	457247366712.391403337905807000457244
-123456789012345.6	4572473667123.91111111111111111111111
-123456789012345.678901234567890123456	4572473667123.91403337905807000457244
-1234567890123456.78901234567890123456	45724736671239.1403337905807000457244
-12345678901234567.8901234567890123456	457247366712391.403337905807000457244
-123456789012345678.901234567890123456	4572473667123914.03337905807000457244
-1234567890123456789.01234567890123456	45724736671239140.3337905807000457244
-12345678901234567890.1234567890123456	457247366712391403.337905807000457244
-123456789012345678901.234567890123456	4572473667123914033.37905807000457244
-1234567890123456789012.34567890123456	45724736671239140333.7905807000457244
-12345678901234567890123.4567890123456	457247366712391403337.905807000457244
-123456789012345678901234.567890123456	4572473667123914033379.05807000457244
-1234567890123456789012345.67890123456	45724736671239140333790.5807000457244
-12345678901234567890123456.7890123456	457247366712391403337905.807000457244
-123456789012345678901234567.890123456	4572473667123914033379058.07000457244
-1234567890123456789012345678.90123456	45724736671239140333790580.7000457244
-12345678901234567890123456789.0123456	457247366712391403337905807.000457244
-123456789012345678901234567890.123456	4572473667123914033379058070.00457244
-1234567890123456789012345678901.23456	45724736671239140333790580700.0457244
-12345678901234567890123456789012.3456	457247366712391403337905807000.457244
-123456789012345678901234567890123.456	4572473667123914033379058070004.57244
-999999999999999999999999999999999	37037037037037037037037037037037
-1234567890123456789012345678901234.56	45724736671239140333790580700045.7244
-9999999999999999999999999999999999	370370370370370370370370370370370.333
-12345678901234567890123456789012345.6	457247366712391403337905807000457.244
-123456789012345678901234567890123456	4572473667123914033379058070004572.44
-123456789012345678901234567890123456	4572473667123914033379058070004572.44
-123456789012345678901234567890123456	4572473667123914033379058070004572.44
-123456789012345678901234567890123456	4572473667123914033379058070004572.44
-123456789012345678901234567890123456	4572473667123914033379058070004572.44
+0.0000000000000000000000000000000000001	0
+0.123456789012345	0.0045724736671238888888888888888888889
+0.1234567890123456789012345678901234578	0.0045724736671239140333790580700045725
+1.234567890123456	0.0457247366712391111111111111111111111
+1.2345678901234567890123456789012345678	0.0457247366712391403337905807000457247
+12.34567890123456	0.4572473667123911111111111111111111111
+12.345678901234567890123456789012345678	0.4572473667123914033379058070004572473
+123.4567890123456	4.5724736671239111111111111111111111111
+123.45678901234567890123456789012345678	4.5724736671239140333790580700045724733
+1234.567890123456	45.724736671239111111111111111111111111
+1234.5678901234567890123456789012345678	45.724736671239140333790580700045724733
+12345.67890123456	457.24736671239111111111111111111111111
+12345.678901234567890123456789012345678	457.24736671239140333790580700045724733
+123456.7890123456	4572.4736671239111111111111111111111111
+123456.78901234567890123456789012345678	4572.4736671239140333790580700045724733
+1234567.890123456	45724.736671239111111111111111111111111
+1234567.8901234567890123456789012345678	45724.736671239140333790580700045724733
+12345678.90123456	457247.36671239111111111111111111111111
+12345678.901234567890123456789012345678	457247.36671239140333790580700045724733
+123456789.0123456	4572473.6671239111111111111111111111111
+123456789.01234567890123456789012345678	4572473.6671239140333790580700045724733
+1234567890.123456	45724736.671239111111111111111111111111
+1234567890.1234567890123456789012345678	45724736.671239140333790580700045724733
+12345678901.23456	457247366.71239111111111111111111111111
+12345678901.234567890123456789012345678	457247366.71239140333790580700045724733
+123456789012.3456	4572473667.1239111111111111111111111111
+123456789012.34567890123456789012345678	4572473667.1239140333790580700045724733
+1234567890123.456	45724736671.239111111111111111111111111
+1234567890123.4567890123456789012345678	45724736671.239140333790580700045724733
+12345678901234.56	457247366712.39111111111111111111111111
+12345678901234.567890123456789012345678	457247366712.39140333790580700045724733
+123456789012345.6	4572473667123.9111111111111111111111111
+123456789012345.67890123456789012345678	4572473667123.9140333790580700045724733
+1234567890123456.7890123456789012345678	45724736671239.140333790580700045724733
+12345678901234567.890123456789012345678	457247366712391.40333790580700045724733
+123456789012345678.90123456789012345678	4572473667123914.0333790580700045724733
+1234567890123456789.0123456789012345678	45724736671239140.333790580700045724733
+12345678901234567890.123456789012345678	457247366712391403.33790580700045724733
+123456789012345678901.23456789012345678	4572473667123914033.3790580700045724733
+1234567890123456789012.3456789012345678	45724736671239140333.790580700045724733
+12345678901234567890123.456789012345678	457247366712391403337.90580700045724733
+123456789012345678901234.56789012345678	4572473667123914033379.0580700045724733
+1234567890123456789012345.6789012345678	45724736671239140333790.580700045724733
+12345678901234567890123456.789012345678	457247366712391403337905.80700045724733
+123456789012345678901234567.89012345678	4572473667123914033379058.0700045724733
+1234567890123456789012345678.9012345678	45724736671239140333790580.700045724733
+12345678901234567890123456789.012345678	457247366712391403337905807.00045724733
+123456789012345678901234567890.12345678	4572473667123914033379058070.0045724733
+1234567890123456789012345678901.2345678	45724736671239140333790580700.045724733
+12345678901234567890123456789012.345678	457247366712391403337905807000.45724733
+123456789012345678901234567890123.45678	4572473667123914033379058070004.5724733
+1234567890123456789012345678901234.5678	45724736671239140333790580700045.724733
+12345678901234567890123456789012345.678	457247366712391403337905807000457.24733
+99999999999999999999999999999999999	3703703703703703703703703703703703.6667
+123456789012345678901234567890123456.78	4572473667123914033379058070004572.4733
 999999999999999999999999999999999999	37037037037037037037037037037037037
+12345678901234567890123456789012345678	457247366712391403337905807000457247.33
+12345678901234567890123456789012345678	457247366712391403337905807000457247.33
+12345678901234567890123456789012345678	457247366712391403337905807000457247.33
+12345678901234567890123456789012345678	457247366712391403337905807000457247.33
+12345678901234567890123456789012345678	457247366712391403337905807000457247.33
+99999999999999999999999999999999999999	3703703703703703703703703703703703703.7
 PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -439,72 +449,74 @@ NULL	NULL
 NULL	NULL
 NULL	NULL
 NULL	NULL
+NULL	NULL
+-99999999999999999999999999999999999999	NULL
 -999999999999999999999999999999999999	NULL
--9999999999999999999999999999999999	NULL
--999999999999999999999999999999999	NULL
--0.00000000000000000000000000000000001	NULL
+-99999999999999999999999999999999999	NULL
+-0.0000000000000000000000000000000000001	NULL
 0	0
-0.00000000000000000000000000000000001	NULL
+0.0000000000000000000000000000000000001	NULL
 0.123456789012345	0.015241578753238669120562399025
-0.12345678901234567890123456789012345	NULL
+0.1234567890123456789012345678901234578	NULL
 1.234567890123456	1.524157875323881726870921383936
-1.23456789012345678901234567890123456	NULL
+1.2345678901234567890123456789012345678	NULL
 12.34567890123456	152.4157875323881726870921383936
-12.3456789012345678901234567890123456	NULL
+12.345678901234567890123456789012345678	NULL
 123.4567890123456	15241.57875323881726870921383936
-123.456789012345678901234567890123456	NULL
+123.45678901234567890123456789012345678	NULL
 1234.567890123456	1524157.875323881726870921383936
-1234.56789012345678901234567890123456	NULL
+1234.5678901234567890123456789012345678	NULL
 12345.67890123456	152415787.5323881726870921383936
-12345.6789012345678901234567890123456	NULL
+12345.678901234567890123456789012345678	NULL
 123456.7890123456	15241578753.23881726870921383936
-123456.789012345678901234567890123456	NULL
+123456.78901234567890123456789012345678	NULL
 1234567.890123456	1524157875323.881726870921383936
-1234567.89012345678901234567890123456	NULL
+1234567.8901234567890123456789012345678	NULL
 12345678.90123456	152415787532388.1726870921383936
-12345678.9012345678901234567890123456	NULL
+12345678.901234567890123456789012345678	NULL
 123456789.0123456	15241578753238817.26870921383936
-123456789.012345678901234567890123456	NULL
+123456789.01234567890123456789012345678	NULL
 1234567890.123456	1524157875323881726.870921383936
-1234567890.12345678901234567890123456	NULL
+1234567890.1234567890123456789012345678	NULL
 12345678901.23456	152415787532388172687.0921383936
-12345678901.2345678901234567890123456	NULL
+12345678901.234567890123456789012345678	NULL
 123456789012.3456	15241578753238817268709.21383936
-123456789012.345678901234567890123456	NULL
+123456789012.34567890123456789012345678	NULL
 1234567890123.456	1524157875323881726870921.383936
-1234567890123.45678901234567890123456	NULL
+1234567890123.4567890123456789012345678	NULL
 12345678901234.56	152415787532388172687092138.3936
-12345678901234.5678901234567890123456	NULL
+12345678901234.567890123456789012345678	NULL
 123456789012345.6	15241578753238817268709213839.36
-123456789012345.678901234567890123456	NULL
-1234567890123456.78901234567890123456	NULL
-12345678901234567.8901234567890123456	NULL
-123456789012345678.901234567890123456	NULL
-1234567890123456789.01234567890123456	NULL
-12345678901234567890.1234567890123456	NULL
-123456789012345678901.234567890123456	NULL
-1234567890123456789012.34567890123456	NULL
-12345678901234567890123.4567890123456	NULL
-123456789012345678901234.567890123456	NULL
-1234567890123456789012345.67890123456	NULL
-12345678901234567890123456.7890123456	NULL
-123456789012345678901234567.890123456	NULL
-1234567890123456789012345678.90123456	NULL
-12345678901234567890123456789.0123456	NULL
-123456789012345678901234567890.123456	NULL
-1234567890123456789012345678901.23456	NULL
-12345678901234567890123456789012.3456	NULL
-123456789012345678901234567890123.456	NULL
-999999999999999999999999999999999	NULL
-1234567890123456789012345678901234.56	NULL
-9999999999999999999999999999999999	NULL
-12345678901234567890123456789012345.6	NULL
-123456789012345678901234567890123456	NULL
-123456789012345678901234567890123456	NULL
-123456789012345678901234567890123456	NULL
-123456789012345678901234567890123456	NULL
-123456789012345678901234567890123456	NULL
+123456789012345.67890123456789012345678	NULL
+1234567890123456.7890123456789012345678	NULL
+12345678901234567.890123456789012345678	NULL
+123456789012345678.90123456789012345678	NULL
+1234567890123456789.0123456789012345678	NULL
+12345678901234567890.123456789012345678	NULL
+123456789012345678901.23456789012345678	NULL
+1234567890123456789012.3456789012345678	NULL
+12345678901234567890123.456789012345678	NULL
+123456789012345678901234.56789012345678	NULL
+1234567890123456789012345.6789012345678	NULL
+12345678901234567890123456.789012345678	NULL
+123456789012345678901234567.89012345678	NULL
+1234567890123456789012345678.9012345678	NULL
+12345678901234567890123456789.012345678	NULL
+123456789012345678901234567890.12345678	NULL
+1234567890123456789012345678901.2345678	NULL
+12345678901234567890123456789012.345678	NULL
+123456789012345678901234567890123.45678	NULL
+1234567890123456789012345678901234.5678	NULL
+12345678901234567890123456789012345.678	NULL
+99999999999999999999999999999999999	NULL
+123456789012345678901234567890123456.78	NULL
 999999999999999999999999999999999999	NULL
+12345678901234567890123456789012345678	NULL
+12345678901234567890123456789012345678	NULL
+12345678901234567890123456789012345678	NULL
+12345678901234567890123456789012345678	NULL
+12345678901234567890123456789012345678	NULL
+99999999999999999999999999999999999999	NULL
 PREHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -514,6 +526,50 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
 NULL	NULL
+PREHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal) FROM DECIMAL_PRECISION LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal) FROM DECIMAL_PRECISION LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal) LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal) LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+PREHOOK: query: SELECT dec * 123456789012345678901234567890.123456789 FROM DECIMAL_PRECISION LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT dec * 123456789012345678901234567890.123456789 FROM DECIMAL_PRECISION LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_precision
+#### A masked pattern was here ####
+0
 PREHOOK: query: DROP TABLE DECIMAL_PRECISION
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@decimal_precision



Mime
View raw message