spark-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From petermaxlee <...@git.apache.org>
Subject [GitHub] spark pull request #14598: [SPARK-17018][SQL] literals.sql for testing liter...
Date Thu, 11 Aug 2016 07:59:56 GMT
Github user petermaxlee commented on a diff in the pull request:

    https://github.com/apache/spark/pull/14598#discussion_r74381024
  
    --- Diff: sql/core/src/test/resources/sql-tests/results/literals.sql.out ---
    @@ -0,0 +1,136 @@
    +-- Automatically generated by SQLQueryTestSuite
    +-- Number of queries: 16
    +
    +
    +-- !query 0
    +select null
    +-- !query 0 schema
    +struct<NULL:null>
    +-- !query 0 output
    +NULL
    +
    +
    +-- !query 1
    +select true, false
    +-- !query 1 schema
    +struct<true:boolean,false:boolean>
    +-- !query 1 output
    +true	false
    +
    +
    +-- !query 2
    +select 1Y, 1 Y, 127 Y, -127 Y
    +-- !query 2 schema
    +struct<1:tinyint,Y:int,Y:int,Y:int>
    +-- !query 2 output
    +1	1	127	-127
    +
    +
    +-- !query 3
    +select 128Y
    +-- !query 3 schema
    +struct<>
    +-- !query 3 output
    +org.apache.spark.sql.catalyst.parser.ParseException
    +
    +Value out of range. Value:"128" Radix:10(line 1, pos 7)
    +
    +== SQL ==
    +select 128Y
    +-------^^^
    +
    +
    +-- !query 4
    +select 1S, 1 S, 32767 S, -32767 S
    +-- !query 4 schema
    +struct<1:smallint,S:int,S:int,S:int>
    +-- !query 4 output
    +1	1	32767	-32767
    +
    +
    +-- !query 5
    +select 32768 S
    +-- !query 5 schema
    +struct<S:int>
    +-- !query 5 output
    +32768
    +
    +
    +-- !query 6
    +select 1L, 1 L, 2147483648 L, 9223372036854775807 L
    +-- !query 6 schema
    +struct<1:bigint,L:int,L:bigint,L:bigint>
    +-- !query 6 output
    +1	1	2147483648	9223372036854775807
    +
    +
    +-- !query 7
    +select 9223372036854775808 L
    +-- !query 7 schema
    +struct<L:decimal(19,0)>
    +-- !query 7 output
    +9223372036854775808
    +
    +
    +-- !query 8
    +select 1, -1
    +-- !query 8 schema
    +struct<1:int,(-1):int>
    +-- !query 8 output
    +1	-1
    +
    +
    +-- !query 9
    +select 2147483647, -2147483648
    +-- !query 9 schema
    +struct<2147483647:int,(-2147483648):bigint>
    +-- !query 9 output
    +2147483647	-2147483648
    +
    +
    +-- !query 10
    +select 2147483648, -2147483649
    +-- !query 10 schema
    +struct<2147483648:bigint,(-2147483649):bigint>
    +-- !query 10 output
    +2147483648	-2147483649
    +
    +
    +-- !query 11
    +select 9223372036854775807, -9223372036854775808
    --- End diff --
    
    this is a bug reported in SPARK-17013


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


Mime
View raw message