 | |
v10: ISOLATION LEVEL 1 clause fails on refresh materialized view
sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
v10: ISOLATION LEVEL 1 clause fails on refresh materialized view -
10-28-2009
, 02:36 AM
#2
| |||
| |||
|
|
Hi, I want to create a materialized view with isolation level 1, as per documentation, but the server returns a syntax error: Error -131: Syntax error near '1' on line 1 (42W04) Statement: REFRESH MATERIALIZED VIEW DBA.MyNewTestMatView3 WITH ISOLATION LEVEL 1 According to the documentation, this should work. Any ideas? |
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere
Blog: http://iablog.sybase.com/paulley
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://case-express.sybase.com
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport
#3
| |||
| |||
|
|
The SQL grammar for REFRESH MATERIALIZED VIEW doesn't recognize the numeric values (ie 0,1,2,3) for isolation levels. You have to use phrase "READ COMMITTED" if you want that isolation level. The documentation for REFRESH seems to be clear on that point, at least to me. |
Do note, I'm looking at SQL Anywhere v10 here! Here's what it says:
REFRESH MATERIALIZED VIEW [ owner.]materialized-view-name
[ WITH { ISOLATION LEVEL isolation-level | EXCLUSIVE MODE } ]
[ FORCE BUILD ]
isolation-level :
0 | 1 | 2 | 3 | snapshot | statement-snapshot | readonly-statement-snapshot
Which is why I said: according to the documentation, this should work.
--
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
Quote:
|
I want to create a materialized view with isolation level 1, as per documentation, but the server returns a syntax error: Error -131: Syntax error near '1' on line 1 (42W04) Statement: REFRESH MATERIALIZED VIEW DBA.MyNewTestMatView3 WITH ISOLATION LEVEL 1 According to the documentation, this should work. Any ideas? -- Glenn Paulley Director, Engineering (Query Processing) Sybase iAnywhere Blog: http://iablog.sybase.com/paulley EBF's and Patches: http://downloads.sybase.com choose SQL Anywhere Studio >> change 'time frame' to all To Submit Bug Reports: http://case-express.sybase.com SQL Anywhere Studio Supported Platforms and Support Status http://my.sybase.com/detail?id=1002288 Whitepapers, TechDocs, and bug fixes are all available through the Sybase iAnywhere pages at http://www.sybase.com/products/datab...chnicalsupport |
#4
| |||
| |||
|
|
Hello Glenn, The SQL grammar for REFRESH MATERIALIZED VIEW doesn't recognize the numeric values (ie 0,1,2,3) for isolation levels. You have to use phrase "READ COMMITTED" if you want that isolation level. The documentation for REFRESH seems to be clear on that point, at least to me. Well, tough, but isn't clear for me ;-) Do note, I'm looking at SQL Anywhere v10 here! Here's what it says: REFRESH MATERIALIZED VIEW [ owner.]materialized-view-name [ WITH { ISOLATION LEVEL isolation-level | EXCLUSIVE MODE } ] [ FORCE BUILD ] isolation-level : 0 | 1 | 2 | 3 | snapshot | statement-snapshot | readonly-statement-snapshot Which is why I said: according to the documentation, this should work. |
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere
Blog: http://iablog.sybase.com/paulley
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://case-express.sybase.com
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport
#5
| |||
| |||
|
|
Arrrrrgh.. My apologies Martijn, I was looking at the V10 source code but mistakenly had opened the v11.0.1 help file. |
Quote:
|
The version 11 help file is correct (alas) but the V10 help is not. One must use the words rather than the numeric values. |
--
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
#6
| |||
| |||
|
|
Hello Glenn, Arrrrrgh.. My apologies Martijn, I was looking at the V10 source code but mistakenly had opened the v11.0.1 help file. Aah, the power of the source code ;-) |
#7
| |||
| |||
|
|
There's that swiss army proverb (poorly translated from a Stroustrup C++ book): "If there's a difference between map and terrain, rely on the latter." Volker Martijn Tonies wrote: Hello Glenn, Arrrrrgh.. My apologies Martijn, I was looking at the V10 source code but mistakenly had opened the v11.0.1 help file. Aah, the power of the source code ;-) |
Breck Carter http://sqlanywhere.blogspot.com/
RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com
#8
| |||
| |||
|
|
A whole new generation of folks are discovering the joys of map-versus-reality, with in-car GPS systems... "WHAT bridge?" Breck On 28 Oct 2009 05:12:56 -0800, Volker Barth No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote: There's that swiss army proverb (poorly translated from a Stroustrup C++ book): "If there's a difference between map and terrain, rely on the latter." Volker Martijn Tonies wrote: Hello Glenn, Arrrrrgh.. My apologies Martijn, I was looking at the V10 source code but mistakenly had opened the v11.0.1 help file. Aah, the power of the source code ;-) -- Breck Carter http://sqlanywhere.blogspot.com/ RisingRoad SQL Anywhere and MobiLink Professional Services breck.carter (AT) risingroad (DOT) com |
#9
| |||
| |||
|
|
A whole new generation of folks are discovering the joys of map-versus-reality, with in-car GPS systems... "WHAT bridge?" Breck On 28 Oct 2009 05:12:56 -0800, Volker Barth No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote: There's that swiss army proverb (poorly translated from a Stroustrup C++ book): "If there's a difference between map and terrain, rely on the latter." Volker Martijn Tonies wrote: Hello Glenn, Arrrrrgh.. My apologies Martijn, I was looking at the V10 source code but mistakenly had opened the v11.0.1 help file. Aah, the power of the source code ;-) -- Breck Carter http://sqlanywhere.blogspot.com/ RisingRoad SQL Anywhere and MobiLink Professional Services breck.carter (AT) risingroad (DOT) com |
#10
| |||
| |||
|
|
There's that swiss army proverb (poorly translated from a Stroustrup C++ book): "If there's a difference between map and terrain, rely on the latter." |
I even recall a news report that someone drove into a river because
his GPS just said take that route, but there usually was a ferry ;-)
--
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.