BEGIN;
-- bigistore istore_io should persist istores;
-- ./spec/istore/istore_io_spec.rb:9;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT '-2147483647 => 10, -10 => -9223372036854775807, 0 => 5, 10 => 9223372036854775806, 2147483647 => 10'::bigistore;
SELECT * FROM istore_io;
                                                   bigistore                                                   
---------------------------------------------------------------------------------------------------------------
 "-2147483647"=>"10", "-10"=>"-9223372036854775807", "0"=>"5", "10"=>"9223372036854775806", "2147483647"=>"10"
(1 row)

ROLLBACK;
BEGIN;
-- bigistore istore_io should persist istores;
-- ./spec/istore/istore_io_spec.rb:15;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT '"-1"=>"+1","1"=>"2"'::bigistore;
SELECT * FROM istore_io;
      bigistore      
---------------------
 "-1"=>"1", "1"=>"2"
(1 row)

ROLLBACK;
BEGIN;
-- bigistore istore_io should persist istores;
-- ./spec/istore/istore_io_spec.rb:21;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT ' "-1"=>"+1","1"=>"2"'::bigistore;
SELECT * FROM istore_io;
      bigistore      
---------------------
 "-1"=>"1", "1"=>"2"
(1 row)

ROLLBACK;
BEGIN;
-- bigistore istore_io should persist empty istores;
-- ./spec/istore/istore_io_spec.rb:27;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT ''::bigistore;
SELECT * FROM istore_io;
 bigistore 
-----------
 
(1 row)

ROLLBACK;
BEGIN;
-- bigistore istore_io should turn istore to json;
-- ./spec/istore/istore_io_spec.rb:32;
CREATE EXTENSION istore;
SELECT istore_to_json('-2147483647 => 10, -10 => -9223372036854775807, 0 => 5, 10 => 9223372036854775806, 2147483647 => 10'::bigistore);
                                            istore_to_json                                             
-------------------------------------------------------------------------------------------------------
 {"-2147483647": 10, "-10": -9223372036854775807, "0": 5, "10": 9223372036854775806, "2147483647": 10}
(1 row)

ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report invalid value input;
-- ./spec/istore/istore_io_spec.rb:38;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>foo, 5=>17'::bigistore;
ERROR:  invalid input syntax for istore: "2=>4, 1=>foo, 5=>17"
LINE 1: SELECT '2=>4, 1=>foo, 5=>17'::bigistore;
               ^
DETAIL:  unexpected sign f, in istore value
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report invalid value input;
-- ./spec/istore/istore_io_spec.rb:42;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>5foo, 5=>17'::bigistore;
ERROR:  invalid input syntax for istore: "2=>4, 1=>5foo, 5=>17"
LINE 1: SELECT '2=>4, 1=>5foo, 5=>17'::bigistore;
               ^
DETAIL:  unexpected sign f, in istore value
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report to big value input;
-- ./spec/istore/istore_io_spec.rb:46;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>18446744073709551612, 5=>17'::bigistore;
ERROR:  istore "2=>4, 1=>18446744073709551612, 5=>17" is out of range
LINE 1: SELECT '2=>4, 1=>18446744073709551612, 5=>17'::bigistore;
               ^
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report to small value input;
-- ./spec/istore/istore_io_spec.rb:51;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>-18446744073709551614, 5=>17'::bigistore;
ERROR:  istore "2=>4, 1=>-18446744073709551614, 5=>17" is out of range
LINE 1: SELECT '2=>4, 1=>-18446744073709551614, 5=>17'::bigistore;
               ^
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report invalid key input;
-- ./spec/istore/istore_io_spec.rb:56;
CREATE EXTENSION istore;
SELECT '2=>4, 54foo=>5, 5=>17'::bigistore;
ERROR:  invalid input syntax for istore: "2=>4, 54foo=>5, 5=>17"
LINE 1: SELECT '2=>4, 54foo=>5, 5=>17'::bigistore;
               ^
DETAIL:  unexpected sign f, in istore key
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report invalid key input;
-- ./spec/istore/istore_io_spec.rb:60;
CREATE EXTENSION istore;
SELECT '2=>4, foo=>5, 5=>17'::bigistore;
ERROR:  invalid input syntax for istore: "2=>4, foo=>5, 5=>17"
LINE 1: SELECT '2=>4, foo=>5, 5=>17'::bigistore;
               ^
DETAIL:  unexpected sign f, in istore key
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report to big key input;
-- ./spec/istore/istore_io_spec.rb:64;
CREATE EXTENSION istore;
SELECT '2=>4, 4000000000=>5, 5=>17'::bigistore;
ERROR:  istore "2=>4, 4000000000=>5, 5=>17" is out of range
LINE 1: SELECT '2=>4, 4000000000=>5, 5=>17'::bigistore;
               ^
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report to small key input;
-- ./spec/istore/istore_io_spec.rb:68;
CREATE EXTENSION istore;
SELECT '2=>4, -4000000000=>5, 5=>17'::bigistore;
ERROR:  istore "2=>4, -4000000000=>5, 5=>17" is out of range
LINE 1: SELECT '2=>4, -4000000000=>5, 5=>17'::bigistore;
               ^
ROLLBACK;
BEGIN;
-- bigistore istore_io invalid input should report invalid delimiter input;
-- ./spec/istore/istore_io_spec.rb:72;
CREATE EXTENSION istore;
SELECT '2=>4, 10=5, 5=>17'::bigistore;
ERROR:  invalid input syntax for istore: "2=>4, 10=5, 5=>17"
LINE 1: SELECT '2=>4, 10=5, 5=>17'::bigistore;
               ^
