Test convert-function-test.Bug-3460.sql (id 627a57e19bb5) (out)
convert-function-test.Bug-3460.stable.err.int128.FILTERED 2018-08-03 01:26:03.791722072 +0200convert-function-test.Bug-3460.test.err.FILTERED 2018-08-03 01:26:03.947726076 +0200
1 Statistics about stderr of test 'convert-function-test.Bug-3460` in directory 'sql/test/BugTracker-2016`: 1 1 Statistics about stderr of test 'convert-function-test.Bug-3460` in directory 'sql/test/BugTracker-2016`: 1
2 2611 lines, 21005 words, 125382 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1232 lines, 9766 words, 61449 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 2611 lines, 21005 words, 125382 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1232 lines, 9766 words, 61449 chars in lines not matching '^$|^(\| |)#` 3
4 # 3769 lines, 30235 words, 206514 chars in all lines 4 ! 4 # 1743 lines, 13886 words, 97098 chars in all lines 4
5 5 5 5
..................
# 3769 lines, 30235 words, 2
8 8 8 8
9 # 19:10:34 > 9 ! 9 # 01:25:51 > 9
10 # 19:10:34 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=37752" "--set" "mapi_usock=/var/tmp/mtest-10540/.s.monetdb.37752" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch2/dinther/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2016" "--set" "embedded_r=yes" 10 ! 10 # 01:25:51 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=38669" "--set" "mapi_usock=/var/tmp/mtest-7710/.s.monetdb.38669" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/627a57e19bb5-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2016" "--dbextra=/export/scratch1/home/monet/testing/627a57e19bb5-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2016_transient" "--set" "embedded_c=true" 10
11 # 19:10:34 > 11 ! 11 # 01:25:51 > 11
12 12 12 12
+ 13 mserver5: /export/scratch1/home/monet/testing/627a57e19bb5-1/MonetDB/gdk/gdk_bat.c:2276: BATassertProps: Assertion `!b->tkey' failed. 13
13 13 14 14
14 # 19:10:35 > 14 ! 15 Aborted 15
15 # 19:10:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-10540" "--port=37752" 15 ! 16 PID: 27013 (mserver5) 16
16 # 19:10:35 > 16 ! 17 UID: 9375 (monet) 17
+ 18 GID: 60020 (da) 18
+ 19 Signal: 6 (ABRT) 19
+ 20 Timestamp: Fri 2018-08-03 01:25:52 CEST (11s ago) 20
+ 21 Command Line: mserver5 --debug=10 --set gdk_nr_threads 0 --set mapi_open true --set mapi_port 38669 --set mapi_usock /var/tmp/mtest-7710/.s.monetdb.38669 --set monet_prompt --forcemito --set gdk_vm_maxsize 8589934592 --dbpath=/export/scratch1/home/monet/testing/627a57e19bb5-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2016 --dbextra=/export/scratch1/home/monet/testing/627a57e19bb5-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2016_transient --set embedded_c true 21
+ 22 Executable: /export/scratch1/home/monet/testing/627a57e19bb5-1/install/bin/mserver5 22
+ 23 Control Group: /user.slice/user-9375.slice/session-3180.scope 23
+ 24 Unit: session-3180.scope 24
+ 25 Slice: user-9375.slice 25
+ 26 Session: 3180 26
+ 27 Owner UID: 9375 (monet) 27
+ 28 Boot ID: ceeb72adeab54012a8eb6c554d93db84 28
+ 29 Machine ID: ce9ef9ca0efa4c3ca8d5f238b2916d86 29
+ 30 Hostname: lab02.da.cwi.nl 30
+ 31 Storage: /var/lib/systemd/coredump/core.mserver5.9375.ceeb72adeab54012a8eb6c554d93db84.27013.1533252352000000.lz4 31
+ 32 Message: Process 27013 (mserver5) of user 9375 dumped core. 32
17 17 33 33
18 #~ MAPI = (monetdb) /var/tmp/mtest-10540/.s.monetdb.37752 18 ! 34 Stack trace of thread 27043: 34
+ 35 #0 0x00007fd1eb760feb raise (libc.so.6) 35
+ 36 #1 0x00007fd1eb74b5c1 abort (libc.so.6) 36
+ 37 #2 0x00007fd1eb74b491 __assert_fail_base.cold.0 (libc.so.6) 37
+ 38 #3 0x00007fd1eb759752 __assert_fail (libc.so.6) 38
+ 39 #4 0x00007fd1eec84b47 BATassertProps (libbat.so.16) 39
+ 40 #5 0x00007fd1eec19360 BBPkeepref (libbat.so.16) 40
+ 41 #6 0x00007fd1ef282009 CMDconvertbat (libmonetdb5.so.24) 41
+ 42 #7 0x00007fd1ef286b71 CMDconvertsignal_bte (libmonetdb5.so.24) 42
+ 43 #8 0x00007fd1ef12499a runMALsequence (libmonetdb5.so.24) 43
+ 44 #9 0x00007fd1ef128ddd runMAL (libmonetdb5.so.24) 44
+ 45 #10 0x00007fd1e5e62b91 SQLrun (lib_sql.so) 45
+ 46 #11 0x00007fd1e5e64c66 SQLengineIntern (lib_sql.so) 46
+ 47 #12 0x00007fd1e5e616b8 SQLengine (lib_sql.so) 47
+ 48 #13 0x00007fd1ef1520b8 runPhase (libmonetdb5.so.24) 48
+ 49 #14 0x00007fd1ef15359d runScenario (libmonetdb5.so.24) 49
+ 50 #15 0x00007fd1ef153e52 MSserveClient (libmonetdb5.so.24) 50
+ 51 #16 0x00007fd1ef1547fe MSscheduleClient (libmonetdb5.so.24) 51
+ 52 #17 0x00007fd1ef2200fb doChallenge (libmonetdb5.so.24) 52
+ 53 #18 0x00007fd1eec86f8b thread_starter (libbat.so.16) 53
+ 54 #19 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 54
+ 55 #20 0x00007fd1eb8240df __clone (libc.so.6) 55
+ 56 56
+ 57 Stack trace of thread 27016: 57
+ 58 #0 0x00007fd1eb81ba37 __select (libc.so.6) 58
+ 59 #1 0x00007fd1eec89c39 MT_sleep_ms (libbat.so.16) 59
+ 60 #2 0x00007fd1ef14b2f0 profilerHeartbeat (libmonetdb5.so.24) 60
+ 61 #3 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 61
+ 62 #4 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 62
+ 63 #5 0x00007fd1eb8240df __clone (libc.so.6) 63
+ 64 64
+ 65 Stack trace of thread 27017: 65
+ 66 #0 0x00007fd1eb81ba37 __select (libc.so.6) 66
+ 67 #1 0x00007fd1ef21d0d7 SERVERlistenThread (libmonetdb5.so.24) 67
+ 68 #2 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 68
+ 69 #3 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 69
+ 70 #4 0x00007fd1eb8240df __clone (libc.so.6) 70
+ 71 71
+ 72 Stack trace of thread 27035: 72
+ 73 #0 0x00007fd1ebaf8de6 do_futex_wait.constprop.1 (libpthread.so.0) 73
+ 74 #1 0x00007fd1ebaf8ed8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 74
+ 75 #2 0x00007fd1ef12a4b8 q_dequeue (libmonetdb5.so.24) 75
+ 76 #3 0x00007fd1ef12b09d DFLOWworker (libmonetdb5.so.24) 76
+ 77 #4 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 77
+ 78 #5 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 78
+ 79 #6 0x00007fd1eb8240df __clone (libc.so.6) 79
+ 80 80
+ 81 Stack trace of thread 27036: 81
+ 82 #0 0x00007fd1ebaf8de6 do_futex_wait.constprop.1 (libpthread.so.0) 82
+ 83 #1 0x00007fd1ebaf8ed8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 83
+ 84 #2 0x00007fd1ef12a4b8 q_dequeue (libmonetdb5.so.24) 84
+ 85 #3 0x00007fd1ef12b09d DFLOWworker (libmonetdb5.so.24) 85
+ 86 #4 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 86
+ 87 #5 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 87
+ 88 #6 0x00007fd1eb8240df __clone (libc.so.6) 88
+ 89 89
+ 90 Stack trace of thread 27039: 90
+ 91 #0 0x00007fd1eb81ba37 __select (libc.so.6) 91
+ 92 #1 0x00007fd1eec89c39 MT_sleep_ms (libbat.so.16) 92
+ 93 #2 0x00007fd1e60006f7 idle_manager (lib_sql.so) 93
+ 94 #3 0x00007fd1e5f295de mvc_idlemanager (lib_sql.so) 94
+ 95 #4 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 95
+ 96 #5 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 96
+ 97 #6 0x00007fd1eb8240df __clone (libc.so.6) 97
+ 98 98
+ 99 Stack trace of thread 27013: 99
+ 100 #0 0x00007fd1eb8150c4 __read (libc.so.6) 100
+ 101 #1 0x00007fd1eb7a6908 _IO_file_underflow@@GLIBC_2.2.5 (libc.so.6) 101
+ 102 #2 0x00007fd1eb7a7a22 _IO_default_uflow (libc.so.6) 102
+ 103 #3 0x00007fd1eb79b35a _IO_getline_info (libc.so.6) 103
+ 104 #4 0x00007fd1eb79a3db _IO_fgets (libc.so.6) 104
+ 105 #5 0x00007fd1ee2b51c5 fgets (libstream.so.11) 105
+ 106 #6 0x00007fd1ef10a6d6 MCreadClient (libmonetdb5.so.24) 106
+ 107 #7 0x00007fd1ef15537b MALreader (libmonetdb5.so.24) 107
+ 108 #8 0x00007fd1ef151e24 runPhase (libmonetdb5.so.24) 108
+ 109 #9 0x00007fd1ef15359d runScenario (libmonetdb5.so.24) 109
+ 110 #10 0x00007fd1ef153e52 MSserveClient (libmonetdb5.so.24) 110
+ 111 #11 0x0000000000403bf3 main (mserver5) 111
+ 112 #12 0x00007fd1eb74d24b __libc_start_main (libc.so.6) 112
+ 113 #13 0x00000000004041ca _start (mserver5) 113
+ 114 114
+ 115 Stack trace of thread 27037: 115
+ 116 #0 0x00007fd1ebaf8de6 do_futex_wait.constprop.1 (libpthread.so.0) 116
+ 117 #1 0x00007fd1ebaf8ed8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 117
+ 118 #2 0x00007fd1ef12a4b8 q_dequeue (libmonetdb5.so.24) 118
+ 119 #3 0x00007fd1ef12b09d DFLOWworker (libmonetdb5.so.24) 119
+ 120 #4 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 120
+ 121 #5 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 121
+ 122 #6 0x00007fd1eb8240df __clone (libc.so.6) 122
+ 123 123
+ 124 Stack trace of thread 27038: 124
+ 125 #0 0x00007fd1eb81ba37 __select (libc.so.6) 125
+ 126 #1 0x00007fd1eec89c39 MT_sleep_ms (libbat.so.16) 126
+ 127 #2 0x00007fd1e6002af6 store_manager (lib_sql.so) 127
+ 128 #3 0x00007fd1e5f2954e mvc_logmanager (lib_sql.so) 128
+ 129 #4 0x00007fd1eec86f30 thread_starter_simple (libbat.so.16) 129
+ 130 #5 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 130
+ 131 #6 0x00007fd1eb8240df __clone (libc.so.6) 131
+ 132 132
+ 133 Stack trace of thread 27048: 133
+ 134 #0 0x00007fd1eb81ba37 __select (libc.so.6) 134
+ 135 #1 0x00007fd1eec89c39 MT_sleep_ms (libbat.so.16) 135
+ 136 #2 0x00007fd1eebf6495 BATidxsync (libbat.so.16) 136
+ 137 #3 0x00007fd1eec86f8b thread_starter (libbat.so.16) 137
+ 138 #4 0x00007fd1ebaf0594 start_thread (libpthread.so.0) 138
+ 139 #5 0x00007fd1eb8240df __clone (libc.so.6) 139
+ 140 140
+ 141 # 01:25:52 > 141
+ 142 # 01:25:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-7710" "--port=38669" 142
+ 143 # 01:25:52 > 143
+ 144 144
+ 145 #~ MAPI = (monetdb) /var/tmp/mtest-7710/.s.monetdb.38669 145
19 QUERY = SELECT v, convert(v, bit) from T_BOOLEAN; -- BIT not valid data type 19 146 QUERY = SELECT v, convert(v, bit) from T_BOOLEAN; -- BIT not valid data type 146
..................
# the original non-normalized output was
1612 CODE = 22000 1612 1739 CODE = 22000 1739
1613 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1613 ! 1740 #~ MAPI = (monetdb) /var/tmp/mtest-7710/.s.monetdb.38669 1740
1614 QUERY = SELECT v, cast(v as char) from T_double where v between 0 and 1; 1614 ! 1741 ACTION= mapi_query_done 1741
1615 ERROR = !value too long for type (var)char(1) 1615 ! 1742 QUERY = SELECT v, cast(v as smallint) from T_double where v between -32767 and 32767; 1742
1616 CODE = 22001 1616 ! 1743 ERROR = !write error on stream 1743
1617 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1617 -
1618 QUERY = SELECT v, cast(v as varchar) from T_double; -- missing length specification 1618 -
1619 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 1619 -
1620 !syntax/parse error, 1620 -
1621 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1621 -
1622 CODE = 42000 1622 -
1623 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1623 -
1624 QUERY = SELECT v, cast(v as longvarchar) from T_double; -- LONGVARCHAR not valid data type 1624 -
1625 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 1625 -
1626 !syntax/parse error, 1626 -
1627 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1627 -
1628 CODE = 22000 1628 -
1629 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1629 -
1630 QUERY = SELECT v, cast(v as long varchar) from T_double; -- LONG VARCHAR not valid data type 1630 -
1631 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 1631 -
1632 !syntax/parse error, 1632 -
1633 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 1633 -
1634 CODE = 22000 1634 -
1635 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1635 -
1636 QUERY = SELECT v, cast(v as Binary) from T_double; -- BINARY not valid data type 1636 -
1637 ERROR = !syntax/parse error, 1637 -
1638 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 1638 -
1639 CODE = 42000 1639 -
1640 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1640 -
1641 QUERY = SELECT v, cast(v as varBinary) from T_double; -- VARBINARY not valid data type 1641 -
1642 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 1642 -
1643 !syntax/parse error, 1643 -
1644 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1644 -
1645 CODE = 22000 1645 -
1646 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1646 -
1647 QUERY = SELECT v, cast(v as longvarBinary) from T_double; -- LONGVARBINARY not valid data type 1647 -
1648 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 1648 -
1649 !syntax/parse error, 1649 -
1650 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1650 -
1651 CODE = 22000 1651 -
1652 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1652 -
1653 QUERY = SELECT v, cast(v as Blob) from T_double; -- conversion not supported 1653 -
1654 ERROR = !types double(53,0) and blob(0,0) are not equal for column 'v' 1654 -
1655 CODE = 42000 1655 -
1656 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1656 -
1657 QUERY = SELECT v, cast(v as date) from T_double; -- conversion not supported 1657 -
1658 ERROR = !types double(53,0) and date(0,0) are not equal for column 'v' 1658 -
1659 CODE = 42000 1659 -
1660 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1660 -
1661 QUERY = SELECT v, cast(v as time) from T_double; -- conversion not supported 1661 -
1662 ERROR = !types double(53,0) and time(1,0) are not equal for column 'v' 1662 -
1663 CODE = 42000 1663 -
1664 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1664 -
1665 QUERY = SELECT v, cast(v as timestamp) from T_double; -- conversion not supported 1665 -
1666 ERROR = !types double(53,0) and timestamp(7,0) are not equal for column 'v' 1666 -
1667 CODE = 42000 1667 -
1668 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1668 -
1669 QUERY = SELECT v, cast(v as time with timezone) from T_double; -- data type not supported (parse error) 1669 -
1670 ERROR = !syntax/parse error, 1670 -
1671 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 1671 -
1672 CODE = 42000 1672 -
1673 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1673 -
1674 QUERY = SELECT v, cast(v as timestamp with timezone) from T_double; -- data type not supported (parse error) 1674 -
1675 ERROR = !syntax/parse error, 1675 -
1676 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 1676 -
1677 CODE = 42000 1677 -
1678 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1678 -
1679 QUERY = SELECT v, cast(v as timetz) from T_double; -- conversion not supported 1679 -
1680 ERROR = !types double(53,0) and timetz(7,0) are not equal for column 'v' 1680 -
1681 CODE = 42000 1681 -
1682 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1682 -
1683 QUERY = SELECT v, cast(v as timestamptz) from T_double; -- conversion not supported 1683 -
1684 ERROR = !types double(53,0) and timestamptz(7,0) are not equal for column 'v' 1684 -
1685 CODE = 42000 1685 -
1686 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1686 -
1687 QUERY = SELECT v, convert(v, boolean) from T_num; 1687 -
1688 ERROR = !types decimal(10,0) and boolean(1,0) are not equal for column 'v' 1688 -
1689 CODE = 42000 1689 -
1690 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1690 -
1691 QUERY = SELECT v, convert(v, bit) from T_num; -- BIT not valid data type 1691 -
1692 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 1692 -
1693 !syntax/parse error, 1693 -
1694 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1694 -
1695 CODE = 22000 1695 -
1696 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1696 -
1697 QUERY = SELECT v, convert(v, varchar) from T_num; -- missing length specification 1697 -
1698 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 1698 -
1699 !syntax/parse error, 1699 -
1700 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1700 -
1701 CODE = 42000 1701 -
1702 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1702 -
1703 QUERY = SELECT v, convert(v, longvarchar) from T_num; -- LONGVARCHAR not valid data type 1703 -
1704 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 1704 -
1705 !syntax/parse error, 1705 -
1706 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1706 -
1707 CODE = 22000 1707 -
1708 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1708 -
1709 QUERY = SELECT v, convert(v, long varchar) from T_num; -- LONG VARCHAR not valid data type 1709 -
1710 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 1710 -
1711 !syntax/parse error, 1711 -
1712 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 1712 -
1713 CODE = 22000 1713 -
1714 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1714 -
1715 QUERY = SELECT v, convert(v, Binary) from T_num; -- BINARY not valid data type 1715 -
1716 ERROR = !syntax/parse error, 1716 -
1717 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 1717 -
1718 CODE = 42000 1718 -
1719 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1719 -
1720 QUERY = SELECT v, convert(v, varBinary) from T_num; -- VARBINARY not valid data type 1720 -
1721 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 1721 -
1722 !syntax/parse error, 1722 -
1723 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1723 -
1724 CODE = 22000 1724 -
1725 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1725 -
1726 QUERY = SELECT v, convert(v, longvarBinary) from T_num; -- LONGVARBINARY not valid data type 1726 -
1727 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 1727 -
1728 !syntax/parse error, 1728 -
1729 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1729 -
1730 CODE = 22000 1730 -
1731 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1731 -
1732 QUERY = SELECT v, convert(v, Blob) from T_num; -- conversion not supported 1732 -
1733 ERROR = !types decimal(10,0) and blob(0,0) are not equal for column 'v' 1733 -
1734 CODE = 42000 1734 -
1735 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1735 -
1736 QUERY = SELECT v, convert(v, date) from T_num; -- conversion not supported 1736 -
1737 ERROR = !types decimal(10,0) and date(0,0) are not equal for column 'v' 1737 -
1738 CODE = 42000 1738 -
1739 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1739 -
1740 QUERY = SELECT v, convert(v, time) from T_num; -- conversion not supported 1740 -
1741 ERROR = !types decimal(10,0) and time(1,0) are not equal for column 'v' 1741 -
1742 CODE = 42000 1742 -
1743 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1743 -
1744 QUERY = SELECT v, convert(v, timestamp) from T_num; -- conversion not supported 1744 -
1745 ERROR = !types decimal(10,0) and timestamp(7,0) are not equal for column 'v' 1745 -
1746 CODE = 42000 1746 -
1747 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1747 -
1748 QUERY = SELECT v, convert(v, time with timezone) from T_num; -- data type not supported (parse error) 1748 -
1749 ERROR = !syntax/parse error, 1749 -
1750 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 1750 -
1751 CODE = 42000 1751 -
1752 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1752 -
1753 QUERY = SELECT v, convert(v, timestamp with timezone) from T_num; -- data type not supported (parse error) 1753 -
1754 ERROR = !syntax/parse error, 1754 -
1755 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 1755 -
1756 CODE = 42000 1756 -
1757 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1757 -
1758 QUERY = SELECT v, convert(v, timetz) from T_num; -- conversion not supported 1758 -
1759 ERROR = !types decimal(10,0) and timetz(7,0) are not equal for column 'v' 1759 -
1760 CODE = 42000 1760 -
1761 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1761 -
1762 QUERY = SELECT v, convert(v, timestamptz) from T_num; -- conversion not supported 1762 -
1763 ERROR = !types decimal(10,0) and timestamptz(7,0) are not equal for column 'v' 1763 -
1764 CODE = 42000 1764 -
1765 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1765 -
1766 QUERY = SELECT v, cast(v as boolean) from T_num; 1766 -
1767 ERROR = !types decimal(10,0) and boolean(1,0) are not equal for column 'v' 1767 -
1768 CODE = 42000 1768 -
1769 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1769 -
1770 QUERY = SELECT v, cast(v as bit) from T_num; -- BIT not valid data type 1770 -
1771 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 1771 -
1772 !syntax/parse error, 1772 -
1773 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1773 -
1774 CODE = 22000 1774 -
1775 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1775 -
1776 QUERY = SELECT v, cast(v as varchar) from T_num; -- missing length specification 1776 -
1777 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 1777 -
1778 !syntax/parse error, 1778 -
1779 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1779 -
1780 CODE = 42000 1780 -
1781 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1781 -
1782 QUERY = SELECT v, cast(v as longvarchar) from T_num; -- LONGVARCHAR not valid data type 1782 -
1783 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 1783 -
1784 !syntax/parse error, 1784 -
1785 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1785 -
1786 CODE = 22000 1786 -
1787 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1787 -
1788 QUERY = SELECT v, cast(v as long varchar) from T_num; -- LONG VARCHAR not valid data type 1788 -
1789 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 1789 -
1790 !syntax/parse error, 1790 -
1791 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 1791 -
1792 CODE = 22000 1792 -
1793 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1793 -
1794 QUERY = SELECT v, cast(v as Binary) from T_num; -- BINARY not valid data type 1794 -
1795 ERROR = !syntax/parse error, 1795 -
1796 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 1796 -
1797 CODE = 42000 1797 -
1798 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1798 -
1799 QUERY = SELECT v, cast(v as varBinary) from T_num; -- VARBINARY not valid data type 1799 -
1800 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 1800 -
1801 !syntax/parse error, 1801 -
1802 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1802 -
1803 CODE = 22000 1803 -
1804 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1804 -
1805 QUERY = SELECT v, cast(v as longvarBinary) from T_num; -- LONGVARBINARY not valid data type 1805 -
1806 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 1806 -
1807 !syntax/parse error, 1807 -
1808 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1808 -
1809 CODE = 22000 1809 -
1810 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1810 -
1811 QUERY = SELECT v, cast(v as Blob) from T_num; -- conversion not supported 1811 -
1812 ERROR = !types decimal(10,0) and blob(0,0) are not equal for column 'v' 1812 -
1813 CODE = 42000 1813 -
1814 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1814 -
1815 QUERY = SELECT v, cast(v as date) from T_num; -- conversion not supported 1815 -
1816 ERROR = !types decimal(10,0) and date(0,0) are not equal for column 'v' 1816 -
1817 CODE = 42000 1817 -
1818 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1818 -
1819 QUERY = SELECT v, cast(v as time) from T_num; -- conversion not supported 1819 -
1820 ERROR = !types decimal(10,0) and time(1,0) are not equal for column 'v' 1820 -
1821 CODE = 42000 1821 -
1822 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1822 -
1823 QUERY = SELECT v, cast(v as timestamp) from T_num; -- conversion not supported 1823 -
1824 ERROR = !types decimal(10,0) and timestamp(7,0) are not equal for column 'v' 1824 -
1825 CODE = 42000 1825 -
1826 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1826 -
1827 QUERY = SELECT v, cast(v as time with timezone) from T_num; -- data type not supported (parse error) 1827 -
1828 ERROR = !syntax/parse error, 1828 -
1829 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 1829 -
1830 CODE = 42000 1830 -
1831 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1831 -
1832 QUERY = SELECT v, cast(v as timestamp with timezone) from T_num; -- data type not supported (parse error) 1832 -
1833 ERROR = !syntax/parse error, 1833 -
1834 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 1834 -
1835 CODE = 42000 1835 -
1836 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1836 -
1837 QUERY = SELECT v, cast(v as timetz) from T_num; -- conversion not supported 1837 -
1838 ERROR = !types decimal(10,0) and timetz(7,0) are not equal for column 'v' 1838 -
1839 CODE = 42000 1839 -
1840 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1840 -
1841 QUERY = SELECT v, cast(v as timestamptz) from T_num; -- conversion not supported 1841 -
1842 ERROR = !types decimal(10,0) and timestamptz(7,0) are not equal for column 'v' 1842 -
1843 CODE = 42000 1843 -
1844 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1844 -
1845 QUERY = SELECT v, convert(v, boolean) from T_dec; 1845 -
1846 ERROR = !types decimal(17,7) and boolean(1,0) are not equal for column 'v' 1846 -
1847 CODE = 42000 1847 -
1848 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1848 -
1849 QUERY = SELECT v, convert(v, bit) from T_dec; -- BIT not valid data type 1849 -
1850 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 1850 -
1851 !syntax/parse error, 1851 -
1852 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1852 -
1853 CODE = 22000 1853 -
1854 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1854 -
1855 QUERY = SELECT v, convert(v, char) from T_dec where v between 0 and 1; 1855 -
1856 ERROR = !value too long for type (var)char(1) 1856 -
1857 CODE = 22001 1857 -
1858 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1858 -
1859 QUERY = SELECT v, convert(v, varchar) from T_dec; -- missing length specification 1859 -
1860 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 1860 -
1861 !syntax/parse error, 1861 -
1862 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1862 -
1863 CODE = 42000 1863 -
1864 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1864 -
1865 QUERY = SELECT v, convert(v, longvarchar) from T_dec; -- LONGVARCHAR not valid data type 1865 -
1866 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 1866 -
1867 !syntax/parse error, 1867 -
1868 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1868 -
1869 CODE = 22000 1869 -
1870 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1870 -
1871 QUERY = SELECT v, convert(v, long varchar) from T_dec; -- LONG VARCHAR not valid data type 1871 -
1872 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 1872 -
1873 !syntax/parse error, 1873 -
1874 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 1874 -
1875 CODE = 22000 1875 -
1876 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1876 -
1877 QUERY = SELECT v, convert(v, Binary) from T_dec; -- BINARY not valid data type 1877 -
1878 ERROR = !syntax/parse error, 1878 -
1879 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 1879 -
1880 CODE = 42000 1880 -
1881 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1881 -
1882 QUERY = SELECT v, convert(v, varBinary) from T_dec; -- VARBINARY not valid data type 1882 -
1883 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 1883 -
1884 !syntax/parse error, 1884 -
1885 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1885 -
1886 CODE = 22000 1886 -
1887 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1887 -
1888 QUERY = SELECT v, convert(v, longvarBinary) from T_dec; -- LONGVARBINARY not valid data type 1888 -
1889 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 1889 -
1890 !syntax/parse error, 1890 -
1891 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1891 -
1892 CODE = 22000 1892 -
1893 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1893 -
1894 QUERY = SELECT v, convert(v, Blob) from T_dec; -- conversion not supported 1894 -
1895 ERROR = !types decimal(17,7) and blob(0,0) are not equal for column 'v' 1895 -
1896 CODE = 42000 1896 -
1897 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1897 -
1898 QUERY = SELECT v, convert(v, date) from T_dec; -- conversion not supported 1898 -
1899 ERROR = !types decimal(17,7) and date(0,0) are not equal for column 'v' 1899 -
1900 CODE = 42000 1900 -
1901 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1901 -
1902 QUERY = SELECT v, convert(v, time) from T_dec; -- conversion not supported 1902 -
1903 ERROR = !types decimal(17,7) and time(1,0) are not equal for column 'v' 1903 -
1904 CODE = 42000 1904 -
1905 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1905 -
1906 QUERY = SELECT v, convert(v, timestamp) from T_dec; -- conversion not supported 1906 -
1907 ERROR = !types decimal(17,7) and timestamp(7,0) are not equal for column 'v' 1907 -
1908 CODE = 42000 1908 -
1909 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1909 -
1910 QUERY = SELECT v, convert(v, time with timezone) from T_dec; -- data type not supported (parse error) 1910 -
1911 ERROR = !syntax/parse error, 1911 -
1912 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 1912 -
1913 CODE = 42000 1913 -
1914 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1914 -
1915 QUERY = SELECT v, convert(v, timestamp with timezone) from T_dec; -- data type not supported (parse error) 1915 -
1916 ERROR = !syntax/parse error, 1916 -
1917 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 1917 -
1918 CODE = 42000 1918 -
1919 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1919 -
1920 QUERY = SELECT v, convert(v, timetz) from T_dec; -- conversion not supported 1920 -
1921 ERROR = !types decimal(17,7) and timetz(7,0) are not equal for column 'v' 1921 -
1922 CODE = 42000 1922 -
1923 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1923 -
1924 QUERY = SELECT v, convert(v, timestamptz) from T_dec; -- conversion not supported 1924 -
1925 ERROR = !types decimal(17,7) and timestamptz(7,0) are not equal for column 'v' 1925 -
1926 CODE = 42000 1926 -
1927 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1927 -
1928 QUERY = SELECT v, cast(v as boolean) from T_dec; 1928 -
1929 ERROR = !types decimal(17,7) and boolean(1,0) are not equal for column 'v' 1929 -
1930 CODE = 42000 1930 -
1931 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1931 -
1932 QUERY = SELECT v, cast(v as bit) from T_dec; -- BIT not valid data type 1932 -
1933 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 1933 -
1934 !syntax/parse error, 1934 -
1935 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1935 -
1936 CODE = 22000 1936 -
1937 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1937 -
1938 QUERY = SELECT v, cast(v as char) from T_dec where v between 0 and 1; 1938 -
1939 ERROR = !value too long for type (var)char(1) 1939 -
1940 CODE = 22001 1940 -
1941 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1941 -
1942 QUERY = SELECT v, cast(v as varchar) from T_dec; -- missing length specification 1942 -
1943 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 1943 -
1944 !syntax/parse error, 1944 -
1945 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1945 -
1946 CODE = 42000 1946 -
1947 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1947 -
1948 QUERY = SELECT v, cast(v as longvarchar) from T_dec; -- LONGVARCHAR not valid data type 1948 -
1949 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 1949 -
1950 !syntax/parse error, 1950 -
1951 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1951 -
1952 CODE = 22000 1952 -
1953 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1953 -
1954 QUERY = SELECT v, cast(v as long varchar) from T_dec; -- LONG VARCHAR not valid data type 1954 -
1955 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 1955 -
1956 !syntax/parse error, 1956 -
1957 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 1957 -
1958 CODE = 22000 1958 -
1959 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1959 -
1960 QUERY = SELECT v, cast(v as Binary) from T_dec; -- BINARY not valid data type 1960 -
1961 ERROR = !syntax/parse error, 1961 -
1962 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 1962 -
1963 CODE = 42000 1963 -
1964 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1964 -
1965 QUERY = SELECT v, cast(v as varBinary) from T_dec; -- VARBINARY not valid data type 1965 -
1966 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 1966 -
1967 !syntax/parse error, 1967 -
1968 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1968 -
1969 CODE = 22000 1969 -
1970 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1970 -
1971 QUERY = SELECT v, cast(v as longvarBinary) from T_dec; -- LONGVARBINARY not valid data type 1971 -
1972 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 1972 -
1973 !syntax/parse error, 1973 -
1974 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 1974 -
1975 CODE = 22000 1975 -
1976 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1976 -
1977 QUERY = SELECT v, cast(v as Blob) from T_dec; -- conversion not supported 1977 -
1978 ERROR = !types decimal(17,7) and blob(0,0) are not equal for column 'v' 1978 -
1979 CODE = 42000 1979 -
1980 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1980 -
1981 QUERY = SELECT v, cast(v as date) from T_dec; -- conversion not supported 1981 -
1982 ERROR = !types decimal(17,7) and date(0,0) are not equal for column 'v' 1982 -
1983 CODE = 42000 1983 -
1984 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1984 -
1985 QUERY = SELECT v, cast(v as time) from T_dec; -- conversion not supported 1985 -
1986 ERROR = !types decimal(17,7) and time(1,0) are not equal for column 'v' 1986 -
1987 CODE = 42000 1987 -
1988 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1988 -
1989 QUERY = SELECT v, cast(v as timestamp) from T_dec; -- conversion not supported 1989 -
1990 ERROR = !types decimal(17,7) and timestamp(7,0) are not equal for column 'v' 1990 -
1991 CODE = 42000 1991 -
1992 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1992 -
1993 QUERY = SELECT v, cast(v as time with timezone) from T_dec; -- data type not supported (parse error) 1993 -
1994 ERROR = !syntax/parse error, 1994 -
1995 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 1995 -
1996 CODE = 42000 1996 -
1997 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 1997 -
1998 QUERY = SELECT v, cast(v as timestamp with timezone) from T_dec; -- data type not supported (parse error) 1998 -
1999 ERROR = !syntax/parse error, 1999 -
2000 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 2000 -
2001 CODE = 42000 2001 -
2002 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2002 -
2003 QUERY = SELECT v, cast(v as timetz) from T_dec; -- conversion not supported 2003 -
2004 ERROR = !types decimal(17,7) and timetz(7,0) are not equal for column 'v' 2004 -
2005 CODE = 42000 2005 -
2006 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2006 -
2007 QUERY = SELECT v, cast(v as timestamptz) from T_dec; -- conversion not supported 2007 -
2008 ERROR = !types decimal(17,7) and timestamptz(7,0) are not equal for column 'v' 2008 -
2009 CODE = 42000 2009 -
2010 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2010 -
2011 QUERY = SELECT v, convert(v, bit) from T_char where v in ('0', '1'); -- BIT not valid data type 2011 -
2012 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 2012 -
2013 !syntax/parse error, 2013 -
2014 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2014 -
2015 CODE = 22000 2015 -
2016 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2016 -
2017 QUERY = SELECT v, convert(v, varchar) from T_char; -- missing length specification 2017 -
2018 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 2018 -
2019 !syntax/parse error, 2019 -
2020 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2020 -
2021 CODE = 42000 2021 -
2022 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2022 -
2023 QUERY = SELECT v, convert(v, longvarchar) from T_char; -- LONGVARCHAR not valid data type 2023 -
2024 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 2024 -
2025 !syntax/parse error, 2025 -
2026 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2026 -
2027 CODE = 22000 2027 -
2028 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2028 -
2029 QUERY = SELECT v, convert(v, long varchar) from T_char; -- LONG VARCHAR not valid data type 2029 -
2030 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 2030 -
2031 !syntax/parse error, 2031 -
2032 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2032 -
2033 CODE = 22000 2033 -
2034 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2034 -
2035 QUERY = SELECT v, convert(v, Binary) from T_char; -- BINARY not valid data type 2035 -
2036 ERROR = !syntax/parse error, 2036 -
2037 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 2037 -
2038 CODE = 42000 2038 -
2039 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2039 -
2040 QUERY = SELECT v, convert(v, varBinary) from T_char; -- VARBINARY not valid data type 2040 -
2041 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 2041 -
2042 !syntax/parse error, 2042 -
2043 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2043 -
2044 CODE = 22000 2044 -
2045 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2045 -
2046 QUERY = SELECT v, convert(v, longvarBinary) from T_char; -- LONGVARBINARY not valid data type 2046 -
2047 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 2047 -
2048 !syntax/parse error, 2048 -
2049 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2049 -
2050 CODE = 22000 2050 -
2051 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2051 -
2052 QUERY = SELECT v, convert(v, date) from T_char; 2052 -
2053 ERROR = !Conversion of string '0' failed 2053 -
2054 CODE = 42000 2054 -
2055 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2055 -
2056 QUERY = SELECT v, convert(v, time) from T_char; 2056 -
2057 ERROR = !Daytime (0) has incorrect format 2057 -
2058 CODE = 22007 2058 -
2059 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2059 -
2060 QUERY = SELECT v, convert(v, timestamp) from T_char; 2060 -
2061 ERROR = !Timestamp (0) has incorrect format 2061 -
2062 CODE = 22007 2062 -
2063 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2063 -
2064 QUERY = SELECT v, convert(v, time with timezone) from T_char; -- data type not supported (parse error) 2064 -
2065 ERROR = !syntax/parse error, 2065 -
2066 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 2066 -
2067 CODE = 42000 2067 -
2068 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2068 -
2069 QUERY = SELECT v, convert(v, timestamp with timezone) from T_char; -- data type not supported (parse error) 2069 -
2070 ERROR = !syntax/parse error, 2070 -
2071 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 2071 -
2072 CODE = 42000 2072 -
2073 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2073 -
2074 QUERY = SELECT v, convert(v, timetz) from T_char; 2074 -
2075 ERROR = !Daytime (0) has incorrect format 2075 -
2076 CODE = 22007 2076 -
2077 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2077 -
2078 QUERY = SELECT v, convert(v, timestamptz) from T_char; 2078 -
2079 ERROR = !Timestamp (0) has incorrect format 2079 -
2080 CODE = 22007 2080 -
2081 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2081 -
2082 QUERY = SELECT v, cast(v as bit) from T_char where v in ('0', '1'); -- BIT not valid data type 2082 -
2083 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 2083 -
2084 !syntax/parse error, 2084 -
2085 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2085 -
2086 CODE = 22000 2086 -
2087 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2087 -
2088 QUERY = SELECT v, cast(v as varchar) from T_char; -- missing length specification 2088 -
2089 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 2089 -
2090 !syntax/parse error, 2090 -
2091 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2091 -
2092 CODE = 42000 2092 -
2093 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2093 -
2094 QUERY = SELECT v, cast(v as longvarchar) from T_char; -- LONGVARCHAR not valid data type 2094 -
2095 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 2095 -
2096 !syntax/parse error, 2096 -
2097 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2097 -
2098 CODE = 22000 2098 -
2099 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2099 -
2100 QUERY = SELECT v, cast(v as long varchar) from T_char; -- LONG VARCHAR not valid data type 2100 -
2101 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 2101 -
2102 !syntax/parse error, 2102 -
2103 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2103 -
2104 CODE = 22000 2104 -
2105 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2105 -
2106 QUERY = SELECT v, cast(v as Binary) from T_char; -- BINARY not valid data type 2106 -
2107 ERROR = !syntax/parse error, 2107 -
2108 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 2108 -
2109 CODE = 42000 2109 -
2110 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2110 -
2111 QUERY = SELECT v, cast(v as varBinary) from T_char; -- VARBINARY not valid data type 2111 -
2112 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 2112 -
2113 !syntax/parse error, 2113 -
2114 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2114 -
2115 CODE = 22000 2115 -
2116 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2116 -
2117 QUERY = SELECT v, cast(v as longvarBinary) from T_char; -- LONGVARBINARY not valid data type 2117 -
2118 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 2118 -
2119 !syntax/parse error, 2119 -
2120 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2120 -
2121 CODE = 22000 2121 -
2122 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2122 -
2123 QUERY = SELECT v, cast(v as date) from T_char; 2123 -
2124 ERROR = !Conversion of string '0' failed 2124 -
2125 CODE = 42000 2125 -
2126 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2126 -
2127 QUERY = SELECT v, cast(v as time) from T_char; 2127 -
2128 ERROR = !Daytime (0) has incorrect format 2128 -
2129 CODE = 22007 2129 -
2130 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2130 -
2131 QUERY = SELECT v, cast(v as timestamp) from T_char; 2131 -
2132 ERROR = !Timestamp (0) has incorrect format 2132 -
2133 CODE = 22007 2133 -
2134 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2134 -
2135 QUERY = SELECT v, cast(v as time with timezone) from T_char; -- data type not supported (parse error) 2135 -
2136 ERROR = !syntax/parse error, 2136 -
2137 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 2137 -
2138 CODE = 42000 2138 -
2139 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2139 -
2140 QUERY = SELECT v, cast(v as timestamp with timezone) from T_char; -- data type not supported (parse error) 2140 -
2141 ERROR = !syntax/parse error, 2141 -
2142 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 2142 -
2143 CODE = 42000 2143 -
2144 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2144 -
2145 QUERY = SELECT v, cast(v as timetz) from T_char; 2145 -
2146 ERROR = !Daytime (0) has incorrect format 2146 -
2147 CODE = 22007 2147 -
2148 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2148 -
2149 QUERY = SELECT v, cast(v as timestamptz) from T_char; 2149 -
2150 ERROR = !Timestamp (0) has incorrect format 2150 -
2151 CODE = 22007 2151 -
2152 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2152 -
2153 QUERY = SELECT v, convert(v, bit) from T_varchar where v in ('0', '1'); -- BIT not valid data type 2153 -
2154 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 2154 -
2155 !syntax/parse error, 2155 -
2156 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2156 -
2157 CODE = 22000 2157 -
2158 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2158 -
2159 QUERY = SELECT v, convert(v, varchar) from T_varchar; -- missing length specification 2159 -
2160 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 2160 -
2161 !syntax/parse error, 2161 -
2162 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2162 -
2163 CODE = 42000 2163 -
2164 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2164 -
2165 QUERY = SELECT v, convert(v, longvarchar) from T_varchar; -- LONGVARCHAR not valid data type 2165 -
2166 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 2166 -
2167 !syntax/parse error, 2167 -
2168 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2168 -
2169 CODE = 22000 2169 -
2170 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2170 -
2171 QUERY = SELECT v, convert(v, long varchar) from T_varchar; -- LONG VARCHAR not valid data type 2171 -
2172 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 2172 -
2173 !syntax/parse error, 2173 -
2174 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2174 -
2175 CODE = 22000 2175 -
2176 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2176 -
2177 QUERY = SELECT v, convert(v, Binary) from T_varchar; -- BINARY not valid data type 2177 -
2178 ERROR = !syntax/parse error, 2178 -
2179 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 2179 -
2180 CODE = 42000 2180 -
2181 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2181 -
2182 QUERY = SELECT v, convert(v, varBinary) from T_varchar; -- VARBINARY not valid data type 2182 -
2183 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 2183 -
2184 !syntax/parse error, 2184 -
2185 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2185 -
2186 CODE = 22000 2186 -
2187 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2187 -
2188 QUERY = SELECT v, convert(v, longvarBinary) from T_varchar; -- LONGVARBINARY not valid data type 2188 -
2189 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 2189 -
2190 !syntax/parse error, 2190 -
2191 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2191 -
2192 CODE = 22000 2192 -
2193 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2193 -
2194 QUERY = SELECT v, convert(v, date) from T_varchar; 2194 -
2195 ERROR = !Conversion of string '0' failed 2195 -
2196 CODE = 42000 2196 -
2197 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2197 -
2198 QUERY = SELECT v, convert(v, time) from T_varchar; 2198 -
2199 ERROR = !Daytime (0) has incorrect format 2199 -
2200 CODE = 22007 2200 -
2201 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2201 -
2202 QUERY = SELECT v, convert(v, timestamp) from T_varchar; 2202 -
2203 ERROR = !Timestamp (0) has incorrect format 2203 -
2204 CODE = 22007 2204 -
2205 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2205 -
2206 QUERY = SELECT v, convert(v, time with timezone) from T_varchar; -- data type not supported (parse error) 2206 -
2207 ERROR = !syntax/parse error, 2207 -
2208 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 2208 -
2209 CODE = 42000 2209 -
2210 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2210 -
2211 QUERY = SELECT v, convert(v, timestamp with timezone) from T_varchar; -- data type not supported (parse error) 2211 -
2212 ERROR = !syntax/parse error, 2212 -
2213 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 2213 -
2214 CODE = 42000 2214 -
2215 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2215 -
2216 QUERY = SELECT v, convert(v, timetz) from T_varchar; 2216 -
2217 ERROR = !Daytime (0) has incorrect format 2217 -
2218 CODE = 22007 2218 -
2219 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2219 -
2220 QUERY = SELECT v, convert(v, timestamptz) from T_varchar; 2220 -
2221 ERROR = !Timestamp (0) has incorrect format 2221 -
2222 CODE = 22007 2222 -
2223 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2223 -
2224 QUERY = SELECT v, cast(v as bit) from T_varchar where v in ('0', '1'); -- BIT not valid data type 2224 -
2225 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 2225 -
2226 !syntax/parse error, 2226 -
2227 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2227 -
2228 CODE = 22000 2228 -
2229 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2229 -
2230 QUERY = SELECT v, cast(v as varchar) from T_varchar; -- missing length specification 2230 -
2231 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 2231 -
2232 !syntax/parse error, 2232 -
2233 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2233 -
2234 CODE = 42000 2234 -
2235 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2235 -
2236 QUERY = SELECT v, cast(v as longvarchar) from T_varchar; -- LONGVARCHAR not valid data type 2236 -
2237 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 2237 -
2238 !syntax/parse error, 2238 -
2239 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2239 -
2240 CODE = 22000 2240 -
2241 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2241 -
2242 QUERY = SELECT v, cast(v as long varchar) from T_varchar; -- LONG VARCHAR not valid data type 2242 -
2243 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 2243 -
2244 !syntax/parse error, 2244 -
2245 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2245 -
2246 CODE = 22000 2246 -
2247 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2247 -
2248 QUERY = SELECT v, cast(v as Binary) from T_varchar; -- BINARY not valid data type 2248 -
2249 ERROR = !syntax/parse error, 2249 -
2250 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 2250 -
2251 CODE = 42000 2251 -
2252 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2252 -
2253 QUERY = SELECT v, cast(v as varBinary) from T_varchar; -- VARBINARY not valid data type 2253 -
2254 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 2254 -
2255 !syntax/parse error, 2255 -
2256 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2256 -
2257 CODE = 22000 2257 -
2258 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2258 -
2259 QUERY = SELECT v, cast(v as longvarBinary) from T_varchar; -- LONGVARBINARY not valid data type 2259 -
2260 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 2260 -
2261 !syntax/parse error, 2261 -
2262 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2262 -
2263 CODE = 22000 2263 -
2264 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2264 -
2265 QUERY = SELECT v, cast(v as date) from T_varchar; 2265 -
2266 ERROR = !Conversion of string '0' failed 2266 -
2267 CODE = 42000 2267 -
2268 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2268 -
2269 QUERY = SELECT v, cast(v as time) from T_varchar; 2269 -
2270 ERROR = !Daytime (0) has incorrect format 2270 -
2271 CODE = 22007 2271 -
2272 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2272 -
2273 QUERY = SELECT v, cast(v as timestamp) from T_varchar; 2273 -
2274 ERROR = !Timestamp (0) has incorrect format 2274 -
2275 CODE = 22007 2275 -
2276 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2276 -
2277 QUERY = SELECT v, cast(v as time with timezone) from T_varchar; -- data type not supported (parse error) 2277 -
2278 ERROR = !syntax/parse error, 2278 -
2279 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 2279 -
2280 CODE = 42000 2280 -
2281 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2281 -
2282 QUERY = SELECT v, cast(v as timestamp with timezone) from T_varchar; -- data type not supported (parse error) 2282 -
2283 ERROR = !syntax/parse error, 2283 -
2284 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 2284 -
2285 CODE = 42000 2285 -
2286 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2286 -
2287 QUERY = SELECT v, cast(v as timetz) from T_varchar; 2287 -
2288 ERROR = !Daytime (0) has incorrect format 2288 -
2289 CODE = 22007 2289 -
2290 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2290 -
2291 QUERY = SELECT v, cast(v as timestamptz) from T_varchar; 2291 -
2292 ERROR = !Timestamp (0) has incorrect format 2292 -
2293 CODE = 22007 2293 -
2294 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2294 -
2295 QUERY = SELECT v, convert(v, bit) from T_clob where v in ('0', '1'); -- BIT not valid data type 2295 -
2296 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 2296 -
2297 !syntax/parse error, 2297 -
2298 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2298 -
2299 CODE = 22000 2299 -
2300 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2300 -
2301 QUERY = SELECT v, convert(v, varchar) from T_clob; -- missing length specification 2301 -
2302 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 2302 -
2303 !syntax/parse error, 2303 -
2304 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2304 -
2305 CODE = 42000 2305 -
2306 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2306 -
2307 QUERY = SELECT v, convert(v, longvarchar) from T_clob; -- LONGVARCHAR not valid data type 2307 -
2308 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 2308 -
2309 !syntax/parse error, 2309 -
2310 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2310 -
2311 CODE = 22000 2311 -
2312 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2312 -
2313 QUERY = SELECT v, convert(v, long varchar) from T_clob; -- LONG VARCHAR not valid data type 2313 -
2314 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 2314 -
2315 !syntax/parse error, 2315 -
2316 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2316 -
2317 CODE = 22000 2317 -
2318 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2318 -
2319 QUERY = SELECT v, convert(v, Binary) from T_clob; -- BINARY not valid data type 2319 -
2320 ERROR = !syntax/parse error, 2320 -
2321 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 2321 -
2322 CODE = 42000 2322 -
2323 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2323 -
2324 QUERY = SELECT v, convert(v, varBinary) from T_clob; -- VARBINARY not valid data type 2324 -
2325 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 2325 -
2326 !syntax/parse error, 2326 -
2327 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2327 -
2328 CODE = 22000 2328 -
2329 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2329 -
2330 QUERY = SELECT v, convert(v, longvarBinary) from T_clob; -- LONGVARBINARY not valid data type 2330 -
2331 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 2331 -
2332 !syntax/parse error, 2332 -
2333 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2333 -
2334 CODE = 22000 2334 -
2335 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2335 -
2336 QUERY = SELECT v, convert(v, date) from T_clob; 2336 -
2337 ERROR = !Conversion of string '0' failed 2337 -
2338 CODE = 42000 2338 -
2339 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2339 -
2340 QUERY = SELECT v, convert(v, time) from T_clob; 2340 -
2341 ERROR = !Daytime (0) has incorrect format 2341 -
2342 CODE = 22007 2342 -
2343 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2343 -
2344 QUERY = SELECT v, convert(v, timestamp) from T_clob; 2344 -
2345 ERROR = !Timestamp (0) has incorrect format 2345 -
2346 CODE = 22007 2346 -
2347 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2347 -
2348 QUERY = SELECT v, convert(v, time with timezone) from T_clob; -- data type not supported (parse error) 2348 -
2349 ERROR = !syntax/parse error, 2349 -
2350 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 2350 -
2351 CODE = 42000 2351 -
2352 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2352 -
2353 QUERY = SELECT v, convert(v, timestamp with timezone) from T_clob; -- data type not supported (parse error) 2353 -
2354 ERROR = !syntax/parse error, 2354 -
2355 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 2355 -
2356 CODE = 42000 2356 -
2357 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2357 -
2358 QUERY = SELECT v, convert(v, timetz) from T_clob; 2358 -
2359 ERROR = !Daytime (0) has incorrect format 2359 -
2360 CODE = 22007 2360 -
2361 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2361 -
2362 QUERY = SELECT v, convert(v, timestamptz) from T_clob; 2362 -
2363 ERROR = !Timestamp (0) has incorrect format 2363 -
2364 CODE = 22007 2364 -
2365 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2365 -
2366 QUERY = SELECT v, cast(v as bit) from T_clob where v in ('0', '1'); -- BIT not valid data type 2366 -
2367 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 2367 -
2368 !syntax/parse error, 2368 -
2369 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2369 -
2370 CODE = 22000 2370 -
2371 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2371 -
2372 QUERY = SELECT v, cast(v as varchar) from T_clob; -- missing length specification 2372 -
2373 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 2373 -
2374 !syntax/parse error, 2374 -
2375 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2375 -
2376 CODE = 42000 2376 -
2377 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2377 -
2378 QUERY = SELECT v, cast(v as longvarchar) from T_clob; -- LONGVARCHAR not valid data type 2378 -
2379 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 2379 -
2380 !syntax/parse error, 2380 -
2381 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2381 -
2382 CODE = 22000 2382 -
2383 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2383 -
2384 QUERY = SELECT v, cast(v as long varchar) from T_clob; -- LONG VARCHAR not valid data type 2384 -
2385 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 2385 -
2386 !syntax/parse error, 2386 -
2387 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2387 -
2388 CODE = 22000 2388 -
2389 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2389 -
2390 QUERY = SELECT v, cast(v as Binary) from T_clob; -- BINARY not valid data type 2390 -
2391 ERROR = !syntax/parse error, 2391 -
2392 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 2392 -
2393 CODE = 42000 2393 -
2394 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2394 -
2395 QUERY = SELECT v, cast(v as varBinary) from T_clob; -- VARBINARY not valid data type 2395 -
2396 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 2396 -
2397 !syntax/parse error, 2397 -
2398 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2398 -
2399 CODE = 22000 2399 -
2400 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2400 -
2401 QUERY = SELECT v, cast(v as longvarBinary) from T_clob; -- LONGVARBINARY not valid data type 2401 -
2402 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 2402 -
2403 !syntax/parse error, 2403 -
2404 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2404 -
2405 CODE = 22000 2405 -
2406 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2406 -
2407 QUERY = SELECT v, cast(v as date) from T_clob; 2407 -
2408 ERROR = !Conversion of string '0' failed 2408 -
2409 CODE = 42000 2409 -
2410 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2410 -
2411 QUERY = SELECT v, cast(v as time) from T_clob; 2411 -
2412 ERROR = !Daytime (0) has incorrect format 2412 -
2413 CODE = 22007 2413 -
2414 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2414 -
2415 QUERY = SELECT v, cast(v as timestamp) from T_clob; 2415 -
2416 ERROR = !Timestamp (0) has incorrect format 2416 -
2417 CODE = 22007 2417 -
2418 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2418 -
2419 QUERY = SELECT v, cast(v as time with timezone) from T_clob; -- data type not supported (parse error) 2419 -
2420 ERROR = !syntax/parse error, 2420 -
2421 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 2421 -
2422 CODE = 42000 2422 -
2423 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2423 -
2424 QUERY = SELECT v, cast(v as timestamp with timezone) from T_clob; -- data type not supported (parse error) 2424 -
2425 ERROR = !syntax/parse error, 2425 -
2426 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 2426 -
2427 CODE = 42000 2427 -
2428 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2428 -
2429 QUERY = SELECT v, cast(v as timetz) from T_clob; 2429 -
2430 ERROR = !Daytime (0) has incorrect format 2430 -
2431 CODE = 22007 2431 -
2432 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2432 -
2433 QUERY = SELECT v, cast(v as timestamptz) from T_clob; 2433 -
2434 ERROR = !Timestamp (0) has incorrect format 2434 -
2435 CODE = 22007 2435 -
2436 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2436 -
2437 QUERY = SELECT v, convert(v, boolean) from T_date; 2437 -
2438 ERROR = !types date(0,0) and boolean(1,0) are not equal for column 'v' 2438 -
2439 CODE = 42000 2439 -
2440 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2440 -
2441 QUERY = SELECT v, convert(v, bit) from T_date; -- BIT not valid data type 2441 -
2442 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 2442 -
2443 !syntax/parse error, 2443 -
2444 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2444 -
2445 CODE = 22000 2445 -
2446 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2446 -
2447 QUERY = SELECT v, convert(v, tinyint) from T_date; 2447 -
2448 ERROR = !types date(0,0) and tinyint(8,0) are not equal for column 'v' 2448 -
2449 CODE = 42000 2449 -
2450 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2450 -
2451 QUERY = SELECT v, convert(v, smallint) from T_date; 2451 -
2452 ERROR = !types date(0,0) and smallint(16,0) are not equal for column 'v' 2452 -
2453 CODE = 42000 2453 -
2454 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2454 -
2455 QUERY = SELECT v, convert(v, integer) from T_date; 2455 -
2456 ERROR = !types date(0,0) and int(32,0) are not equal for column 'v' 2456 -
2457 CODE = 42000 2457 -
2458 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2458 -
2459 QUERY = SELECT v, convert(v, bigint) from T_date; 2459 -
2460 ERROR = !types date(0,0) and bigint(64,0) are not equal for column 'v' 2460 -
2461 CODE = 42000 2461 -
2462 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2462 -
2463 QUERY = SELECT v, convert(v, hugeint) from T_date; 2463 -
2464 ERROR = !types date(0,0) and hugeint(128,0) are not equal for column 'v' 2464 -
2465 CODE = 42000 2465 -
2466 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2466 -
2467 QUERY = SELECT v, convert(v, float) from T_date; 2467 -
2468 ERROR = !types date(0,0) and double(53,0) are not equal for column 'v' 2468 -
2469 CODE = 42000 2469 -
2470 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2470 -
2471 QUERY = SELECT v, convert(v, float(24)) from T_date; 2471 -
2472 ERROR = !types date(0,0) and real(24,0) are not equal for column 'v' 2472 -
2473 CODE = 42000 2473 -
2474 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2474 -
2475 QUERY = SELECT v, convert(v, real) from T_date; 2475 -
2476 ERROR = !types date(0,0) and real(24,0) are not equal for column 'v' 2476 -
2477 CODE = 42000 2477 -
2478 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2478 -
2479 QUERY = SELECT v, convert(v, double) from T_date; 2479 -
2480 ERROR = !types date(0,0) and double(53,0) are not equal for column 'v' 2480 -
2481 CODE = 42000 2481 -
2482 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2482 -
2483 QUERY = SELECT v, convert(v, double precision) from T_date; 2483 -
2484 ERROR = !types date(0,0) and double(53,0) are not equal for column 'v' 2484 -
2485 CODE = 42000 2485 -
2486 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2486 -
2487 QUERY = SELECT v, convert(v, numeric) from T_date; 2487 -
2488 ERROR = !types date(0,0) and decimal(18,3) are not equal for column 'v' 2488 -
2489 CODE = 42000 2489 -
2490 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2490 -
2491 QUERY = SELECT v, convert(v, decimal) from T_date; 2491 -
2492 ERROR = !types date(0,0) and decimal(18,3) are not equal for column 'v' 2492 -
2493 CODE = 42000 2493 -
2494 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2494 -
2495 QUERY = SELECT v, convert(v, numeric(10)) from T_date; 2495 -
2496 ERROR = !types date(0,0) and decimal(10,0) are not equal for column 'v' 2496 -
2497 CODE = 42000 2497 -
2498 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2498 -
2499 QUERY = SELECT v, convert(v, decimal(11)) from T_date; 2499 -
2500 ERROR = !types date(0,0) and decimal(11,0) are not equal for column 'v' 2500 -
2501 CODE = 42000 2501 -
2502 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2502 -
2503 QUERY = SELECT v, convert(v, numeric(12,0)) from T_date; 2503 -
2504 ERROR = !types date(0,0) and decimal(12,0) are not equal for column 'v' 2504 -
2505 CODE = 42000 2505 -
2506 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2506 -
2507 QUERY = SELECT v, convert(v, decimal(15,3)) from T_date; 2507 -
2508 ERROR = !types date(0,0) and decimal(15,3) are not equal for column 'v' 2508 -
2509 CODE = 42000 2509 -
2510 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2510 -
2511 QUERY = SELECT v, convert(v, char) from T_date; 2511 -
2512 ERROR = !value too long for type (var)char(1) 2512 -
2513 CODE = 22001 2513 -
2514 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2514 -
2515 QUERY = SELECT v, convert(v, varchar) from T_date; -- missing length specification 2515 -
2516 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 2516 -
2517 !syntax/parse error, 2517 -
2518 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2518 -
2519 CODE = 42000 2519 -
2520 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2520 -
2521 QUERY = SELECT v, convert(v, longvarchar) from T_date; -- LONGVARCHAR not valid data type 2521 -
2522 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 2522 -
2523 !syntax/parse error, 2523 -
2524 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2524 -
2525 CODE = 22000 2525 -
2526 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2526 -
2527 QUERY = SELECT v, convert(v, long varchar) from T_date; -- LONG VARCHAR not valid data type 2527 -
2528 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 2528 -
2529 !syntax/parse error, 2529 -
2530 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2530 -
2531 CODE = 22000 2531 -
2532 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2532 -
2533 QUERY = SELECT v, convert(v, Binary) from T_date; -- BINARY not valid data type 2533 -
2534 ERROR = !syntax/parse error, 2534 -
2535 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 2535 -
2536 CODE = 42000 2536 -
2537 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2537 -
2538 QUERY = SELECT v, convert(v, varBinary) from T_date; -- VARBINARY not valid data type 2538 -
2539 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 2539 -
2540 !syntax/parse error, 2540 -
2541 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2541 -
2542 CODE = 22000 2542 -
2543 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2543 -
2544 QUERY = SELECT v, convert(v, longvarBinary) from T_date; -- LONGVARBINARY not valid data type 2544 -
2545 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 2545 -
2546 !syntax/parse error, 2546 -
2547 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2547 -
2548 CODE = 22000 2548 -
2549 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2549 -
2550 QUERY = SELECT v, convert(v, Blob) from T_date where v in (date '2016-01-01'); 2550 -
2551 ERROR = !types date(0,0) and blob(0,0) are not equal for column 'v' 2551 -
2552 CODE = 42000 2552 -
2553 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2553 -
2554 QUERY = SELECT v, convert(v, time) from T_date; 2554 -
2555 ERROR = !types date(0,0) and time(1,0) are not equal for column 'v' 2555 -
2556 CODE = 42000 2556 -
2557 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2557 -
2558 QUERY = SELECT v, convert(v, time with timezone) from T_date; -- data type not supported (parse error) 2558 -
2559 ERROR = !syntax/parse error, 2559 -
2560 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 2560 -
2561 CODE = 42000 2561 -
2562 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2562 -
2563 QUERY = SELECT v, convert(v, timestamp with timezone) from T_date; -- data type not supported (parse error) 2563 -
2564 ERROR = !syntax/parse error, 2564 -
2565 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 2565 -
2566 CODE = 42000 2566 -
2567 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2567 -
2568 QUERY = SELECT v, convert(v, timetz) from T_date; 2568 -
2569 ERROR = !types date(0,0) and timetz(7,0) are not equal for column 'v' 2569 -
2570 CODE = 42000 2570 -
2571 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2571 -
2572 QUERY = SELECT v, cast(v as boolean) from T_date; 2572 -
2573 ERROR = !types date(0,0) and boolean(1,0) are not equal for column 'v' 2573 -
2574 CODE = 42000 2574 -
2575 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2575 -
2576 QUERY = SELECT v, cast(v as bit) from T_date; -- BIT not valid data type 2576 -
2577 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 2577 -
2578 !syntax/parse error, 2578 -
2579 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2579 -
2580 CODE = 22000 2580 -
2581 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2581 -
2582 QUERY = SELECT v, cast(v as tinyint) from T_date; 2582 -
2583 ERROR = !types date(0,0) and tinyint(8,0) are not equal for column 'v' 2583 -
2584 CODE = 42000 2584 -
2585 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2585 -
2586 QUERY = SELECT v, cast(v as smallint) from T_date; 2586 -
2587 ERROR = !types date(0,0) and smallint(16,0) are not equal for column 'v' 2587 -
2588 CODE = 42000 2588 -
2589 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2589 -
2590 QUERY = SELECT v, cast(v as integer) from T_date; 2590 -
2591 ERROR = !types date(0,0) and int(32,0) are not equal for column 'v' 2591 -
2592 CODE = 42000 2592 -
2593 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2593 -
2594 QUERY = SELECT v, cast(v as bigint) from T_date; 2594 -
2595 ERROR = !types date(0,0) and bigint(64,0) are not equal for column 'v' 2595 -
2596 CODE = 42000 2596 -
2597 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2597 -
2598 QUERY = SELECT v, cast(v as hugeint) from T_date; 2598 -
2599 ERROR = !types date(0,0) and hugeint(128,0) are not equal for column 'v' 2599 -
2600 CODE = 42000 2600 -
2601 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2601 -
2602 QUERY = SELECT v, cast(v as float) from T_date; 2602 -
2603 ERROR = !types date(0,0) and double(53,0) are not equal for column 'v' 2603 -
2604 CODE = 42000 2604 -
2605 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2605 -
2606 QUERY = SELECT v, cast(v as float(24)) from T_date; 2606 -
2607 ERROR = !types date(0,0) and real(24,0) are not equal for column 'v' 2607 -
2608 CODE = 42000 2608 -
2609 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2609 -
2610 QUERY = SELECT v, cast(v as real) from T_date; 2610 -
2611 ERROR = !types date(0,0) and real(24,0) are not equal for column 'v' 2611 -
2612 CODE = 42000 2612 -
2613 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2613 -
2614 QUERY = SELECT v, cast(v as double) from T_date; 2614 -
2615 ERROR = !types date(0,0) and double(53,0) are not equal for column 'v' 2615 -
2616 CODE = 42000 2616 -
2617 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2617 -
2618 QUERY = SELECT v, cast(v as double precision) from T_date; 2618 -
2619 ERROR = !types date(0,0) and double(53,0) are not equal for column 'v' 2619 -
2620 CODE = 42000 2620 -
2621 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2621 -
2622 QUERY = SELECT v, cast(v as numeric) from T_date; 2622 -
2623 ERROR = !types date(0,0) and decimal(18,3) are not equal for column 'v' 2623 -
2624 CODE = 42000 2624 -
2625 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2625 -
2626 QUERY = SELECT v, cast(v as decimal) from T_date; 2626 -
2627 ERROR = !types date(0,0) and decimal(18,3) are not equal for column 'v' 2627 -
2628 CODE = 42000 2628 -
2629 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2629 -
2630 QUERY = SELECT v, cast(v as numeric(10)) from T_date; 2630 -
2631 ERROR = !types date(0,0) and decimal(10,0) are not equal for column 'v' 2631 -
2632 CODE = 42000 2632 -
2633 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2633 -
2634 QUERY = SELECT v, cast(v as decimal(11)) from T_date; 2634 -
2635 ERROR = !types date(0,0) and decimal(11,0) are not equal for column 'v' 2635 -
2636 CODE = 42000 2636 -
2637 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2637 -
2638 QUERY = SELECT v, cast(v as numeric(12,0)) from T_date; 2638 -
2639 ERROR = !types date(0,0) and decimal(12,0) are not equal for column 'v' 2639 -
2640 CODE = 42000 2640 -
2641 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2641 -
2642 QUERY = SELECT v, cast(v as decimal(15,3)) from T_date; 2642 -
2643 ERROR = !types date(0,0) and decimal(15,3) are not equal for column 'v' 2643 -
2644 CODE = 42000 2644 -
2645 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2645 -
2646 QUERY = SELECT v, cast(v as char) from T_date; 2646 -
2647 ERROR = !value too long for type (var)char(1) 2647 -
2648 CODE = 22001 2648 -
2649 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2649 -
2650 QUERY = SELECT v, cast(v as varchar) from T_date; -- missing length specification 2650 -
2651 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 2651 -
2652 !syntax/parse error, 2652 -
2653 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2653 -
2654 CODE = 42000 2654 -
2655 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2655 -
2656 QUERY = SELECT v, cast(v as longvarchar) from T_date; -- LONGVARCHAR not valid data type 2656 -
2657 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 2657 -
2658 !syntax/parse error, 2658 -
2659 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2659 -
2660 CODE = 22000 2660 -
2661 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2661 -
2662 QUERY = SELECT v, cast(v as long varchar) from T_date; -- LONG VARCHAR not valid data type 2662 -
2663 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 2663 -
2664 !syntax/parse error, 2664 -
2665 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2665 -
2666 CODE = 22000 2666 -
2667 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2667 -
2668 QUERY = SELECT v, cast(v as Binary) from T_date; -- BINARY not valid data type 2668 -
2669 ERROR = !syntax/parse error, 2669 -
2670 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 2670 -
2671 CODE = 42000 2671 -
2672 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2672 -
2673 QUERY = SELECT v, cast(v as varBinary) from T_date; -- VARBINARY not valid data type 2673 -
2674 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 2674 -
2675 !syntax/parse error, 2675 -
2676 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2676 -
2677 CODE = 22000 2677 -
2678 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2678 -
2679 QUERY = SELECT v, cast(v as longvarBinary) from T_date; -- LONGVARBINARY not valid data type 2679 -
2680 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 2680 -
2681 !syntax/parse error, 2681 -
2682 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2682 -
2683 CODE = 22000 2683 -
2684 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2684 -
2685 QUERY = SELECT v, cast(v as Blob) from T_date where v in (date '2016-01-01'); 2685 -
2686 ERROR = !types date(0,0) and blob(0,0) are not equal for column 'v' 2686 -
2687 CODE = 42000 2687 -
2688 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2688 -
2689 QUERY = SELECT v, cast(v as time) from T_date; 2689 -
2690 ERROR = !types date(0,0) and time(1,0) are not equal for column 'v' 2690 -
2691 CODE = 42000 2691 -
2692 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2692 -
2693 QUERY = SELECT v, cast(v as time with timezone) from T_date; -- data type not supported (parse error) 2693 -
2694 ERROR = !syntax/parse error, 2694 -
2695 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 2695 -
2696 CODE = 42000 2696 -
2697 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2697 -
2698 QUERY = SELECT v, cast(v as timestamp with timezone) from T_date; -- data type not supported (parse error) 2698 -
2699 ERROR = !syntax/parse error, 2699 -
2700 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 2700 -
2701 CODE = 42000 2701 -
2702 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2702 -
2703 QUERY = SELECT v, cast(v as timetz) from T_date; 2703 -
2704 ERROR = !types date(0,0) and timetz(7,0) are not equal for column 'v' 2704 -
2705 CODE = 42000 2705 -
2706 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2706 -
2707 QUERY = SELECT v, convert(v, boolean) from T_time; 2707 -
2708 ERROR = !types time(1,0) and boolean(1,0) are not equal for column 'v' 2708 -
2709 CODE = 42000 2709 -
2710 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2710 -
2711 QUERY = SELECT v, convert(v, bit) from T_time; -- BIT not valid data type 2711 -
2712 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 2712 -
2713 !syntax/parse error, 2713 -
2714 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2714 -
2715 CODE = 22000 2715 -
2716 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2716 -
2717 QUERY = SELECT v, convert(v, tinyint) from T_time; 2717 -
2718 ERROR = !types time(1,0) and tinyint(8,0) are not equal for column 'v' 2718 -
2719 CODE = 42000 2719 -
2720 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2720 -
2721 QUERY = SELECT v, convert(v, smallint) from T_time; 2721 -
2722 ERROR = !types time(1,0) and smallint(16,0) are not equal for column 'v' 2722 -
2723 CODE = 42000 2723 -
2724 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2724 -
2725 QUERY = SELECT v, convert(v, integer) from T_time; 2725 -
2726 ERROR = !types time(1,0) and int(32,0) are not equal for column 'v' 2726 -
2727 CODE = 42000 2727 -
2728 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2728 -
2729 QUERY = SELECT v, convert(v, bigint) from T_time; 2729 -
2730 ERROR = !types time(1,0) and bigint(64,0) are not equal for column 'v' 2730 -
2731 CODE = 42000 2731 -
2732 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2732 -
2733 QUERY = SELECT v, convert(v, hugeint) from T_time; 2733 -
2734 ERROR = !types time(1,0) and hugeint(128,0) are not equal for column 'v' 2734 -
2735 CODE = 42000 2735 -
2736 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2736 -
2737 QUERY = SELECT v, convert(v, float) from T_time; 2737 -
2738 ERROR = !types time(1,0) and double(53,0) are not equal for column 'v' 2738 -
2739 CODE = 42000 2739 -
2740 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2740 -
2741 QUERY = SELECT v, convert(v, float(24)) from T_time; 2741 -
2742 ERROR = !types time(1,0) and real(24,0) are not equal for column 'v' 2742 -
2743 CODE = 42000 2743 -
2744 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2744 -
2745 QUERY = SELECT v, convert(v, real) from T_time; 2745 -
2746 ERROR = !types time(1,0) and real(24,0) are not equal for column 'v' 2746 -
2747 CODE = 42000 2747 -
2748 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2748 -
2749 QUERY = SELECT v, convert(v, double) from T_time; 2749 -
2750 ERROR = !types time(1,0) and double(53,0) are not equal for column 'v' 2750 -
2751 CODE = 42000 2751 -
2752 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2752 -
2753 QUERY = SELECT v, convert(v, double precision) from T_time; 2753 -
2754 ERROR = !types time(1,0) and double(53,0) are not equal for column 'v' 2754 -
2755 CODE = 42000 2755 -
2756 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2756 -
2757 QUERY = SELECT v, convert(v, numeric) from T_time; 2757 -
2758 ERROR = !types time(1,0) and decimal(18,3) are not equal for column 'v' 2758 -
2759 CODE = 42000 2759 -
2760 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2760 -
2761 QUERY = SELECT v, convert(v, decimal) from T_time; 2761 -
2762 ERROR = !types time(1,0) and decimal(18,3) are not equal for column 'v' 2762 -
2763 CODE = 42000 2763 -
2764 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2764 -
2765 QUERY = SELECT v, convert(v, numeric(10)) from T_time; 2765 -
2766 ERROR = !types time(1,0) and decimal(10,0) are not equal for column 'v' 2766 -
2767 CODE = 42000 2767 -
2768 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2768 -
2769 QUERY = SELECT v, convert(v, decimal(11)) from T_time; 2769 -
2770 ERROR = !types time(1,0) and decimal(11,0) are not equal for column 'v' 2770 -
2771 CODE = 42000 2771 -
2772 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2772 -
2773 QUERY = SELECT v, convert(v, numeric(12,0)) from T_time; 2773 -
2774 ERROR = !types time(1,0) and decimal(12,0) are not equal for column 'v' 2774 -
2775 CODE = 42000 2775 -
2776 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2776 -
2777 QUERY = SELECT v, convert(v, decimal(15,3)) from T_time; 2777 -
2778 ERROR = !types time(1,0) and decimal(15,3) are not equal for column 'v' 2778 -
2779 CODE = 42000 2779 -
2780 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2780 -
2781 QUERY = SELECT v, convert(v, char) from T_time; 2781 -
2782 ERROR = !value too long for type (var)char(1) 2782 -
2783 CODE = 22001 2783 -
2784 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2784 -
2785 QUERY = SELECT v, convert(v, varchar) from T_time; -- missing length specification 2785 -
2786 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 2786 -
2787 !syntax/parse error, 2787 -
2788 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2788 -
2789 CODE = 42000 2789 -
2790 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2790 -
2791 QUERY = SELECT v, convert(v, longvarchar) from T_time; -- LONGVARCHAR not valid data type 2791 -
2792 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 2792 -
2793 !syntax/parse error, 2793 -
2794 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2794 -
2795 CODE = 22000 2795 -
2796 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2796 -
2797 QUERY = SELECT v, convert(v, long varchar) from T_time; -- LONG VARCHAR not valid data type 2797 -
2798 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 2798 -
2799 !syntax/parse error, 2799 -
2800 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2800 -
2801 CODE = 22000 2801 -
2802 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2802 -
2803 QUERY = SELECT v, convert(v, Binary) from T_time; -- BINARY not valid data type 2803 -
2804 ERROR = !syntax/parse error, 2804 -
2805 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 2805 -
2806 CODE = 42000 2806 -
2807 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2807 -
2808 QUERY = SELECT v, convert(v, varBinary) from T_time; -- VARBINARY not valid data type 2808 -
2809 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 2809 -
2810 !syntax/parse error, 2810 -
2811 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2811 -
2812 CODE = 22000 2812 -
2813 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2813 -
2814 QUERY = SELECT v, convert(v, longvarBinary) from T_time; -- LONGVARBINARY not valid data type 2814 -
2815 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 2815 -
2816 !syntax/parse error, 2816 -
2817 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2817 -
2818 CODE = 22000 2818 -
2819 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2819 -
2820 QUERY = SELECT v, convert(v, Blob) from T_time; 2820 -
2821 ERROR = !types time(1,0) and blob(0,0) are not equal for column 'v' 2821 -
2822 CODE = 42000 2822 -
2823 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2823 -
2824 QUERY = SELECT v, convert(v, date) from T_time; 2824 -
2825 ERROR = !types time(1,0) and date(0,0) are not equal for column 'v' 2825 -
2826 CODE = 42000 2826 -
2827 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2827 -
2828 QUERY = SELECT v, convert(v, timestamp) from T_time; 2828 -
2829 ERROR = !types time(1,0) and timestamp(7,0) are not equal for column 'v' 2829 -
2830 CODE = 42000 2830 -
2831 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2831 -
2832 QUERY = SELECT v, convert(v, time with timezone) from T_time; -- data type not supported (parse error) 2832 -
2833 ERROR = !syntax/parse error, 2833 -
2834 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 2834 -
2835 CODE = 42000 2835 -
2836 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2836 -
2837 QUERY = SELECT v, convert(v, timestamp with timezone) from T_time; -- data type not supported (parse error) 2837 -
2838 ERROR = !syntax/parse error, 2838 -
2839 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 2839 -
2840 CODE = 42000 2840 -
2841 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2841 -
2842 QUERY = SELECT v, convert(v, timestamptz) from T_time; 2842 -
2843 ERROR = !types time(1,0) and timestamptz(7,0) are not equal for column 'v' 2843 -
2844 CODE = 42000 2844 -
2845 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2845 -
2846 QUERY = SELECT v, cast(v as boolean) from T_time; 2846 -
2847 ERROR = !types time(1,0) and boolean(1,0) are not equal for column 'v' 2847 -
2848 CODE = 42000 2848 -
2849 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2849 -
2850 QUERY = SELECT v, cast(v as bit) from T_time; -- BIT not valid data type 2850 -
2851 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 2851 -
2852 !syntax/parse error, 2852 -
2853 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2853 -
2854 CODE = 22000 2854 -
2855 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2855 -
2856 QUERY = SELECT v, cast(v as tinyint) from T_time; 2856 -
2857 ERROR = !types time(1,0) and tinyint(8,0) are not equal for column 'v' 2857 -
2858 CODE = 42000 2858 -
2859 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2859 -
2860 QUERY = SELECT v, cast(v as smallint) from T_time; 2860 -
2861 ERROR = !types time(1,0) and smallint(16,0) are not equal for column 'v' 2861 -
2862 CODE = 42000 2862 -
2863 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2863 -
2864 QUERY = SELECT v, cast(v as integer) from T_time; 2864 -
2865 ERROR = !types time(1,0) and int(32,0) are not equal for column 'v' 2865 -
2866 CODE = 42000 2866 -
2867 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2867 -
2868 QUERY = SELECT v, cast(v as bigint) from T_time; 2868 -
2869 ERROR = !types time(1,0) and bigint(64,0) are not equal for column 'v' 2869 -
2870 CODE = 42000 2870 -
2871 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2871 -
2872 QUERY = SELECT v, cast(v as hugeint) from T_time; 2872 -
2873 ERROR = !types time(1,0) and hugeint(128,0) are not equal for column 'v' 2873 -
2874 CODE = 42000 2874 -
2875 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2875 -
2876 QUERY = SELECT v, cast(v as float) from T_time; 2876 -
2877 ERROR = !types time(1,0) and double(53,0) are not equal for column 'v' 2877 -
2878 CODE = 42000 2878 -
2879 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2879 -
2880 QUERY = SELECT v, cast(v as float(24)) from T_time; 2880 -
2881 ERROR = !types time(1,0) and real(24,0) are not equal for column 'v' 2881 -
2882 CODE = 42000 2882 -
2883 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2883 -
2884 QUERY = SELECT v, cast(v as real) from T_time; 2884 -
2885 ERROR = !types time(1,0) and real(24,0) are not equal for column 'v' 2885 -
2886 CODE = 42000 2886 -
2887 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2887 -
2888 QUERY = SELECT v, cast(v as double) from T_time; 2888 -
2889 ERROR = !types time(1,0) and double(53,0) are not equal for column 'v' 2889 -
2890 CODE = 42000 2890 -
2891 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2891 -
2892 QUERY = SELECT v, cast(v as double precision) from T_time; 2892 -
2893 ERROR = !types time(1,0) and double(53,0) are not equal for column 'v' 2893 -
2894 CODE = 42000 2894 -
2895 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2895 -
2896 QUERY = SELECT v, cast(v as numeric) from T_time; 2896 -
2897 ERROR = !types time(1,0) and decimal(18,3) are not equal for column 'v' 2897 -
2898 CODE = 42000 2898 -
2899 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2899 -
2900 QUERY = SELECT v, cast(v as decimal) from T_time; 2900 -
2901 ERROR = !types time(1,0) and decimal(18,3) are not equal for column 'v' 2901 -
2902 CODE = 42000 2902 -
2903 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2903 -
2904 QUERY = SELECT v, cast(v as numeric(10)) from T_time; 2904 -
2905 ERROR = !types time(1,0) and decimal(10,0) are not equal for column 'v' 2905 -
2906 CODE = 42000 2906 -
2907 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2907 -
2908 QUERY = SELECT v, cast(v as decimal(11)) from T_time; 2908 -
2909 ERROR = !types time(1,0) and decimal(11,0) are not equal for column 'v' 2909 -
2910 CODE = 42000 2910 -
2911 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2911 -
2912 QUERY = SELECT v, cast(v as numeric(12,0)) from T_time; 2912 -
2913 ERROR = !types time(1,0) and decimal(12,0) are not equal for column 'v' 2913 -
2914 CODE = 42000 2914 -
2915 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2915 -
2916 QUERY = SELECT v, cast(v as decimal(15,3)) from T_time; 2916 -
2917 ERROR = !types time(1,0) and decimal(15,3) are not equal for column 'v' 2917 -
2918 CODE = 42000 2918 -
2919 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2919 -
2920 QUERY = SELECT v, cast(v as char) from T_time; 2920 -
2921 ERROR = !value too long for type (var)char(1) 2921 -
2922 CODE = 22001 2922 -
2923 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2923 -
2924 QUERY = SELECT v, cast(v as varchar) from T_time; -- missing length specification 2924 -
2925 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 2925 -
2926 !syntax/parse error, 2926 -
2927 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2927 -
2928 CODE = 42000 2928 -
2929 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2929 -
2930 QUERY = SELECT v, cast(v as longvarchar) from T_time; -- LONGVARCHAR not valid data type 2930 -
2931 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 2931 -
2932 !syntax/parse error, 2932 -
2933 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2933 -
2934 CODE = 22000 2934 -
2935 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2935 -
2936 QUERY = SELECT v, cast(v as long varchar) from T_time; -- LONG VARCHAR not valid data type 2936 -
2937 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 2937 -
2938 !syntax/parse error, 2938 -
2939 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 2939 -
2940 CODE = 22000 2940 -
2941 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2941 -
2942 QUERY = SELECT v, cast(v as Binary) from T_time; -- BINARY not valid data type 2942 -
2943 ERROR = !syntax/parse error, 2943 -
2944 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 2944 -
2945 CODE = 42000 2945 -
2946 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2946 -
2947 QUERY = SELECT v, cast(v as varBinary) from T_time; -- VARBINARY not valid data type 2947 -
2948 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 2948 -
2949 !syntax/parse error, 2949 -
2950 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2950 -
2951 CODE = 22000 2951 -
2952 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2952 -
2953 QUERY = SELECT v, cast(v as longvarBinary) from T_time; -- LONGVARBINARY not valid data type 2953 -
2954 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 2954 -
2955 !syntax/parse error, 2955 -
2956 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2956 -
2957 CODE = 22000 2957 -
2958 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2958 -
2959 QUERY = SELECT v, cast(v as Blob) from T_time; 2959 -
2960 ERROR = !types time(1,0) and blob(0,0) are not equal for column 'v' 2960 -
2961 CODE = 42000 2961 -
2962 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2962 -
2963 QUERY = SELECT v, cast(v as date) from T_time; 2963 -
2964 ERROR = !types time(1,0) and date(0,0) are not equal for column 'v' 2964 -
2965 CODE = 42000 2965 -
2966 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2966 -
2967 QUERY = SELECT v, cast(v as timestamp) from T_time; 2967 -
2968 ERROR = !types time(1,0) and timestamp(7,0) are not equal for column 'v' 2968 -
2969 CODE = 42000 2969 -
2970 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2970 -
2971 QUERY = SELECT v, cast(v as time with timezone) from T_time; -- data type not supported (parse error) 2971 -
2972 ERROR = !syntax/parse error, 2972 -
2973 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 2973 -
2974 CODE = 42000 2974 -
2975 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2975 -
2976 QUERY = SELECT v, cast(v as timestamp with timezone) from T_time; -- data type not supported (parse error) 2976 -
2977 ERROR = !syntax/parse error, 2977 -
2978 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 2978 -
2979 CODE = 42000 2979 -
2980 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2980 -
2981 QUERY = SELECT v, cast(v as timestamptz) from T_time; 2981 -
2982 ERROR = !types time(1,0) and timestamptz(7,0) are not equal for column 'v' 2982 -
2983 CODE = 42000 2983 -
2984 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2984 -
2985 QUERY = SELECT v, convert(v, boolean) from T_timestamp; 2985 -
2986 ERROR = !types timestamp(7,0) and boolean(1,0) are not equal for column 'v' 2986 -
2987 CODE = 42000 2987 -
2988 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2988 -
2989 QUERY = SELECT v, convert(v, bit) from T_timestamp; -- BIT not valid data type 2989 -
2990 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 2990 -
2991 !syntax/parse error, 2991 -
2992 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 2992 -
2993 CODE = 22000 2993 -
2994 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2994 -
2995 QUERY = SELECT v, convert(v, tinyint) from T_timestamp; 2995 -
2996 ERROR = !types timestamp(7,0) and tinyint(8,0) are not equal for column 'v' 2996 -
2997 CODE = 42000 2997 -
2998 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 2998 -
2999 QUERY = SELECT v, convert(v, smallint) from T_timestamp; 2999 -
3000 ERROR = !types timestamp(7,0) and smallint(16,0) are not equal for column 'v' 3000 -
3001 CODE = 42000 3001 -
3002 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3002 -
3003 QUERY = SELECT v, convert(v, integer) from T_timestamp; 3003 -
3004 ERROR = !types timestamp(7,0) and int(32,0) are not equal for column 'v' 3004 -
3005 CODE = 42000 3005 -
3006 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3006 -
3007 QUERY = SELECT v, convert(v, bigint) from T_timestamp; 3007 -
3008 ERROR = !types timestamp(7,0) and bigint(64,0) are not equal for column 'v' 3008 -
3009 CODE = 42000 3009 -
3010 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3010 -
3011 QUERY = SELECT v, convert(v, hugeint) from T_timestamp; 3011 -
3012 ERROR = !types timestamp(7,0) and hugeint(128,0) are not equal for column 'v' 3012 -
3013 CODE = 42000 3013 -
3014 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3014 -
3015 QUERY = SELECT v, convert(v, float) from T_timestamp; 3015 -
3016 ERROR = !types timestamp(7,0) and double(53,0) are not equal for column 'v' 3016 -
3017 CODE = 42000 3017 -
3018 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3018 -
3019 QUERY = SELECT v, convert(v, float(24)) from T_timestamp; 3019 -
3020 ERROR = !types timestamp(7,0) and real(24,0) are not equal for column 'v' 3020 -
3021 CODE = 42000 3021 -
3022 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3022 -
3023 QUERY = SELECT v, convert(v, real) from T_timestamp; 3023 -
3024 ERROR = !types timestamp(7,0) and real(24,0) are not equal for column 'v' 3024 -
3025 CODE = 42000 3025 -
3026 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3026 -
3027 QUERY = SELECT v, convert(v, double) from T_timestamp; 3027 -
3028 ERROR = !types timestamp(7,0) and double(53,0) are not equal for column 'v' 3028 -
3029 CODE = 42000 3029 -
3030 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3030 -
3031 QUERY = SELECT v, convert(v, double precision) from T_timestamp; 3031 -
3032 ERROR = !types timestamp(7,0) and double(53,0) are not equal for column 'v' 3032 -
3033 CODE = 42000 3033 -
3034 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3034 -
3035 QUERY = SELECT v, convert(v, numeric) from T_timestamp; 3035 -
3036 ERROR = !types timestamp(7,0) and decimal(18,3) are not equal for column 'v' 3036 -
3037 CODE = 42000 3037 -
3038 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3038 -
3039 QUERY = SELECT v, convert(v, decimal) from T_timestamp; 3039 -
3040 ERROR = !types timestamp(7,0) and decimal(18,3) are not equal for column 'v' 3040 -
3041 CODE = 42000 3041 -
3042 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3042 -
3043 QUERY = SELECT v, convert(v, numeric(10)) from T_timestamp; 3043 -
3044 ERROR = !types timestamp(7,0) and decimal(10,0) are not equal for column 'v' 3044 -
3045 CODE = 42000 3045 -
3046 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3046 -
3047 QUERY = SELECT v, convert(v, decimal(11)) from T_timestamp; 3047 -
3048 ERROR = !types timestamp(7,0) and decimal(11,0) are not equal for column 'v' 3048 -
3049 CODE = 42000 3049 -
3050 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3050 -
3051 QUERY = SELECT v, convert(v, numeric(12,0)) from T_timestamp; 3051 -
3052 ERROR = !types timestamp(7,0) and decimal(12,0) are not equal for column 'v' 3052 -
3053 CODE = 42000 3053 -
3054 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3054 -
3055 QUERY = SELECT v, convert(v, decimal(15,3)) from T_timestamp; 3055 -
3056 ERROR = !types timestamp(7,0) and decimal(15,3) are not equal for column 'v' 3056 -
3057 CODE = 42000 3057 -
3058 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3058 -
3059 QUERY = SELECT v, convert(v, char) from T_timestamp; 3059 -
3060 ERROR = !value too long for type (var)char(1) 3060 -
3061 CODE = 22001 3061 -
3062 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3062 -
3063 QUERY = SELECT v, convert(v, varchar) from T_timestamp; -- missing length specification 3063 -
3064 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 3064 -
3065 !syntax/parse error, 3065 -
3066 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3066 -
3067 CODE = 42000 3067 -
3068 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3068 -
3069 QUERY = SELECT v, convert(v, longvarchar) from T_timestamp; -- LONGVARCHAR not valid data type 3069 -
3070 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 3070 -
3071 !syntax/parse error, 3071 -
3072 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3072 -
3073 CODE = 22000 3073 -
3074 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3074 -
3075 QUERY = SELECT v, convert(v, long varchar) from T_timestamp; -- LONG VARCHAR not valid data type 3075 -
3076 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 3076 -
3077 !syntax/parse error, 3077 -
3078 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 3078 -
3079 CODE = 22000 3079 -
3080 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3080 -
3081 QUERY = SELECT v, convert(v, Binary) from T_timestamp; -- BINARY not valid data type 3081 -
3082 ERROR = !syntax/parse error, 3082 -
3083 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 3083 -
3084 CODE = 42000 3084 -
3085 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3085 -
3086 QUERY = SELECT v, convert(v, varBinary) from T_timestamp; -- VARBINARY not valid data type 3086 -
3087 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 3087 -
3088 !syntax/parse error, 3088 -
3089 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3089 -
3090 CODE = 22000 3090 -
3091 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3091 -
3092 QUERY = SELECT v, convert(v, longvarBinary) from T_timestamp; -- LONGVARBINARY not valid data type 3092 -
3093 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 3093 -
3094 !syntax/parse error, 3094 -
3095 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3095 -
3096 CODE = 22000 3096 -
3097 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3097 -
3098 QUERY = SELECT v, convert(v, Blob) from T_timestamp; 3098 -
3099 ERROR = !types timestamp(7,0) and blob(0,0) are not equal for column 'v' 3099 -
3100 CODE = 42000 3100 -
3101 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3101 -
3102 QUERY = SELECT v, convert(v, time with timezone) from T_timestamp; -- data type not supported (parse error) 3102 -
3103 ERROR = !syntax/parse error, 3103 -
3104 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 3104 -
3105 CODE = 42000 3105 -
3106 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3106 -
3107 QUERY = SELECT v, convert(v, timestamp with timezone) from T_timestamp; -- data type not supported (parse error) 3107 -
3108 ERROR = !syntax/parse error, 3108 -
3109 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 3109 -
3110 CODE = 42000 3110 -
3111 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3111 -
3112 QUERY = SELECT v, cast(v as boolean) from T_timestamp; 3112 -
3113 ERROR = !types timestamp(7,0) and boolean(1,0) are not equal for column 'v' 3113 -
3114 CODE = 42000 3114 -
3115 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3115 -
3116 QUERY = SELECT v, cast(v as bit) from T_timestamp; -- BIT not valid data type 3116 -
3117 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 3117 -
3118 !syntax/parse error, 3118 -
3119 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3119 -
3120 CODE = 22000 3120 -
3121 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3121 -
3122 QUERY = SELECT v, cast(v as tinyint) from T_timestamp; 3122 -
3123 ERROR = !types timestamp(7,0) and tinyint(8,0) are not equal for column 'v' 3123 -
3124 CODE = 42000 3124 -
3125 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3125 -
3126 QUERY = SELECT v, cast(v as smallint) from T_timestamp; 3126 -
3127 ERROR = !types timestamp(7,0) and smallint(16,0) are not equal for column 'v' 3127 -
3128 CODE = 42000 3128 -
3129 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3129 -
3130 QUERY = SELECT v, cast(v as integer) from T_timestamp; 3130 -
3131 ERROR = !types timestamp(7,0) and int(32,0) are not equal for column 'v' 3131 -
3132 CODE = 42000 3132 -
3133 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3133 -
3134 QUERY = SELECT v, cast(v as bigint) from T_timestamp; 3134 -
3135 ERROR = !types timestamp(7,0) and bigint(64,0) are not equal for column 'v' 3135 -
3136 CODE = 42000 3136 -
3137 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3137 -
3138 QUERY = SELECT v, cast(v as hugeint) from T_timestamp; 3138 -
3139 ERROR = !types timestamp(7,0) and hugeint(128,0) are not equal for column 'v' 3139 -
3140 CODE = 42000 3140 -
3141 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3141 -
3142 QUERY = SELECT v, cast(v as float) from T_timestamp; 3142 -
3143 ERROR = !types timestamp(7,0) and double(53,0) are not equal for column 'v' 3143 -
3144 CODE = 42000 3144 -
3145 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3145 -
3146 QUERY = SELECT v, cast(v as float(24)) from T_timestamp; 3146 -
3147 ERROR = !types timestamp(7,0) and real(24,0) are not equal for column 'v' 3147 -
3148 CODE = 42000 3148 -
3149 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3149 -
3150 QUERY = SELECT v, cast(v as real) from T_timestamp; 3150 -
3151 ERROR = !types timestamp(7,0) and real(24,0) are not equal for column 'v' 3151 -
3152 CODE = 42000 3152 -
3153 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3153 -
3154 QUERY = SELECT v, cast(v as double) from T_timestamp; 3154 -
3155 ERROR = !types timestamp(7,0) and double(53,0) are not equal for column 'v' 3155 -
3156 CODE = 42000 3156 -
3157 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3157 -
3158 QUERY = SELECT v, cast(v as double precision) from T_timestamp; 3158 -
3159 ERROR = !types timestamp(7,0) and double(53,0) are not equal for column 'v' 3159 -
3160 CODE = 42000 3160 -
3161 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3161 -
3162 QUERY = SELECT v, cast(v as numeric) from T_timestamp; 3162 -
3163 ERROR = !types timestamp(7,0) and decimal(18,3) are not equal for column 'v' 3163 -
3164 CODE = 42000 3164 -
3165 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3165 -
3166 QUERY = SELECT v, cast(v as decimal) from T_timestamp; 3166 -
3167 ERROR = !types timestamp(7,0) and decimal(18,3) are not equal for column 'v' 3167 -
3168 CODE = 42000 3168 -
3169 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3169 -
3170 QUERY = SELECT v, cast(v as numeric(10)) from T_timestamp; 3170 -
3171 ERROR = !types timestamp(7,0) and decimal(10,0) are not equal for column 'v' 3171 -
3172 CODE = 42000 3172 -
3173 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3173 -
3174 QUERY = SELECT v, cast(v as decimal(11)) from T_timestamp; 3174 -
3175 ERROR = !types timestamp(7,0) and decimal(11,0) are not equal for column 'v' 3175 -
3176 CODE = 42000 3176 -
3177 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3177 -
3178 QUERY = SELECT v, cast(v as numeric(12,0)) from T_timestamp; 3178 -
3179 ERROR = !types timestamp(7,0) and decimal(12,0) are not equal for column 'v' 3179 -
3180 CODE = 42000 3180 -
3181 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3181 -
3182 QUERY = SELECT v, cast(v as decimal(15,3)) from T_timestamp; 3182 -
3183 ERROR = !types timestamp(7,0) and decimal(15,3) are not equal for column 'v' 3183 -
3184 CODE = 42000 3184 -
3185 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3185 -
3186 QUERY = SELECT v, cast(v as char) from T_timestamp; 3186 -
3187 ERROR = !value too long for type (var)char(1) 3187 -
3188 CODE = 22001 3188 -
3189 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3189 -
3190 QUERY = SELECT v, cast(v as varchar) from T_timestamp; -- missing length specification 3190 -
3191 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 3191 -
3192 !syntax/parse error, 3192 -
3193 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3193 -
3194 CODE = 42000 3194 -
3195 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3195 -
3196 QUERY = SELECT v, cast(v as longvarchar) from T_timestamp; -- LONGVARCHAR not valid data type 3196 -
3197 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 3197 -
3198 !syntax/parse error, 3198 -
3199 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3199 -
3200 CODE = 22000 3200 -
3201 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3201 -
3202 QUERY = SELECT v, cast(v as long varchar) from T_timestamp; -- LONG VARCHAR not valid data type 3202 -
3203 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 3203 -
3204 !syntax/parse error, 3204 -
3205 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 3205 -
3206 CODE = 22000 3206 -
3207 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3207 -
3208 QUERY = SELECT v, cast(v as Binary) from T_timestamp; -- BINARY not valid data type 3208 -
3209 ERROR = !syntax/parse error, 3209 -
3210 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 3210 -
3211 CODE = 42000 3211 -
3212 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3212 -
3213 QUERY = SELECT v, cast(v as varBinary) from T_timestamp; -- VARBINARY not valid data type 3213 -
3214 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 3214 -
3215 !syntax/parse error, 3215 -
3216 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3216 -
3217 CODE = 22000 3217 -
3218 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3218 -
3219 QUERY = SELECT v, cast(v as longvarBinary) from T_timestamp; -- LONGVARBINARY not valid data type 3219 -
3220 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 3220 -
3221 !syntax/parse error, 3221 -
3222 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3222 -
3223 CODE = 22000 3223 -
3224 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3224 -
3225 QUERY = SELECT v, cast(v as Blob) from T_timestamp; 3225 -
3226 ERROR = !types timestamp(7,0) and blob(0,0) are not equal for column 'v' 3226 -
3227 CODE = 42000 3227 -
3228 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3228 -
3229 QUERY = SELECT v, cast(v as time with timezone) from T_timestamp; -- data type not supported (parse error) 3229 -
3230 ERROR = !syntax/parse error, 3230 -
3231 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 3231 -
3232 CODE = 42000 3232 -
3233 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3233 -
3234 QUERY = SELECT v, cast(v as timestamp with timezone) from T_timestamp; -- data type not supported (parse error) 3234 -
3235 ERROR = !syntax/parse error, 3235 -
3236 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 3236 -
3237 CODE = 42000 3237 -
3238 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3238 -
3239 QUERY = SELECT v, convert(v, boolean) from T_timetz; 3239 -
3240 ERROR = !types timetz(7,0) and boolean(1,0) are not equal for column 'v' 3240 -
3241 CODE = 42000 3241 -
3242 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3242 -
3243 QUERY = SELECT v, convert(v, bit) from T_timetz; -- BIT not valid data type 3243 -
3244 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 3244 -
3245 !syntax/parse error, 3245 -
3246 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3246 -
3247 CODE = 22000 3247 -
3248 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3248 -
3249 QUERY = SELECT v, convert(v, tinyint) from T_timetz; 3249 -
3250 ERROR = !types timetz(7,0) and tinyint(8,0) are not equal for column 'v' 3250 -
3251 CODE = 42000 3251 -
3252 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3252 -
3253 QUERY = SELECT v, convert(v, smallint) from T_timetz; 3253 -
3254 ERROR = !types timetz(7,0) and smallint(16,0) are not equal for column 'v' 3254 -
3255 CODE = 42000 3255 -
3256 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3256 -
3257 QUERY = SELECT v, convert(v, integer) from T_timetz; 3257 -
3258 ERROR = !types timetz(7,0) and int(32,0) are not equal for column 'v' 3258 -
3259 CODE = 42000 3259 -
3260 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3260 -
3261 QUERY = SELECT v, convert(v, bigint) from T_timetz; 3261 -
3262 ERROR = !types timetz(7,0) and bigint(64,0) are not equal for column 'v' 3262 -
3263 CODE = 42000 3263 -
3264 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3264 -
3265 QUERY = SELECT v, convert(v, hugeint) from T_timetz; 3265 -
3266 ERROR = !types timetz(7,0) and hugeint(128,0) are not equal for column 'v' 3266 -
3267 CODE = 42000 3267 -
3268 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3268 -
3269 QUERY = SELECT v, convert(v, float) from T_timetz; 3269 -
3270 ERROR = !types timetz(7,0) and double(53,0) are not equal for column 'v' 3270 -
3271 CODE = 42000 3271 -
3272 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3272 -
3273 QUERY = SELECT v, convert(v, float(24)) from T_timetz; 3273 -
3274 ERROR = !types timetz(7,0) and real(24,0) are not equal for column 'v' 3274 -
3275 CODE = 42000 3275 -
3276 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3276 -
3277 QUERY = SELECT v, convert(v, real) from T_timetz; 3277 -
3278 ERROR = !types timetz(7,0) and real(24,0) are not equal for column 'v' 3278 -
3279 CODE = 42000 3279 -
3280 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3280 -
3281 QUERY = SELECT v, convert(v, double) from T_timetz; 3281 -
3282 ERROR = !types timetz(7,0) and double(53,0) are not equal for column 'v' 3282 -
3283 CODE = 42000 3283 -
3284 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3284 -
3285 QUERY = SELECT v, convert(v, double precision) from T_timetz; 3285 -
3286 ERROR = !types timetz(7,0) and double(53,0) are not equal for column 'v' 3286 -
3287 CODE = 42000 3287 -
3288 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3288 -
3289 QUERY = SELECT v, convert(v, numeric) from T_timetz; 3289 -
3290 ERROR = !types timetz(7,0) and decimal(18,3) are not equal for column 'v' 3290 -
3291 CODE = 42000 3291 -
3292 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3292 -
3293 QUERY = SELECT v, convert(v, decimal) from T_timetz; 3293 -
3294 ERROR = !types timetz(7,0) and decimal(18,3) are not equal for column 'v' 3294 -
3295 CODE = 42000 3295 -
3296 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3296 -
3297 QUERY = SELECT v, convert(v, numeric(10)) from T_timetz; 3297 -
3298 ERROR = !types timetz(7,0) and decimal(10,0) are not equal for column 'v' 3298 -
3299 CODE = 42000 3299 -
3300 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3300 -
3301 QUERY = SELECT v, convert(v, decimal(11)) from T_timetz; 3301 -
3302 ERROR = !types timetz(7,0) and decimal(11,0) are not equal for column 'v' 3302 -
3303 CODE = 42000 3303 -
3304 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3304 -
3305 QUERY = SELECT v, convert(v, numeric(12,0)) from T_timetz; 3305 -
3306 ERROR = !types timetz(7,0) and decimal(12,0) are not equal for column 'v' 3306 -
3307 CODE = 42000 3307 -
3308 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3308 -
3309 QUERY = SELECT v, convert(v, decimal(15,3)) from T_timetz; 3309 -
3310 ERROR = !types timetz(7,0) and decimal(15,3) are not equal for column 'v' 3310 -
3311 CODE = 42000 3311 -
3312 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3312 -
3313 QUERY = SELECT v, convert(v, char) from T_timetz; 3313 -
3314 ERROR = !value too long for type (var)char(1) 3314 -
3315 CODE = 22001 3315 -
3316 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3316 -
3317 QUERY = SELECT v, convert(v, varchar) from T_timetz; -- missing length specification 3317 -
3318 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 3318 -
3319 !syntax/parse error, 3319 -
3320 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3320 -
3321 CODE = 42000 3321 -
3322 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3322 -
3323 QUERY = SELECT v, convert(v, longvarchar) from T_timetz; -- LONGVARCHAR not valid data type 3323 -
3324 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 3324 -
3325 !syntax/parse error, 3325 -
3326 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3326 -
3327 CODE = 22000 3327 -
3328 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3328 -
3329 QUERY = SELECT v, convert(v, long varchar) from T_timetz; -- LONG VARCHAR not valid data type 3329 -
3330 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 3330 -
3331 !syntax/parse error, 3331 -
3332 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 3332 -
3333 CODE = 22000 3333 -
3334 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3334 -
3335 QUERY = SELECT v, convert(v, Binary) from T_timetz; -- BINARY not valid data type 3335 -
3336 ERROR = !syntax/parse error, 3336 -
3337 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 3337 -
3338 CODE = 42000 3338 -
3339 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3339 -
3340 QUERY = SELECT v, convert(v, varBinary) from T_timetz; -- VARBINARY not valid data type 3340 -
3341 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 3341 -
3342 !syntax/parse error, 3342 -
3343 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3343 -
3344 CODE = 22000 3344 -
3345 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3345 -
3346 QUERY = SELECT v, convert(v, longvarBinary) from T_timetz; -- LONGVARBINARY not valid data type 3346 -
3347 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 3347 -
3348 !syntax/parse error, 3348 -
3349 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3349 -
3350 CODE = 22000 3350 -
3351 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3351 -
3352 QUERY = SELECT v, convert(v, Blob) from T_timetz; 3352 -
3353 ERROR = !types timetz(7,0) and blob(0,0) are not equal for column 'v' 3353 -
3354 CODE = 42000 3354 -
3355 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3355 -
3356 QUERY = SELECT v, convert(v, date) from T_timetz; 3356 -
3357 ERROR = !types timetz(7,0) and date(0,0) are not equal for column 'v' 3357 -
3358 CODE = 42000 3358 -
3359 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3359 -
3360 QUERY = SELECT v, convert(v, timestamp) from T_timetz; 3360 -
3361 ERROR = !types timetz(7,0) and timestamp(7,0) are not equal for column 'v' 3361 -
3362 CODE = 42000 3362 -
3363 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3363 -
3364 QUERY = SELECT v, convert(v, time with timezone) from T_timetz; -- data type not supported (parse error) 3364 -
3365 ERROR = !syntax/parse error, 3365 -
3366 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 3366 -
3367 CODE = 42000 3367 -
3368 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3368 -
3369 QUERY = SELECT v, convert(v, timestamp with timezone) from T_timetz; -- data type not supported (parse error) 3369 -
3370 ERROR = !syntax/parse error, 3370 -
3371 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 3371 -
3372 CODE = 42000 3372 -
3373 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3373 -
3374 QUERY = SELECT v, convert(v, timestamptz) from T_timetz; 3374 -
3375 ERROR = !types timetz(7,0) and timestamptz(7,0) are not equal for column 'v' 3375 -
3376 CODE = 42000 3376 -
3377 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3377 -
3378 QUERY = SELECT v, cast(v as boolean) from T_timetz; 3378 -
3379 ERROR = !types timetz(7,0) and boolean(1,0) are not equal for column 'v' 3379 -
3380 CODE = 42000 3380 -
3381 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3381 -
3382 QUERY = SELECT v, cast(v as bit) from T_timetz; -- BIT not valid data type 3382 -
3383 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 3383 -
3384 !syntax/parse error, 3384 -
3385 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3385 -
3386 CODE = 22000 3386 -
3387 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3387 -
3388 QUERY = SELECT v, cast(v as tinyint) from T_timetz; 3388 -
3389 ERROR = !types timetz(7,0) and tinyint(8,0) are not equal for column 'v' 3389 -
3390 CODE = 42000 3390 -
3391 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3391 -
3392 QUERY = SELECT v, cast(v as smallint) from T_timetz; 3392 -
3393 ERROR = !types timetz(7,0) and smallint(16,0) are not equal for column 'v' 3393 -
3394 CODE = 42000 3394 -
3395 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3395 -
3396 QUERY = SELECT v, cast(v as integer) from T_timetz; 3396 -
3397 ERROR = !types timetz(7,0) and int(32,0) are not equal for column 'v' 3397 -
3398 CODE = 42000 3398 -
3399 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3399 -
3400 QUERY = SELECT v, cast(v as bigint) from T_timetz; 3400 -
3401 ERROR = !types timetz(7,0) and bigint(64,0) are not equal for column 'v' 3401 -
3402 CODE = 42000 3402 -
3403 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3403 -
3404 QUERY = SELECT v, cast(v as hugeint) from T_timetz; 3404 -
3405 ERROR = !types timetz(7,0) and hugeint(128,0) are not equal for column 'v' 3405 -
3406 CODE = 42000 3406 -
3407 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3407 -
3408 QUERY = SELECT v, cast(v as float) from T_timetz; 3408 -
3409 ERROR = !types timetz(7,0) and double(53,0) are not equal for column 'v' 3409 -
3410 CODE = 42000 3410 -
3411 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3411 -
3412 QUERY = SELECT v, cast(v as float(24)) from T_timetz; 3412 -
3413 ERROR = !types timetz(7,0) and real(24,0) are not equal for column 'v' 3413 -
3414 CODE = 42000 3414 -
3415 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3415 -
3416 QUERY = SELECT v, cast(v as real) from T_timetz; 3416 -
3417 ERROR = !types timetz(7,0) and real(24,0) are not equal for column 'v' 3417 -
3418 CODE = 42000 3418 -
3419 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3419 -
3420 QUERY = SELECT v, cast(v as double) from T_timetz; 3420 -
3421 ERROR = !types timetz(7,0) and double(53,0) are not equal for column 'v' 3421 -
3422 CODE = 42000 3422 -
3423 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3423 -
3424 QUERY = SELECT v, cast(v as double precision) from T_timetz; 3424 -
3425 ERROR = !types timetz(7,0) and double(53,0) are not equal for column 'v' 3425 -
3426 CODE = 42000 3426 -
3427 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3427 -
3428 QUERY = SELECT v, cast(v as numeric) from T_timetz; 3428 -
3429 ERROR = !types timetz(7,0) and decimal(18,3) are not equal for column 'v' 3429 -
3430 CODE = 42000 3430 -
3431 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3431 -
3432 QUERY = SELECT v, cast(v as decimal) from T_timetz; 3432 -
3433 ERROR = !types timetz(7,0) and decimal(18,3) are not equal for column 'v' 3433 -
3434 CODE = 42000 3434 -
3435 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3435 -
3436 QUERY = SELECT v, cast(v as numeric(10)) from T_timetz; 3436 -
3437 ERROR = !types timetz(7,0) and decimal(10,0) are not equal for column 'v' 3437 -
3438 CODE = 42000 3438 -
3439 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3439 -
3440 QUERY = SELECT v, cast(v as decimal(11)) from T_timetz; 3440 -
3441 ERROR = !types timetz(7,0) and decimal(11,0) are not equal for column 'v' 3441 -
3442 CODE = 42000 3442 -
3443 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3443 -
3444 QUERY = SELECT v, cast(v as numeric(12,0)) from T_timetz; 3444 -
3445 ERROR = !types timetz(7,0) and decimal(12,0) are not equal for column 'v' 3445 -
3446 CODE = 42000 3446 -
3447 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3447 -
3448 QUERY = SELECT v, cast(v as decimal(15,3)) from T_timetz; 3448 -
3449 ERROR = !types timetz(7,0) and decimal(15,3) are not equal for column 'v' 3449 -
3450 CODE = 42000 3450 -
3451 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3451 -
3452 QUERY = SELECT v, cast(v as char) from T_timetz; 3452 -
3453 ERROR = !value too long for type (var)char(1) 3453 -
3454 CODE = 22001 3454 -
3455 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3455 -
3456 QUERY = SELECT v, cast(v as varchar) from T_timetz; -- missing length specification 3456 -
3457 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 3457 -
3458 !syntax/parse error, 3458 -
3459 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3459 -
3460 CODE = 42000 3460 -
3461 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3461 -
3462 QUERY = SELECT v, cast(v as longvarchar) from T_timetz; -- LONGVARCHAR not valid data type 3462 -
3463 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 3463 -
3464 !syntax/parse error, 3464 -
3465 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3465 -
3466 CODE = 22000 3466 -
3467 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3467 -
3468 QUERY = SELECT v, cast(v as long varchar) from T_timetz; -- LONG VARCHAR not valid data type 3468 -
3469 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 3469 -
3470 !syntax/parse error, 3470 -
3471 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 3471 -
3472 CODE = 22000 3472 -
3473 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3473 -
3474 QUERY = SELECT v, cast(v as Binary) from T_timetz; -- BINARY not valid data type 3474 -
3475 ERROR = !syntax/parse error, 3475 -
3476 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 3476 -
3477 CODE = 42000 3477 -
3478 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3478 -
3479 QUERY = SELECT v, cast(v as varBinary) from T_timetz; -- VARBINARY not valid data type 3479 -
3480 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 3480 -
3481 !syntax/parse error, 3481 -
3482 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3482 -
3483 CODE = 22000 3483 -
3484 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3484 -
3485 QUERY = SELECT v, cast(v as longvarBinary) from T_timetz; -- LONGVARBINARY not valid data type 3485 -
3486 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 3486 -
3487 !syntax/parse error, 3487 -
3488 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3488 -
3489 CODE = 22000 3489 -
3490 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3490 -
3491 QUERY = SELECT v, cast(v as Blob) from T_timetz; 3491 -
3492 ERROR = !types timetz(7,0) and blob(0,0) are not equal for column 'v' 3492 -
3493 CODE = 42000 3493 -
3494 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3494 -
3495 QUERY = SELECT v, cast(v as date) from T_timetz; 3495 -
3496 ERROR = !types timetz(7,0) and date(0,0) are not equal for column 'v' 3496 -
3497 CODE = 42000 3497 -
3498 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3498 -
3499 QUERY = SELECT v, cast(v as timestamp) from T_timetz; 3499 -
3500 ERROR = !types timetz(7,0) and timestamp(7,0) are not equal for column 'v' 3500 -
3501 CODE = 42000 3501 -
3502 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3502 -
3503 QUERY = SELECT v, cast(v as time with timezone) from T_timetz; -- data type not supported (parse error) 3503 -
3504 ERROR = !syntax/parse error, 3504 -
3505 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 3505 -
3506 CODE = 42000 3506 -
3507 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3507 -
3508 QUERY = SELECT v, cast(v as timestamp with timezone) from T_timetz; -- data type not supported (parse error) 3508 -
3509 ERROR = !syntax/parse error, 3509 -
3510 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 3510 -
3511 CODE = 42000 3511 -
3512 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3512 -
3513 QUERY = SELECT v, cast(v as timestamptz) from T_timetz; 3513 -
3514 ERROR = !types timetz(7,0) and timestamptz(7,0) are not equal for column 'v' 3514 -
3515 CODE = 42000 3515 -
3516 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3516 -
3517 QUERY = SELECT v, convert(v, boolean) from T_timestamptz; 3517 -
3518 ERROR = !types timestamptz(7,0) and boolean(1,0) are not equal for column 'v' 3518 -
3519 CODE = 42000 3519 -
3520 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3520 -
3521 QUERY = SELECT v, convert(v, bit) from T_timestamptz; -- BIT not valid data type 3521 -
3522 ERROR = !Type (bit) unknown in: "select v, convert(v, bit)" 3522 -
3523 !syntax/parse error, 3523 -
3524 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3524 -
3525 CODE = 22000 3525 -
3526 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3526 -
3527 QUERY = SELECT v, convert(v, tinyint) from T_timestamptz; 3527 -
3528 ERROR = !types timestamptz(7,0) and tinyint(8,0) are not equal for column 'v' 3528 -
3529 CODE = 42000 3529 -
3530 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3530 -
3531 QUERY = SELECT v, convert(v, smallint) from T_timestamptz; 3531 -
3532 ERROR = !types timestamptz(7,0) and smallint(16,0) are not equal for column 'v' 3532 -
3533 CODE = 42000 3533 -
3534 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3534 -
3535 QUERY = SELECT v, convert(v, integer) from T_timestamptz; 3535 -
3536 ERROR = !types timestamptz(7,0) and int(32,0) are not equal for column 'v' 3536 -
3537 CODE = 42000 3537 -
3538 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3538 -
3539 QUERY = SELECT v, convert(v, bigint) from T_timestamptz; 3539 -
3540 ERROR = !types timestamptz(7,0) and bigint(64,0) are not equal for column 'v' 3540 -
3541 CODE = 42000 3541 -
3542 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3542 -
3543 QUERY = SELECT v, convert(v, hugeint) from T_timestamptz; 3543 -
3544 ERROR = !types timestamptz(7,0) and hugeint(128,0) are not equal for column 'v' 3544 -
3545 CODE = 42000 3545 -
3546 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3546 -
3547 QUERY = SELECT v, convert(v, float) from T_timestamptz; 3547 -
3548 ERROR = !types timestamptz(7,0) and double(53,0) are not equal for column 'v' 3548 -
3549 CODE = 42000 3549 -
3550 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3550 -
3551 QUERY = SELECT v, convert(v, float(24)) from T_timestamptz; 3551 -
3552 ERROR = !types timestamptz(7,0) and real(24,0) are not equal for column 'v' 3552 -
3553 CODE = 42000 3553 -
3554 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3554 -
3555 QUERY = SELECT v, convert(v, real) from T_timestamptz; 3555 -
3556 ERROR = !types timestamptz(7,0) and real(24,0) are not equal for column 'v' 3556 -
3557 CODE = 42000 3557 -
3558 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3558 -
3559 QUERY = SELECT v, convert(v, double) from T_timestamptz; 3559 -
3560 ERROR = !types timestamptz(7,0) and double(53,0) are not equal for column 'v' 3560 -
3561 CODE = 42000 3561 -
3562 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3562 -
3563 QUERY = SELECT v, convert(v, double precision) from T_timestamptz; 3563 -
3564 ERROR = !types timestamptz(7,0) and double(53,0) are not equal for column 'v' 3564 -
3565 CODE = 42000 3565 -
3566 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3566 -
3567 QUERY = SELECT v, convert(v, numeric) from T_timestamptz; 3567 -
3568 ERROR = !types timestamptz(7,0) and decimal(18,3) are not equal for column 'v' 3568 -
3569 CODE = 42000 3569 -
3570 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3570 -
3571 QUERY = SELECT v, convert(v, decimal) from T_timestamptz; 3571 -
3572 ERROR = !types timestamptz(7,0) and decimal(18,3) are not equal for column 'v' 3572 -
3573 CODE = 42000 3573 -
3574 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3574 -
3575 QUERY = SELECT v, convert(v, numeric(10)) from T_timestamptz; 3575 -
3576 ERROR = !types timestamptz(7,0) and decimal(10,0) are not equal for column 'v' 3576 -
3577 CODE = 42000 3577 -
3578 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3578 -
3579 QUERY = SELECT v, convert(v, decimal(11)) from T_timestamptz; 3579 -
3580 ERROR = !types timestamptz(7,0) and decimal(11,0) are not equal for column 'v' 3580 -
3581 CODE = 42000 3581 -
3582 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3582 -
3583 QUERY = SELECT v, convert(v, numeric(12,0)) from T_timestamptz; 3583 -
3584 ERROR = !types timestamptz(7,0) and decimal(12,0) are not equal for column 'v' 3584 -
3585 CODE = 42000 3585 -
3586 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3586 -
3587 QUERY = SELECT v, convert(v, decimal(15,3)) from T_timestamptz; 3587 -
3588 ERROR = !types timestamptz(7,0) and decimal(15,3) are not equal for column 'v' 3588 -
3589 CODE = 42000 3589 -
3590 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3590 -
3591 QUERY = SELECT v, convert(v, char) from T_timestamptz; 3591 -
3592 ERROR = !value too long for type (var)char(1) 3592 -
3593 CODE = 22001 3593 -
3594 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3594 -
3595 QUERY = SELECT v, convert(v, varchar) from T_timestamptz; -- missing length specification 3595 -
3596 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" 3596 -
3597 !syntax/parse error, 3597 -
3598 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3598 -
3599 CODE = 42000 3599 -
3600 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3600 -
3601 QUERY = SELECT v, convert(v, longvarchar) from T_timestamptz; -- LONGVARCHAR not valid data type 3601 -
3602 ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)" 3602 -
3603 !syntax/parse error, 3603 -
3604 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3604 -
3605 CODE = 22000 3605 -
3606 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3606 -
3607 QUERY = SELECT v, convert(v, long varchar) from T_timestamptz; -- LONG VARCHAR not valid data type 3607 -
3608 ERROR = !Type (long) unknown in: "select v, convert(v, long varchar" 3608 -
3609 !syntax/parse error, 3609 -
3610 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 3610 -
3611 CODE = 22000 3611 -
3612 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3612 -
3613 QUERY = SELECT v, convert(v, Binary) from T_timestamptz; -- BINARY not valid data type 3613 -
3614 ERROR = !syntax/parse error, 3614 -
3615 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, convert(v, binary)" 3615 -
3616 CODE = 42000 3616 -
3617 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3617 -
3618 QUERY = SELECT v, convert(v, varBinary) from T_timestamptz; -- VARBINARY not valid data type 3618 -
3619 ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)" 3619 -
3620 !syntax/parse error, 3620 -
3621 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3621 -
3622 CODE = 22000 3622 -
3623 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3623 -
3624 QUERY = SELECT v, convert(v, longvarBinary) from T_timestamptz; -- LONGVARBINARY not valid data type 3624 -
3625 ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)" 3625 -
3626 !syntax/parse error, 3626 -
3627 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3627 -
3628 CODE = 22000 3628 -
3629 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3629 -
3630 QUERY = SELECT v, convert(v, Blob) from T_timestamptz; 3630 -
3631 ERROR = !types timestamptz(7,0) and blob(0,0) are not equal for column 'v' 3631 -
3632 CODE = 42000 3632 -
3633 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3633 -
3634 QUERY = SELECT v, convert(v, time with timezone) from T_timestamptz; -- data type not supported (parse error) 3634 -
3635 ERROR = !syntax/parse error, 3635 -
3636 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" 3636 -
3637 CODE = 42000 3637 -
3638 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3638 -
3639 QUERY = SELECT v, convert(v, timestamp with timezone) from T_timestamptz; -- data type not supported (parse error) 3639 -
3640 ERROR = !syntax/parse error, 3640 -
3641 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" 3641 -
3642 CODE = 42000 3642 -
3643 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3643 -
3644 QUERY = SELECT v, cast(v as boolean) from T_timestamptz; 3644 -
3645 ERROR = !types timestamptz(7,0) and boolean(1,0) are not equal for column 'v' 3645 -
3646 CODE = 42000 3646 -
3647 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3647 -
3648 QUERY = SELECT v, cast(v as bit) from T_timestamptz; -- BIT not valid data type 3648 -
3649 ERROR = !Type (bit) unknown in: "select v, cast(v as bit)" 3649 -
3650 !syntax/parse error, 3650 -
3651 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3651 -
3652 CODE = 22000 3652 -
3653 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3653 -
3654 QUERY = SELECT v, cast(v as tinyint) from T_timestamptz; 3654 -
3655 ERROR = !types timestamptz(7,0) and tinyint(8,0) are not equal for column 'v' 3655 -
3656 CODE = 42000 3656 -
3657 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3657 -
3658 QUERY = SELECT v, cast(v as smallint) from T_timestamptz; 3658 -
3659 ERROR = !types timestamptz(7,0) and smallint(16,0) are not equal for column 'v' 3659 -
3660 CODE = 42000 3660 -
3661 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3661 -
3662 QUERY = SELECT v, cast(v as integer) from T_timestamptz; 3662 -
3663 ERROR = !types timestamptz(7,0) and int(32,0) are not equal for column 'v' 3663 -
3664 CODE = 42000 3664 -
3665 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3665 -
3666 QUERY = SELECT v, cast(v as bigint) from T_timestamptz; 3666 -
3667 ERROR = !types timestamptz(7,0) and bigint(64,0) are not equal for column 'v' 3667 -
3668 CODE = 42000 3668 -
3669 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3669 -
3670 QUERY = SELECT v, cast(v as hugeint) from T_timestamptz; 3670 -
3671 ERROR = !types timestamptz(7,0) and hugeint(128,0) are not equal for column 'v' 3671 -
3672 CODE = 42000 3672 -
3673 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3673 -
3674 QUERY = SELECT v, cast(v as float) from T_timestamptz; 3674 -
3675 ERROR = !types timestamptz(7,0) and double(53,0) are not equal for column 'v' 3675 -
3676 CODE = 42000 3676 -
3677 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3677 -
3678 QUERY = SELECT v, cast(v as float(24)) from T_timestamptz; 3678 -
3679 ERROR = !types timestamptz(7,0) and real(24,0) are not equal for column 'v' 3679 -
3680 CODE = 42000 3680 -
3681 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3681 -
3682 QUERY = SELECT v, cast(v as real) from T_timestamptz; 3682 -
3683 ERROR = !types timestamptz(7,0) and real(24,0) are not equal for column 'v' 3683 -
3684 CODE = 42000 3684 -
3685 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3685 -
3686 QUERY = SELECT v, cast(v as double) from T_timestamptz; 3686 -
3687 ERROR = !types timestamptz(7,0) and double(53,0) are not equal for column 'v' 3687 -
3688 CODE = 42000 3688 -
3689 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3689 -
3690 QUERY = SELECT v, cast(v as double precision) from T_timestamptz; 3690 -
3691 ERROR = !types timestamptz(7,0) and double(53,0) are not equal for column 'v' 3691 -
3692 CODE = 42000 3692 -
3693 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3693 -
3694 QUERY = SELECT v, cast(v as numeric) from T_timestamptz; 3694 -
3695 ERROR = !types timestamptz(7,0) and decimal(18,3) are not equal for column 'v' 3695 -
3696 CODE = 42000 3696 -
3697 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3697 -
3698 QUERY = SELECT v, cast(v as decimal) from T_timestamptz; 3698 -
3699 ERROR = !types timestamptz(7,0) and decimal(18,3) are not equal for column 'v' 3699 -
3700 CODE = 42000 3700 -
3701 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3701 -
3702 QUERY = SELECT v, cast(v as numeric(10)) from T_timestamptz; 3702 -
3703 ERROR = !types timestamptz(7,0) and decimal(10,0) are not equal for column 'v' 3703 -
3704 CODE = 42000 3704 -
3705 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3705 -
3706 QUERY = SELECT v, cast(v as decimal(11)) from T_timestamptz; 3706 -
3707 ERROR = !types timestamptz(7,0) and decimal(11,0) are not equal for column 'v' 3707 -
3708 CODE = 42000 3708 -
3709 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3709 -
3710 QUERY = SELECT v, cast(v as numeric(12,0)) from T_timestamptz; 3710 -
3711 ERROR = !types timestamptz(7,0) and decimal(12,0) are not equal for column 'v' 3711 -
3712 CODE = 42000 3712 -
3713 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3713 -
3714 QUERY = SELECT v, cast(v as decimal(15,3)) from T_timestamptz; 3714 -
3715 ERROR = !types timestamptz(7,0) and decimal(15,3) are not equal for column 'v' 3715 -
3716 CODE = 42000 3716 -
3717 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3717 -
3718 QUERY = SELECT v, cast(v as char) from T_timestamptz; 3718 -
3719 ERROR = !value too long for type (var)char(1) 3719 -
3720 CODE = 22001 3720 -
3721 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3721 -
3722 QUERY = SELECT v, cast(v as varchar) from T_timestamptz; -- missing length specification 3722 -
3723 ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" 3723 -
3724 !syntax/parse error, 3724 -
3725 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3725 -
3726 CODE = 42000 3726 -
3727 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3727 -
3728 QUERY = SELECT v, cast(v as longvarchar) from T_timestamptz; -- LONGVARCHAR not valid data type 3728 -
3729 ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)" 3729 -
3730 !syntax/parse error, 3730 -
3731 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3731 -
3732 CODE = 22000 3732 -
3733 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3733 -
3734 QUERY = SELECT v, cast(v as long varchar) from T_timestamptz; -- LONG VARCHAR not valid data type 3734 -
3735 ERROR = !Type (long) unknown in: "select v, cast(v as long varchar" 3735 -
3736 !syntax/parse error, 3736 -
3737 # the original non-normalized output was: !syntax error, unexpected ')' in: ")" 3737 -
3738 CODE = 22000 3738 -
3739 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3739 -
3740 QUERY = SELECT v, cast(v as Binary) from T_timestamptz; -- BINARY not valid data type 3740 -
3741 ERROR = !syntax/parse error, 3741 -
3742 # the original non-normalized output was: ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v as binary)" 3742 -
3743 CODE = 42000 3743 -
3744 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3744 -
3745 QUERY = SELECT v, cast(v as varBinary) from T_timestamptz; -- VARBINARY not valid data type 3745 -
3746 ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)" 3746 -
3747 !syntax/parse error, 3747 -
3748 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3748 -
3749 CODE = 22000 3749 -
3750 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3750 -
3751 QUERY = SELECT v, cast(v as longvarBinary) from T_timestamptz; -- LONGVARBINARY not valid data type 3751 -
3752 ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)" 3752 -
3753 !syntax/parse error, 3753 -
3754 # the original non-normalized output was: !syntax error, unexpected FROM in: "from" 3754 -
3755 CODE = 22000 3755 -
3756 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3756 -
3757 QUERY = SELECT v, cast(v as Blob) from T_timestamptz; 3757 -
3758 ERROR = !types timestamptz(7,0) and blob(0,0) are not equal for column 'v' 3758 -
3759 CODE = 42000 3759 -
3760 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3760 -
3761 QUERY = SELECT v, cast(v as time with timezone) from T_timestamptz; -- data type not supported (parse error) 3761 -
3762 ERROR = !syntax/parse error, 3762 -
3763 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" 3763 -
3764 CODE = 42000 3764 -
3765 #~ MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 3765 -
3766 QUERY = SELECT v, cast(v as timestamp with timezone) from T_timestamptz; -- data type not supported (parse error) 3766 -
3767 ERROR = !syntax/parse error, 3767 -
3768 # the original non-normalized output was: ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" 3768 -
3769 CODE = 42000 3769 -
3770 3770 1744 1744