PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@DECIMAL_PRECISION PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION PREHOOK: type: LOAD PREHOOK: Output: default@decimal_precision POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION POSTHOOK: type: LOAD POSTHOOK: Output: default@decimal_precision PREHOOK: query: SELECT * FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL -99999999999999999999999999999999999999 -999999999999999999999999999999999999 -99999999999999999999999999999999999 -0.0000000000000000000000000000000000001 0 0.0000000000000000000000000000000000001 0.123456789012345 0.1234567890123456789012345678901234578 1.234567890123456 1.2345678901234567890123456789012345678 12.34567890123456 12.345678901234567890123456789012345678 123.4567890123456 123.45678901234567890123456789012345678 1234.567890123456 1234.5678901234567890123456789012345678 12345.67890123456 12345.678901234567890123456789012345678 123456.7890123456 123456.78901234567890123456789012345678 1234567.890123456 1234567.8901234567890123456789012345678 12345678.90123456 12345678.901234567890123456789012345678 123456789.0123456 123456789.01234567890123456789012345678 1234567890.123456 1234567890.1234567890123456789012345678 12345678901.23456 12345678901.234567890123456789012345678 123456789012.3456 123456789012.34567890123456789012345678 1234567890123.456 1234567890123.4567890123456789012345678 12345678901234.56 12345678901234.567890123456789012345678 123456789012345.6 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 #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -99999999999999999999999999999999999999 -99999999999999999999999999999999999998 NULL -999999999999999999999999999999999999 -999999999999999999999999999999999998 -1000000000000000000000000000000000000 -99999999999999999999999999999999999 -99999999999999999999999999999999998 -100000000000000000000000000000000000 -0.0000000000000000000000000000000000001 0.9999999999999999999999999999999999999 -1.0000000000000000000000000000000000001 0 1 -1 0.0000000000000000000000000000000000001 1.0000000000000000000000000000000000001 -0.9999999999999999999999999999999999999 0.123456789012345 1.123456789012345 -0.876543210987655 0.1234567890123456789012345678901234578 1.1234567890123456789012345678901234578 -0.8765432109876543210987654321098765422 1.234567890123456 2.234567890123456 0.234567890123456 1.2345678901234567890123456789012345678 2.2345678901234567890123456789012345678 0.2345678901234567890123456789012345678 12.34567890123456 13.34567890123456 11.34567890123456 12.345678901234567890123456789012345678 13.345678901234567890123456789012345678 11.345678901234567890123456789012345678 123.4567890123456 124.4567890123456 122.4567890123456 123.45678901234567890123456789012345678 124.45678901234567890123456789012345678 122.45678901234567890123456789012345678 1234.567890123456 1235.567890123456 1233.567890123456 1234.5678901234567890123456789012345678 1235.5678901234567890123456789012345678 1233.5678901234567890123456789012345678 12345.67890123456 12346.67890123456 12344.67890123456 12345.678901234567890123456789012345678 12346.678901234567890123456789012345678 12344.678901234567890123456789012345678 123456.7890123456 123457.7890123456 123455.7890123456 123456.78901234567890123456789012345678 123457.78901234567890123456789012345678 123455.78901234567890123456789012345678 1234567.890123456 1234568.890123456 1234566.890123456 1234567.8901234567890123456789012345678 1234568.8901234567890123456789012345678 1234566.8901234567890123456789012345678 12345678.90123456 12345679.90123456 12345677.90123456 12345678.901234567890123456789012345678 12345679.901234567890123456789012345678 12345677.901234567890123456789012345678 123456789.0123456 123456790.0123456 123456788.0123456 123456789.01234567890123456789012345678 123456790.01234567890123456789012345678 123456788.01234567890123456789012345678 1234567890.123456 1234567891.123456 1234567889.123456 1234567890.1234567890123456789012345678 1234567891.1234567890123456789012345678 1234567889.1234567890123456789012345678 12345678901.23456 12345678902.23456 12345678900.23456 12345678901.234567890123456789012345678 12345678902.234567890123456789012345678 12345678900.234567890123456789012345678 123456789012.3456 123456789013.3456 123456789011.3456 123456789012.34567890123456789012345678 123456789013.34567890123456789012345678 123456789011.34567890123456789012345678 1234567890123.456 1234567890124.456 1234567890122.456 1234567890123.4567890123456789012345678 1234567890124.4567890123456789012345678 1234567890122.4567890123456789012345678 12345678901234.56 12345678901235.56 12345678901233.56 12345678901234.567890123456789012345678 12345678901235.567890123456789012345678 12345678901233.567890123456789012345678 123456789012345.6 123456789012346.6 123456789012344.6 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 #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -99999999999999999999999999999999999999 NULL -33333333333333333333333333333333333333 -999999999999999999999999999999999999 -1999999999999999999999999999999999998 -333333333333333333333333333333333333 -99999999999999999999999999999999999 -199999999999999999999999999999999998 -33333333333333333333333333333333333 -0.0000000000000000000000000000000000001 -0.0000000000000000000000000000000000002 0 0 0 0 0.0000000000000000000000000000000000001 0.0000000000000000000000000000000000002 0 0.123456789012345 0.24691357802469 0.041152263004115 0.1234567890123456789012345678901234578 0.2469135780246913578024691357802469156 0.0411522630041152263004115226300411526 1.234567890123456 2.469135780246912 0.411522630041152 1.2345678901234567890123456789012345678 2.4691357802469135780246913578024691356 0.4115226300411522630041152263004115226 12.34567890123456 24.69135780246912 4.11522630041152 12.345678901234567890123456789012345678 24.691357802469135780246913578024691356 4.115226300411522630041152263004115226 123.4567890123456 246.9135780246912 41.1522630041152 123.45678901234567890123456789012345678 246.91357802469135780246913578024691356 41.15226300411522630041152263004115226 1234.567890123456 2469.135780246912 411.522630041152 1234.5678901234567890123456789012345678 2469.1357802469135780246913578024691356 411.5226300411522630041152263004115226 12345.67890123456 24691.35780246912 4115.22630041152 12345.678901234567890123456789012345678 24691.357802469135780246913578024691356 4115.226300411522630041152263004115226 123456.7890123456 246913.5780246912 41152.2630041152 123456.78901234567890123456789012345678 246913.57802469135780246913578024691356 41152.26300411522630041152263004115226 1234567.890123456 2469135.780246912 411522.630041152 1234567.8901234567890123456789012345678 2469135.7802469135780246913578024691356 411522.6300411522630041152263004115226 12345678.90123456 24691357.80246912 4115226.30041152 12345678.901234567890123456789012345678 24691357.802469135780246913578024691356 4115226.300411522630041152263004115226 123456789.0123456 246913578.0246912 41152263.0041152 123456789.01234567890123456789012345678 246913578.02469135780246913578024691356 41152263.00411522630041152263004115226 1234567890.123456 2469135780.246912 411522630.041152 1234567890.1234567890123456789012345678 2469135780.2469135780246913578024691356 411522630.0411522630041152263004115226 12345678901.23456 24691357802.46912 4115226300.41152 12345678901.234567890123456789012345678 24691357802.469135780246913578024691356 4115226300.411522630041152263004115226 123456789012.3456 246913578024.6912 41152263004.1152 123456789012.34567890123456789012345678 246913578024.69135780246913578024691356 41152263004.11522630041152263004115226 1234567890123.456 2469135780246.912 411522630041.152 1234567890123.4567890123456789012345678 2469135780246.9135780246913578024691356 411522630041.1522630041152263004115226 12345678901234.56 24691357802469.12 4115226300411.52 12345678901234.567890123456789012345678 24691357802469.135780246913578024691356 4115226300411.522630041152263004115226 123456789012345.6 246913578024691.2 41152263004115.2 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 #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -99999999999999999999999999999999999999 -11111111111111111111111111111111111111 -999999999999999999999999999999999999 -111111111111111111111111111111111111 -99999999999999999999999999999999999 -11111111111111111111111111111111111 -0.0000000000000000000000000000000000001 0 0 0 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 #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -99999999999999999999999999999999999999 -3703703703703703703703703703703703703.7 -999999999999999999999999999999999999 -37037037037037037037037037037037037 -99999999999999999999999999999999999 -3703703703703703703703703703703703.6667 -0.0000000000000000000000000000000000001 0 0 0 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 #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -99999999999999999999999999999999999999 NULL -999999999999999999999999999999999999 NULL -99999999999999999999999999999999999 NULL -0.0000000000000000000000000000000000001 NULL 0 0 0.0000000000000000000000000000000000001 NULL 0.123456789012345 0.015241578753238669120562399025 0.1234567890123456789012345678901234578 NULL 1.234567890123456 1.524157875323881726870921383936 1.2345678901234567890123456789012345678 NULL 12.34567890123456 152.4157875323881726870921383936 12.345678901234567890123456789012345678 NULL 123.4567890123456 15241.57875323881726870921383936 123.45678901234567890123456789012345678 NULL 1234.567890123456 1524157.875323881726870921383936 1234.5678901234567890123456789012345678 NULL 12345.67890123456 152415787.5323881726870921383936 12345.678901234567890123456789012345678 NULL 123456.7890123456 15241578753.23881726870921383936 123456.78901234567890123456789012345678 NULL 1234567.890123456 1524157875323.881726870921383936 1234567.8901234567890123456789012345678 NULL 12345678.90123456 152415787532388.1726870921383936 12345678.901234567890123456789012345678 NULL 123456789.0123456 15241578753238817.26870921383936 123456789.01234567890123456789012345678 NULL 1234567890.123456 1524157875323881726.870921383936 1234567890.1234567890123456789012345678 NULL 12345678901.23456 152415787532388172687.0921383936 12345678901.234567890123456789012345678 NULL 123456789012.3456 15241578753238817268709.21383936 123456789012.34567890123456789012345678 NULL 1234567890123.456 1524157875323881726870921.383936 1234567890123.4567890123456789012345678 NULL 12345678901234.56 152415787532388172687092138.3936 12345678901234.567890123456789012345678 NULL 123456789012345.6 15241578753238817268709213839.36 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 #### A masked pattern was here #### POSTHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION 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 PREHOOK: Output: default@decimal_precision POSTHOOK: query: DROP TABLE DECIMAL_PRECISION POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_precision POSTHOOK: Output: default@decimal_precision