DETAIL:  unexpected sign 5, expected '>'
ROLLBACK;
BEGIN;
-- istore istore_io should persist istores;
-- ./spec/istore/istore_io_spec.rb:9;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT '-2147483647 => 10, -10 => -2147483647, 0 => 5, 10 => 2147483647, 2147483647 => 10'::istore;
SELECT * FROM istore_io;
                                           istore                                            
---------------------------------------------------------------------------------------------
 "-2147483647"=>"10", "-10"=>"-2147483647", "0"=>"5", "10"=>"2147483647", "2147483647"=>"10"
(1 row)

ROLLBACK;
BEGIN;
-- istore istore_io should persist istores;
-- ./spec/istore/istore_io_spec.rb:15;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT '"-1"=>"+1","1"=>"2"'::istore;
SELECT * FROM istore_io;
       istore        
---------------------
 "-1"=>"1", "1"=>"2"
(1 row)

ROLLBACK;
BEGIN;
-- istore istore_io should persist istores;
-- ./spec/istore/istore_io_spec.rb:21;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT ' "-1"=>"+1","1"=>"2"'::istore;
SELECT * FROM istore_io;
       istore        
---------------------
 "-1"=>"1", "1"=>"2"
(1 row)

ROLLBACK;
BEGIN;
-- istore istore_io should persist empty istores;
-- ./spec/istore/istore_io_spec.rb:27;
CREATE EXTENSION istore;
CREATE TABLE istore_io AS SELECT ''::istore;
SELECT * FROM istore_io;
 istore 
--------
 
(1 row)

ROLLBACK;
BEGIN;
-- istore istore_io should turn istore to json;
-- ./spec/istore/istore_io_spec.rb:32;
CREATE EXTENSION istore;
SELECT istore_to_json('-2147483647 => 10, -10 => -2147483647, 0 => 5, 10 => 2147483647, 2147483647 => 10'::istore);
                                   istore_to_json                                    
-------------------------------------------------------------------------------------
 {"-2147483647": 10, "-10": -2147483647, "0": 5, "10": 2147483647, "2147483647": 10}
(1 row)

ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report invalid value input;
-- ./spec/istore/istore_io_spec.rb:38;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>foo, 5=>17'::istore;
ERROR:  invalid input syntax for istore: "2=>4, 1=>foo, 5=>17"
LINE 1: SELECT '2=>4, 1=>foo, 5=>17'::istore;
               ^
DETAIL:  unexpected sign f, in istore value
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report invalid value input;
-- ./spec/istore/istore_io_spec.rb:42;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>5foo, 5=>17'::istore;
ERROR:  invalid input syntax for istore: "2=>4, 1=>5foo, 5=>17"
LINE 1: SELECT '2=>4, 1=>5foo, 5=>17'::istore;
               ^
DETAIL:  unexpected sign f, in istore value
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report to big value input;
-- ./spec/istore/istore_io_spec.rb:46;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>4294967294, 5=>17'::istore;
ERROR:  integer out of range
LINE 1: SELECT '2=>4, 1=>4294967294, 5=>17'::istore;
               ^
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report to small value input;
-- ./spec/istore/istore_io_spec.rb:51;
CREATE EXTENSION istore;
SELECT '2=>4, 1=>-4294967294, 5=>17'::istore;
ERROR:  integer out of range
LINE 1: SELECT '2=>4, 1=>-4294967294, 5=>17'::istore;
               ^
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report invalid key input;
-- ./spec/istore/istore_io_spec.rb:56;
CREATE EXTENSION istore;
SELECT '2=>4, 54foo=>5, 5=>17'::istore;
ERROR:  invalid input syntax for istore: "2=>4, 54foo=>5, 5=>17"
LINE 1: SELECT '2=>4, 54foo=>5, 5=>17'::istore;
               ^
DETAIL:  unexpected sign f, in istore key
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report invalid key input;
-- ./spec/istore/istore_io_spec.rb:60;
CREATE EXTENSION istore;
SELECT '2=>4, foo=>5, 5=>17'::istore;
ERROR:  invalid input syntax for istore: "2=>4, foo=>5, 5=>17"
LINE 1: SELECT '2=>4, foo=>5, 5=>17'::istore;
               ^
DETAIL:  unexpected sign f, in istore key
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report to big key input;
-- ./spec/istore/istore_io_spec.rb:64;
CREATE EXTENSION istore;
SELECT '2=>4, 4000000000=>5, 5=>17'::istore;
ERROR:  istore "2=>4, 4000000000=>5, 5=>17" is out of range
LINE 1: SELECT '2=>4, 4000000000=>5, 5=>17'::istore;
               ^
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report to small key input;
-- ./spec/istore/istore_io_spec.rb:68;
CREATE EXTENSION istore;
SELECT '2=>4, -4000000000=>5, 5=>17'::istore;
ERROR:  istore "2=>4, -4000000000=>5, 5=>17" is out of range
LINE 1: SELECT '2=>4, -4000000000=>5, 5=>17'::istore;
               ^
ROLLBACK;
BEGIN;
-- istore istore_io invalid input should report invalid delimiter input;
-- ./spec/istore/istore_io_spec.rb:72;
CREATE EXTENSION istore;
SELECT '2=>4, 10=5, 5=>17'::istore;
ERROR:  invalid input syntax for istore: "2=>4, 10=5, 5=>17"
LINE 1: SELECT '2=>4, 10=5, 5=>17'::istore;
               ^
DETAIL:  unexpected sign 5, expected '>'
ROLLBACK;